| Microsoft Excel 9.0 Sensitivity Report | |||||||
| Worksheet: [Contoh Soal LP-Solver.xls]LP02 | |||||||
| Report Created: 20/06/00 19:37:50 | |||||||
| Adjustable Cells | |||||||
| Final | Reduced | Objective | Allowable | Allowable | |||
| Cell | Name | Value | Cost | Coefficient | Increase | Decrease | |
| $B$6 | Jawaban: X1 | 133,33 | 0,00 | 1000 | 141,3043554 | 203,1250113 | |
| $C$6 | Jawaban: X2 | 100,00 | 0,00 | 1000 | 216,666678 | 135,4166742 | |
| $D$6 | Jawaban: X3 | 25,00 | 0,00 | 1000 | 120,3703769 | 270,8333484 | |
| $E$6 | Jawaban: X4 | 100,00 | 0,00 | 750 | 135,4166742 | 60,18518854 | |
| $F$6 | Jawaban: X5 | 250,00 | 0,00 | 750 | 90,2777828 | 77,38095669 | |
| $G$6 | Jawaban: X6 | 150,00 | 0,00 | 750 | 180,5555656 | 54,16666968 | |
| $H$6 | Jawaban: X7 | 0,00 | -83,33 | 249,9999944 | 83,33333808 | 1E+30 | |
| $I$6 | Jawaban: X8 | 0,00 | -83,33 | 249,9999944 | 83,33333808 | 1E+30 | |
| $J$6 | Jawaban: X9 | 0,00 | -83,33 | 249,9999944 | 83,33333808 | 1E+30 | |
| Constraints | |||||||
| Final | Shadow | Constraint | Allowable | Allowable | |||
| Cell | Name | Value | Price | R.H. Side | Increase | Decrease | |
| $K$11 | 1. Tanah berguna LHS | 233,33 | 0,00 | 400 | 1E+30 | 166,6666667 | |
| $K$12 | 2. Jatah Air LHS | 600,00 | 333,33 | 600 | 144,4444444 | 167,7419355 | |
| $K$13 | LHS | 800,00 | 333,33 | 800 | 162,5 | 144,4444444 | |
| $K$14 | LHS | 375,00 | 333,33 | 375 | 195 | 29,54545455 | |
| $K$15 | 3. Luas tanaman LHS | 258,33 | 0,00 | 600 | 1E+30 | 341,6666667 | |
| $K$16 | LHS | 500,00 | 83,33 | 500 | 162,5 | 325 | |
| $K$17 | LHS | 0,00 | 0,00 | 325 | 1E+30 | 325 | |
| $K$18 | 4. Equity LHS | 0,00 | 0,00 | 0 | 288,8888889 | 144,4444444 | |
| $K$19 | LHS | 0,00 | 0,00 | 0 | 130 | 32,5 | |