Data Set E1
$$\begin{array} { c c }
\text { Periqd } &\text { Sales Volume } \
1 & 10000\
2 & 12400\
3 & 14250 \
4 & 15750 \
5 & 20500 \
6 & 18500\
7 &15750 \
8 & 20500 \
9 & 21500\
10&22550
\end{array}$$

-Using the actual demand shown in the table below,what is the forecast for May (accurate to 1 decimal)using a 4-month weighted moving average and the weights 0.1,0.2,0.3,0.4 (with the heaviest weight applied to the most recent period)?
$$\begin{array} { c c c c c c }
\text { Nuv. } & \text { Dec. } & \text { Jan. } & \text { Feb. } & \text { Mar. } & \text { Apr. } \
\hline 39 & 36 & 40 & 38 & 48 & 46
\end{array}$$
A) 44.4
B) 43.0
C) 42.5
D) 41.6

Question

Data Set E1
 $$\begin{array} { c c } 
\text { Periqd } &\text { Sales Volume } \
1 & 10000\
2 & 12400\
3 & 14250 \
4 & 15750 \
5 & 20500 \
6 & 18500\
7 &15750 \
8 & 20500 \
9 & 21500\
10&22550
\end{array}$$

-Using the actual demand shown in the table below,what is the forecast for May (accurate to 1 decimal)using a 4-month weighted moving average and the weights 0.1,0.2,0.3,0.4 (with the heaviest weight applied to the most recent period)?
$$\begin{array} { c c c c c c } 
\text { Nuv. } & \text { Dec. } & \text { Jan. } & \text { Feb. } & \text { Mar. } & \text { Apr. } \
\hline 39 & 36 & 40 & 38 & 48 & 46
\end{array}$$
A) 44.4
B) 43.0
C) 42.5
D) 41.6

Quizplus · Accepted Answer

To calculate the 4-month weighted moving average for May, use the weights 0.1, 0.2, 0.3, and 0.4 for the months of April, March, February, and January respectively: (0.4 * 46) + (0.3 * 48) + (0.2 * 38) + (0.1 * 40) = 44.4.

Data Set E1 -Using the Actual Demand Shown in the Table Below,what Is