Microsoft Excel 9.0 Sensitivity Report
Worksheet: [Staffing.xls]Sheet1
Report Created: 9/23/2001 11:41:13 PM
Adjustable Cells
			Final	Reduced	Objective	Allowable	Allowable
	Cell	Name	Value	Cost	Coefficient	Increase	Decrease
	$B$10	Number of Workers to hire 9-5	20	-16	80	16	1E+30
	$C$10	Number of Workers to hire 6-10	4	0	45	1E+30	7.5
Constraints
			Final	Shadow	Constraint	Allowable	Allowable
	Cell	Name	Value	Price	R.H. Side	Increase	Decrease
	$D$17	Wives Total	312	0	240	72	1E+30
	$D$18	Husbands Total	228	0	180	48	1E+30
	$D$19	Single Adult Males Total	210	10	210	72	18
	$D$20	SIngle Adult Females Total	216	0	160	56	1E+30