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
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%.


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.