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

Net Working Time: Why 250 Days Become 205

How to calculate the attendance days and hours one employee really delivers, where the absence rate comes from, and what the attendance factor decides.

The most common error in workforce planning is quiet and expensive: treating an employee as available for every operating day. A plan built on 250 days needs a fifth more people than it has, and finds out in the first week of the year.

From the calendar to attendance days

Area A2 of this series runs 250 operating days. One employee of that area is at a station on 205 of them:

Step Note Days
Calendar days 365
Minus weekends Saturdays and Sundays of the example year 104
Minus public holidays on working days Example value for one site 11
Gross working days The operating days of the area 250
Minus vacation Entitlement of the area 30
Minus absence Sickness and other, from the last twelve months 12
Minus qualification and training Planned as days, not taken from the staffing 3
Net attendance days 205

At 7.5 paid hours per shift that is 1,537.5 net attendance hours per employee and year. Vacation and absence days are paid, so the cost is spread over fewer attendance hours: a fully loaded EUR 58,425 per year, an example value, becomes EUR 38.00 per attendance hour.

The attendance factor

Net attendance days divided by gross working days is the attendance factor. In area A2 it is 205 / 250 = 82 percent. On an average day, 82 of every 100 employees of the area are at a station.

Every crew size follows from it. A shift that has to cover eight posts needs 8 / 0.82 = 9.8 people on its list, not eight. Plan eight and the shift is short on four days out of five.

Where the absence rate comes from

The rate used in the plan has to come from this area, not from the plant. A three-shift area with heavy work behaves differently from an office, and a plant average hides both. Four rules keep the figure honest:

  • From this area, over twelve months. Sickness is seasonal, and one quarter proves nothing.
  • Split short-term from long-term. Only absence of one to three days has to be covered on the day by a floater. A case of several weeks is a named replacement or a temporary transfer, and it is not covered by the allowance for variation.
  • Count training as its own line. Qualification time that is taken out of the staffing when it is needed is training that does not happen.
  • Write it down and date it. The rate is signed off by the area manager once a year, so that next year starts with a figure and not with a debate.

In area A2 short-term absence is 4.8 percent of attendance days. Long-term cases are counted separately and come to 1.4 employees over the year.

The vacation calendar comes before the roster

Thirty days per employee is the largest single block in the table, and it is the only one that can be steered. In A2 the months above 95 percent load are April to June and September to November, so vacation is guided toward July, August and the turn of the year.

Three rules make it work. Protect the peak months. Cap vacation at two of ten in one crew at the same time, so the pattern still runs. Never let both remaining qualified people of a thin station leave in the same week. The calendar closes eight weeks before the quarter.

What the number buys you

With 1,537.5 attendance hours per employee, the 35,000 hours of the program become 22.8 employees, which is the floor before any shift model. The rest of the arithmetic is simple. Getting here is where most plans go wrong, because every step in the table looks small and together they remove 45 days, or nine employees out of 26.

Newsletter

One Lean idea.
Every two weeks.