HR analytics

Almost the entire wage increase was indexation.

Nobody had ever taken the payroll apart. Once it sat on one screen, the argument changed from "we are too expensive" to "here is the part we can actually move".

Where the wage increase came fromShare of the total rise
97% — automatic indexation
3%
0%50%100%

Indexation is not a lever. What is left is the structure underneath it: who is on the payroll, how long they have been there, how often they are out, and what the replacement costs.

What we built, first

Payroll against the sector

We tracked how the wage bill had evolved and found that nearly every increase traced back to indexation. Then we put the team's age distribution and pay grades next to the sector benchmark. The workforce was older, and therefore more expensive, than comparable companies.

This phase ran under our free startup package

What we built, second

What absence actually costs

We singled out the people with persistent absence and put a figure on the interim cover. Not a percentage in a report: the real yearly cost of keeping the shifts filled.

The company introduced a one-off bonus tied to attendance. Absence dropped quickly, and the interim bill came down with it.

Before100
After68

Absence, indexed to 100. A drop of 32%.

What we built, third

One screen instead of four spreadsheets

Wage evolution, absence patterns, performance ratings and the differences between branches, all in a single overview. It showed how the wage bill had grown, how the team compared with the sector, who was structurally absent, and what each branch was contributing.

That last column turned out to matter most.

1 branch

Comparing branches side by side exposed a management problem that had been showing up as a company-wide number. The leadership there was replaced and strengthened. Stability and performance followed.

The breakthrough

Pay finally lined up with performance

A full internal evaluation brought compensation back in line with what people actually delivered. Together with the attendance bonus and the branch intervention, that restored fairness in the team and took the swings out of the HR budget.

A year on

Wage costs are predictable, absence is down, and people are paid for what they deliver.

Phase one is free: we listen, pull your data and build a working prototype. You decide afterwards whether we carry on.Ask for your prototype