The StaffBacklog.xlsx Model

Staffing with Backlogging

View the model

Download the model

Given an hourly demand pattern, how many staffers should we start each hour? Work not completed in hour t is carried forward (backlogged) to t+1 or later, at a cost. Demand is assumed cyclic, i.e., same demand pattern tomorrow, so the schedule "wraps around." Notice how the formula in the Available Staff column changes. Each staffer works an 8 hour shift. There are 3 criteria: 1) Staffing costs, 2) Amount of Backlog, 3) Max overstaffing any period.

Keywords:

Scheduling | Staff Scheduling | Covering | Multi-criteria | Backlogging | Workforce Scheduling |