Your manager is trying to determine what forecasting method to use. Based upon the following historical data, calculate the following forecast and specify what procedure you would utilize. MONTH 1 2 3 4 5 6 7 B 9 10 11 12 ACTUAL DEMAND 59 65 65 67 71 20 77 77 77 75 83 81 a. Calculate the simple three-month moving average forecast for periods 4-12. (Round your answers to 3 decimal places.) Month 4 Three-Month Moving Average 5 7 8 9 10 11 12 b. Calculate the weighted three-month moving average for periods 4-12 using weights of 0.50 (for the period 2-1); 0.30 (for the period t-2), and 0.20 (for the period (-3). (Do not round intermediate calculations. 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 (Ff of 63 and an a of 0.20. (Do not round intermediate calculations. Round your answers to 3 decimal places.) Month Single Exponential Smoothing Forecast 2 3 4 5 B 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 1.60, an Initial exponential smoothing forecast (F) of 62, an a of 0.20, and a 5 of 0.30. (Do not round intermediate calculations. Round your answers to 3 decimal places.) Month Three-Month Weighted Moving Average 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. (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