| Microsoft Excel 9.0 Sensitivity Report | |||||||
| Worksheet: [Contoh Soal LP-Solver.xls]LP07 | |||||||
| Report Created: 20/06/00 19:35:26 | |||||||
| Adjustable Cells | |||||||
| Final | Reduced | Objective | Allowable | Allowable | |||
| Cell | Name | Value | Cost | Coefficient | Increase | Decrease | |
| $B$6 | Jawaban: XF1-F2 | 0,000 | 1,000 | 2 | 1E+30 | 1 | |
| $C$6 | Jawaban: XF1-DC | 40,000 | 0,000 | 4 | 1 | 1E+30 | |
| $D$6 | Jawaban: XF1-W1 | 10,000 | 0,000 | 9 | 1E+30 | 2 | |
| $E$6 | Jawaban: XF2-DC | 40,000 | 0,000 | 3 | 1E+30 | 1 | |
| $F$6 | Jawaban: XDC-W2 | 80,000 | 0,000 | 1 | 2 | 1E+30 | |
| $G$6 | Jawaban: XW1-W2 | 0,000 | 5,000 | 3 | 1E+30 | 5 | |
| $H$6 | Jawaban: XW2-W1 | 20,000 | 0,000 | 2 | 2 | 5 | |
| Constraints | |||||||
| Final | Shadow | Constraint | Allowable | Allowable | |||
| Cell | Name | Value | Price | R.H. Side | Increase | Decrease | |
| $I$11 | 1. Net flow LHS | 50,00 | 7,00 | 50 | 0 | 10 | |
| $I$12 | LHS | 40,00 | 6,00 | 40 | 0 | 10 | |
| $I$13 | LHS | 0,00 | 3,00 | 0 | 0 | 10 | |
| $I$14 | LHS | -30,00 | -2,00 | -30 | 0 | 1E+30 | |
| $I$15 | LHS | -60,00 | 0,00 | -60 | 1E+30 | 0 | |
| $I$16 | 2. Upper-bound LHS | 0,00 | 0,00 | 10 | 1E+30 | 10 | |
| $I$17 | LHS | 80,00 | -2,00 | 80 | 10 | 20 | |