Industry
Attrition Rate Calculation
 
ATTRITION Price CALCULATION
(The formula and correct logic behind calculation of Attrition Price)
((no. Of attritions x one hundred) / (Actual Workers + New Joined)) /one hundred.
 
Examples:
 
1) Actual Employees No. Of individuals left No. Of Joined Total Staff
(Opening BAL) (Attritions) (Present Headcount)
150 20 25 155
 
So according to the formula: ((20 x one hundred) / (150 + 25)) / 100
 
Which comes to .1142 i.e. 11%
 
Now as you had 150 previously and now 25 joined so it tends to make 150 + 25 =175
 
Now if you calculate 11.42% of 175 i.e. 175 x .1142 = 20
 
Which clearly shows that 175 – 20 = 155, which is your present headcount and at the same time you can say my attrition is 11.42% that shows you lost 20 workers of 150 and 25 far more joined which makes count to 175.
 
two) Actual Employees No. Of men and women left No. Of Joined Total Workers
(Opening BAL) (Attritions) (Current Headcount)
100 50 0 50
 
This is the particular case where we are contemplating attritions only keeping into thoughts that no one has joined in particular month.
 
So according to the formula: ((50 x one hundred) / (100)) / one hundred
 
Which comes to .five i.e. 50%
 
Now as you had 100 previously and now joined so it makes one hundred + =one hundred
 
Now if you calculate 50% of one hundred i.e. one hundred x .5 = 50
 
Which clearly shows that 100 – 50 = 50, which is your current headcount and at the same time you can say my attrition is 50% that shows you lost 50 employees of 100 and joined which tends to make count to 50.
 
3) Actual Employees No. Of men and women left No. Of Joined Total Employees
(Opening BAL) (Attritions) (Present Headcount)
500 200 100 400
So according to the formula: ((200 x one hundred) / (500 +one hundred)) / one hundred
 
Which comes to .3333 i.e. 33.33%
 
Now as you had 500 previously and now one hundred joined so it tends to make 500 + one hundred =600
 
Now if you calculate 33.33% of 600 i.e. 600 x .3333 = 200
 
Which clearly shows that 600 – 200 = 400, which is your current headcount and at the same time you can say my attrition is 33.33% that shows you lost 200 staff of 500 and 100 far more joined which tends to make count to 400.
 
4) Actual Employees No. Of people left No. Of Joined Total Staff
(Opening BAL) (Attritions) (Existing Headcount)
8000 5000 500 3500
 
 
So according to the formula: ((5000 x one hundred) / (8000 +500)) / one hundred
 
Which comes to .5882 i.e. 58.82%
 
Now as you had 8000 previously and now 500 joined so it tends to make 8000 + 500 =8500
 
Now if you calculate 58.82% of 8500 i.e. 8500 x .5882 = 5000
 
Which clearly shows that 8500 – 5000 = 3500, which is your current headcount and at the exact same time you can say my attrition is 58.82% that shows you lost 5000 staff of 8000 and 500 more joined which tends to make count to 3500.
