Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Consider the following LP problem: Max 4X1-3X2+5X3 2Xi-3X3 S20 3X2+5X3 25 Using the Excel Solver, one obtains the optimal objective value of 37 and the
Consider the following LP problem: Max 4X1-3X2+5X3 2Xi-3X3 S20 3X2+5X3 25 Using the Excel Solver, one obtains the optimal objective value of 37 and the following Sensitivity Report Microsoft Excel 16.0 Sensitivity Report Report Created: 6/12/2017 4:27:59 PM Variable Cells Cell uS5 X1 SK$5 X2 L$5 X3 Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 1.5 E+30 E+30 4 1E+30 8.8 -8.8 Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease Cell SMS11 Constraint 3 Obj 5-0.6 5 205 10 3.5 13 20 1E 30 1. What is the optimal solutions for Xi Xa, and X? 2. Please answer following questions by circling Yes or No in the "Answer" column Question Answer 1. Will the optimal objective value still be 37 if the coefficient for X in the objective function increasesYesNo from 4 to 4.5? 2. Will the optimal solutions to Xi, X and Xa remain unchanged if the coefficient for X in the objectve YesNo function decreases from -3 to -5 3. Will the optimal solutions to Xi, X andX, remain unchanged if the coefficient for X, in the objective YesNo function increases from 5 to 9? Is constraint 1 binding under the optimal solution? 5. Is constraint 2 binding under the optimal solution? Yes No No raint 7. The shadow of constraint 3 will still be -0.6 if its RHS increases from 5 to 10
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started