Skip to content
Shop | Excel system

Workforce Planning and Shift Scheduling System

Requirement, availability, shift model comparison, monthly plan with peaks and valleys, stations and posts, crew sizes and rolling pattern, qualification coverage, measure ladder, working time account, key figures and audit.

Screenshot of the Workforce Planning and Shift Scheduling System workbook with example data
Example data from the workbook.

How it works

  1. 02 Setup holds the area, its operating hours, the utilization, the allowance, the rates and the working time account band.
  2. 03 Program and 04 Availability turn units and calendar days into attendance hours and net working time per employee.
  3. 05 Requirement gives the head count. 06 Shift Models compares models with hours, load, people, cost and burden.
  4. 07 Monthly Plan shows the peaks and valleys of the year against the capacity of the chosen model.
  5. 08 Stations, 09 Crews and Pattern and 10 Qualification give posts, crew sizes, a rolling pattern and a coverage check.
  6. 11 Flexibility holds the measure ladder and the working time account. 12 Key Figures tracks six numbers per month.
  7. 13 Audit holds the 25 statements with the radar. 14 Status is the one-page summary for the monthly review.

Definitions used in the workbook

  • Attendance hours: Productive hours / utilization. The hours you have to pay for at the stations.
  • Attendance factor: Net attendance days / gross working days. Crew size = posts to cover / attendance factor.
  • Load of a model: Attendance hours needed / station hours of the model. Above 100 percent the model does not carry the program.
  • Minimum coverage: People at level 3 or higher that a station needs: one per shift plus the reserve from 02 Setup.

Sheets in the workbook

  1. Start
  2. Setup
  3. Program
  4. Availability
  5. Requirement
  6. Shift Models
  7. Monthly Plan
  8. Stations
  9. Crews and Pattern
  10. Qualification
  11. Flexibility
  12. Key Figures
  13. Audit
  14. Status

Who it is for

Area managers, shift leaders and planners who build a roster that holds and want the numbers behind it.

Cheaper in the pack

This workbook is part of the Leadership and Management Tool Pack (EUR 129), which holds all 16 Excel tools of this topic area, and of the Excel Tools Complete Library with all 100 tools.

The method behind the numbers

This workbook is part of the Workforce Planning and Shift Scheduling toolkits. The Starter Kit adds the guide and the checklist for the first 30 days. The Excellence Bundle adds playbook, workshop pack, templates, deck and the complete Excel system.

Newsletter

One Lean idea.
Every two weeks.