Community » HR Forums » Human Resources » Attrition and Retention» Attrition formula
Attrition formula

Last post April 16, 2020 10:31 AM by caseykody. 2 repiles.
January 11, 2012 11:05 PM 1
Total Posts: 4
Join Date: January 11, 2012
Rank: Beginner
Post Date: April 16, 2020
Posts: 4
Location: India

Attrition formula

New joinees:50

left:30

Closing bal: 100+50-30=120

Attrition%=(30/120)*100

=25%
March 16, 2012 02:192
chunduri
Total Posts: 3
Join Date: January 11, 2012
Rank: Beginner
Post Date: March 16, 2012
Points: 15
Location: India

Re: Attrition formula

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

 
March 20, 2012 08:383
nsjha30
Total Posts: 1
Join Date: January 11, 2012
Rank: Beginner
Post Date: March 20, 2012
Points: 5
Location: India

Re: Attrition formula

Thanks 

How Attrition Rate for A Month and Ayear is calculated? 
May 20, 2012 11:264
agursukh
Total Posts: 1
Join Date: January 11, 2012
Rank: Beginner
Post Date: May 20, 2012
Points: 5
Location: India

Re: Attrition formula

The formula may also be as follows:

Attrition for the month / average (Opening for the month, Closing for the month)*100
January 3, 2020 10:055
debora
Total Posts: 108
Join Date: January 11, 2012
Rank: Leader
Post Date: January 3, 2020
Points: 540
Location: India

Re: Attrition formula

 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%.
1 2 Next
Explore the Site