Search for question

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:

Property

Percentage of tin

Percentage of zinc

Percentage of lead

Cost ($/lb)

1

60

10

30

22

2

25

15

60

20

Alloy

3

45

45

10

25

4

20

50

30

24

5

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) Formulate a linear programming model for this problem.

(b) Obtain the optimal solution using Microsoft Excel Solver and Python Solver. Attach the

completed Excel and Python files containing the codes and solutions.

Fig: 1