Numbers File Edit Insert G 1 11%O Thu 5:28 PM Q = Edited Table Format Arrange View Share Window Help Individual Assignment 7_Ch3 Forecasting xv 1 Formula Table Chart Text Shape Media Comment ? 125% Zoom 6 Share 1 Format Sort & Filter Tips View + Prob Set 3 Prob Set 4 Prob Set 5 Prob Set 6 Prob Set 7 Tableau Forecasting Ex Problem Set 6 Calculate the simple three-month moving average forecast for April through December. What is the forecast for December? Calculate the weighted three-month moving average using weights of 0.50 (t-1), 0.30 (t-2), and 0.20 (t-3) for April through December. What is the forecast for December? Calculate the single exponential smoothing forecast for February through December using an initial forecast (F1=F-January) of 63. (Use alpha of 0.2) What is the forecast for December? Calculate the mean absolute deviation (MAD) for the forecasts made by each technique in April through December. Which forecasting method do you prefer? 0.2 FORECAST 3-WMA 3-MA Abs. Dev Smoothing constant (a): 3-WMA ES (0.20) Abs. Dev Abs. Dev 3-MA ES (0.20) 63 ACUAL DEMAND 58 67 69 Weight 0.2 0.3 0.5 62 66 MONTH January February March April May June July August September October November December 78 75 79 86 79 88 89 MAD Hybri 15 nent_R PM.pdf