***ANSWER ONLY AND ONLY IN EXCEL DO NOT COPY, I NEED CLEAR ANSWER, DO NOT COPY FROM OTHERCHEGG SOLUTIONS I NEED CLEARV SOLUTION. IF NOT ILL REPORT YOU.

***ANSWER ONLY AND ONLY IN EXCEL DO NOT COPY, I NEED CLEAR ANSWER, DO NOT COPY FROM OTHERCHEGG SOLUTIONS I NEED CLEARV SOLUTION. IF NOT ILL REPORT YOU.

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 bromze sprinkders require three operators and can produce up to 15,000 sprinklers. The plastic injection molding machine needed for the plastic spriniklers requires five operators and can produce up to 235,000 sprinkders. 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 leaming) (Enter the demand values in thousands. Round your answers to 2 decimal places.)