Need objective function formula and contraints written out, then need to put it all on excel spreadsheet and use excel solver to find the answer. Final answer is given at the bottom. Thank you

A steel company is producing steel for a new contract. The contract specifies the information in the following table for the steel. The steel company mixes batches of eight different available materials to produce each ton of steel 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- US ton (2000 lb) load of steel so that the company can meet the specifications under the contract while minimizing costs