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