A product has the following demand history for the past six months:
$$\begin{array} { | c | c | }
\hline \text { January } & 212 \
\hline \text { February } & 201 \
\hline \text { March } & 242 \
\hline \text { April } & 188 \
\hline \text { May } & 198 \
\hline \text { June } & 208 \
\hline
\end{array}$$
A) Using a 4-month moving average, find the July forecast.
B) Using a weighted moving average with weights of 0.5, 0.3, and 0.2, find the July forecast.
C) Using exponential smoothing with α = 0.2 and a June forecast of 196, find the July forecast.

Question

A product has the following demand history for the past six months:
 $$\begin{array} { | c | c | } 
\hline \text { January } & 212 \
\hline \text { February } & 201 \
\hline \text { March } & 242 \
\hline \text { April } & 188 \
\hline \text { May } & 198 \
\hline \text { June } & 208 \
\hline
\end{array}$$ 
A) Using a 4-month moving average, find the July forecast.
B) Using a weighted moving average with weights of 0.5, 0.3, and 0.2, find the July forecast.
C) Using exponential smoothing with α = 0.2 and a June forecast of 196, find the July forecast.

Quizplus · Accepted Answer

The Answer of A product has the following demand history for the past six months:
 $$\begin{array} { | c | c | } 
\hline \text { January } & 212 \
\hline \text { February } & 201 \
\hline \text { March } & 242 \
\hline \text { April } & 188 \
\hline \text { May } & 198 \
\hline \text { June } & 208 \
\hline
\end{array}$$ 
A) Using a 4-month moving average, find the July forecast.
B) Using a weighted moving average with weights of 0.5, 0.3, and 0.2, find the July forecast.
C) Using exponential smoothing with α = 0.2 and a June forecast of 196, find the July forecast.

A Product Has the Following Demand History for the Past