| 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 | ||