Calculate Three Forecasts Using the Following Data $\mathrm { F } _ { 3 }$

Essay

Calculate three forecasts using the following data.First,for periods 4 through 11,develop the exponentially smoothed forecasts using a forecast for period 3 ( $\mathrm { F } _ { 3 }$ )of 120.0 and an alpha of 0.3.Second,calculate the 3-period moving average forecast for periods 4 through 11.Third,calculate the weighted moving average for periods 4 through 11,using weights of .60,.30,and .10.Calculate the mean absolute deviation (MAD)and the cumulative sum of forecast error (CFE)for each forecasting procedure.Which forecasting procedure would you select? Why?
$$\begin{array} { | c | c | } \hline \text { Month } & \text { Demand } \\\hline 1 & 120 \\2 & 115 \\3 & 125 \\4 & 119 \\5 & 127 \\6 & 114 \\7 & 120 \\8 & 124 \\9 & 116 \\10 & 137 \\\hline\end{array}$$