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?

*Please show excel formulas

J 0.2 11 MONTH 3-MA 3-WMA B C D E F G H 1 Problem Set 6 2 Calculate the simple three-month moving average forecast for April through December. What is the forecast for 3 December? 4 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 5 through December. What is the forecast for December? 6 Calculate the single exponential smoothing forecast for February through December using an initial forecast (F1=F- 7 January) of 63. (Use alpha of 0.2) What is the forecast for December? 8 calculate the mean absolute deviation (MAD) for the forecasts made by each technique in April through December. 9 Which forecasting method do you prefer? 10 Smoothing constant (a): FORECAST 3-MA 3-WMA ES (0-20) 12 ACUAL DEMAND ES (0.20) Abs. Dev Abs. Dev Abs. Dev 13 January 59 63 February 65 15 March 65 16 April 67 17 65 18 June 70 19 July 73 20 August 77 21 September 80 22 October 75 23 November 85 24 December 81 25 Weight 0.2 0.3 14 0.5 May MAD