Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Consider the following Excel sensitivity report and it's accompanying problem: Minimize cost = $X + 2Y subject to Variable Cells Constraints Cell Name $B$3 X1
Consider the following Excel sensitivity report and it's accompanying problem: Minimize cost = $X + 2Y subject to Variable Cells Constraints Cell Name $B$3 X1 $C$3 X2 True False LHS LHS X + 3Y 2 90 8X + 2Y Z LHS 160 3X + 2Y 120 Y 70 X, Y2 0 Final Value Final Cell Name Value $J$6 LHS $J$7 $J$8 $J$9 25.71428571 0 21.42857143 0 90 Reduced Cost 120 Shadow Price 248.5714286 0 Objective Allowable Coefficient Increase 2 0.571428571 90 21.42857143 0 Constraint Allowable R.H. Side Increase 160 0.142857143 120 2 1 70 62 150 Allowable Decrease 1E+30 0.333333333 1.333333333 Allowable Decrease 88.57142857 1E+30 50 28.18181818 48.57142857 If we increase the objective function coefficient of both x and y, by $0.5, the optimal solution would change.
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