Question: Use the Solver sensitivity report to answer the following question. What's the maximum value of the coefficient of Variable 2 that can be increased without

Use the Solver sensitivity report to answer the following question.
What's the maximum value of the coefficient of Variable 2 that can be increased without change the optimal solution?
Sensitivity Report
Changing Cells
Final
Reduced
Objective
Allowable
Allowable
Cell
Name
Value
Cost
Coefficient
Increase
Decrease
$B$12
Variable 1
8.461538462
0
5
7
3.4
$C$12
Variable 2
4.615384615
0
4
8.5
2.333333333
Constraints
Final
Shadow
Constraint
Allowable
Allowable
Cell
Name
Value
Price
R.H. Side
Increase
Decrease
$B$15
constraint 1 Used
40
0.538461538
40
110
7
$B$16
constraint 2 Used
30
1.307692308
30
30
4.666666667
$B$17
constraint 3 Used
13.07692308
0
12
1.076923077
1E+30
Question 17 options:
4.61
8.5
2.33
13.11

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!