NewAge Pharmaceuticals 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% must consist of B, and at least 2% must consist 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 P04_48.xlsx. At least 100 pounds of chemical 2 must be used.

a. Determine the cheapest way of producing today’s batch of NasaMist.

b. Use SolverTable to see how much the percentage of requirement of A is really costing NewAge. Let the percentage required vary from 6% to 12%.