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 ACTUAL DEMAND 64 67 69 65 71 23 76 77 77 02 83 85 7 B 9 10 11 12 o, Calculate the simple three month moving average forecast for perlods 4-12. (Round your answers to 3 decimal places.) Month 4 5 6 7 Three Month Moving Average - 69.667 71.000 72 333 72.667 74 333 75.667 78 667 81.667 B 9 10 18 7 8 9 10 72.667 74.333 75.667 78.667 81.667 34.000 11 12 b. Calculate the weighted three-month moving average for periods 4-12 using weights of 0.30 (for the period 2-1): 0.20 (for the period 1-2), and 0.50 (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 0 10 11 12 c. Calculate the single exponential smoothing forecast for periods 2-12 using an initial forecast (F) of 63 and an a of 0.40. (Do not round intermediate calculations. Round your answers to 3 decimal places.) Month Single Exponential Smoothing Forecast 2 3 4 5 5 7 B 9 10 11 12 d. Calculate the exponential smoothing with trend component forecast for periods 2-12 using an initial trend forecast (T7 of 1.60, an initial exponential smoothing forecast (F4 of 62, an a of 0.40, and a 8 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 Absoluto 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 Exponential smoothing with trend forecast Three-month moving average