Hi,
Good evening to everybody.
This is Prema from Chennai, newly joined in our group.
Can you plz help me out in calculating attrition rate on monthly, quarterly and annual basis with examples/formula. For eg. in a month if 100 people are joining and 25 are leaving us and the strength is 1000. How do you do the calculation.
Thanx & Regards,
Prema
From India, Madras
Good evening to everybody.
This is Prema from Chennai, newly joined in our group.
Can you plz help me out in calculating attrition rate on monthly, quarterly and annual basis with examples/formula. For eg. in a month if 100 people are joining and 25 are leaving us and the strength is 1000. How do you do the calculation.
Thanx & Regards,
Prema
From India, Madras
Kindly click on the following link, it will give you some required information,
https://www.citehr.com/search_new.ph...ate+&submit=Go
Kindly find attached some material on the said subject,, the same might be of some use to you,,,
Regards
M. Peer Mohamed Sardhar
93831 93832
From India, Coimbatore
733https://www.citehr.com/search_new.ph...ate+&submit=Go
Kindly find attached some material on the said subject,, the same might be of some use to you,,,
Regards
M. Peer Mohamed Sardhar
93831 93832
From India, Coimbatore
Hi Peer,
Thanx a lot for your info.
Able to understand the formula from the link what you have provided. its very useful information. But, unable to open the second sheet of the excel what you have sent bcz it is protected. If you could send me the same, it will be of great help.
Regards,
Prema
From India, Madras
Thanx a lot for your info.
Able to understand the formula from the link what you have provided. its very useful information. But, unable to open the second sheet of the excel what you have sent bcz it is protected. If you could send me the same, it will be of great help.
Regards,
Prema
From India, Madras
Hi Prema,
We have a online tool for this called Exit Pulse.
It also comes with various analytics.
No need to to do any manual calculations..
Regards
Shinto
quote="Premz"]Hi,
Good evening to everybody.
This is Prema from Chennai, newly joined in our group.
Can you plz help me out in calculating attrition rate on monthly, quarterly and annual basis with examples/formula. For eg. in a month if 100 people are joining and 25 are leaving us and the strength is 1000. How do you do the calculation.
Thanx & Regards,
Prema[/quote]
From India, Bangalore
We have a online tool for this called Exit Pulse.
It also comes with various analytics.
No need to to do any manual calculations..
Regards
Shinto
quote="Premz"]Hi,
Good evening to everybody.
This is Prema from Chennai, newly joined in our group.
Can you plz help me out in calculating attrition rate on monthly, quarterly and annual basis with examples/formula. For eg. in a month if 100 people are joining and 25 are leaving us and the strength is 1000. How do you do the calculation.
Thanx & Regards,
Prema[/quote]
From India, Bangalore
Prema,
The simple way to calculate attrition rate is as follows:
[[
{FORMULA}
1. Opening Headcount : actual candidates exist in a month.
2. New Joinees : New staff recruited.
3. Actual HeadCount : (1+2) Opening Headcount+New Joinees
4. Attrition Headcount : No. of employees terminated+absconding+Resigned
5. Closing Headcount : (3-4) Actual Headcount-Attrition Headcount
6. Attrition % : (4/3*100) Attrition Headcount/Actual Headcount*100]
]]
{
Eg.
1. Existing employees in Jan. =47
2. New Joinees in Jan.=12
3. Actual Headcount = 47+12= 59
4. Attrition Headcount : 5
5. Closing Headcount: 59-5 =54
6. Attrition% : 5/59*100 = 8.47
Therefore, 8.47% is your required result.
Hope you understood it or ele revert if any doubts.
Regards,
Shelly.
:)
From India, Delhi
The simple way to calculate attrition rate is as follows:
[[
{FORMULA}
1. Opening Headcount : actual candidates exist in a month.
2. New Joinees : New staff recruited.
3. Actual HeadCount : (1+2) Opening Headcount+New Joinees
4. Attrition Headcount : No. of employees terminated+absconding+Resigned
5. Closing Headcount : (3-4) Actual Headcount-Attrition Headcount
6. Attrition % : (4/3*100) Attrition Headcount/Actual Headcount*100]
]]
{
Eg.
1. Existing employees in Jan. =47
2. New Joinees in Jan.=12
3. Actual Headcount = 47+12= 59
4. Attrition Headcount : 5
5. Closing Headcount: 59-5 =54
6. Attrition% : 5/59*100 = 8.47
Therefore, 8.47% is your required result.
Hope you understood it or ele revert if any doubts.
Regards,
Shelly.
:)
From India, Delhi
Hi Prema,
formula to calculate attrition rate.
ATTRITION RATE
(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.
now I hope it may be clear....
Rdgs,
Rinky
From India, Lucknow
formula to calculate attrition rate.
ATTRITION RATE
(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.
now I hope it may be clear....
Rdgs,
Rinky
From India, Lucknow
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.
Calculation of Attrition Rate.doc
Attrition-rate. xls