Prepare a master schedule given this information: The forecast for each week of an eight-week schedule is 50 units. The MPS rule is to schedule production if the projected on-hand inventory would be negative without it. Customer orders (committed) are follows:
Week ______________Customer Order
1...................................52
2...................................35
3...................................20
4...................................12
Use a production lot size of 74 units and no beginning inventory. (Leave no cells blank - be certain to enter "0" wherever required.)

June July 5 4 3 8 50 50 50 50 50 50 Forecast 50 Customer Orders 35 52 20 12 Projected on-hand inventory MPS ATP 2.