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|} \hline MAD \\ \hline MSE \\ \hline MAPE \\ \hline \end{tabular} Q2 Which of the above 3 methods above /SMA vs WMA vS FS) is the most accurate and why? Please write vour rational in text