Please do not copy other Chegg answers

Problem 3-22 (Algo) 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 ACTUAL DEMAND 53 56 58 65 74 75 76 77 77 79 81 82 9 10 11 12 a. Calculate the simple three-month moving average forecast for periods 412. (Round your answers to 3 decimal places.) Answer is complete and correct. Month Three-Month Moving Average 55.666 4 5 59.666 6 65.666 7 71.333 8 75.000 9 76.000 10 76.666 11 77.666 12 79.000 b. Calculate the weighted three-month moving average for periods 412 using weights of 0.60 (for the period t-1); 0.20 (for the period t-2), and 0.20 (for the period t3). (Do not round intermediate calculations. Round your answers to 1 decimal place.) Answer is complete and correct. Month Three-Month Weighted Moving Average 4 56.6 5 61.8 6 69.0 7 72.8 8 75.4 9 76.4 10 76.8 11 78.2 C. Calculate the single exponential smoothing forecast for periods 212 using an initial forecast (1) of 61 and an a of 0.30. (Do not round intermediate calculations. Round your answers to 3 decimal places.) Answer is complete and correct. Month Single Exponential Smoothing Forecast 2 58.600 3 57.820 4 57.874 5 60.012 6 64.208 7 67.446 8 70.012 9 72.108 d. Calculate the exponential smoothing with trend component forecast for periods 212 using an initial trend forecast (T1) of 1.70, an initial exponential smoothing forecast (F1) of 62, an a of 0.30, and a d of 0.20. (Do not round intermediate calculations. Round your answers to 3 decimal places.) Answer is not complete. Month Three-Month Weighted Moving Average 61.550 2 3 59.300 x 4 5 59.150 x 6 7 8 e-1. Calculate the mean absolute deviation (MAD) for the forecasts made by each technique in periods 412. (Do not round intermediate calculations. Round your answers to 3 decimal places.) Answer is complete but not entirely correct. Mean Absolute Deviation 2.704 X 1.622 x Three-month moving average Three-month weighted moving average Single exponential smoothing forecast Exponential smoothing with trend 4.829 X .910 x