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%.
Attachment:- Sat.zip