Chapter $4,$ Problem $4$

Implement the following LP model in a spreadsheet. Use Solver to solve the problem and

create a Sensitivity Report. Use this information to answer the following questions:

$x_1+2x_{2}12$

$x_1+x_{2}2$

$x_1,x_{2}0$

a$.$ Which of the constraints are binding at the optimal solution?

b$.$ Is the optimal solution to this problem unique, or is there an alternate optimal solution?

c$.$ What is the optimal solution to this problem if the value of the objective function

coefficient for variable $x_1$ is zero?

d$.$ How much can the objective function coefficient for variable $x_2$ decrease before changing

the optimal solution?

e$.$ Given the objective in this problem, if management could increase the RHS value for any

of the constraints for identical costs, which would you choose to increase and why?

$*$Submit your Excel spreadsheet.

a$.$ Write your answer and provide explanation here.

b$.$ Write your answer and provide explanation here.

c$.$ Write your answer and provide explanation here.

d$.$ Write your answer and provide explanation here.

e$.$ Write your answer and provide explanation here.