Prepare a master schedule given this information: The forecast for each week of an eight-week schedule is 60 units. The MPS rule is to schedule production if the projected on-hand inventory would be negative without it. Customer orders (committed) are as follows:

Week	Customer Orders
1	36
2	28
3	4
4	1

	June				July
	1	2	3	4	5	6	7	8
Forecast	60	60	60	60	60	60	60	60
Customer Orders	36	28	4	1	0	0	0	0
Projected On-Hand Inventory
MPS
ATP

Use a production lot size of 120 units and no beginning inventory. (In the ATP row, enter a value of 0 (zero) in any periods where ATP should not be calculated. Leave no cells blank - be certain to enter "0" wherever required.)