Materials Mgmt- Zeek the Geek
ryleesimonee
2018MGMT4317Chapter8HomeworkProblems.docxMGMT 4317 Chapter 8 Homework Problems – You must show all work in all problems to receive credit. You will receive zero (0) credit for providing the answer only.
1. Demand over past 3 months has been 250, 210, and 224 units. Using a three-month moving average, determine the forecast for month four. If the actual demand in month 4 is 264, calculate the forecast for month 5.
2. Given the following data, calculate the three-month moving average forecasts for months 4, 5, 6, and 7.
|
Month |
Actual Demand |
Forecast |
|
1 |
65 |
|
|
2 |
80 |
|
|
3 |
50 |
|
|
4 |
45 |
|
|
5 |
60 |
|
|
6 |
70 |
|
|
7 |
|
|
3. If the forecast for May was 222, and the actual demand for May is 235, what would be the forecast for June if the smoothing constant (alpha) is .20? If June demand is actually 290, calculate forecast for July.
4. Given the following average demand, calculate the seasonal indices for each quarter:
|
Quarter |
Average Demand |
Seasonal Index |
|
1 |
164 |
|
|
2 |
480 |
|
|
3 |
490 |
|
|
4 |
170 |
|
|
Total |
|
|
Note that your answer, if calculated correctly, should have all of the seasonal indices add up to the number of quarters in the entire season.
5. Using the data in problem 4, and the seasonal indices you have calculated, calculate expected quarterly demand if the annual forecast is 2000 units.
|
Quarter |
Seasonal Index |
Forecast |
|
1 |
|
|
|
2 |
|
|
|
3 |
|
|
|
4 |
|
|
6. Calculate the deseasonalized demands for the following:
|
Quarter |
Annual Demand |
Seasonal Index |
Deseasonalized Demand |
|
1 |
130 |
0.70 |
|
|
2 |
170 |
1.00 |
|
|
3 |
375 |
1.80 |
|
|
4 |
90 |
0.50 |
|
|
Total |
|
|
|
7. For the following data, calculate the mean absolute deviation (MAD).
|
Period |
Forecast |
Actual Demand |
Absolute Deviation |
|
1 |
100 |
80 |
|
|
2 |
100 |
110 |
|
|
3 |
100 |
130 |
|
|
4 |
100 |
75 |
|
|
5 |
100 |
105 |
|
|
Total |
|
|
|
8. A company uses a tracking signal trigger of + or – 4 to decide whether a forecast should be reviewed. Given the following history, determine in which period the forecast should be reviewed. Mean Absolute Deviation (MAD) for the item is 15. Is there any previous indication that the forecast should be reviewed?
|
Period |
Forecast |
Actual |
Deviation |
Cumulative Deviation |
Tracking Signal |
|
1 |
100 |
110 |
|
|
|
|
2 |
105 |
90 |
|
|
|
|
3 |
110 |
85 |
|
|
|
|
4 |
115 |
110 |
|
|
|
|
5 |
120 |
105 |
|
|
|
|
6 |
125 |
95 |
|
|
|
