Can anybody please help me in calculating the attrition rate? I am not able to figure out the actual formula. I tried Google as well, but there are too many formulae, and I can't make out which is the actual one.
Thanks,
Axita
From India, Chandigarh
Acknowledge(0)
Amend(0)
21Thanks,
Axita
From India, Chandigarh
Acknowledge(0)Amend(0)
Opening Balance
- No. of Employees Joined
- No. of Employees Left
- Closing Balance: Opening balance + No. of Employees Joined - No. of Employees Left
- Average Head Count: (Opening balance + Closing Balance) / 2
- Attrition Rate: (No. of Employees Left / Average Head Count) * 100
Ensure Proper Paragraph Formatting:
- Opening balance
- No. of Employees Joined
- No. of Employees Left
- Closing Balance: Opening balance + No. of Employees Joined - No. of Employees Left
- Average Head Count: (Opening balance + Closing Balance) / 2
- Attrition Rate: (No. of Employees Left / Average Head Count) * 100
From India, Delhi
Acknowledge(0)Amend(0)
- No. of Employees Joined
- No. of Employees Left
- Closing Balance: Opening balance + No. of Employees Joined - No. of Employees Left
- Average Head Count: (Opening balance + Closing Balance) / 2
- Attrition Rate: (No. of Employees Left / Average Head Count) * 100
Ensure Proper Paragraph Formatting:
- Opening balance
- No. of Employees Joined
- No. of Employees Left
- Closing Balance: Opening balance + No. of Employees Joined - No. of Employees Left
- Average Head Count: (Opening balance + Closing Balance) / 2
- Attrition Rate: (No. of Employees Left / Average Head Count) * 100
From India, Delhi
Acknowledge(0)Amend(0)
Hi Axita, This one can also help you....... Resignees/Closing Headcount closing Headcount= Opening Headcount+New Joinees-Resignees Check out
From India, Gurgaon
Acknowledge(0)Amend(0)
From India, Gurgaon
Acknowledge(0)Amend(0)
Attrition Rate Calculation
Opening balance: 817
No. of Employees Joined: 35
No. of Employees Left: 19
Closing Balance: 833
Average Head Count: 825
Attrition %: 2.30
Formula:
- Opening balance (817) + No. of Employees Joined (35) - No. of Employees Left (19) = Closing Balance (833)
- (Opening balance (817) + Closing Balance (833)) / 2 = Average Head Count (825)
- (No. of Employees Left (19) / Average Head Count (825)) * 100 = Attrition % (2.30)
Now, the Attrition Rate is 2.30%.
From India, Delhi
Acknowledge(0)Amend(0)
Opening balance: 817
No. of Employees Joined: 35
No. of Employees Left: 19
Closing Balance: 833
Average Head Count: 825
Attrition %: 2.30
Formula:
- Opening balance (817) + No. of Employees Joined (35) - No. of Employees Left (19) = Closing Balance (833)
- (Opening balance (817) + Closing Balance (833)) / 2 = Average Head Count (825)
- (No. of Employees Left (19) / Average Head Count (825)) * 100 = Attrition % (2.30)
Now, the Attrition Rate is 2.30%.
From India, Delhi
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Attrition Rate formula.pdf
SAMPLE Employee Attrition Calculation sheet for FY 09-10 .xls
Calculation of Attrition Rate.doc