Microsoft Excel 9.0 Sensitivity Report
Worksheet: [petromorcase.xls]petro3
Report Created: 10/16/2001 10:26:10 PM
Adjustable Cells
			Final	Reduced	Objective	Allowable	Allowable
	Cell	Name	Value	Cost	Coefficient	Increase	Decrease
	$D$24	Zone 1 A	1	0	1783.5	1E+30	0
	$E$24	Zone 1 B	0	-40.99999996	1742.5	40.99999996	1E+30
	$F$24	Zone 1 C	0	0	1804	22.49999994	8.500000061
	$G$24	Zone 1 D	0	0	1783.5	0	20.50000003
	$H$24	Zone 1 E	0	-20.50000003	1763	20.50000003	1E+30
	$I$24	Zone 1 F	0	-40.99999996	1742.5	40.99999996	1E+30
	$D$25	Zone 2 A	0	-96.00000007	1632	96.00000007	1E+30
	$E$25	Zone 2 B	1	0	1728	0	8.50000006
	$F$25	Zone 2 C	0	-8.500000061	1740	8.500000061	1E+30
	$G$25	Zone 2 D	0	-48.00000006	1680	48.00000006	1E+30
	$H$25	Zone 2 E	0	0	1728	9.250000063	0
	$I$25	Zone 2 F	0	-84.00000006	1644	84.00000006	1E+30
	$D$26	Zone 3 A	0	-65.50000008	1784.5	65.50000008	1E+30
	$E$26	Zone 3 B	0	-87.00000004	1763	87.00000004	1E+30
	$F$26	Zone 3 C	1	0	1870.5	1E+30	22.49999994
	$G$26	Zone 3 D	0	-151.5	1698.5	151.5	1E+30
	$H$26	Zone 3 E	0	-22.49999994	1827.5	22.49999994	1E+30
	$I$26	Zone 3 F	0	-43.99999995	1806	43.99999995	1E+30
	$D$27	Zone 4 A	0	-101.2500001	1710	101.2500001	1E+30
	$E$27	Zone 4 B	0	-11.25000001	1800	11.25000001	1E+30
	$F$27	Zone 4 C	0	-9.250000063	1822.5	9.250000063	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.250000063
	$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
	$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
	$D$28	Total A	1	0	1	0	1
	$E$28	Total B	1	0	1	1E+30	0
	$F$28	Total C	1	20.50000003	1	0	0
	$G$28	Total D	0	0	1	1E+30	1
	$H$28	Total E	1	0	1	1	0
	$I$28	Total F	0	0	1	1E+30	1