| STAFFING.XLS | Telephone Staffing Problem | |||||||
| Day | Evening | |||||||
| Shift | 9am-5pm | 6-9pm | ||||||
| Hours per shift | 8 | 3 | Total Cost | |||||
| Calls per hour | 12 | 10 | ||||||
| Cost per hour | н$ннннннн 10 | н$ннннннн 15 | ||||||
| Cost per worker | н$ннннннн 80 | н$ннннннн 45 | ||||||
| Number of workers to hire | ||||||||
| Limit | 20 | 20 | ||||||
| Number of Calls | ||||||||
| Minimum | ||||||||
| Expected Results | Day | Evening | Total | Requirement | ||||
| Wives | 15% | 20% | 240 | |||||
| Husbands | 10% | 30% | 180 | |||||
| Single Adult Males | 10% | 15% | 210 | |||||
| Single Adult Females | 10% | 20% | 160 | |||||
| No Answer | 55% | 15% | ||||||