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 the attrition figures (are you using the standard formula). Also, it is a trend to report annualized attrition even though it is calculated on a monthly basis. 4% looks good, but on an annualized basis, it might be up to 40% or more!
b) What are the reasons for attrition? At an executive level, they might be more interested in that.
c) What are you doing to reduce the same!
Studies in HR
LinkedIn.com
[Link updated to site home]
From India, Bangalore
Acknowledge(0)Amend(0)
5a) Are you reporting annualized attrition? Check the attrition figures (are you using the standard formula). Also, it is a trend to report annualized attrition even though it is calculated on a monthly basis. 4% looks good, but on an annualized basis, it might be up to 40% or more!
b) What are the reasons for attrition? At an executive level, they might be more interested in that.
c) What are you doing to reduce the same!
Studies in HR
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 dividing the number of employees left by the average employees for the month, which will be =E6/((C6+F6)/2). Also, always calculate attrition as an annualized figure as the monthly average is not an accurate 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 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%
Month
Opening Balance
New Employees
Employees Left
Closing
Attrition Rate
Balance
January
75
5
2
78
2.61%
February
78
0
3
75
3.92%
March
75
3
2
76
2.65%
April
May
June
July
August
September
October
November
December
TOTAL
228
8
7
229
3.06%
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
January
75
5
2
78
2.61%
February
78
0
3
75
3.92%
March
75
3
2
76
2.65%
April
May
June
July
August
September
October
November
December
TOTAL
228
8
7
229
3.06%
From India, Pune
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Attrition Rate formula.pdf
Calculation of Attrition Rate.doc