A company has just received a contract to construct frames for automobiles that are to be produced in Tennessee. The manufacturer has strict quality control standards for all of its components subcontractors and his informed the company that each frame must have the steel content shown in the table. The company combines eight different materials to produce one ton of steel used in the frames. The table includes details for these materials. In addition, each ton of steel must include at least 100 pounds of an Alloy, at least 200 pounds of Iron, and at least 150 pounds of a Carbide.

Formulate and solve the model that will determine how much each of the materials should be blended into a one-ton (2000 pounds) load of steel so that the company meets the requirements while minimizing costs.

EXCEL SOLVER SOLUTION ONLY PLEASE!!!!!!!!

Materials Available		Manganese (%)	Silicon (%)	Carbon (%)	Pounds available	Cost per pound
A	Alloy 1	70.0%	15.0%	3.0%	No limit	$0.12
B	Alloy 2	55.0%	30.0%	1.0%	300	$0.13
C	Alloy 3	12.0%	26.0%	0.0%	No limit	$0.15
D	Iron 1	1.0%	10.0%	3.0%	No limit	$0.09
E	Iron 2	5.0%	2.5%	0.0%	No limit	$0.07
F	Carbide 1	0.0%	24.0%	18.0%	50	$0.10
G	Carbide 2	0.0%	25.0%	20.0%	200	$0.12
H	Carbide 3	0.0%	23.0%	25.0%	100	$0.09
Steel Content
	Min percent	3.0%	4.0%	1.0%
	Max percent	5.0%	6.0%	3.0%