The typical situation
Rosters were built each month from the previous month, so technicians were overstaffed in branches where demand had moved and overstretched where it had grown.
Ticket data from two years sat in the service-management tool. Nobody had looked at it by weekday, branch and season together.
What the data looked like
Two years of tickets with timestamps and branch, attendance records, overtime claims and the SLA definitions. No data-quality problems to speak of; the tool was well maintained.
What we built
- A weekly demand forecast per branch, accurate to within 9% on average.
- A roster suggestion the planner adjusts, not a replacement for the planner.
- A one-page report comparing forecast to actual every week, so the planner can see when to trust it.
Typical outcome
| Measure | Before | After | Period |
|---|---|---|---|
| Overtime hours | 2,100 / month | 1,720 / month | quarter before vs quarter after |
| Tickets breaching SLA | 6.1% | 4.4% | same period |
What usually trips these projects up
We should have involved branch managers earlier; the first roster suggestions were technically right and politically unwelcome. Adoption rose once managers could see the forecast-vs-actual report.