Assigning telephone operators to shifts at New Brunswick Telephone Company

I developed a procedure for assigning telephone operators to shifts at New Brunswick Telephone Company (NBTel). Although the problem has received scant attention in the literature, its solution greatly affects employees' satisfaction with their work schedules. NBTel requires that all shifts be assigned to employees, and it is obligated contractually to satisfy preferences for shifts in order of employee seniority. The specialized shift assignment heuristic (SSAH) that I developed runs on a personal computer, generating approximately three solutions per second. Employee and shift databases are maintained in a spreadsheet, and macros are used to integrate the heuristic into the spreadsheet. Both management and employees see SSAH as an improvement over the previous manual procedure.