Question: X 1 X 2 Q 1 5 1 7 Max 4 1 2 . 5 Microsoft Excel 7 . 0 Sensitivity Report Changing Cells Final

X1
X2
Q
15
17
Max
412.5
Microsoft Excel 7.0 Sensitivity Report
Changing Cells
Final
Reduced
Objective
Allowable
Allowable
Name
Value
Cost
Coefficient
Increase
Decrease
Variables Variable 1
15
0
10
12.5
2.5
Variables Variable 2
17
0
15
5
8.33
Constraints
Final
Shadow
Constraint
Allowable
Allowable
Name
Value
Price
R.H. Side
Increase
Decrease
constraint 1 Used
100
3.13
100
60
46.66
constraint 2 Used
80
1.25
80
70
30
Which of the following best explain the range of optimality for x2?
a.
The range in which the shadow price for x2 is still valid.
b.
The range in which the contribution to profit for x1 can stay within without changing the optimal solution
c.
The range in which the contribution for profit for x2 can stay within without changing the optimal solution
d.
The range in which the contribution for profit x2 can stay within without changing the optimal solution, holding the contribution for profit for x1 constraint.

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!