Your manager is trying to determine what forecasting method to use. Based on the following historical data, calculate the following forecast and specify what procedure you would utilize HONTH 1 2 3 4 5 6 7 5 9 10 11 12 ACTUAL DEMAND 62 65 67 68 71 73 76 78 78 80 84 85 a. Calculate the simple three month moving average forecast for periods 4-12. (Round your answers to 3 decimal places.) b. Calculate the weighted three month moving average for the periods 4-12 using weights of 0.50 (for the period -1); 0.30 (for the period (-2) and 0.20 (for the period -3), (Round your answers to 1 decimal place.) Month Three Month Weighted Moving Average 4 5 6 7 8 9 10 11 12 c. Calculate the single exponential smoothing forecast for periods 2-12 using an initial forecast (F) of 61 and an a of 0.30. (Round your answers to 3 decimal places.) Month Single Exponential Smoothing Forecast 2 3 5 6 7 8 9 10 11 12 d. Calculate the exponential smoothing with trend component forecast for periods 2-12 using an initial trend forecast (T) of 18 an Initial exponential smoothing forecast (F) of 60, an a of 0.30, and a 5 of 0.30 (Round your answers to 3 decimal places.) Month Exponential Smoothing with Trend 2 3 4 5 6 7 8 9 10 11 12 e-1. Calculate the mean absolute deviation (MAD) for the forecasts made by each technique in periods 4-12. (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