| Microsoft Excel 9.0 Answer Report | ||||||
| Worksheet: [Staffing.xls]Sheet1 | ||||||
| Report Created: 9/23/2001 11:41:12 PM | ||||||
| Target Cell (Min) | ||||||
| Cell | Name | Original Value | Final Value | |||
| $E$6 | Calls per hour Total Cost | 1475 | 1780 | |||
| Adjustable Cells | ||||||
| Cell | Name | Original Value | Final Value | |||
| $B$10 | Number of Workers to hire 9-5 | 10 | 20 | |||
| $C$10 | Number of Workers to hire 6-10 | 15 | 4 | |||
| Constraints | ||||||
| Cell | Name | Cell Value | Formula | Status | Slack | |
| $D$17 | Wives Total | 312 | $D$17>=$F$17 | Not Binding | 72 | |
| $D$18 | Husbands Total | 228 | $D$18>=$F$18 | Not Binding | 48 | |
| $D$19 | Single Adult Males Total | 210 | $D$19>=$F$19 | Binding | 0 | |
| $D$20 | SIngle Adult Females Total | 216 | $D$20>=$F$20 | Not Binding | 56 | |
| $B$10 | Number of Workers to hire 9-5 | 20 | $B$10<=$B$12 | Binding | 0 | |
| $C$10 | Number of Workers to hire 6-10 | 4 | $C$10<=$C$12 | Not Binding | 16 | |