STAFFING.XLS Telephone Staffing Problem
Day Evening
Shift 9-5 6-10
Hours per shift 8 3 Total Cost
Calls per hour 12 10 1780
Cost per hour 10 15
Cost per worker 80 45
Number of Workers to hire 20 4
Decision Variables
<= <=
Limit 20 20
Number of Calls 1920 120
Expected Results Day Evening Total Minimun Requirement
Wives 15% 20% 312 >= 240
Husbands 10% 30% 228 >= 180
Single Adult Males 10% 15% 210 >= 210
SIngle Adult Females 10% 20% 216 >= 160
No Answer 55% 15% 1074