I worked out the answers for most of this, and provided the answers in the tables that follow. But for the total cost table, I need help working out the values for 10%, 11%, and 12%. A pharmaceutical company produces the drug NasaMist from four chemicals. Today, the company must produce 1000 pounds of the drug. The three active ingredients in NasaMist are A, B, and C. By weight, at least 8% of NasaMist must consist of A, at least 4% of B, and at least 2% of C. The cost per pound of each chemical and the amount of each active ingredient in one pound of each chemical are given in the data at the bottom. It is necessary that at least 100 pounds of chemical 2 and at least 450 pounds of chemical 3 be used. a. Determine the cheapest way of producing today’s batch of NasaMist. If needed, round your answers to one decimal digit. Production plan Weight (lbs) Chemical 1 257.1 Chemical 2 100 Chemical 3 450 Chemical 4 192.9 b. Use SolverTable to see how much the percentage of requirement of A is really costing the company. Find the total cost for each value of this percentage, varied from 6% to 12% in increments of 1%. (Round your answers to nearest whole number. Enter a total cost of 0 if the model for a given percentage requirement for active ingredient A is not feasible.) TotCost 6% $ 10707 7% $ 10707 8% $ 10707 9% $ 11013 10% $ 11% $ 12% $ The 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
I worked out the answers for most of this, and provided the answers in the tables that follow. But for the total cost table, I need help working out the values for 10%, 11%, and 12%.
A pharmaceutical company produces the drug NasaMist from four chemicals. Today, the company must produce 1000 pounds of the drug. The three active ingredients in NasaMist are A, B, and C. By weight, at least 8% of NasaMist must consist of A, at least 4% of B, and at least 2% of C. The cost per pound of each chemical and the amount of each active ingredient in one pound of each chemical are given in the data at the bottom. It is necessary that at least 100 pounds of chemical 2 and at least 450 pounds of chemical 3 be used.
a. Determine the cheapest way of producing today’s batch of NasaMist. If needed, round your answers to one decimal digit.
| Production plan | Weight (lbs) |
| Chemical 1 | 257.1 |
| Chemical 2 | 100 |
| Chemical 3 | 450 |
| Chemical 4 | 192.9 |
b. Use SolverTable to see how much the percentage of requirement of A is really costing the company. Find the total cost for each value of this percentage, varied from 6% to 12% in increments of 1%. (Round your answers to nearest whole number. Enter a total cost of 0 if the model for a given percentage requirement for active ingredient A is not feasible.)
| TotCost | |
| 6% | $ 10707 |
| 7% | $ 10707 |
| 8% | $ 10707 |
| 9% | $ 11013 |
| 10% | $ |
| 11% | $ |
| 12% | $ |
The 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 |
Step by step
Solved in 2 steps
