36.13 HR
HR interviews ask attrition, offer acceptance, and time to fill. "We got 200 CVs" is the vanity metric of this function. Do not invent salaries in this table. Headcount does not need pay (Module 35.4).
| KPI | What the number means | Who uses it | Action it drives |
|---|---|---|---|
| Attrition | People who left in the month divided by headcount at the start. | HR business partner, city lead | A spike is exit interviews, not a hiring poster. |
| Offer acceptance | Offers accepted divided by offers made. | Recruiter | A low rate means pay, role, or delay. More CVs will not fix a refused offer. |
| Time to fill | Sum of days to fill divided by roles filled. | HR lead | A long fill on one role blocks that team's work. Report the role, not only the average. |
Fictional sample rows. One month.
| City | Start headcount | Left | Offers | Accepted | Days-to-fill sum | Roles filled | Applications |
|---|---|---|---|---|---|---|---|
| Pune | 40 | 2 | 8 | 6 | 48 | 4 | 200 |
| Nashik | 30 | 3 | 4 | 3 | 60 | 3 | 40 |
| Kolhapur | 20 | 1 | 2 | 2 | 20 | 2 | 30 |
| Nagpur | 25 | 0 | 3 | 1 | 45 | 1 | 150 |
| Mumbai | 15 | 1 | 2 | 2 | 16 | 2 | 20 |
| Sambhaji Nagar | 18 | 2 | 4 | 2 | 36 | 2 | 80 |
Worked from those rows.
- Start headcount 148. Left 9. Offers 23. Accepted 16. Days-to-fill sum 225. Roles filled 14. Applications 520.
- Attrition is 9 ÷ 148 = 6.1%.
- Offer acceptance is 16 ÷ 23 = 69.6%.
- Time to fill is 225 ÷ 14 = 16.1 days.
Nashik attrition is 3 ÷ 30 = 10.0%. Acceptance is 3 ÷ 4 = 75.0%. Time to fill is 60 ÷ 3 = 20.0 days. Nagpur attrition is 0, but acceptance is 1 ÷ 3 = 33.3%, time to fill is 45 ÷ 1 = 45 days, and applications are 150.
| Good KPI | Vanity metric | |
|---|---|---|
| From the same rows | Nagpur acceptance 33.3% and 45 days to fill one role | Nagpur 150 applications, and Pune 200 applications |
| Why | Two offers were refused and the one hire took a month and a half. | The CV card says recruiting "worked". Nashik hired 3 people from 40 applications. |
What the manager does. The Nashik HR partner holds exit conversations for the 3 leavers (10% of a 30-person start). That is the week's work, not a job fair. The Pune partner does not celebrate 200 CVs. Pune acceptance is 6 ÷ 8 = 75.0% and time to fill is 48 ÷ 4 = 12 days, which is fine in this file. Ask Nagpur why two offers died before posting the role again.
Ravindra Bagale's Tip
A common mistake in attrition is putting people who just joined into "left" as well, or dividing by the end headcount. This table uses the start headcount. Write which denominator you used in the title. Remember this rule.
Ravindra Bagale's Tip – मराठी
Attrition मधली एक common चूक म्हणजे नुकतेच join झालेल्यांना पण "left" मध्ये घालणं, किंवा end headcount ने भागणं. हा table start headcount वापरतो. कोणता denominator वापरला ते title मध्ये लिहा. हा नियम लक्षात ठेवा.
Ravindra Bagale's Tip – हिंदी
Attrition की एक common गलती है अभी join हुए लोगों को भी "left" में डालना, या end headcount से भाग देना. यह table start headcount इस्तेमाल करती है. कौन-सा denominator इस्तेमाल किया, title में लिखो. यह नियम याद रखो.