Review QM for Windows and$/$or Excel and Changes in Objective Function Coefficients

and Sensitivity Analysis Output$/$Report before beginning this assignment $($see Render et

al$.,2023).$

The computer output below is for a product$-$mix problem with two products and three

resource constraints. To find the solution, use QM for Windows and$/$or Excel to help you

answer the following questions. Assume that you wish to maximize profit in each case.

How many units of product $1$ and product $2$ should be produced?

How much of each of the three resources is being used? How much slack is there

for each constraint? Which of the constraints are binding, and which are non$-$

binding?

What are the dual prices for each resource?

If you could obtain one of the resources, which one should you obtain? How much

should you be willing to pay for this resource?

What would happen to profit if$,$ with the original output, management decided to

produce one more unit of product $2?$