Please provide the formulas for the excel question. Thank you!

3.20. The Metalco Company desires to blend a new alloy of 40 percent tin, 35 percent zinc, and 25 percent lead from several available alloys having the following properties. Alloy 1 2. 3 4 5 Property Percentage of tin Percentage of zinc Percentage of lead Cost ($/b) 60 10 30 22 25 15 60 20 45 45 10 25 20 50 30 24 50 40 10 27 The objective is to determine the proportions of these alloys that should be blended to produce the new alloy at a minimum cost. a. Identify all the requirements that will need to be expressed in fixed-requirement constraints. E* b. Formulate and solve a linear programming model for this problem on a spreadsheet. C. Express this model in algebraic form