5 given the following sensitivity report from excel solver for a maxim

Search for question

Question

5. Given the following sensitivity report from Excel SOLVER for a maximization LP problem:
Variable Cells
Cell Name Value
Final Reduced Objective Allowable
Cost Coefficient Increase Decrease
Allowable
$C$4 X1
6
0
1
0.5 0.333333333
$D$4 X2
6
0
1
0.5 0.333333333
Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value
Price
R.H. Side
Increase
Decrease
$E$8
30
0.2
30
15
10
$E$9
30
0.2
30
15
10
(1) What is the current optimal solution? What is the current optimal objective value?
(2) What is the new optimal objective value (z) if the right-hand-side coefficient of the first
constraint (b1) changes to 35?
(3) What is the new optimal objective value (z) if the right-hand-side coefficient of the second
constraint (b2) changes to 28?
(4) For what range of the objective coefficient of X1 (c1) does the current optimal solution
remain optimal?
(5) If the objective coefficient of X2 (c2) changes to 0.75, find the new optimal solution (x1, x2)
and the new optimal objective value (z).