| Microsoft Excel 15.0 Sensitivity Report |
| Worksheet: [Transportation.xlsx]Transportation |
| Report Created: 2/27/2014 9:12:54 PM |
| Variable Cells |
|
|
|
| Final |
Reduced |
Objective |
Allowable |
Allowable |
|
| Cell |
Name |
Value |
Cost |
Coefficient |
Increase |
Decrease |
|
| $B$7 |
Morgan Valley |
0 |
80 |
50 |
1E+30 |
80 |
|
| $C$7 |
Morgan Town |
35 |
0 |
30 |
50 |
1E+30 |
|
| $D$7 |
Morgan Junction |
0 |
100 |
60 |
1E+30 |
100 |
|
| $E$7 |
Morgan Burg |
0 |
50 |
70 |
1E+30 |
50 |
|
| $B$8 |
Youngs Valley |
30 |
0 |
20 |
80 |
1E+30 |
|
| $C$8 |
Youngs Town |
5 |
0 |
80 |
20 |
40 |
|
| $D$8 |
Youngs Junction |
25 |
0 |
10 |
100 |
1E+30 |
|
| $E$8 |
Youngs Burg |
0 |
20 |
90 |
1E+30 |
20 |
|
| $B$9 |
Pitts Valley |
0 |
120 |
100 |
1E+30 |
120 |
|
| $C$9 |
Pitts Town |
5 |
0 |
40 |
40 |
20 |
|
| $D$9 |
Pitts Junction |
0 |
110 |
80 |
1E+30 |
110 |
|
| $E$9 |
Pitts Burg |
20 |
0 |
30 |
20 |
1E+30 |
| Constraints |
|
|
|
| Final |
Shadow |
Constraint |
Allowable |
Allowable |
|
| Cell |
Name |
Value |
Price |
R.H. Side |
Increase |
Decrease |
|
| $B$10 |
Shipped Valley |
30 |
20 |
30 |
0 |
30 |
|
| $C$10 |
Shipped Town |
45 |
80 |
45 |
0 |
5 |
|
| $D$10 |
Shipped Junction |
25 |
10 |
25 |
0 |
25 |
|
| $E$10 |
Shipped Burg |
20 |
70 |
20 |
0 |
5 |
|
| $F$7 |
Morgan Used |
35 |
-50 |
35 |
5 |
0 |
|
| $F$8 |
Youngs Used |
60 |
0 |
60 |
1E+30 |
0 |
|
| $F$9 |
Pitts Used |
25 |
-40 |
25 |
5 |
0 |