Skip to content
Workforce Planning and Shift Scheduling | Part 8 of 8

Six Key Figures for Workforce Planning

Staffing level, overtime rate, agency share, turnover, cost per attendance hour and planning accuracy: definitions, targets and what they looked like after twelve months.

Six numbers, the same definitions every month, one page and one meeting. More than six and the review becomes a report. Fewer and the first bad month looks like bad luck.

The six

Key figure Formula A2 before Target
Staffing level Posts covered / posts planned 94 % 100 %
Overtime rate Overtime hours / attendance hours 9.0 % Below 3 %
Agency share Agency hours / attendance hours 7.4 % Below 2 %
Turnover Leavers in 12 months / average head count 23.8 % Below 10 %
Cost per attendance hour Labor cost / attendance hours EUR 40.87 Watched
Planning accuracy Shifts staffed as published / shifts published 78 % Above 95 %

The first three measure the plan. Turnover measures what the plan does to people. Planning accuracy measures the promise a published roster makes. Cost per attendance hour is watched rather than pushed: a model with more night and weekend hours has a higher rate and can still be the cheaper model. Push the rate and the area will quietly return to the model that cannot carry the program.

Why the staffing level matters more than it looks

Ninety-four percent sounds close to full. In area A2 it meant 1,800 post hours per year with no operator at a station. The area recovered that output with 2,900 hours of overtime and 2,400 hours of agency labor, which is roughly three paid hours for every post hour lost: catch-up work, extra handovers and agency people who reach full output only after about three weeks. At EUR 47.50 and EUR 46.00 per hour, those two lines came to EUR 248,150 per year of avoidable cost.

Twelve months in area A2

Key figure Month 0 Month 6 Month 12
Staffing level 94 % 98 % 100 %
Overtime rate 9.0 % 4.1 % 2.3 %
Agency share 7.4 % 3.0 % 1.5 %
Turnover 23.8 % 15.4 % 7.7 %
Planning accuracy 78 % 90 % 96 %
Changes after the roster was published, per month 34 14 6

Overtime fell from 2,900 to 900 hours and agency labor from 2,400 to 600, worth EUR 177,800 per year. Together with the EUR 356,250 saved by choosing two shifts plus a partial night shift instead of three full shifts, the area ended the year EUR 534,050 below the alternative it almost chose.

Turnover is the figure that moved last and mattered most. The roster was the cause. One week of notice and 34 changes a month is a working life nobody can plan around, and the people with the most options leave first, which is exactly the group whose qualification the area cannot spare.

The monthly review

Five items, forty minutes, one owner per figure:

  • The requirement of the next three months against capacity, brought by the planner. Decision: which measure from the ladder, and when.
  • The six figures with trend, brought by the area manager. Decision: one action per figure that is off target.
  • Working time account balances and qualification coverage, brought by the shift leaders. Decision: build-up, reduction and the next trainings with names and dates.
  • Open points from the daily rounds, brought by the shift leaders. Decision: what has to be fixed outside the shift.
  • One structural question per quarter: is the allowance still right, is the absence rate still right, has the program moved beyond the agreed threshold?

A figure without an owner and an action is decoration. A review that takes more than forty minutes has turned into a report, and the next one will be skipped.

Newsletter

One Lean idea.
Every two weeks.