Problem 18-22 (Algo) Your manager is trying to determine what forecasting method to use. Based on the following historical data, calculate the following forecasts and specify what procedure you would utilize. MONTH 1 2 3 4 5 6 7 8 9 10 11 12 ACTUAL DEMAND 52 55 57 67 73 75 76 77 77 79 80 82 a. Calculate the simple three-month moving average forecast for periods 412. (Round your answers to 3 decimal places.) Answer is complete but not entirely correct. Three-Month Month Moving Average 4 12.333 X 5 13.333 X 6 9.333 X 7 4.333 X 8 2.333 X 9 1.000 X 10 2.333 X 11 2.333 X 12 3.333 X b. Calculate the weighted three-month moving average for periods 412 using weights of 0.40 (for the period t-1); 0.30 (for the period t-2), and 0.30 (for the period t-3). (Do not round intermediate calculations. Round your answers to 1 decimal place.) Answer is complete but not entirely correct. Three-Month Weighted Month Moving Average 4 12.1X 5 12.6 x 6 8.6 X 7 4.0 X 8 2.2x 9 0.9 X 10 2.3 x 11 22x 12 3.2 X c. Calculate the single exponential smoothing forecast for periods 212 using an initial forecast (F) of 62 and an a of 0.20. (Do not round intermediate calculations. Round your answers to 3 decimal places.) X Answer is complete but not entirely correct. Single Exponential Month Smoothing Forecast 2 10.000 X 3 5.000 X 4 2.000 X 5 8.400 X 6 12.720 X 7 12.176 X 8 10.741 X 9 9.593 X 10 7.674X 11 7.511 X 12 8.009 X d. Calculate the exponential smoothing with trend component forecast for periods 212 using an initial trend forecast (T) of 1.80, an initial exponential smoothing forecast (F) of 61, an a of 0.20, and a 8 of 0.30. (Do not round intermediate calculations. Round your answers to 3 decimal places.) > Answer is complete but not entirely correct. Month 2 3 4 5 6 Exponential Smoothing with Trend 6.792 X 4.178 X 6.164 X 10.067 X 8.586 X 5.886 X 3.373 X 0.160X 0.420 X 1.859 X 1.898 X 7 8 9 10 11 12