Hi,
Request you to tell me the formula to calculate Annual Attrition Percentage? To calculate per month attrition, we use (Total attrites/Avg Headcount)*100 and avg headcount= (opening+closing)/2. How do I calculate annual attrition percentage? Please give the details.
Regards,
CB
From India, Delhi
4Request you to tell me the formula to calculate Annual Attrition Percentage? To calculate per month attrition, we use (Total attrites/Avg Headcount)*100 and avg headcount= (opening+closing)/2. How do I calculate annual attrition percentage? Please give the details.
Regards,
CB
From India, Delhi
Hi Govind, My query is similar to that of shalini. Please let me know the same. Regards, Suparna
From India, New Delhi
From India, New Delhi
Attrition rate is percentage rate of people leaving the organisation, people left - and is relative to the total number of people who have worked for the organisation during the period under consideration, hence :
Attrition Rate =
number of people left/number of people worked for the organisation =
number left/opening balance+new joinees x 100
the number left could be from old employees or those who join and immediately leave in a short period
i understand those who have been asked to leave also reflects the effectiveness of the organisation in attracting and retaining the right kind of people and hence need to be included to have an overall measure of attrition in the organisation including those who retire and are not given extensions.
say, the opening balance was 100 people, joined 50 people
therefore total people worked during the period = 150
left at different points of time 30 people
therefore Attrition Rate =
30/100 + 50 = 30/150x100 = 20%
if you calculate Attrition on the closing strength ie 150-30 = 120
the rate would be 30/120 = 25% which is wrongly exaggerated
which would show the wrong flow rate, 120 is the figure after attrition
we would rather want to know the rate of attrition, how many people joining the organisation leave for a given period.
hope the above makes sense,
regards,
kshantaram
From India, Ahmadabad
Attrition Rate =
number of people left/number of people worked for the organisation =
number left/opening balance+new joinees x 100
the number left could be from old employees or those who join and immediately leave in a short period
i understand those who have been asked to leave also reflects the effectiveness of the organisation in attracting and retaining the right kind of people and hence need to be included to have an overall measure of attrition in the organisation including those who retire and are not given extensions.
say, the opening balance was 100 people, joined 50 people
therefore total people worked during the period = 150
left at different points of time 30 people
therefore Attrition Rate =
30/100 + 50 = 30/150x100 = 20%
if you calculate Attrition on the closing strength ie 150-30 = 120
the rate would be 30/120 = 25% which is wrongly exaggerated
which would show the wrong flow rate, 120 is the figure after attrition
we would rather want to know the rate of attrition, how many people joining the organisation leave for a given period.
hope the above makes sense,
regards,
kshantaram
From India, Ahmadabad
Govindi, The detailed excel sheet is excellent know-how, one which I would like to continue but my understanding is not very clear. My queries are same as Shalini, can you please clarify.
From India, Nagpur
From India, Nagpur
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.
Attrition Calculator and Annual Register.xls
Calculating Employee Attrition.pptx