| Microsoft Excel 9.0 Sensitivity Report | |||||||
| Worksheet: [Contoh Soal LP-Solver.xls]LP08 | |||||||
| Report Created: 20/06/00 19:33:56 | |||||||
| Adjustable Cells | |||||||
| Final | Reduced | Objective | Allowable | Allowable | |||
| Cell | Name | Value | Cost | Coefficient | Increase | Decrease | |
| $B$6 | Jawaban: X11 | 0,00 | 16,00 | 464 | 1E+30 | 16 | |
| $C$6 | Jawaban: X12 | 20,00 | 0,00 | 512 | 16 | 20 | |
| $D$6 | Jawaban: X13 | 0,00 | 84,00 | 654 | 1E+30 | 84 | |
| $E$6 | Jawaban: X14 | 55,00 | 0,00 | 867 | 20 | 352 | |
| $F$6 | Jawaban: X21 | 80,00 | 0,00 | 352 | 16 | 1E+30 | |
| $G$6 | Jawaban: X22 | 45,00 | 0,00 | 416 | 20 | 16 | |
| $H$6 | Jawaban: X23 | 0,00 | 216,00 | 690 | 1E+30 | 216 | |
| $I$6 | Jawaban: X24 | 0,00 | 20,00 | 791 | 1E+30 | 20 | |
| $J$6 | Jawaban: X31 | 0,00 | 729,00 | 995 | 1E+30 | 729 | |
| $K$6 | Jawaban: X32 | 0,00 | 352,00 | 682 | 1E+30 | 352 | |
| $L$6 | Jawaban: X33 | 70,00 | 0,00 | 388 | 84 | 1E+30 | |
| $M$6 | Jawaban: X34 | 30,00 | 0,00 | 685 | 352 | 84 | |
| Constraints | |||||||
| Final | Shadow | Constraint | Allowable | Allowable | |||
| Cell | Name | Value | Price | R.H. Side | Increase | Decrease | |
| $N$17 | LHS | 85,00 | 771,00 | 85 | 0 | 45 | |
| $N$11 | 1. Cannery LHS | 75,00 | 96,00 | 75 | 45 | 0 | |
| $N$12 | LHS | 125,00 | 0,00 | 125 | 0 | 1E+30 | |
| $N$14 | 2. Allocation LHS | 80,00 | 352,00 | 80 | 0 | 80 | |
| $N$13 | LHS | 100,00 | -86,00 | 100 | 45 | 0 | |
| $N$15 | LHS | 65,00 | 416,00 | 65 | 0 | 45 | |
| $N$16 | LHS | 70,00 | 474,00 | 70 | 0 | 45 | |