1 Use the Historical demand data below to calculate THREE forecasts. 1) 3 Period Simple moving average 2) 3 Period Weighted moving average using weights of .5, .3,.2 (the highest weight being associated with the most recent months) and 3) Exponential Smoothing forecast using an Alpha of .3. and a Week 3 forecast of 600 units. For each of the 3 forecasts calculate the Mean Absolute Deviation, Mean Squared Error and Mean Absolute Percent Error. Use the ABS formula for Absolute Value. NOTE: You will fill in the only the cells in grey. Use formulas for each calculation. For the perecentages, please leave your answer in decimal points (e.g. 10.38% = 0.1038)

\begin{tabular}{|c|c|} \hline Week & Demand \\ \hline 1 & 420 \\ \hline 2 & 485 \\ \hline 3 & 615 \\ \hline 4 & 675 \\ \hline 5 & 550 \\ \hline 6 & 460 \\ \hline 7 & 435 \\ \hline 8 & 545 \\ \hline 9 & 620 \\ \hline 10 & 600 \\ \hline 11 & 765 \\ \hline 12 & 615 \\ \hline \multicolumn{2}{|c|}{ MAD } \\ \hline \multicolumn{2}{|c|}{ MSE } \\ \hline \multicolumn{2}{|c|}{ MAPE } \\ \hline \multicolumn{3}{|c|}{} \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|l|l|} \hline \multicolumn{7}{|c|}{ WEIGHTED MOVING AVERAGE (WMA) } \\ \hline \multicolumn{2}{|c|}{ Abs (et) } & e & (et)2 & \\ \hline \end{tabular}