End of the quarter. The operations manager wants to recognize the best inspectors. He also wants to know which branch needs support.
His challenge is to be fair. Counting reports rewards whoever produces most, even if many get cancelled. The villain is the simple metric.
The question
«Give me the top 10 most efficient inspectors, grouped by branch, with charts.»
You can also ask
- «Recalculate giving more weight to speed.»
- «Separate the cancelled reports that were reissued.»
How the assistant answered
Give me the top 10 most efficient inspectors, grouped by branch, with charts.
Method: 40% effective reports, 40% low rework (cancelled or returned) and 20% verification speed. Last 90 days, inspectors with more than 100 reports.
The top 10 has 6 from the North branch and 4 from Center. Center is the fastest, but with the most rework (18%). South has the least (4%).
If you prefer other weights, I’ll recalculate.
Based on a real case; names and figures changed
What it answers and why it matters
- 1
A method you can see and change
The assistant explains how it scores and keeps it adjustable. If you prefer other weights or another period, ask and it recalculates.
- 2
Charts by inspector and by branch
Top 10 scores, average by branch and rework by branch. The assistant draws them with the data it queries in RETGAS.
- 3
Findings the simple metric hides
The fastest branch isn’t the one with the least rework. Whoever produces most isn’t necessarily the most efficient. The score is relative to the group compared.
Read-only and with your same permissions. Gas users’ personal data never leaves RETGAS. See privacy
The manager didn’t need a count. He needed a criterion he could explain. Now he has one, and adjusts it with a sentence.
