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