Microsoft Excel 9.0 Sensitivity Report |
|
|
|
|
Worksheet:
[Contoh Soal.xls]LP04 |
|
Report
Created: 20/06/00 11:03:39 |
|
|
Adjustable
Cells |
|
|
|
|
Final |
Reduced |
Objective |
Allowable |
Allowable |
|
Cell |
Name |
Value |
Cost |
Coefficient |
Increase |
Decrease |
|
$B$6 |
Jawaban: XA1 |
412,28 |
0,00 |
5,5 |
0 |
0,46 |
|
$C$6 |
Jawaban: XA2 |
859,65 |
0,00 |
5,5 |
1,035714286 |
0,668604651 |
|
$D$6 |
Jawaban: XA3 |
447,37 |
84,00 |
5,5 |
1,050724638 |
0 |
|
$E$6 |
Jawaban: XA4 |
429,82 |
0,00 |
5,5 |
2,071428571 |
1,337209302 |
|
$F$6 |
Jawaban: XB1 |
2.587,72 |
0,00 |
4,5 |
0,46 |
0 |
|
$G$6 |
Jawaban: XB2 |
517,54 |
0,00 |
4,5 |
2,22027972 |
3,152173913 |
|
$H$6 |
Jawaban: XB3 |
1.552,63 |
216,00 |
4,5 |
0 |
1,050724638 |
|
$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 |
-232,46 |
771,00 |
0 |
1E+30 |
232,4561404 |
|
$N$12 |
LHS |
0,00 |
96,00 |
0 |
324,137931 |
200 |
|
$N$13 |
LHS |
-627,19 |
0,00 |
0 |
1E+30 |
627,1929825 |
|
$N$14 |
LHS |
0,00 |
352,00 |
0 |
66,66666667 |
452,991453 |
|
$N$15 |
LHS |
0,00 |
-86,00 |
0 |
412,2807018 |
232,4561404 |
|
$N$16 |
LHS |
0,00 |
416,00 |
0 |
324,137931 |
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 |
376 |
333,3333333 |
|
$N$26 |
LHS |
947,37 |
|
500 |
447,3684211 |
1E+30 |
|
$N$27 |
4. Cost LHS |
30.000,00 |
|
30000 |
1000 |
3071,428571 |
|
|
|
|
|
|
|
|