Problem 11-21 (Algo) 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 54 2 38 3 25 4 20 Use a production lot size of 73 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.) please show all you work . need answers for projected on hand inventory and mps and ATP

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: Use a production lot size of 73 units and no beginning inventory. (In the ATP row, enter a value of O (zero) in any periods where ATP should not be calculated. Leave no cells blank - be certain to enter "0" wherever reautirad