No Tags Found!


Faygeorge
3

Hi plz find attached the calculation in excel for the same. BR Fay
From Kuwait
Attached Files (Download Requires Membership)
File Type: xls attrition_calculator_and_register_109.xls (26.5 KB, 557 views)

hrchandu
Hi Friends, Can any one forward me the Attrition Calculator with different methods of calculating like Rolling Attrition etc. Wishes Chandu

Ruchi Saini
1

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
Rajesh_k_singh
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
Rajesh_k_singh
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
planetanup
1

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
jmoktali
Hi All, Attached is the excel sheet to calculate attrition rate. Regards, Jmoktali
From India, Mumbai
Attached Files (Download Requires Membership)
File Type: xls attrition_report_177.xls (17.0 KB, 651 views)
File Type: xls attrition_calendar_196.xls (23.0 KB, 455 views)
File Type: xls attrition_report_177.xls (17.0 KB, 417 views)

sanjay_acil
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)


shashi sharma
Kindly forward me the same. How to calculate attrition rate monthly as well as yearly. Thannks :)
From India
katyana
35

Hi sonia, The formula to calculate attrition is NO OF EMPLOYEES LEFT DURING THE MONTH/TOTAL NO OF EMPLOYEES*100 KATYANA
From India, Gurgaon
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.






Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.