Maximize Profit

Subject to

Consider the linear optimization model displayed above.

Set$-$up the model in an Excel spreadsheet.

Use the Solver add$-$in to solve for the optimal solution.

Generate the answer and sensitivity reports from Solver. What is the value of the objective function at the optimal solution? Suppose the right$-$hand side $($RHS$)$ of the second constraint were increased by $5.$ How much will the objective function increase? How many of the constraints are binding? How much can the coefficient of in the objective function increase before the optimal product mix changes? One of the decision variables takes the value of $0$ at the optimal solution. What objective function coefficient value would cause the optimal solution to have a nonzero value for this decision variable?