Microsoft Excel 9.0 Sensitivity Report
Worksheet: [petromorcase.xls]petro2
Report Created: 10/16/2001 10:22:54 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	51.25
	$E$24	Zone 1 B	0	-9.25	1742.5	9.25	1E+30
	$F$24	Zone 1 C	0	0	1804	2	29.75
	$G$24	Zone 1 E	0	0	1763	24.5	2
	$H$24	Zone 1 F	0	0	1742.5	9.25	3
	$D$25	Zone 2 A	0	-138	1632	138	1E+30
	$E$25	Zone 2 B	1	0	1728	1E+30	11.25
	$F$25	Zone 2 C	0	-40.25	1740	40.25	1E+30
	$G$25	Zone 2 E	0	-11.25	1728	11.25	1E+30
	$H$25	Zone 2 F	0	-74.75	1644	74.75	1E+30
	$D$26	Zone 3 A	0	-75.75	1784.5	75.75	1E+30
	$E$26	Zone 3 B	0	-55.25	1763	55.25	1E+30
	$F$26	Zone 3 C	1	0	1870.5	1E+30	2
	$G$26	Zone 3 E	0	-2	1827.5	2	1E+30
	$H$26	Zone 3 F	0	-3	1806	3	1E+30
	$D$27	Zone 4 A	0	-132	1710	132	1E+30
	$E$27	Zone 4 B	0	0	1800	11.25	9.25
	$F$27	Zone 4 C	0	-29.75	1822.5	29.75	1E+30
	$G$27	Zone 4 E	1	0	1811.25	9.25	11.25
	$H$27	Zone 4 F	0	-24.5	1766.25	24.5	1E+30
Constraints
			Final	Shadow	Constraint	Allowable	Allowable
	Cell	Name	Value	Price	R.H. Side	Increase	Decrease
	$D$28	Total A	1	51.25	1	0	1
	$E$28	Total B	1	9.25	1	0	0
	$F$28	Total C	1	61.5	1	0	0
	$G$28	Total E	1	20.5	1	0	0
	$H$28	Total F	0	0	1	1E+30	1
	$I$24	Zone 1 Total	1	1742.5	1	1	0
	$I$25	Zone 2 Total	1	1718.75	1	0	0
	$I$26	Zone 3 Total	1	1809	1	0	0
	$I$27	Zone 4 Total	1	1790.75	1	0	0