Share
Explore BrainMass

Linear programming blending problem using Excel Solver Table.

NewAge data

Cost/lb of chemicals
Chemical 1 $8
Chemical 2 $10
Chemical 3 $11
Chemical 4 $14

Ingredient/lb of chemical
A B C
Chemical 1 0.03 0.02 0.01
Chemical 2 0.06 0.04 0.01
Chemical 3 0.10 0.03 0.04
Chemical 4 0.12 0.09 0.04

The Mist pharmacy produce four chemicals, today the company must produce 1000 pounds of the drug. The three active ingredients in Mist are A,B, and C. By weight, at least 8% of Mist must consist A, at least 4 % of B, and 2% of C. The cost per pound of each chemical and amount of each active ingredient in 1 pound of each chemical are given above. It is necessary that at least 100 pound of chemical 2 be used

1. Determine the cheapest way of producing today's batch of Mist
2. Use SolverTable to see how much the percentage of requirement of A is really costing Mist. Let the percentage required vary from 6% to 12%.

Attachments

Solution Summary

The solution examines linear programming blending problems using the Excel Solver Table. The cost of chemicals per pound and the ingredient per pound of chemicals is also examined.

$2.19