UUANT PROBLEMS (CHAP 18) i Saved Help Save & Exit You skipped this question in the previous attempt. Check 6 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, 2 points eBook MONTH 1 2 3 4 5 6 7 8 9 10 11 12 ACTUAL DEMAND 62 65 67 68 71 73 76 78 78 80 84 85 References a. Calculate the simple three-month moving average forecast for periods 412. (Round al calculations to 3 decimal places.) Month Three-Month Moving Average 4 5 6 7 8 You skipped this question in the previous attempt. b. Calculate the weighted three-month moving average for the periods 4-12 using weights of 0.50 (for the period t-1); 0.30 (for the period t-2) and 0.20 (for the period t-3). (Round all calculations to 3 decimal places.) Month Three-Month Weighted Moving Average s 4 5 eBook 6 ferences 7 8 9 10 11 12 c. Calculate the single exponential smoothing forecast for periods 2-12 using an initial forecast (F) of 61 and an a of 0.30. (Round all calculations to 3 decimal places.) c. Calculate the single exponential smoothing forecast for periods 212 using an initial forecast (F) of 61 and an a of 0.30. (Round all calculations to 3 decimal places.) Month Single Exponential Smoothing Forecast 2 k 3 aces 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 (T1) of 1.8, an initial exponential smoothing forecast (F) of 60. an a of 0.30, and a 8 of 0.30. (Round your answers to 3 decimal places.) Exponential Smoothing a. Calculate the exponential Smoothing with trena component forecast for perious 2-12 using an initial trend forecast ( 1 O 1.8, an initial exponential smoothing forecast (F) of 60, an a of 0.30, and a 5 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 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 Help S You skipped this question in the previous attempt. 121 e-1. Calculate the mean absolute deviation (MAD) for the forecasts made by each technique in periods 412. (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 do you prefer? Three-month moving average O Exponential smoothing with trend forecast O Three-month weighted moving average O Single exponential smoothing forecast