HR Attrition Rate Formula Doc Download.. CiteHR
CiteHR
 
HOME ANSWERED NEW ABOUT LOGIN
Home > Human Resource Section > Human Resource Management

HR Attrition Rate Formula

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 - Contributing Member
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

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

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 - Senior Member
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 - 
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.
File Type: doc attrition formula.doc (30.5 KB, 2621 views)
smart_neha - Contributing Member
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 - Contributing Member
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 - Contributing Member
Wow.... so many responses.. i am impressed.. seriously...Thank you everyone for your valuable inputs :) You all Rock :) Thread Closed :)

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.

Found This Useful? +Vote Up This Page 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.






Explore Topical Knowledge Areas

Interesting Relevant Discussions


DISCUSSSION STATISTICS


3
LIKES

7673
VIEWS

9
REPLIES

PLEASE KEEP YOUR CONDUCT PROFESSIONAL AND POLITE


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

Share »

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