Question: Just B and C , please put in Excel Plot the tracking signals for each forecast and evaluate the movement of the signal. Assume that

Just B and C , please put in Excel Just B and C , please put in Excel Plot the tracking

Plot the tracking signals for each forecast and evaluate the movement of the signal. Assume that the analyst would flag forecasts with signals that are greater than 3 or less than -3 . Which product(s) should be reviewed immediately for potential forecasting issues? Discuss the tracking signals for each and what the implications are. Here are the actual tabulated demands for an item for a nine-month period (January through September). Your supervisor wants to test two forecasting methods to see which method was better over this period. a. Forecast April through September using a three-month moving average. b. Use simple exponential smoothing with an alpha of 0.3 to estimate April through September, using the average of January through March as the initial forecast for April. c. Use MAD to decide which method produced the better forecast over the six-month period

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!