Question: DO THIS IN EXCEL PLEASE! AlwaysRain Irrigation, Inc. would like to determine capacity requirements for the next four years. Currently, two production lines are in

DO THIS IN EXCEL PLEASE!
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.)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
