Question

Consider the following sensitivity report:
Sensitivity Report
Variable Cells
Cell
Name
SBS2 Coffee blend A (xl)
SCS2 Coffee Blend B (x2)
Final Reduced Objective Allowable Allowable
Value Cost Coefficient Increase Decrease
120 0
1E+30 3.083333333
80
0 1.7 1E+30 4.625
1.95
Constraints
Cell
Name
SD$10 Available quantity of Coffee G
SDS11 Proportion of sales
SDS7 Brewing capacity
SDS8 Available quanitity of Coffee B
SDS9 Available quanitity of Coffee T
Final Shadow Constraint Allowable
Value Price R.H. Side Increase
78
0
80 1E+30
0 0.1
0 33.33333333
200 1.85 200 5.128205128
74
1E+30
48
0
80 1E+30
Allowable
Decrease
2
50
200
6
32
What would be the change in optimal solution if the objective coefficient for
variable xl is changed from 1.95 to 2?
a) Final value for XI will increase, but final value of X2 will decrease
b) Final value for XI will increase, but final value of X2 will remain unchanged
c) No change would take place in the final value of X1 and X2
d) Can't be determined due to insufficient information

Answer 1

Answer:

200

Explanation:

Answer 2

Explanation:

final value for xl will increase but fin value of x2 will remain unchanged