Exhibit 11.6
The following questions use the data below.
A store wants to predict quarterly sales. The owner has collected 3 years of sales data and wants your help in analyzing the data using the double moving average model with k = 4.
-Refer to Exhibit 11.6. What formula should be entered in cell I16 to compute the forecast for time period 14?
A) =I15+2*$H$14
B) =G14+B16*H14
C) =G14+3*H14
D) =G12+H12

Question

Exhibit 11.6
The following questions use the data below.
A store wants to predict quarterly sales. The owner has collected 3 years of sales data and wants your help in analyzing the data using the double moving average model with k = 4. 
-Refer to Exhibit 11.6. What formula should be entered in cell I16 to compute the forecast for time period 14?
A) =I15+2*$H$14 
B) =G14+B16*H14 
C) =G14+3*H14 
D) =G12+H12

Quizplus · Accepted Answer

The correct formula to compute the forecast for time period 14 is =I15+2*$H$14. This formula takes the previous forecast value (I15) and adds twice the smoothing constant (H14) to adjust the forecast.

Exhibit 11.6 The Following Questions Use the Data Below