In: Operations Management
Prepare a master production schedule for industrial pumps in the
manner of the following table. Use the MPS rule to "schedule
production when the projected on-hand inventory would be less than
10 without production.". Suppose that there are currently 64 pumps
in inventory and a production lot size of 70 pumps is used.
(Leave no cells blank - be certain to enter "0" wherever
required.)
June | July | ||||||||
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | ||
Forecast | 30 | 30 | 30 | 30 | 40 | 40 | 40 | 40 | |
Customer orders (committed) | 33 | 20 | 10 | 4 | 2 | ||||
Projected on-hand inventory | |||||||||
MPS | |||||||||
ATP | |||||||||