3
Hi Friends, Can any one forward me the Attrition Calculator with different methods of calculating like Rolling Attrition etc. Wishes Chandu
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
From India, Surat
Dear Sonia,
Very good question you have asked. People generally say"attrition rate is very high in that organisation" but few people know about how to calculate the attrition rate of an organisation. I am also one of them. I am having two yrs. of experience in HR field but still i dont know how to calculate attrition rate.
Request you to share with me, if you get something about the captioned subject.
Regards,
Rajesh
Officer - HR
Tata Projects Ltd.
011 - 6616 9033
From India, New Delhi
Very good question you have asked. People generally say"attrition rate is very high in that organisation" but few people know about how to calculate the attrition rate of an organisation. I am also one of them. I am having two yrs. of experience in HR field but still i dont know how to calculate attrition rate.
Request you to share with me, if you get something about the captioned subject.
Regards,
Rajesh
Officer - HR
Tata Projects Ltd.
011 - 6616 9033
From India, New Delhi
Dear Sonia,
Good question you have asked. Generally people say "attrition rate is very high in that organisation" but few people know about how to calculate attrition rate. I am also one of them. I am having two yrs. of experience in HR field but still i dont know how to calcualte attrition rate.
Request you to share with me, if you get something about the captioned subject.
Regards,
Rajesh
Officer - HR
Tata Projects Ltd.
011 -6616 9033
From India, New Delhi
Good question you have asked. Generally people say "attrition rate is very high in that organisation" but few people know about how to calculate attrition rate. I am also one of them. I am having two yrs. of experience in HR field but still i dont know how to calcualte attrition rate.
Request you to share with me, if you get something about the captioned subject.
Regards,
Rajesh
Officer - HR
Tata Projects Ltd.
011 -6616 9033
From India, New Delhi
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 organisation after base date - j
Determine the resignations in the organisation after 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, 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 organisation - Y
So, Attrition rate = r / ((X+Y)/2)
(X+Y)/2 --> averages out the employee count in the organisation 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
Identify the base date and the employee count on that day. - X
Determine the new joinings in the organisation after base date - j
Determine the resignations in the organisation after 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, 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 organisation - Y
So, Attrition rate = r / ((X+Y)/2)
(X+Y)/2 --> averages out the employee count in the organisation 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
Hi All, Attached is the excel sheet to calculate attrition rate. Regards, Jmoktali
From India, Mumbai
From India, Mumbai
there is no thumb rule to calculate the attrition rate but logically it should be calculated like this
No. employee as on date = x
No. of employee left in one year = n
Annualized % of attrition = n*100/(x+n)
But if you only have data for less than 12 months say 8 months
then it should be calculated like this
NO. of emp. as on date = x
no. of emp. left in 8 months = n
annualized % of attrition = n*12*100/8*(n+x)
No. employee as on date = x
No. of employee left in one year = n
Annualized % of attrition = n*100/(x+n)
But if you only have data for less than 12 months say 8 months
then it should be calculated like this
NO. of emp. as on date = x
no. of emp. left in 8 months = n
annualized % of attrition = n*12*100/8*(n+x)
Kindly forward me the same. How to calculate attrition rate monthly as well as yearly. Thannks :)
From India
From India
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
What is Annualized Attrition and How to Calculate It.doc
Attrition-rate. xls