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 |