| Microsoft Excel 9.0 Answer Report | ||||||
| Worksheet: [petromorcase.xls]petro4 | ||||||
| Report Created: 10/16/2001 10:33:53 PM | ||||||
| Target Cell (Max) | ||||||
| Cell | Name | Original Value | Final Value | |||
| $I$5 | Zone 1 Revenue | 8955.25 | 7149.25 | |||
| Adjustable Cells | ||||||
| Cell | Name | Original Value | Final Value | |||
| $D$24 | Zone 1 A | 1 | 1 | |||
| $E$24 | Zone 1 B | 0 | 0 | |||
| $F$24 | Zone 1 D | 0 | 0 | |||
| $G$24 | Zone 1 E | 0 | 0 | |||
| $H$24 | Zone 1 F | 0 | 0 | |||
| $D$25 | Zone 2 A | 0 | 0 | |||
| $E$25 | Zone 2 B | 1 | 1 | |||
| $F$25 | Zone 2 D | 0 | 0 | |||
| $G$25 | Zone 2 E | 0 | 0 | |||
| $H$25 | Zone 2 F | 0 | 0 | |||
| $D$26 | Zone 3 A | 0 | 0 | |||
| $E$26 | Zone 3 B | 0 | 0 | |||
| $F$26 | Zone 3 D | 0 | 0 | |||
| $G$26 | Zone 3 E | 1 | 1 | |||
| $H$26 | Zone 3 F | 1 | 0 | |||
| $D$27 | Zone 4 A | 0 | 0 | |||
| $E$27 | Zone 4 B | 0 | -7.2136E-25 | |||
| $F$27 | Zone 4 D | 1 | 1 | |||
| $G$27 | Zone 4 E | 0 | 1.10134E-13 | |||
| $H$27 | Zone 4 F | 0 | 0 | |||
| Constraints | ||||||
| Cell | Name | Cell Value | Formula | Status | Slack | |
| $I$24 | Zone 1 Total | 1 | $I$24<=1 | Binding | 0 | |
| $I$25 | Zone 2 Total | 1 | $I$25<=1 | Binding | 0 | |
| $I$26 | Zone 3 Total | 1 | $I$26<=1 | Binding | 0 | |
| $I$27 | Zone 4 Total | 1 | $I$27<=1 | Binding | 0 | |
| $D$28 | Total A | 1 | $D$28<=1 | Binding | 0 | |
| $E$28 | Total B | 1 | $E$28<=1 | Binding | 0 | |
| $F$28 | Total D | 1 | $F$28<=1 | Binding | 0 | |
| $G$28 | Total E | 1 | $G$28<=1 | Binding | 0 | |
| $H$28 | Total F | 0 | $H$28<=1 | Not Binding | 1 | |