Hi,
Good evening, everybody. This is Prema from Chennai, newly joined in our group. Can you please help me out in calculating the attrition rate on a monthly, quarterly, and annual basis with examples/formulas? For example, in a month, if 100 people are joining and 25 are leaving us, and the strength is 1000, how do you do the calculation?
Thank you & Regards,
Prema
From India, Madras
Acknowledge(0)
Amend(0)
Good evening, everybody. This is Prema from Chennai, newly joined in our group. Can you please help me out in calculating the attrition rate on a monthly, quarterly, and annual basis with examples/formulas? For example, in a month, if 100 people are joining and 25 are leaving us, and the strength is 1000, how do you do the calculation?
Thank you & Regards,
Prema
From India, Madras
Acknowledge(0)Amend(0)
Kindly click on the following link; it will provide you with the required information: https://www.citehr.com/search_new.ph...;amp;submit=Go
Kindly find attached some materials on the said subject; the same might be of use to you.
Regards,
M. Peer Mohamed Sardhar
93831 93832
From India, Coimbatore
Acknowledge(0)Amend(0)
746Kindly find attached some materials on the said subject; the same might be of use to you.
Regards,
M. Peer Mohamed Sardhar
93831 93832
From India, Coimbatore
Acknowledge(0)Amend(0)
Hi Peer,
Thank you a lot for your information. I was able to understand the formula from the link you provided; it's very useful. However, I am unable to open the second sheet of the Excel file you sent because it is protected. If you could send me the same, it would be of great help.
Regards,
Prema
From India, Madras
Acknowledge(0)Amend(0)
Thank you a lot for your information. I was able to understand the formula from the link you provided; it's very useful. However, I am unable to open the second sheet of the Excel file you sent because it is protected. If you could send me the same, it would be of great help.
Regards,
Prema
From India, Madras
Acknowledge(0)Amend(0)
Prema,
The simple way to calculate attrition rate is as follows:
{FORMULA}
1. Opening Headcount: actual candidates exist in a month.
2. New Joinees: New staff recruited.
3. Actual Headcount: (1+2) Opening Headcount + New Joinees
4. Attrition Headcount: No. of employees terminated + absconding + Resigned
5. Closing Headcount: (3-4) Actual Headcount - Attrition Headcount
6. Attrition %: (4/3*100) Attrition Headcount / Actual Headcount * 100
Eg.
1. Existing employees in Jan. = 47
2. New Joinees in Jan. = 12
3. Actual Headcount = 47 + 12 = 59
4. Attrition Headcount: 5
5. Closing Headcount: 59 - 5 = 54
6. Attrition%: 5/59 * 100 = 8.47
Therefore, 8.47% is your required result.
Hope you understood it or else revert if any doubts.
Regards,
Shelly. :)
From India, Delhi
Acknowledge(0)Amend(0)
The simple way to calculate attrition rate is as follows:
{FORMULA}
1. Opening Headcount: actual candidates exist in a month.
2. New Joinees: New staff recruited.
3. Actual Headcount: (1+2) Opening Headcount + New Joinees
4. Attrition Headcount: No. of employees terminated + absconding + Resigned
5. Closing Headcount: (3-4) Actual Headcount - Attrition Headcount
6. Attrition %: (4/3*100) Attrition Headcount / Actual Headcount * 100
Eg.
1. Existing employees in Jan. = 47
2. New Joinees in Jan. = 12
3. Actual Headcount = 47 + 12 = 59
4. Attrition Headcount: 5
5. Closing Headcount: 59 - 5 = 54
6. Attrition%: 5/59 * 100 = 8.47
Therefore, 8.47% is your required result.
Hope you understood it or else revert if any doubts.
Regards,
Shelly. :)
From India, Delhi
Acknowledge(0)Amend(0)
Hi Prema,
formula to calculate attrition rate.
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.
now I hope it may be clear....
Rdgs,
Rinky
From India, Lucknow
Acknowledge(0)Amend(0)
formula to calculate attrition rate.
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.
now I hope it may be clear....
Rdgs,
Rinky
From India, Lucknow
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.
SAMPLE Employee Attrition Calculation sheet for FY 09-10 .xls
Calculation of Attrition Rate.doc