Question: Question 17 (3 points) Suppose that an operations manager is trying to determine what forecasting method to use for the following forecasting problem. Based on





Question 17 (3 points) Suppose that an operations manager is trying to determine what forecasting method to use for the following forecasting problem. Based on the following historical data, calculate the following forecasts and specify which forecasting method you would utilize. Actual Demand Month 63 1 2 3 65 3882 4. 5 6 68 70 73 75 We can calculate the weighted 3-month forecasts using weights of 0.6, 0.3, and 0.1 for periods 4-6. In particular, the forecast for period 6 is 66.6 65 au AWN 2 3 4. 5 6 3682 70 73 75 We can calculate the weighted 3-month forecasts using weights of 0.6, 0.3, and 0.1 for periods 4-6. In particular, the forecast for period 6 is 66.6 68.9 71.6 0 71.4 Question 18 (4 points) Refer to the information in 117 Question 18 (4 points) Refer to the information in Q17. We can calculate the double exponential smoothing forecasts for periods 2-6 using an initial trend forecast (T) of 1.8, and initial exponential smoothing forecast (S1) of 60, an a of 0.30 and a B of 0.30. In particular, the forecast for period 3 is 64.8480 68.1653 71.2525 of 0.30 and a of 0.30. In particular, the forecast for period 3 is 64.8480 68.1653 71.2525 74.4708 Question 19 (3 points) Question 19 (3 points) Refer to your calculations in Q17 and Q18, Calculate the Mean Absolute Deviation (MAD) for the forecasts made by the above each technique in periods 5 and 6. Which forecasting method is better in terms of MAD performance measure? weighted 3-month method 3 double exponential smoothing method
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
