Microsoft Excel 9.0 Sensitivity Report
Worksheet: [petromorcase.xls]petro4
Report Created: 10/16/2001 10:33:53 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.25
$E$24 Zone 1 B 0 -41 1742.5 41 1E+30
$F$24 Zone 1 D 0 0 1783.5 10.25 31.75
$G$24 Zone 1 E 0 -31.75 1763 31.75 1E+30
$H$24 Zone 1 F 0 -41 1742.5 41 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 11.25
$F$25 Zone 2 D 0 -48 1680 48 1E+30
$G$25 Zone 2 E 0 -11.25 1728 11.25 1E+30
$H$25 Zone 2 F 0 -84 1644 84 1E+30
$D$26 Zone 3 A 0 -42 1784.5 42 1E+30
$E$26 Zone 3 B 0 -53.25 1763 53.25 1E+30
$F$26 Zone 3 D 0 -117.75 1698.5 117.75 1E+30
$G$26 Zone 3 E 1 0 1827.5 1E+30 10.25
$H$26 Zone 3 F 0 -10.25 1806 10.25 1E+30
$D$27 Zone 4 A 0 -100.25 1710 100.25 1E+30
$E$27 Zone 4 B -7.2136E-25 0 1800 11.25 0
$F$27 Zone 4 D 1 0 1800 0 10.25
$G$27 Zone 4 E 1.10134E-13 0 1811.25 10.25 11.25
$H$27 Zone 4 F 0 -33.75 1766.25 33.75 1E+30
Constraints
    Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$I$24 Zone 1 Total 1 1783.5 1 0 0
$I$25 Zone 2 Total 1 1728 1 0 1
$I$26 Zone 3 Total 1 1816.25 1 0 1
$I$27 Zone 4 Total 1 1800 1 0 1
$D$28 Total A 1 10.25 1 0 0
$E$28 Total B 1 0 1 1 0
$F$28 Total D 1 0 1 1E+30 0
$G$28 Total E 1 11.25 1 1 0
$H$28 Total F 0 0 1 1E+30 1