Microsoft Excel 9.0 Sensitivity Report |
|
|
|
|
Worksheet:
[Contoh Soal.xls]LP05 |
|
Report
Created: 20/06/00 10:57:13 |
|
|
Adjustable
Cells |
|
|
|
|
Final |
Reduced |
Objective |
Allowable |
Allowable |
|
Cell |
Name |
Value |
Cost |
Coefficient |
Increase |
Decrease |
|
$B$6 |
Jawaban: XA1 |
644,74 |
0,00 |
5,5 |
1,380952381 |
0 |
|
$C$6 |
Jawaban: XA2 |
859,65 |
0,00 |
5,5 |
1,035714286 |
0,668604651 |
|
$D$6 |
Jawaban: XA3 |
214,91 |
84,00 |
5,5 |
0 |
2,212543554 |
|
$E$6 |
Jawaban: XA4 |
429,82 |
0,00 |
5,5 |
2,071428571 |
1,337209302 |
|
$F$6 |
Jawaban: XB1 |
2.355,26 |
0,00 |
4,5 |
0 |
0,435435435 |
|
$G$6 |
Jawaban: XB2 |
517,54 |
0,00 |
4,5 |
2,22027972 |
3,152173913 |
|
$H$6 |
Jawaban: XB3 |
1.785,09 |
216,00 |
4,5 |
0,424354244 |
0 |
|
$I$6 |
Jawaban: XB4 |
517,54 |
20,00 |
4,5 |
2,3 |
3,152173913 |
|
$J$6 |
Jawaban: XC1 |
0,00 |
729,00 |
3,5 |
0,795739348 |
1E+30 |
|
$K$6 |
Jawaban: XC2 |
0,00 |
352,00 |
3,5 |
2,785087719 |
1E+30 |
|
$L$6 |
Jawaban: XC3 |
0,00 |
0,00 |
3,5 |
0,557017544 |
1,644736842 |
|
$M$6 |
Jawaban: XC4 |
0,00 |
0,00 |
3,5 |
1,644736842 |
1E+30 |
|
Constraints |
|
|
|
|
Final |
Shadow |
Constraint |
Allowable |
Allowable |
|
Cell |
Name |
Value |
Price |
R.H. Side |
Increase |
Decrease |
|
$N$11 |
1. Mix. spec. LHS |
0,00 |
771,00 |
0 |
214,9122807 |
232,4561403 |
|
$N$12 |
LHS |
0,00 |
96,00 |
0 |
170,7317073 |
200 |
|
$N$13 |
LHS |
-859,65 |
0,00 |
0 |
1E+30 |
859,6491228 |
|
$N$14 |
LHS |
0,00 |
352,00 |
0 |
66,66666667 |
452,991453 |
|
$N$15 |
LHS |
-232,46 |
-86,00 |
0 |
1E+30 |
232,4561403 |
|
$N$16 |
LHS |
0,00 |
416,00 |
0 |
830,5084746 |
200 |
|
$N$17 |
LHS |
0,00 |
474,00 |
0 |
66,66666667 |
418,4397163 |
|
$N$18 |
LHS |
0,00 |
|
0 |
0 |
270,8029197 |
|
$N$19 |
2. Availability LHS |
3.000,00 |
|
3000 |
514,5631068 |
500 |
|
$N$20 |
LHS |
1.377,19 |
|
2000 |
1E+30 |
622,8070175 |
|
$N$21 |
LHS |
2.000,00 |
|
4000 |
1E+30 |
2000 |
|
$N$22 |
LHS |
947,37 |
|
1000 |
1E+30 |
52,63157895 |
|
$N$23 |
3. Amount treated LHS |
3.000,00 |
|
1500 |
1500 |
1E+30 |
|
$N$24 |
LHS |
1.377,19 |
|
1000 |
377,1929825 |
1E+30 |
|
$N$25 |
LHS |
2.000,00 |
|
2000 |
704,9180328 |
333,3333334 |
|
$N$26 |
LHS |
947,37 |
|
500 |
447,368421 |
1E+30 |
|
$N$27 |
4. Cost LHS |
30.000,00 |
|
30000 |
1000 |
3071,428571 |
|
|
|
|
|
|
|
|