Microsoft Excel 16.
0 Sensitivity Report
Worksheet: [Book1]Sheet1
Report Created: 01/04/2023 2:55:17 SA
Variable Cells
Final Reduced Objective Allowable Allowable Upper Lower
Cell Name Value Cost Coefficient Increase Decrease Limit Limit
$B$11 A 0 -7.5 50 7.5 1E+030 57.5 -1E+30
$C$11 B 70 0 60 1E+030 5 1E+030 55
$D$11 C 30 0 55 5 15 60 40
optimal solution
Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$B$16 LHS 100 60 100 10 6.666666667
$B$17 LHS 270 0 300 1E+030 30
$B$18 LHS 270 0 250 20 1E+030
$B$19 LHS 60 -2.5 60 40 60
If the RHS of const 1 increases by 5
Change in profit = 5*60 = 300 the amount of change * the shadow price
Profit will increase by 300 from 5850 to become 6150
Profit = 300 + 5850 = 6150
If the RHS of Const 2 decreases to 250
The proposed decrease = the current value of RHS - the decrease = 300 - 250 = 50
hence 50 > 30
-> re-solve the model
If the RHS of const 4 changes to 44
The currentt value = 60
-> Change in RHS = 44 - 60 = -16
Change in profit = -16*-2.5(shadow price) = 40
Since this value is positive, optimal profit will increase by 40 to become 5890
Profit = 5850 + 40 = 5890
Profit = 50*0+60*70+30*55 = 5850
If unit profit on B decrease by 20 20 > 5 optimal solution will change
If unit profit on C decrease to 45 60 < 45 < 40 optimal solution will remain optimal
Profit (after changing) = 50*0+60*70+45*30 = 5550
If the unit profit A and C change to 53 A increase and C decrease
A: 53 - 50 = 3 C: 55 - 53 = 2
3/7.5 = 0.4 2/15 = 0.13333333333
A B C amount
Const 1 1 1 1 100
Const 2 2 3 2 300
Const 3 2 3 2 250
Const 4 1 0 2 60
Max Profit 50 60 55
Decision Variables
A B C
0 70 30
OFV 5850
Const LHS RHS
1 100 <= 100
2 270 <= 300
3 270 <= 250
4 60 <= 60
