Exhibit 11.4
The following questions use the data below.
Joe's Sporting Goods wants to forecast quarterly sales figures using the additive seasonal method. The store has collected 12 quarters of data and needs your help to analyze the data.
-Refer to Exhibit 11.4. What formula should be entered in cell F7 to compute the seasonal factor using the additive seasonal effects model?
A) =$J$3*D4+(1-$J$3)*(E3+F3)
B) =$J$4*(D7-E7)+(1-$J$4)*F3
C) =$J$4*(E7-E6)+(1-$J$4)*E6
D) =$J$3*G3+(1-$J$3)*(D3+G3)

Question

Exhibit 11.4
The following questions use the data below.
Joe's Sporting Goods wants to forecast quarterly sales figures using the additive seasonal method. The store has collected 12 quarters of data and needs your help to analyze the data. 
-Refer to Exhibit 11.4. What formula should be entered in cell F7 to compute the seasonal factor using the additive seasonal effects model?
A) =$J$3*D4+(1-$J$3)*(E3+F3) 
B) =$J$4*(D7-E7)+(1-$J$4)*F3 
C) =$J$4*(E7-E6)+(1-$J$4)*E6 
D) =$J$3*G3+(1-$J$3)*(D3+G3)

Quizplus · Accepted Answer

The additive seasonal effects model calculates the seasonal factor by adjusting the difference between actual and expected values, which is represented by the formula in choice B.

Exhibit 11.4 The Following Questions Use the Data Below