PLEASE SHOW ME WHAT FORMULAS TO USE IN EACH CELL ON EXCEL! ALSO PLEASE SHOW ME HOW TO ENTER IT INTO SOLVER BECAUSE I AM DOING IT INCORRECTLY.

3.6D SPREADSHEET:

3.6.* The Omega Manufacturing Company has discontinued the production of a certain unprofitable product line. This act created considerable excess production capacity. Management is considering devoting this excess capacity to one or more of three products, Products 1,2, and 3 . The available capacity of the machines that might limit output is summarized in the following table. The number of machine-hours required for each unit of the respective products are shown in the next table. Productivity Coefficient (in Machine-Hours per Unit) d. Formulate a spreadsheet model for this problem. Identify the data cells, the changing cells, the objective cell, and the other output cells. Also show the Excel equation for each output cell expressed as a SUMPRODUCT function. Then use Solver to solve the model. \begin{tabular}{|r|cc|} \hline \multicolumn{1}{|c|}{ A } & B & C \\ \hline Unit Profit & Product 1 & Product 2 \\ \hline Milling machine & \\ \hline Lathe & \\ \hline Grinder & \\ \hline \end{tabular} 3.6.* The Omega Manufacturing Company has discontinued the production of a certain unprofitable product line. This act created considerable excess production capacity. Management is considering devoting this excess capacity to one or more of three products, Products 1,2, and 3 . The available capacity of the machines that might limit output is summarized in the following table. The number of machine-hours required for each unit of the respective products are shown in the next table. Productivity Coefficient (in Machine-Hours per Unit) d. Formulate a spreadsheet model for this problem. Identify the data cells, the changing cells, the objective cell, and the other output cells. Also show the Excel equation for each output cell expressed as a SUMPRODUCT function. Then use Solver to solve the model. \begin{tabular}{|r|cc|} \hline \multicolumn{1}{|c|}{ A } & B & C \\ \hline Unit Profit & Product 1 & Product 2 \\ \hline Milling machine & \\ \hline Lathe & \\ \hline Grinder & \\ \hline \end{tabular}