A chemical manufacturer uses chemicals 1 and 2 to produce two drugs. Drug 1 must be at least 70% chemical 1, and drug 2 must be at least 60%chemical 2. Up to 50,000 ounces of drug 1 can be sold at $30 per ounce; up to 60,000 ounces of drug 2 can be sold at $25 per ounce. Up to 45,000 ounces of chemical 1 can be purchased at $15 per ounce, and up to 55,000 ounces of chemical 2 can be purchased at $18 per ounce. Determine how to maximize the manufacturer's profit. Use the template below and Solver to do this.

\begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F & G & H \\ \hline 1 & Drug production & & & & & & & \\ \hline \multicolumn{9}{|l|}{2} \\ \hline 3 & Purchasing price/oz & & & & & & & \\ \hline 4 & C1 & $15 & & & & & & \\ \hline 5 & C2 & $18 & & & & & & \\ \hline \multicolumn{9}{|c|}{6} \\ \hline 7 & & D1 & D2 & & & & & \\ \hline 8 & Selling price/oz & $30 & $25 & & & & & \\ \hline \multicolumn{9}{|c|}{9} \\ \hline \multicolumn{9}{|c|}{0 Blending plan (oz of each chemical used in each drug) } \\ \hline 11 & & D1 & D2 & Total & & MaxAvail & & \\ \hline 12 & C1 & & & & & 45000 & & \\ \hline 13 & C2 & & & & & 55000 & & \\ \hline 14 & Total & & & & & & & \\ \hline \multicolumn{7}{|c|}{15} & & \\ \hline 16 & MaxSales & 50000 & 60000 & & & & & \\ \hline \multicolumn{9}{|l|}{17} \\ \hline 18 & Min \% of C1 in D1 & 70% & & & \multicolumn{2}{|c|}{ Min \% of C2 in D2 } & 60% & \\ \hline 19 & Ounces of C1 in D1: & & & & \multicolumn{2}{|c|}{ Ounces of C2 in D2: } & & \\ \hline 20 & Actual & & Required & & Actual & & Required & \\ \hline 21 & & & & & & & & \\ \hline 22 & & & & & & & & \\ \hline 23 & Cost of chemicals & & & & & & & \\ \hline 24 & Revenue from drugs & & & & & & & \\ \hline 25 & Profit & & & & & & & \\ \hline \end{tabular}