How Can I Improve This Attrition Rate Report for Executive Review?

Can you review this spreadsheet and let me know if anything else should be considered in the attrition rate to report up to an executive level.

Thanks for your input!

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]

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.

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%

How does this look? Specifically, the YTD calculation.

Thanks for your time!

Hi folks,

Just have a look at this formula. This will clarify all your doubts.

Attrition% = (No. of Employees Quit) / (Avg. Employees during that time frame) % 100.

Thanks all.