Master production schedule
July 11th, 2022
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 a production lot size of 70 pumps is used. (Leave no cells blank – be certain to enter “0” wherever required.) |
June |
July |
||||||||
64 | 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 | [removed] | [removed] | [removed] | [removed] | [removed] | [removed] | [removed] | [removed] | |
MPS | [removed] | [removed] | [removed] | [removed] | [removed] | [removed] | [removed] | [removed] | |
ATP | [removed] | [removed] | [removed] | [removed] | [removed] | [removed] | [removed] | [removed] | |
|