Problem 3-22 (Static) 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. MONTH 1 3 ACTUAL DEMAND 62 65 67 68 71 73 76 78 78 6 BEWUN ubmw 9 le 11 12 84 85 incimal places b. Calculate the weighted three month moving average for the periods 4-12 using weights of 0.50 (for the period -15.0.30 (for the period t-2) and 0.20 (for the period 1-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 {Fof 61 and an a of030. (Round your answers to 3 decimal places.) Month Single Exponential Smoothing Forecast 2 3 4 5 6 7 8 9 10 11 12 Ro d. Calculate the exponential smoothing with trend component forecast for periods 2-12 using an initial trend forecast (Tof 18 an initial exponential smoothing forecast (Fof 60, and of 0.30, and a 8 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 Next 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