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