please use excel to demonstrate answer with formula Question 4 and 5

question 4 capacity is Bronze 12,000/year with 2 operators and plastic 4 operators and 200,000 capacity.

LO4-2 4. Always Rain 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: YEARLY DEMAND 2 (IN 000s) 3 (IN 000s) 1 (IN 000s) 4 (IN 000s) Plastic 90 Plastic 180 Plastic 360 Bronze 90 Bronze 180 Bronze 360 12 Form 67 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.) 5. Suppose that Always Rain Irrigation's marketing department will undertake an intense ad campaign for the bronze sprinklers, which are more expensive but also more durable than the plastic ones. Forecast demand for the next four years is YEARLY DEMAND 2 (IN 000s) 3 (IN 000s) 1 (IN 000s) 4 (IN 000s) 32 50 67 Plastic 90 Plastic 180 Plastic 360 Bronze 90 Bronze 180 Bronze 360 23 16 What are the capacity implications of the marketing campaign (assume no learning)