a1 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 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) 5,3,.2 WEIGHTED MOVING AVERAGE (WMA) Abs (e) laj' (Abs(e)/D,x100% Alpha-3 EXPONENTIAL SMOOTHING (ES) Abs (e) (e 600 Week Demand SIMPLE MOVING AVERAGE (SMA) 123456789012 430 3 Period Abs (e) lej [Abs(e)/D,x100% 490 630 610 (430+490+630)/3=516.67 550 (490+630+610)/3=576.67 470 (630+610+550)/3=596.67 445 (610+550+470)/3=543.33 520 620 500 635 560 (550+470+445)/3=488.33 (470+445+520)/3=478.33 (445+520+620)/3 = 528.33 (520+620+500)/3-546.67 (620+500+635)/3 = 585 Q2 MAD MSE MAPE [(630 0.5)+(490*0.3)+(430*0.2)) [(610*0.5)+(630*0.3)+(490*0.2)) [(550 0.5)+(610*0.3)+(630*0.2)] (470 0.5)+(550*0.3)+(610*0.2)] ((445 0.5)+(470*0.3)+(550*0.2) Which of the above 3 methods above (SMA vs. WMA vs. ES) is the most accurate and why? Please write your rational in text box below.