| Microsoft Excel 9.0 Sensitivity Report | |||||||
| Worksheet: [Contoh Soal LP-Solver.xls]LP01 | |||||||
| Report Created: 20/06/00 19:38:18 | |||||||
| Adjustable Cells | |||||||
| Final | Reduced | Objective | Allowable | Allowable | |||
| Cell | Name | Value | Cost | Coefficient | Increase | Decrease | |
| $B$6 | Jawaban: X1 | 2,00 | 0,00 | 3 | 4,5 | 3 | |
| $C$6 | Jawaban: X2 | 6,00 | 0,00 | 5 | 1E+30 | 3 | |
| Constraints | |||||||
| Final | Shadow | Constraint | Allowable | Allowable | |||
| Cell | Name | Value | Price | R.H. Side | Increase | Decrease | |
| $D$11 | LHS | 2,00 | 0,00 | 4 | 1E+30 | 2 | |
| $D$12 | LHS | 12,00 | 1,50 | 12 | 6 | 6 | |
| $D$13 | LHS | 18,00 | 1,00 | 18 | 6 | 6 | |