Question
Implement the following LP model in a spreadsheet. Use Solver to solve the problem and use a Sensitivity Report. Use sensitivity report information to answer
Implement the following LP model in a spreadsheet. Use Solver to solve the problem and use a Sensitivity Report. Use sensitivity report information to answer the following questions: (It'd be great if you showed the Excel steps. Thank you!)
MAX: 2X1 + 4X2
Subject to:
2X1 + 2X2 <= 8
X1 + 2X2 <= 12
X1 + X2 >= 2
X1, X2 >= 0
1) Which of the constraints are binding at the optimal solution?
2) Is the optimal solution to this problem unique? If not, explain what is it?
3) What is the optimal solution to this problem if the value of the objective function coefficient for variable X1 is zero? Can you answer this question only using the sensitivity report?
4) How much can the objective function coefficient for variable X2 decrease before changing the optimal solution?
5) 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
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started