hi guys...
can anyone tell me about the formulae to calculate:
1. monthly annualized employee attrition rate
2. Quarter to date annualized attrition rate
3. YTD annualized attrition rate.
what i could deduce logically was:
1. for monthly =[ no. of exits in the month/(avg head count for the month)]*12 *100
2. QTD annualized = [no of exits till date in the qtr/(avg head count till date in qtr)]*4*100
3. YTD annualized = [no. of exits till date in the year/(avg head count till date in the year)*100
Just want to confirm the above... Please if anyone could help me out with the above, it would be really great.
Thanks in advance...
Natasha
From India, Bangalore
can anyone tell me about the formulae to calculate:
1. monthly annualized employee attrition rate
2. Quarter to date annualized attrition rate
3. YTD annualized attrition rate.
what i could deduce logically was:
1. for monthly =[ no. of exits in the month/(avg head count for the month)]*12 *100
2. QTD annualized = [no of exits till date in the qtr/(avg head count till date in qtr)]*4*100
3. YTD annualized = [no. of exits till date in the year/(avg head count till date in the year)*100
Just want to confirm the above... Please if anyone could help me out with the above, it would be really great.
Thanks in advance...
Natasha
From India, Bangalore
7
hi
Have seen lots of post for attrition calculation but still a chaos is ther as to what is the right method to calculate attrition sply when we want to calculate on a mnthly & qtlr basis.Pls clear me on this whether the method provided by Nivritti is correct or it is the same generalized method as mentioned below for calculating mnthly/qtly /annualy attritions :
((no. Of attritions x 100) / (Actual Employees + New Joined)) /100.
Also in this method i don't undertsd d logic as to why we multiply 100 with no. of attritions????
Eagerly waiting for the reply with logic from experts.
Thanks
Deepa
From India, Gurgaon
Have seen lots of post for attrition calculation but still a chaos is ther as to what is the right method to calculate attrition sply when we want to calculate on a mnthly & qtlr basis.Pls clear me on this whether the method provided by Nivritti is correct or it is the same generalized method as mentioned below for calculating mnthly/qtly /annualy attritions :
((no. Of attritions x 100) / (Actual Employees + New Joined)) /100.
Also in this method i don't undertsd d logic as to why we multiply 100 with no. of attritions????
Eagerly waiting for the reply with logic from experts.
Thanks
Deepa
From India, Gurgaon
Hi Deepa,
As per my study & the material with me,
Attrition rate = No. of resignation / Available manpower *100
Example- If 1st of any of the month the Manpower is 200, during that particular month 10 employees Joined whereas 5 resigned, so at the end of the month the available manpower would be
Available Manpower = 200+10-5 = 205
Attrition Rate = 5 / 205 *100
Hope it must have helped you to understand the same...
Pandurang
From India, Pune
As per my study & the material with me,
Attrition rate = No. of resignation / Available manpower *100
Example- If 1st of any of the month the Manpower is 200, during that particular month 10 employees Joined whereas 5 resigned, so at the end of the month the available manpower would be
Available Manpower = 200+10-5 = 205
Attrition Rate = 5 / 205 *100
Hope it must have helped you to understand the same...
Pandurang
From India, Pune
Hi Nivriti,
I do agree with pandurang but one small correction regd the placement of 100
Attrition rate :
Attrition rate = No. of resignation / Available manpower *100 as given by Pandurang
Attrition rate = (No. of resignation / Available manpower )*100
You can check what difference it makes.
Truly Yours,
Kumar.H.P
From Hong Kong
I do agree with pandurang but one small correction regd the placement of 100
Attrition rate :
Attrition rate = No. of resignation / Available manpower *100 as given by Pandurang
Attrition rate = (No. of resignation / Available manpower )*100
You can check what difference it makes.
Truly Yours,
Kumar.H.P
From Hong Kong
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