| Microsoft Excel 9.0 Sensitivity Report | |||||||
| Worksheet: [Contoh Soal LP-Solver.xls]LP03 | |||||||
| Report Created: 20/06/00 19:36:56 | |||||||
| Adjustable Cells | |||||||
| Final | Reduced | Objective | Allowable | Allowable | |||
| Cell | Name | Value | Cost | Coefficient | Increase | Decrease | |
| $B$6 | Jawaban: X1 | 1,000 | 0,000 | 8 | 0,336210968 | 1E+30 | |
| $C$6 | Jawaban: X2 | 0,623 | 0,000 | 10 | 0,429446287 | 0,666961637 | |
| $D$6 | Jawaban: X3 | 0,343 | 0,000 | 7 | 0,381632653 | 2,011459969 | |
| $E$6 | Jawaban: X4 | 1,000 | 0,000 | 6 | 1,816085017 | 1E+30 | |
| $F$6 | Jawaban: X5 | 0,048 | 0,000 | 11 | 2,975225225 | 0,044638358 | |
| $G$6 | Jawaban: X6 | 1,000 | 0,000 | 9 | 0,044161637 | 1E+30 | |
| Constraints | |||||||
| Final | Shadow | Constraint | Allowable | Allowable | |||
| Cell | Name | Value | Price | R.H. Side | Increase | Decrease | |
| $H$11 | 1. Emission reduc. LHS | 60,00 | 0,11 | 60 | 14,29714286 | 7,48 | |
| $H$12 | LHS | 150,00 | 0,13 | 150 | 20,453125 | 1,689655172 | |
| $H$13 | LHS | 125,00 | 0,07 | 125 | 2,041666667 | 21,69195612 | |
| $H$14 | 2. Tech. limit LHS | 1,00 | -0,34 | 1 | 0,246231156 | 0,748477435 | |
| $H$15 | LHS | 0,62 | 0,00 | 1 | 1E+30 | 0,377302545 | |
| $H$16 | LHS | 0,34 | 0,00 | 1 | 1E+30 | 0,656520598 | |
| $H$17 | LHS | 1,00 | -1,82 | 1 | 0,110609481 | 1 | |
| $H$18 | LHS | 0,05 | 0,00 | 1 | 1E+30 | 0,952427184 | |
| $H$19 | LHS | 1,00 | -0,04 | 1 | 0,048086359 | 0,962708538 | |