Think HR Think CHRM
Friday - 21 Feb 2020

CHRMGlobal.com on LinkedIn
Username : Password: Forgot Password?
Updates
Updates
Attrition formula
Human Resources » Attrition and Retention


Chrm Message From: Jai_6969 Total Posts: 4 Join Date: 11/01/2012
Rank: Beginner Post Date: 11/01/2012 23:05:01 Points: 20 Location: India

New joinees:50

left:30

Closing bal: 100+50-30=120

Attrition%=(30/120)*100

=25%

Chrm Message From: chunduri Total Posts: 3 Join Date: 11/01/2012  
Rank: Beginner Post Date: 16/03/2012 02:19:37 Points: 15 Location: India

Am new to HR management, Thank you for your formula to calculate attrition.

 

Chrm Message From: nsjha30 Total Posts: 1 Join Date: 11/01/2012  
Rank: Beginner Post Date: 20/03/2012 08:38:01 Points: 5 Location: India

Thanks 

How Attrition Rate for A Month and Ayear is calculated? 

Chrm Message From: agursukh Total Posts: 1 Join Date: 11/01/2012  
Rank: Beginner Post Date: 20/05/2012 23:26:01 Points: 5 Location: India

The formula may also be as follows:

Attrition for the month / average (Opening for the month, Closing for the month)*100

Chrm Message From: debora Total Posts: 108 Join Date: 11/01/2012  
Rank: Leader Post Date: 03/01/2020 10:05:05 Points: 540 Location: India

 ATTRITION RATE = ((No. Of Attritions x 100) / (Actual Employees + New Joined)) /100.

Example:
Actual Employees (Opening BAL) - 150
No. Of people left (Attritions) - 20
No. Of Joined - 25
 
So according to the formula: ((20 x 100) / (150 + 25)) / 100

Which comes to 0.1142 i.e. 11%
Now as you had 150 previously and now 25 joined so it makes 150 + 25 =175
Now if you calculate 11.42% of 175 i.e. 175 x 0.1142 = 20
Which clearly shows that 175 – 20 = 155, which is your current headcount and at the same time you can say my attrition is 11.42%.