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 ACTUAL MONTH DEMAND 59 65 65 67 71 70 6 7 75 83 81 10 a. Calculate the simple three-month moving average forecast for periods 4-12. (Round your answers to 3 decimal places.) Three-Month Month Moving Average 63 65.667 67.667 69.333 72.667 74,667 10 76.333 78.333 12 b. Calculate the weighted three-month moving average for 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). (Do not round intermediate calculations. Round your answers to 1 decimal place.) Three-Month Weighted Moving Average Month 63.8 68.6 69.7 73.7 75.6。 77.0 10 76。 79.4 12
