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.