ProblemNew Age Pharmaceuticals produces the drug NasaMist from four chemicals. T

ProblemNew Age 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% 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. At leasat 100 pounds of chemical 2 must be used.a. Determine the cheapest way of producing todays bath of NasaMist.b. Use SolverTable to see how much the percentage of requirement of A is really costing New Age. Let the percentage required vary from 6% to 12%.