please explain the answer with an excel formula

10 Mod 21 1 T " . W 4 MAL M MAY Asher NOTE TH 41 A 430 Au 306 410 46 3 sek 3 411 ENHE P Tven 1h 33. gr Med be PAL pertapes, alg WE RACEWA W Mw M TAPINDO. M Maton 13 H 35 18 12 18 23 23 221 23 24 75 25 21 25 30 31 01 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, .32 and 3) Exponential 5mnd 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 form 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) Werk Demand SIMPLE MOVING AVERAGE (SMA WEIGHTED MOVING AVERAGE (WMA) Abs(n) Inj 1 430 3 Period e Abn (e) Inj Able/Dx100 5,3,2 Abel/Dx100 Alpha- 7 3 600 4 5 6: 7 1 9 10 11 12 MAD MSE MAPE 66935582288 610 470 445 500 560 recasts 113 Period Simple moving average 2) 3 Period Weighted moving average using weights of 3, -3,2 and 33 Exponential Smoothing forecast using of the 3 forecasts calculate the Mean Abute Deviation, Mean Squared Error and Mean Absolute Percent Error. Use the ABS formula for Absolute Vale s for each calculation. For the percentages, please leave your answer in decimal points (g. 10.38% -0.1038) AVERAGE MA Abe WEIGHTED MOVING AVERAGE (WMA Abs (e IN' DXPONENTIAL SMOOTHING An W Ahdinus SLI W Abination