t1 t2 t3 w1 w2
9 4 16
0.0001 0.0001 0.0624187 0.0001 0.0713929
i/p const 5 14
H1s effi 9 4 16 -5 -14
H2s effi 5 7 10 -8 -15
H3s effi 4 9 13 -7 -12
1
1
1
1
1
1
1= 1
0 <= 0
-0.446305 <= 0
-0.044671 <= 0
0.0001 >= 0.0001
0.0001 >= 0.0001
0.0624187 >= 0.0001
0.0001 >= 0.0001
0.0713929 >= 0.0001
t1 t2 w1 w2
6 8
0.0001 0.124925 0.00497 0.0001
i/p const 200 60
1 6 8 -200 -60
2 8 9.5 -300 -90
3 10 11 -400 -120
1
1
1
1
1
1= 1
-1.06E-16 <= 0
-0.312413 <= 0
-0.624825 <= 0
0.0001 >= 0.0001
0.124925 >= 0.0001
0.00497 >= 0.0001
0.0001 >= 0.0001
Microsoft Excel 16.0 Sensitivity Report
Worksheet: [Book1]H2Prob
Report Created: 05-07-2024 13:28:10
Variable Cells
Final Reduced Objective
Cell Name Value Cost Coefficient
$B$5 t1 0.0798206154 0 5
$C$5 t2 0.0532752821 0 7
$D$5 t3 0.0001 0 10
$E$5 w1 0.0001 0 0
$F$5 w2 0.0666133333 0 0
Constraints
Final Shadow Constraint
Cell Name Value Price R.H. Side
$H$11 0.0798206154 0 0.0001
$H$12 0.0532752821 0 0.0001
$H$13 0.0001 -2.7846153846 0.0001
$H$14 0.0001 -0.2482051282 0.0001
$H$15 0.0666133333 0 0.0001
$H$7 i/p const 1 0.7733333333 1
$H$8 H1s effi 0 0.2615384615 0
$H$9 H2s effi -0.2269699487 0 0
$H$10 H3s effi 0 0.6615384615 0
Allowable Allowable
Increase Decrease
10.75 0.6558265583
1.056768559 3.4150943396
2.7846153846 1E+030
0.2482051282 1E+030
1E+030 0.4653846154
Allowable Allowable
Increase Decrease
0.0797206154 1E+030
0.0531752821 1E+030
0.0563243478 0.0001
0.1247125 0.0001
0.0665133333 1E+030
1E+030 0.9965076923
0.8640983333 0.57576
1E+030 0.2269699487
0.3430941085 0.3840437037
t1 t2 t3 w1 w2
5 7 10
0.0798206 0.0532753 0.0001 0.0001 0.0666133
i/p const 8 15
H1s effi 9 4 16 -5 -14
H2s effi 5 7 10 -8 -15
H3s effi 4 9 13 -7 -12
1
1
1
1
1
SP
H1s effi 0 0.2615385 9 4 16
H2s effi -0.22697 0 5 7 10
H3s effi 0 0.6615385 4 9 13
5 7 12.784615
0.7730301
1= 1
0 <= 0
-0.22697 <= 0
0 <= 0
0.0798206 >= 0.0001
0.0532753 >= 0.0001
0.0001 >= 0.0001
0.0001 >= 0.0001
0.0666133 >= 0.0001
-5 -14
-8 -15
-7 -12
-5.938462 -11.6
t1 t2 t3 w1 w2
4 9 13
0.0001 0.0091603 0.0705505 0.0001 0.083275
i/p const 7 12
H1s effi 9 4 16 -5 -14
H2s effi 5 7 10 -8 -15
H3s effi 4 9 13 -7 -12
1
1
1
1
1
1
1= 1
0 <= 0
-0.479797 <= 0
0 <= 0
0.0001 >= 0.0001
0.0091603 >= 0.0001
0.0705505 >= 0.0001
0.0001 >= 0.0001
0.083275 >= 0.0001