Answered step by step
Verified Expert Solution
Link Copied!

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.
image text in transcribed
Consider the following Excel sensitivity report and it's accompanying problem: Minimizecost=$X+2Ysubjectto120X+3Y908X+2Y1603X+2YY70X,Y0 Variable Cells Constraints If we increase the objective function coefficient of both x and y, by $0.5, the optimal solution would change. True False

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Tourism Supply Chain Management

Authors: Haiyan Song

1st Edition

0415581567, 9780415581561

More Books

Students also viewed these General Management questions