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: $x_1,x_2,$ and $x_3.$

Machine hours required per unit are

The available time in machine hours per week is

The salespeople estimate they can sell all the units of $x_1$ and $x_2$ that can be made. But the sales potential of $x_3$ is $120$ units per

week maximum.

Unit profits for the three products are

a$.$ Set up the equations that can be solved to maximize the profit per week. $($Leave no cells blank $-$ be certain to enter $"0"$ wherever

required.$)$

b$.$ Solve these equations using the Excel Solver. $($Leave no cells blank $-$ be certain to enter $"0"$ wherever required. Round your

answers to the nearest whole number. Use your ROUNDED decision variable values to compute total profit.$)$