Problem 11-21 (Algo) Prepare a master schedule given this information: The forecast for each week of an eight-week schedule is 65 units. The MPS rule is to schedule production if the projected on hand inventory would be negative without it. Customer orders (committed) are as folows: Week customer Orders 28 3 36 1 2 Use a production lot size of 80 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 "O" wherever required.) June My 4 5 7 B Forecast 55 55 55 55 55 56 Customer Orders 28 4 0 0 0 Projected On Hand Inventory MPS 55 1 ATP Problem 11-21 (Algo) Prepare a master schedule given this information: The forecast for each week of an eight-week schedule is 55 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: Customer orders Week 1 2 3 36 28 Use a production lot size of 80 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.) July June 2 3 4 5 6 7 B 55 55 55 36 55 28 55 4 55 1 55 0 55 0 0 O Forecast Customer Orders Projected On-Hand Inventory MPS ATP