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