minimize costs using Excel and Solver. please show all of the values in excel and the equations.

34 A steel company is producing steel for a new contract The contract specifies the information in the follow. ing table for the steel. The steel company mixes batches of eight differ. ent available materials to produce each ton of stee according to the specification. The table at the bottom of this page details these materials. Formulate and solve the LP model that will indicate how much of each of the eight materials should be blended into a 1-ton load of steel so that the company can meet the specifications under the contract while minimizing costs. 34 A steel company is producing steel for a new contract The contract specifies the information in the follow. ing table for the steel. The steel company mixes batches of eight differ. ent available materials to produce each ton of stee according to the specification. The table at the bottom of this page details these materials. Formulate and solve the LP model that will indicate how much of each of the eight materials should be blended into a 1-ton load of steel so that the company can meet the specifications under the contract while minimizing costs