Coyote Inc produces the drug Hydrox from four chemicals. Today they must produce 1,000 lb of the drug. The three active ingredients in Hydrox are A, B, and C. By weight, at least 9% of Hydrox must consist of A, at least 5% of B, and at least 3% of C. The cost per pound of each chemical and the amount of each active ingredient in 1 lb of each chemical are given in table below. It is necessary that at least 120 lb of chemical 2 be used.

Coyote Inc produces the drug Hydrox from four chemicals. Today they must produce 1,000lb of the drug. The three active ingredients in Hydrox are A, B, and C. By weight, at least 9% of Hydrox must consist of A, at least 5% of Btand and least 3% of C. The cost per pound of each chemical and the amount of each active ingredient in 1lb of each chemical are given in table below. It is necessary that at least 120lb of chemical 2 be used. a) Formulate an LP whose solution would determine the cheapest way of producing today's batch of Hydrox. b) Solve the LP using Excel Solver, show your Excel spreadsheet and report your solutions