Decision Variables \begin{tabular}{|l|l|l|} \hline Acme (A) & & units \\ \hline Globex (G) & & units \\ \hline \end{tabular} \begin{tabular}{|l|r|l|l|r|} \hline \multicolumn{1}{l}{ Gonstraints } & \multicolumn{2}{l|}{ Equation } & \multicolumn{2}{l|}{ Given } \\ \hline & Acme & Globex & Amount Needed & Amount Available \\ \hline Drums Required & 1 & 1 & & 200 \\ \hline Labor Required & 18 & 12 & & 3132 \\ \hline Rubber Housing Required & 6 & 8 & & 1440 \\ \hline \end{tabular} Given \begin{tabular}{|l|r|r|} \hline & Acme & Globex \\ \hline Unit Profits & $350 & $300 \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline Objective Functions & Equation \\ \hline Total Profits: & \\ \hline \end{tabular} FEP Co. is a manufacturer of washing machines. It currently sells two models of washing machines: the Acme and the Globex. At the start of every production cycle, FEP Co. must decide how many units of each washing machine to produce, given its available resources. In the coming production cycle, FEP Co. faces key resource constraints. These constraints are summarized in the table below. Based on these facts and the assumption that 100% of production will be sold, help FEP Co. figure out how many units of each washing machine to produce in the coming production run to maximize profits. Use the Washing Machine Problem worksheet in the provided Excel template along with Solver to answer the following questions: Formula in Cell D8: (equations should be comprised of Excel cells only) = Formula in Cell D9: (equations should be comprised of Excel cells only) = Formula in Cell D10: (equations should be comprised of Excel cells only) = Formula in Cell B17: (equations should be comprised of Excel cells only) = +C+C9+C10+C14