| Microsoft Excel 9.0 Sensitivity Report | |||||||
| Worksheet: [Contoh Soal LP-Solver.xls]LP06 | |||||||
| Report Created: 20/06/00 19:36:06 | |||||||
| Adjustable Cells | |||||||
| Final | Reduced | Objective | Allowable | Allowable | |||
| Cell | Name | Value | Cost | Coefficient | Increase | Decrease | |
| $B$6 | Jawaban: X1 | 48,000 | 0,000 | 170 | 1E+30 | 10 | |
| $C$6 | Jawaban: X2 | 31,000 | 0,000 | 160 | 10 | 160 | |
| $D$6 | Jawaban: X3 | 39,000 | 0,000 | 175 | 5 | 175 | |
| $E$6 | Jawaban: X4 | 43,000 | 0,000 | 180 | 1E+30 | 5 | |
| $F$6 | Jawaban: X5 | 15,000 | 0,000 | 195 | 1E+30 | 195 | |
| Constraints | |||||||
| Final | Shadow | Constraint | Allowable | Allowable | |||
| Cell | Name | Value | Price | R.H. Side | Increase | Decrease | |
| $G$11 | LHS | 48,00 | 10,00 | 48 | 6 | 48 | |
| $G$12 | LHS | 79,00 | 160,00 | 79 | 1E+30 | 6 | |
| $G$13 | LHS | 118,00 | 0,00 | 87 | 31 | 1E+30 | |
| $G$14 | LHS | 70,00 | 0,00 | 64 | 6 | 1E+30 | |
| $G$15 | LHS | 82,00 | 175,00 | 82 | 1E+30 | 6 | |
| $G$16 | LHS | 43,00 | 5,00 | 43 | 6 | 6 | |
| $G$17 | LHS | 58,00 | 0,00 | 52 | 6 | 1E+30 | |
| $G$18 | LHS | 15,00 | 195,00 | 15 | 1E+30 | 6 | |