Questions:
Linear programming blending problem using Excel Solver Table.
NewAge data
| 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%.