Table 14.11
A sales manager wants to forecast monthly sales of the machines the company makes using the following monthly sales data.

-Use the information in Table 14.11.Use the 3-month weighted moving-average method to calculate the forecast for month 9.The weights are 0.60,0.30,and 0.10,where 0.60 refers to the most recent demand.
A)$3,916
B)$3,880
C)$3,396
D)$3,229

Question

Table 14.11
A sales manager wants to forecast monthly sales of the machines the company makes using the following monthly sales data.
 
-Use the information in Table 14.11.Use the 3-month weighted moving-average method to calculate the forecast for month 9.The weights are 0.60,0.30,and 0.10,where 0.60 refers to the most recent demand.
A)$3,916 
B)$3,880 
C)$3,396 
D)$3,229

Quizplus · Accepted Answer

The 3-month weighted moving-average forecast for month 9 is calculated as follows: (0.60 * Demand in month 8) + (0.30 * Demand in month 7) + (0.10 * Demand in month 6). The correct calculation using the given weights results in $3,916.

Table 14.11 a Sales Manager Wants to Forecast Monthly Sales of the of the Machines