Question: Please answer all the questions above Two experienced managers at Wilson Boat Inc. are resisting the introduction of a computerized exponential smoothing system, claiming that


Please answer all the questions above
Two experienced managers at Wilson Boat Inc. are resisting the introduction of a computerized exponential smoothing system, claiming that their judgmental forecasts are much better than any computer could do. Their past record of predictions is as follows: Week Actual Demand Manager's Forecast 1 4,000 4,300 2 4,100 4,600 3 4,300 3,900 4 2,800 3,800 5 3,600 3,300 6 5,500 4,500 7 5,700 4,600 8 4,200 4,600 9 5,500 4,500 10 4,700 5,200 a. How would the manager's forecast compare to a single exponential smoothing forecast using a = 0.2? Do not round intermediate calculations. Round your answers to two decimal places. The MSE value based on the manger's forecast is The MSE value based on the single exponential smoothing forecast using a = 0.2 is The -Select- should be chosen based on MSE value. b. Find the best single exponential smoothing model by evaluating the MSE from 0.1 to 0.9, in increments of 0.1. Do not round intermediate calculations. Round your answers to two decimal places. Alpha MSE 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 The model based on a smoothing constant of -Select- is the best. How does this model compare with the manager's forecast? The -Select- has the lowest MSEStep 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
