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.

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.
b. Formulate and solve a linear programming model for this problem on a spreadsheet.
c. Express this model in algebraic form?

Transcribed Image Text:

Alloy Property Percentage of tin Percentage of zinc Percentage of lead Cost ($/b) 4 50 40 10 27 60 10 30 22 25 15 60 45 45 10 25 20 50 30 20 24 3.