SHOW STEP BY STEP IN EXCEL SOLVER

A manufacturing firm has discontinued production of a certain unprofitable product line. Considerable excess production capacity was created as a result. Management is considering devoting this excess capacity to one or more of three products: X1,X2, and X3. Marhina hource racuirad nor unit ora The availahle time in machine hours ner week is Unit profits for the three products are $14 (for X1),$6 (for X2 ), and $8 (for X3 ). Solve this problem using Solver in the template that is provided (the Excel file) with the objective of maximizing the profit. After solving with Excel, what is the optimal solution? x1=0,x2=0,x3=0x1=113.33,x2=5.83,x3=78.33x1=4,x2=2,x3=3x1=700,x2=465,x3=305 Which constraint represents the availability of lathe machines correctly? 41+22641+22>465 After solving with Solver, what is the optimal profit? 2482.23 4423.88 2248.33 3242.32 Which of the following functions represents the objective function? Minimize 7001+4652+3053 Minimize 141+62+83 Maximize 7001+4652+3053 Maximize 141+62+83