**NEED IN EXCEL, DO NOT ANSWER IF YOU DONT KNOW.ILL REPORT YOU IF WRONG, NEED PROPER EXPLANATION.

**NEED IN EXCEL, DO NOT ANSWER IF YOU DONT KNOW.ILL REPORT YOU IF WRONG, NEED PROPER EXPLANATION.....

PROPER EXPLANATION ONLY IN EXCEL ** (DO NOT COPY FROM OTHER CHEGG ANSWERS, I DID NOT UNDERSTAND IT, SO IM POSTING AGAIN)

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:

	YEARLY DEMAND
	1 (IN 000s)	2 (IN 000s)	3 (IN 000s)	4 (IN 000s)
Plastic 90	32		42		57		54
Plastic 180	13		15		18		14
Plastic 360	51		57		67		65
Bronze 90	6		9		8		15
Bronze 180	4		4		6		11
Bronze 360	11		12		17		19

Both production lines can produce all the different types of nozzles. The bronze machines needed for the bronze sprinklers require three operators and can produce up to 16,000 sprinklers. The plastic injection molding machine needed for the plastic sprinklers requires four operators and can produce up to 270,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.) (Enter the demand values in thousands. Round your answers to 2 decimal places.)

**NEED IN EXCEL, DO NOT ANSWER IF YOU DONT KNOW.ILL REPORT YOU IF WRONG, NEED PROPER EXPLANATION.

**NEED IN EXCEL, DO NOT ANSWER IF YOU DONT KNOW.ILL REPORT YOU IF WRONG, NEED PROPER EXPLANATION.....

PROPER EXPLANATION ONLY IN EXCEL ** (DO NOT COPY FROM OTHER CHEGG ANSWERS, I DID NOT UNDERSTAND IT, SO IM POSTING AGAIN)