can any one give me the detail about how to find the attrition rate. i am totally confused. Ragahavan
From India, Madras
Acknowledge(0)
Amend(0)

Hi Ragha, Please do find what I have if this useful to you.
From India, Mumbai
Attached Files (Download Requires Membership)
File Type: xls Attrition Calculator and Register(1).xls (23.0 KB, 7745 views)

Acknowledge(0)
Amend(0)

hi.............. i hope the following link may help you in some way..............
From India, Ludhiana
Acknowledge(0)
Amend(0)

Dear raghav, TO CALCULATE ATTRITION THE FORMULA IS : ATTRITION RATE — TOTAL NO OF EMPLOYEES LEFT DURING THAT MONTH/TOTAL NO OF EMPLOYEES*100
From India, Gurgaon
Acknowledge(0)
Amend(0)

Nawas
52

Attrition Formula:
(No.of employees left in the organization/ Avg employees or total employees) X 100
some organization would take total employees to calculate attrition rate & sme takes avg employees during the year or month, depends upon monthly or yearly report.
Thanks

From Kuwait, Kuwait
Acknowledge(0)
Amend(0)

hii, find the attached document on attrition and retention.... if any points to be added ...kindly do it
From India, Hyderabad
Attached Files (Download Requires Membership)
File Type: doc Attrtion & Retention.doc (43.0 KB, 1801 views)

Acknowledge(0)
Amend(0)

hi, please find the attached formula. hope this will help you to understand attrition. rgds jyoti negi
From India, Delhi
Attached Files (Download Requires Membership)
File Type: pdf Attrition Rate formula.pdf (55.0 KB, 1581 views)

Acknowledge(0)
Amend(0)

ATTRITION RATE
(The formula and correct logic behind calculation of Attrition Rate)
((no. Of attritions x 100) / (Actual Employees + New Joined)) /100.
Examples:
1) Actual Employees No. Of people left No. Of Joined Total Employees
(Opening BAL) (Attritions) (Current Headcount)
150 20 25 155
So according to the formula: ((20 x 100) / (150 + 25)) / 100
Which comes to 0.1142 i.e. 11%
Now as you had 150 previously and now 25 joined so it makes 150 + 25 =175
Now if you calculate 11.42% of 175 i.e. 175 x 0.1142 = 20

Which clearly shows that 175 – 20 = 155, which is your current headcount and at the same time you can say my attrition is 11.42% that shows you lost 20 employees of 150 and 25 more joined which makes count to 175.

From India, Bangalore
Acknowledge(0)
Amend(0)

Dear Philip,This is really helpful. May be it will be personal question, but still i would like to know, your designation, do you belong to HR? I am looking for some practical aspects of HR.Like HR Policy format for healthcare industry or any other industry, which i can customize for healthcare industry. Definitely, it is not a easy task, but will be continue touch with you all to give final shape.eagerly looking for valuable answers and postings.regards,priyanka
From India, Bhopal
Acknowledge(0)
Amend(0)

Engage with peers to discuss and resolve work and business challenges collaboratively. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Register and Log In.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.