MONTH 1 2 3 4 5 6 7 B 9 10 11 12 ACTUAL DEMAND 59 65 65 67 71 70 77 77 77 75 83 81 a. Calculate the simple three-month moving average forecast for periods 412. (Round your answers to 3 decimal places.) Month 4 5 6 7 8 Three-Month Moving Average 63.000 65.667 67.667 69.333 72.667 74,667 77.000 76.333 78.333 9 10 11 12 b. Calculate the weighted three-month moving average for periods 4-12 using weights of 0.50 (for the period (-1); 0.30 (for the period t-2), and 0.20 (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 9 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.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 212 using an Initial trend forecast (Tp of 160, an initial exponential smoothing forecast (F) of 62, an a of 0.20, and a 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