Problem 11-21

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 75 units and no beginning inventory. (Leave no cells blank - be certain to enter "0" wherever required.)

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