Question: Implement the following LP problem in a spreadsheet. Use Solver to solve the problem and create a Sensitivity Report. Use the information to answer the
Implement the following LP problem in a spreadsheet. Use Solver to solve the problem and create a Sensitivity Report. Use the information to answer the following questions:
MAX: XX
Subject to:
XX
XX
X X
X X
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 is zero?
d How much can the objective function coefficient for variable X 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?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
