Question

clear hand writing

AlwaysRain Imigation, Inc., would Ike 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 DEMANDE 2 UN 000s) 43 1 (N 000s) 3 IN 000s) 4 (IN 000s) 57 Plastic 90 Plastic 180 33 54 16 14 19 18 66 16 Plastic 360 Bronze 90 Bronze 180 7 12 15 Bronze 360 12 18 Both production lines can produce all the different types of nozzles. The bronze machines needed for the bronze sprinklers require four operators and can produce up to 17.000 sprinklers. The plastic injection molding machine needed for the plastic sprinklers requires three operators and can produce up to 275,000 sprinklers Three bronze machines and only one injection molding machine are available. What are the capacty requirements for the nexxt four years? (Assume that there is no learning) (Enter the demand values in thousands. Round your answers to 2 decimal places.) Year 1 Year 2 Year 31 Year 4 Plastic Demand for plastic sprinklers Percentage of capacity used Machine requirements Labor requiremerts Bronze Demand for bronze spriniders Percentage of capacity used Machine requirements Labor requirementsa

Answer 1

		Available capacities	A	B	C=A*B
			Capacity per machine	Number of machines	Total Capacity
		Plastic Sprinklers	275,000	1	275,000
		Bronze Sprinklers	17,000	3	51,000
			Demand (in thousands)
			Year1	Year2	Year3	Year4
		Total Plastic Sprinkler Demand	(33+14+48)=95	(43+16+54)=113	(54+19+66)=139	(57+18+66)=141
		Total Bronze Sprinkler Demand	(7+5+12)=24	(6+5+15)=26	(9+7+18)=34	(16+12+19)=47
			Year1	Year2	Year3	Year4
		Plastic
	A	Demand for plastic sprinklers	95000	113000	139000	141000
	B=(A/275000)*100	Percentage of capacity Used	35%	41%	51%	51%
	C	Machine Requirement	1	1	1	1
	D=C*3	Labor Requirement	3	3	3	3
		Brone
	E	Demand for Bronze sprinklers	24000	26000	34000	47000
	F=(E/51000)*100	Percentage of capacity Used	47%	51%	67%	92%
	G=E/17000(Rounded to higher whole number)	Machine Requirement	2	2	2	3
	H=G*4	Labor Requirement	8	8	8	12