How To Calculate Attrition Rate - Xls Download

Hi
plz find attached the calculation in excel for the same.
BR
Fay

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

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

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

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.

Hi All,
Attached is the excel sheet to calculate attrition rate.
Regards,
Jmoktali

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)

Kindly forward me the same. How to calculate attrition rate monthly as well as yearly.
Thannks :)

Hi sonia,
The formula to calculate attrition is
NO OF EMPLOYEES LEFT DURING THE MONTH/TOTAL NO OF EMPLOYEES*100
KATYANA