Microsoft Excel 9.0 Sensitivity Report |
|
|
|
Worksheet:
[Contoh Soal LP-Solver.xls]LP07 |
|
Report
Created: 20/06/00 19:35:26 |
|
|
Adjustable
Cells |
|
|
|
|
Final |
Reduced |
Objective |
Allowable |
Allowable |
|
Cell |
Name |
Value |
Cost |
Coefficient |
Increase |
Decrease |
|
$B$6 |
Jawaban: XF1-F2 |
0,000 |
1,000 |
2 |
1E+30 |
1 |
|
$C$6 |
Jawaban: XF1-DC |
40,000 |
0,000 |
4 |
1 |
1E+30 |
|
$D$6 |
Jawaban: XF1-W1 |
10,000 |
0,000 |
9 |
1E+30 |
2 |
|
$E$6 |
Jawaban: XF2-DC |
40,000 |
0,000 |
3 |
1E+30 |
1 |
|
$F$6 |
Jawaban: XDC-W2 |
80,000 |
0,000 |
1 |
2 |
1E+30 |
|
$G$6 |
Jawaban: XW1-W2 |
0,000 |
5,000 |
3 |
1E+30 |
5 |
|
$H$6 |
Jawaban: XW2-W1 |
20,000 |
0,000 |
2 |
2 |
5 |
|
Constraints |
|
|
|
|
Final |
Shadow |
Constraint |
Allowable |
Allowable |
|
Cell |
Name |
Value |
Price |
R.H. Side |
Increase |
Decrease |
|
$I$11 |
1. Net flow LHS |
50,00 |
7,00 |
50 |
0 |
10 |
|
$I$12 |
LHS |
40,00 |
6,00 |
40 |
0 |
10 |
|
$I$13 |
LHS |
0,00 |
3,00 |
0 |
0 |
10 |
|
$I$14 |
LHS |
-30,00 |
-2,00 |
-30 |
0 |
1E+30 |
|
$I$15 |
LHS |
-60,00 |
0,00 |
-60 |
1E+30 |
0 |
|
$I$16 |
2. Upper-bound LHS |
0,00 |
0,00 |
10 |
1E+30 |
10 |
|
$I$17 |
LHS |
80,00 |
-2,00 |
80 |
10 |
20 |
|
|
|
|
|
|
|
|