| 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 | |