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 G12 to compute the forecast for time period 10?
A) =E10+F7
B) =E12+F12
C) =E12+F8
D) =E11+F8

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 G12 to compute the forecast for time period 10?
A) =E10+F7 
B) =E12+F12 
C) =E12+F8 
D) =E11+F8

Quizplus · Accepted Answer

The formula for the additive seasonal method is Forecast = Average Demand + Seasonal Factor. Time period 10 is in quarter 3 of year 3. Therefore, using the additive seasonal method, the forecast for time period 10 would be the average demand for quarter 3 plus the seasonal factor for quarter 3, which would be E11 + F8.

Exhibit 11.4 The Following Questions Use the Data Below