Problem 18-22 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. 300 Pri references MONTH ACTUAL DEMAND 1 63 2 66 3 68 4 69 5 71 6 74 7 77 8 78 9 78 10 81 11 83 12 84 a. Calculate the simple three-month moving average forecast for periods 4-12. (Round your answers to 3 decimal places.) Month Three-Month Moving Average 4 5 6 17 B 19 10 11 12 neck my work 8 b. Calculate the weighted three month moving average for periods 4--12 using weights of 0.40 (for the period 2-1); 0.30 (for the period t-2), and 0.30 (for the period 1-3). (Do not round intermediate calculations. Round your answers to 1 decimal place.) 1 points Month eBook Three Month Weighted Moving Average 4 5 References 6 7 8 9 10 11 12 c. Calculate the single exponential smoothing forecast for periods 2-12 using an initial forecast (F) of 62 and an a c. Calculate the single exponential smoothing forecast for periods 2-12 using an initial forecast (Ff of 62 and an a of 0.20 (Do not round intermediate calculations. Round your answers to 3 decimal places.) Month Single Exponential Smoothing Forecast 2 OK w 3 rences 5 6 7 B 10 11 12 1 paints d. Calculate the exponential smoothing with trend component forecast for periods 2-12 using an initial trend forecast (Tg of 170. an initial exponential smoothing forecast (Fs of 61. an a of 0.20, and a 5 of 0.40. (Do not round intermediate calculations. Round your answers to 3 decimal places.) Pa Month Exponential Smoothing with Trend References 2 3 4 5 6 7 8 10 11 12 e-1. Calculate the mean absolute deviation (MAD) for the forecasts made by each technique in periods 4-12. (Do not round intermediate calculations. Round your answers to 3 decimal places.) Mean Absolute Deviation Three-month moving average Three-month weighted moving average Single exponential smoothing forecast Exponential smoothing with trend Book Print references e-2. Which forecasting method do you prefer? Three-month moving average Three-month weighted moving average Single exponential smoothing forecast Exponential smoothing with trend forecast