Hi plz find attached the calculation in excel for the same. BR Fay
From Kuwait
Acknowledge(0)
Amend(0)
3From Kuwait
Acknowledge(0)Amend(0)
Hi Friends, Can any one forward me the Attrition Calculator with different methods of calculating like Rolling Attrition etc. Wishes Chandu
Acknowledge(0)Amend(0)
Acknowledge(0)Amend(0)
Hi , this is ruchi. can u plz mail it to me also.(d attrition calculator) plz i really need it. thanx tk cr
From India, Surat
Acknowledge(0)Amend(0)
From India, Surat
Acknowledge(0)Amend(0)
Dear Sonia,
That's a very good question you have asked. People generally say, "attrition rate is very high in that organization," but few people know how to calculate the attrition rate of an organization. I am also one of them. I have two years of experience in the HR field, but still, I don't know how to calculate attrition rate.
I request you to share with me if you get any information about the captioned subject.
Regards,
Rajesh Officer - HR Tata Projects Ltd. 011 - 6616 9033
From India, New Delhi
Acknowledge(0)Amend(0)
That's a very good question you have asked. People generally say, "attrition rate is very high in that organization," but few people know how to calculate the attrition rate of an organization. I am also one of them. I have two years of experience in the HR field, but still, I don't know how to calculate attrition rate.
I request you to share with me if you get any information about the captioned subject.
Regards,
Rajesh Officer - HR Tata Projects Ltd. 011 - 6616 9033
From India, New Delhi
Acknowledge(0)Amend(0)
Dear Sonia,
Welcome to CiteHR! I'm pleased to hear that you find it beneficial, especially for all the freshers. Your question about calculating the attrition rate is quite insightful. While many mention that the attrition rate is high in certain organizations, the actual calculation method is not widely known. I, too, am in the same boat. Despite having two years of experience in the HR field, I am still unsure about how to calculate the attrition rate.
If you come across any information on this topic, I would greatly appreciate it if you could share it with me.
Best regards,
Rajesh
Officer - HR
Tata Projects Ltd.
011-6616 9033
From India, New Delhi
Acknowledge(0)Amend(0)
Welcome to CiteHR! I'm pleased to hear that you find it beneficial, especially for all the freshers. Your question about calculating the attrition rate is quite insightful. While many mention that the attrition rate is high in certain organizations, the actual calculation method is not widely known. I, too, am in the same boat. Despite having two years of experience in the HR field, I am still unsure about how to calculate the attrition rate.
If you come across any information on this topic, I would greatly appreciate it if you could share it with me.
Best regards,
Rajesh
Officer - HR
Tata Projects Ltd.
011-6616 9033
From India, New Delhi
Acknowledge(0)Amend(0)
The calculation of attrition rate is fairly simple. Identify the base date and the employee count on that day - X. Determine the new joinings in the organization after the base date - J. Determine the resignations in the organization after the base date - R. (If you want to identify reasons related to attrition, use the Date of resignation of the employee. However, for accurate attrition data for calculation for productivity, the usage of 'Last Working Day' is preferred. If you are not sure of the reason, use 'Last working day' as criteria.)
Now, what you have is the current employee count in the organization - Y. So, Attrition rate = R / ((X+Y)/2). (X+Y)/2 averages out the employee count in the organization during the period. To annualize the attrition, Annual Attrition = (12/Duration (in months)) * (R / (X+Y)/2). Hope this solves the attrition problem. You can build your own calculator in Excel using the above formula.
Regards, Anup.
From India, Ghansoli
Acknowledge(0)Amend(0)
Now, what you have is the current employee count in the organization - Y. So, Attrition rate = R / ((X+Y)/2). (X+Y)/2 averages out the employee count in the organization during the period. To annualize the attrition, Annual Attrition = (12/Duration (in months)) * (R / (X+Y)/2). Hope this solves the attrition problem. You can build your own calculator in Excel using the above formula.
Regards, Anup.
From India, Ghansoli
Acknowledge(0)Amend(0)
Hi All, Attached is the excel sheet to calculate attrition rate. Regards, Jmoktali
From India, Mumbai
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
There is no thumb rule to calculate the attrition rate, but logically it should be calculated like this:
No. of employees as on the date = x
No. of employees left in one year = n
Annualized % of attrition = n * 100 / (x + n)
However, if you only have data for less than 12 months, say 8 months, then it should be calculated like this:
No. of employees as on the date = x
No. of employees left in 8 months = n
Annualized % of attrition = n * 12 * 100 / 8 * (n + x)
Acknowledge(0)Amend(0)
No. of employees as on the date = x
No. of employees left in one year = n
Annualized % of attrition = n * 100 / (x + n)
However, if you only have data for less than 12 months, say 8 months, then it should be calculated like this:
No. of employees as on the date = x
No. of employees left in 8 months = n
Annualized % of attrition = n * 12 * 100 / 8 * (n + x)
Acknowledge(0)Amend(0)Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
Attrition-rate. xls
Calculation of Attrition Rate.doc