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 8 9 10 12 12 ACTUAL DEMAND 63 64 68 67 72 71 72 77 77 79 85 87 a. Calculate the simple three-month moving average forecast for periods 4-12. (Round your answers to 3 decimal places.) Three-Month Moving Average Month 4 5 6 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 t-1); 0.20 (for the period 1-2), and 0.30 (for the period 1-3). (Do not round intermediate calculations. Round your answers to 1 decimal place.) Month Three Month Weighted Moving Average 4 5 6 7 8 10 11 12 c. Calculate the single exponential smoothing forecast for periods 2-12 using an initial forecast (F) of 64 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 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 (T4 of 1.80, an initial exponential smoothing forecast (F) of 63, an a of 0.20, and a 7 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 0 7 B 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 e-2. Which forecasting method is best? Three-month weighted moving average Single exponential smoothing forecast Three-month moving average Exponential smoothing with trend forecast