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%