Hello
Follow the link below
https://www.citehr.com/97361-calcula...-turnover.html
Thank You
Octavious
https://www.citehr.com/99968-major-h...tml#post386938
From India, Mumbai
575Follow the link below
https://www.citehr.com/97361-calcula...-turnover.html
Thank You
Octavious
https://www.citehr.com/99968-major-h...tml#post386938
From India, Mumbai
Dear All,
Following is the formula of attrition with example & proven logic.
((no. Of attritions x 100) / (Actual Employees + New Joined)) /100.
Examples:
1) Actual Employees No. Of people left No. Of Joined Total Employees
(Opening BAL) (Attritions) (Current Headcount)
150 20 25 155
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% that shows you lost 20 employees of 150 and 25 more joined which makes count to 175.
2) Actual Employees No. Of people left No. Of Joined Total Employees
(Opening BAL) (Attritions) (Current Headcount)
100 50 0 50
This is the special case where we are considering attritions only keeping into mind that nobody has joined in particular month.
So according to the formula: ((50 x 100) / (100)) / 100
Which comes to 0.5 i.e. 50%
Now as you had 100 previously and now 0 joined so it makes 100 + 0 =100
Now if you calculate 50% of 100 i.e. 100 x 0.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 0 joined which makes count to 50.
3) Actual Employees No. Of people left No. Of Joined Total Employees
(Opening BAL) (Attritions) (Current Headcount)
500 200 100 400
So according to the formula: ((200 x 100) / (500 +100)) / 100
Which comes to 0.3333 i.e. 33.33%
Now as you had 500 previously and now 100 joined so it makes 500 + 100 =600
Now if you calculate 33.33% of 600 i.e. 600 x 0.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 employees of 500 and 100 more joined which makes count to 400.
4) Actual Employees No. Of people left No. Of Joined Total Employees
(Opening BAL) (Attritions) (Current Headcount)
8000 5000 500 3500
So according to the formula: ((5000 x 100) / (8000 +500)) / 100
Which comes to 0.5882 i.e. 58.82%
Now as you had 8000 previously and now 500 joined so it makes 8000 + 500 =8500
Now if you calculate 58.82% of 8500 i.e. 8500 x 0.5882 = 5000 Which clearly shows that 8500 - 5000 = 3500, which is your current headcount and at the same time you can say my attrition is 58.82% that shows you lost 5000 employees of 8000 and 500 more joined which makes count to 3500.
Regards,
Sharad
From India, Mumbai
Following is the formula of attrition with example & proven logic.
((no. Of attritions x 100) / (Actual Employees + New Joined)) /100.
Examples:
1) Actual Employees No. Of people left No. Of Joined Total Employees
(Opening BAL) (Attritions) (Current Headcount)
150 20 25 155
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% that shows you lost 20 employees of 150 and 25 more joined which makes count to 175.
2) Actual Employees No. Of people left No. Of Joined Total Employees
(Opening BAL) (Attritions) (Current Headcount)
100 50 0 50
This is the special case where we are considering attritions only keeping into mind that nobody has joined in particular month.
So according to the formula: ((50 x 100) / (100)) / 100
Which comes to 0.5 i.e. 50%
Now as you had 100 previously and now 0 joined so it makes 100 + 0 =100
Now if you calculate 50% of 100 i.e. 100 x 0.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 0 joined which makes count to 50.
3) Actual Employees No. Of people left No. Of Joined Total Employees
(Opening BAL) (Attritions) (Current Headcount)
500 200 100 400
So according to the formula: ((200 x 100) / (500 +100)) / 100
Which comes to 0.3333 i.e. 33.33%
Now as you had 500 previously and now 100 joined so it makes 500 + 100 =600
Now if you calculate 33.33% of 600 i.e. 600 x 0.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 employees of 500 and 100 more joined which makes count to 400.
4) Actual Employees No. Of people left No. Of Joined Total Employees
(Opening BAL) (Attritions) (Current Headcount)
8000 5000 500 3500
So according to the formula: ((5000 x 100) / (8000 +500)) / 100
Which comes to 0.5882 i.e. 58.82%
Now as you had 8000 previously and now 500 joined so it makes 8000 + 500 =8500
Now if you calculate 58.82% of 8500 i.e. 8500 x 0.5882 = 5000 Which clearly shows that 8500 - 5000 = 3500, which is your current headcount and at the same time you can say my attrition is 58.82% that shows you lost 5000 employees of 8000 and 500 more joined which makes count to 3500.
Regards,
Sharad
From India, Mumbai
Hello
Follow the below link mentioned, hope the same will help you
https://www.citehr.com/97361-calcula...-turnover.html
Thank You
Octavious
From India, Mumbai
Follow the below link mentioned, hope the same will help you
https://www.citehr.com/97361-calcula...-turnover.html
Thank You
Octavious
https://www.citehr.com/99968-major-hr-links.html#post386938
From India, Mumbai
Hi,
We are using this formula to calculate :
Attrition = no of employees left in month*100/total no of employees in month.
Is it the correct one and in case if u are using someother then pls do mail me on this id :
From India, Sangrur
We are using this formula to calculate :
Attrition = no of employees left in month*100/total no of employees in month.
Is it the correct one and in case if u are using someother then pls do mail me on this id :
From India, Sangrur
yes meenakshi is right. even i am aware of this formula only in case you know some other method. plz mail me
From India, Faridabad
From India, Faridabad
I have calulated attritonrate by using the fundamental below ie
total no. of left amployees x 100
emplyees on the 1st dayof the month
But this doesnt seem to be working out. Can any body please help me.
Regards
Anuja
From India, Mumbai
total no. of left amployees x 100
emplyees on the 1st dayof the month
But this doesnt seem to be working out. Can any body please help me.
Regards
Anuja
From India, Mumbai
I have vacany for the post of HR Co-ordinator - profile would be trime - office, mis, welfare activiteis, collaboration with bank etc. if somebody is interested contact me on 
Regards
Anuja
From India, Mumbai
Regards
Anuja
From India, Mumbai
Hi,
This is for information to all.
<LI class=MsoNormal style="MARGIN: 0in 0in 0pt; COLOR: black; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1; tab-stops: list .5in">
<LI class=MsoNormal style="MARGIN: 0in 0in 0pt; COLOR: black; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1; tab-stops: list .5in">
<LI class=MsoNormal style="MARGIN: 0in 0in 0pt; COLOR: black; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1; tab-stops: list .5in">
<LI class=MsoNormal style="MARGIN: 0in 0in 0pt; COLOR: black; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1; tab-stops: list .5in">
From India, Vadodara
This is for information to all.
<LI class=MsoNormal style="MARGIN: 0in 0in 0pt; COLOR: black; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1; tab-stops: list .5in">Attrition: Number of employees who left in the year / average employees in the year x 100. Thus, if the company had 1,000 employees in April 2004, 2,000 in March 2005, and 300 quit in the year, then the average employee strength is 1,500 and attrition is 100 x (300/1500) = 20 percent.
A graded system can probably depict the true picture.
A graded system can probably depict the true picture.
<LI class=MsoNormal style="MARGIN: 0in 0in 0pt; COLOR: black; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1; tab-stops: list .5in">
Fresher attrition: the number of freshers who left within one year. It tells you how many are using the company as a springboard.
<LI class=MsoNormal style="MARGIN: 0in 0in 0pt; COLOR: black; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1; tab-stops: list .5in">
Infant mortality: percentage of people who left within one year. This indicates the ease with which people adapt to the company.
<LI class=MsoNormal style="MARGIN: 0in 0in 0pt; COLOR: black; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1; tab-stops: list .5in">
Critical resource attrition: key men exit.
<LI class=MsoNormal style="MARGIN: 0in 0in 0pt; COLOR: black; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1; tab-stops: list .5in">
Low performance attrition: those who left due to poor performance.
MINESH PANDYA
MINESH PANDYA
From India, Vadodara
This can be calculated....
No of employees left during the month / no of employee at the start of month + new joinees during the month/12
At the end of the year no of emplyees left / Avg. Manpower
Further clarification you can mail me on
Rajesh Kumar Bhat
No of employees left during the month / no of employee at the start of month + new joinees during the month/12
At the end of the year no of emplyees left / Avg. Manpower
Further clarification you can mail me on
Rajesh Kumar Bhat
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
What is Annualized Attrition and How to Calculate It.doc
Attrition-rate. xls