Can you review this spreadsheet and let me know if anything else should be considered in the attrition rate to report up to an execuative level. Thanks for your input!
From Canada, Edmonton
Acknowledge(0)
Amend(0)
From Canada, Edmonton
Acknowledge(0)Amend(0)
I feel you have to check on two things
a) Are you reporting annualized attrition? Check on the attrition figures (are you using the standard formula) . Also it is the trend to report annualized attrition eventhough it is calculated on a monthly basis. 4% looks good..but on an annualized basis it might be upto 40% + !
b) What are the reasons of attrition. At an executive level they might be more interested in that.
c) what are you doing to reduce the same !
studies in hr
http://linkedin.com <link updated to site home>
From India, Bangalore
Acknowledge(0)Amend(0)
5a) Are you reporting annualized attrition? Check on the attrition figures (are you using the standard formula) . Also it is the trend to report annualized attrition eventhough it is calculated on a monthly basis. 4% looks good..but on an annualized basis it might be upto 40% + !
b) What are the reasons of attrition. At an executive level they might be more interested in that.
c) what are you doing to reduce the same !
studies in hr
http://linkedin.com <link updated to site home>
From India, Bangalore
Acknowledge(0)Amend(0)
Your formula for calculating attrition rate seems to be incorrect. Try divinding the no of employees left by avg employees for the month which will be =E6/((C6+F6)/2). And always calculate attrition as an annualised figure as monthly average is no indicator since it is a small number compared to the annual one....
From India, Mumbai
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
The formula which we use to calculate attrition is as follows
Attrition %: Number of Employees Attrite / Average Strength of Employees
Average Strength of Employees : (Employee count in the Beginning /Employee Count in the end)/2
Correct formula : =E6/(AVERAGE(C6,F6)) = 2.61%
January
February
March
April
May
June
July
August
September
October
November
December
TOTAL
From India, Pune
Acknowledge(0)Amend(0)
Attrition %: Number of Employees Attrite / Average Strength of Employees
Average Strength of Employees : (Employee count in the Beginning /Employee Count in the end)/2
Correct formula : =E6/(AVERAGE(C6,F6)) = 2.61%
Month
Opening Balance
New Employees
Employees Left
Closing
Attrition Rate
Balance
75
5
2
78
2.61%
78
0
3
75
3.92%
75
3
2
76
2.65%
May
June
July
August
September
October
November
December
TOTAL
228
8
7
229
3.06%
From India, Pune
Acknowledge(0)Amend(0)Engage with peers to discuss and resolve work and business challenges collaboratively - share and document your knowledge. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Join & Be Part Of Our Community.
Attrition-rate. xls
Attrition-rate- in-different-se ctors_906.jpg