HR Attrition Rate Formula Doc Download.. CiteHR
 .subbutton {border: none; overflow: hidden;cursor:hand;} HOME RISE NEW TEAM →|

kamalarya Started The Discussion:

Hello Everyone

I have seen almost all the threads on Citehr however in the all threads there are different formulas for calculating the attrition rate. I am really very confused because of this.

Please tell me the correct formula for calculating the attrition rate with an example?

Your help is much appreciated.

Thanks

Kamal

phaniacp -  Member Since: Aug 2007
Attrition is defined as unpredictable and uncontrollable, but normal, reduction of work force due to resignations, retirement, sickness, or death.

it is calculated as follows

Attrition%=(No. of Employees Quit) /(Avg. Employees during that time frame) %100

Inputs for computing Annualized Value is
Monthly – Multiply the Value by 12
Quarterly – Multiply the Value by 4
Half Yearly – Multiply the value by 2
Annual – Do not multiply :-)

Regards,
Phani

coolmanny2002 -  Member Since: Jul 2009
Monthly Attrition =Monthly Voluntary Leaver/Actual Headcount of month*100

YTD =Total Voluntary Leaver/Average Headcount of no .of months *100

Annualised =Total Voluntary leavers/Actual Headcount of month * 12*100

Rolling Annualised =Total Voluntary Leaver/Average Headcount of no .of months *100*12/no of months

arunhsharma -  Member Since: Aug 2010
Attrition%=(No. of Employees Quit) divided by (Avg. Employees during that time frame) multiplied by 100.

For annualised Attrition % we have to multiply it by 52 or 12 or 4 or 2 (depending on the input value of time frame).
such as
If the time frame is of a week multipy by 52
If the time frame is of a month multipy by 12
If the time frame is of a quarter multipy by 4
If the time frame is of a half year multipy by 2

nabomita1979 -  Member Since: Apr 2006
Greetings, Please find the standard calculation discussed in the link shared below : http://www.citeman.com/10549-taming-attrition-through-numbers-a-relook-at-its-calculation/ Regards, Nabomita

v2varun -  Member Since: Jan 2009
Hello kamalarya Please find the attached file i think you get an idea how to calculate Attrition rate

Attached FilesProvided by community member v2varun. Join us to learn and grow with your peers.
 attrition formula.doc (30.5 KB, 2913 views)
smart_neha -  Member Since: Jul 2009
Hello Kamalarya, The simplest formula for calculating Attrition rate =Total No. of people left the organization in the period Hope this will serve ur need Regards Neha

kannanmv -  Member Since: Apr 2009
Dear Kamal arya,

The attrition rate calculation can be arrived as follows.

Attrition rate for April

Employee strength April = 100
Employees left in April = 2
Attrition rate = 2/100 X 100 = 2%

Attrition rate for May

Employee strength May = 102
Average employee strength = 100 + 102 = 202/2 = 101

Employee left in May = 2
Cumulative exits = 2 + 2 = 4
Attrition rate = 4/101X 100= 3.96 and not 4 as the average strength now is not 100 and is 101 in May.

Likewise you can compute month on month.

Trust the matter is clear.

M.V.KANNAN

kamalarya -  Member Since: Jun 2008
Wow.... so many responses.. i am impressed.. seriously...Thank you everyone for your valuable inputs :) You all Rock :) Thread Closed :)

harsimranpreet -  Member Since: Apr 2009
As per rules of science 'rate' is defined at any particular point of time, so Attrirition rate is also calculated at any particular point of time ie Attrition rate = number of employees who left the organization divided by total number of employees working in the organization at that particular time at which attrition is being calculated.

POSTING RULES OF CONDUCT
• Do not post anything derogatory about any company or person.
• Sharing articles from other websites should be done by posting a link to the original article.
• To discuss sensitive issues create a pseudo/anonymous account.
• Please avoid repeat posting your company profile - such accounts are removed automatically.
• Found This Useful? +Vote Up This Via Google.

Why Vote? User validation is extremely important for good content to prosper.
Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction towards the actions necessary. The advice should be validated by proper consultation with a certified professional. The network or the members providing advice cannot be held liable for any consequences, under any circumstances.

3M Users, 100K+ Documents & 450K+ Discussions

Share »

Cite.Co helps people come together to solve each other's problems on all aspects of professional life.
Community Support & Professional Insights. Login or Register.
 Email/Username Password

About Us - Advertise - Contact Us - RSS   On Google+
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network