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

1. alwaysrain irrigation, inc. would like to determine capacity requirements for the next four years. currently, two production lines are in place for making bronze and plastic sprinklers. three types of sprinklers are available in both bronze and plastic: 90-degree nozzle sprinklers, 180-degree nozzle sprinklers, and 360-degree nozzle sprinklers. management has forecast demand for the next four years as follows: both production lines can produce all the different types of nozzles. the bronze machines needed for the bronze sprinklers require two operators and can produce up to 12,000 sprinklers. the plastic injection molding machine needed for the plastic sprinklers requires four operators and can produce up to 200,000 sprinklers. three bronze machines and only one injection molding machine are available. what are the capacity requirements for the next four years? (assume that there is no learning.)