| Microsoft Excel 9.0 Sensitivity Report | |||||||
| Worksheet: [petromorcase.xls]Sheet1 | |||||||
| Report Created: 10/16/2001 9:41:20 PM | |||||||
| Adjustable Cells | |||||||
| Final | Reduced | Objective | Allowable | Allowable | |||
| Cell | Name | Value | Cost | Coefficient | Increase | Decrease | |
| $D$24 | Zone 1 A | 1 | 0 | 1793.75 | 1E+30 | 10.24999996 | |
| $E$24 | Zone 1 B | 0 | -41.00000006 | 1742.5 | 41.00000006 | 1E+30 | |
| $F$24 | Zone 1 C | 0 | 0 | 1804 | 22.50000004 | 8.499999981 | |
| $G$24 | Zone 1 D | 0 | 0 | 1783.5 | 8.499999981 | 20.50000003 | |
| $H$24 | Zone 1 E | 0 | -20.50000003 | 1763 | 20.50000003 | 1E+30 | |
| $I$24 | Zone 1 F | 0 | -41.00000006 | 1742.5 | 41.00000006 | 1E+30 | |
| $D$25 | Zone 2 A | 0 | -106.25 | 1632 | 106.25 | 1E+30 | |
| $E$25 | Zone 2 B | 1 | 0 | 1728 | 1E+30 | 0 | |
| $F$25 | Zone 2 C | 0 | -8.499999981 | 1740 | 8.499999981 | 1E+30 | |
| $G$25 | Zone 2 D | 0 | -48.00000007 | 1680 | 48.00000007 | 1E+30 | |
| $H$25 | Zone 2 E | 0 | 0 | 1728 | 0 | 1E+30 | |
| $I$25 | Zone 2 F | 0 | -84.00000007 | 1644 | 84.00000007 | 1E+30 | |
| $D$26 | Zone 3 A | 0 | -75.75000009 | 1784.5 | 75.75000009 | 1E+30 | |
| $E$26 | Zone 3 B | 0 | -87.00000014 | 1763 | 87.00000014 | 1E+30 | |
| $F$26 | Zone 3 C | 1 | 0 | 1870.5 | 1E+30 | 22.50000004 | |
| $G$26 | Zone 3 D | 0 | -151.5000001 | 1698.5 | 151.5000001 | 1E+30 | |
| $H$26 | Zone 3 E | 0 | -22.50000004 | 1827.5 | 22.50000004 | 1E+30 | |
| $I$26 | Zone 3 F | 0 | -44.00000004 | 1806 | 44.00000004 | 1E+30 | |
| $D$27 | Zone 4 A | 0 | -111.5 | 1710 | 111.5 | 1E+30 | |
| $E$27 | Zone 4 B | 0.00E+00 | -1.13E+01 | 1800 | 11.25000001 | 1E+30 | |
| $F$27 | Zone 4 C | 0 | -9.249999972 | 1822.5 | 9.249999972 | 1E+30 | |
| $G$27 | Zone 4 D | 0 | -11.25000001 | 1800 | 11.25000001 | 1E+30 | |
| $H$27 | Zone 4 E | 1 | 0 | 1811.25 | 1E+30 | 9.249999972 | |
| $I$27 | Zone 4 F | 0 | -44.99999998 | 1766.25 | 44.99999998 | 1E+30 | |
| Constraints | |||||||
| Final | Shadow | Constraint | Allowable | Allowable | |||
| Cell | Name | Value | Price | R.H. Side | Increase | Decrease | |
| $D$28 | Total A | 1 | 10.24999996 | 1 | 0 | 1 | |
| $E$28 | Total B | 1 | 0 | 1 | 1E+30 | 0 | |
| $F$28 | Total C | 1 | 20.49999994 | 1 | 0 | 0 | |
| $G$28 | Total D | 0 | 0 | 1 | 1E+30 | 1 | |
| $H$28 | Total E | 1 | 0 | 1 | 1E+30 | 0 | |
| $I$28 | Total F | 0 | 0 | 1 | 1E+30 | 1 | |
| $J$24 | Zone 1 Total | 1 | 1783.5 | 1 | 1 | 0 | |
| $J$25 | Zone 2 Total | 1 | 1728 | 1 | 0 | 1 | |
| $J$26 | Zone 3 Total | 1 | 1850 | 1 | 0 | 0 | |
| $J$27 | Zone 4 Total | 1 | 1811.25 | 1 | 0 | 1 | |