Question: Please see the numbers correctly, as they are different from the other problems here. Thank you very much. Q2. Forecasting ABC Company is creating the

Please see the numbers correctly, as they are different from the other problems here. Thank you very much. Please see the numbers correctly, as they are

Q2. Forecasting ABC Company is creating the production plan for the coming month. The company has collected the following data on the average marketing demand during the past 21 months. Month 1 2 3 4 5 6 Demand 60 65 67 58 59 6 56 7 65 65 8 9 10 69 60 70 11 12 71 64 75 13 14 15 16 17 18 70 72 65 77 19 20 62 59 a. Using a three-month moving average, forecast demand for month 21. b. Using a three-month weighted average with the most recent month weighted 0.55, the next most recent month weighted 0.35, and the third month weighted 0.1, forecast the demand for month 21. c. Compute an exponentially smoothed forecasting using a = 0.32 and forecast the demand 21. d. Compare the forecast in (a), (b), and (c) using MAD. Indicate the most accurate forecasting method. e. Compute the tracking signal for the most accurate method (based on MAD value), and construct a control chart. Comment on the forecasting result

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!