Who is actually carrying our overtime?
Eleven people worked 37% of the overtime, and seven of them have since left. The cost is concentrated on the people walking out the door.
What went in
- Files
- 3
- Rows
- 100,459
- Period
- Jul 1, 2025 – Jun 30, 2026
- Verification
- 19 checks passed
Source files
- rota_2025_2026.xlsx48,900 rows
- clock_records.csv51,272 rows
- headcount_and_leavers.xlsx287 rows
What came back
- 28.8%
- 5.0%
- $574,454
The finished project
rota_2025_2026.xlsx
48,900 rowsCheckedThe overtime is not spread across the team, and the people carrying it are the ones leaving.
Eleven people worked 6,884 of the year's 18,412 overtime hours, and nine of them are on the night rota. Seven of those eleven have since left. Separately, the 27% attrition the business reports is computed on closing headcount, which flatters a year in which headcount grew from 198 to 226; on average headcount the same 61 leavers give 28.8%. Seven in ten of them left inside their first year.
28.8%Attrition+4.7pp
70.5%Leavers inside a year
5.0%Overtime on scheduled hours+1.1pp
Most of the leaving happens in the first year
43 of 61 leavers were inside their first year
- 01Eleven people worked 37% of the overtime, and seven of them have left.
- 02Attrition is 28.8%, not the 27.0% currently reported.
- 03Seven in ten leavers went inside their first year.
Filed under
Closest to this one
Have something like this?
Drop it in and see what comes back. You only pay once you like it.
No account needed to start. You only pay when you like what you see.