A G 0.2 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 (1-1), 0.80 (1-2), and 0.20 (1-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? Smoothing constant (a): FORECAST 3-MA 3-WMA ES (0-20) MONTH ACUAL DEMAND MA 3-WMA ES 20 Abs. Dev Abs. De Abs. Dev January S8 63 February March 69 April 62 May 66 June 78 July 75 August 79 September 86 October 79 November 88 December 89 Weight 0.2 0.3 0.5 MAD