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 file
P14_80.xlsx. It is necessary that at least 100 pounds of chemical 2 and at least 450 pounds of chemical 3
be used.
Determine the cheapest way of producing today’s batch of NasaMist.
Use SolverTable to see how much the percentage of requirement of A is really costing the company. Let
the percentage required vary from 6% to 12%.
Sample Solution