Santoshgujjar355
Senior Executive
Vkokamthankar
Asst. General Manager - Hr
+2 Others

Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
Hello All
I need your help for calculating Attrition Rate.I myself tried this using Attrition Rate formula i.e,
Attrition Rate=Total Headcounts left in a period/(Total headcount at the start of the period+Total headcounts recruited in the period)*100
and herewith attaching file. I would like to know whether I am following right track for the same?If yes,then please guide me how to calculate Average attrition rate as given in the sheet.
anticipating your response.

From India, Kolkata

Attached Files
File Type: xls Attrition Rate.xls (27.5 KB, 3307 views)

You are really smart. Attrition Formula mentioned by you and also used in excel sheet is absolutely correct.
From India, Pune
Pl. find enclosed file for monthly & quarterly attrition calculation.
From India, New Delhi

Attached Files
File Type: xls attrition calculator.xls (22.0 KB, 2380 views)

Hi,
I would suggest that you first decide what is the period for which you want to report attrition. Ideally it should be reported on quarterly basis and then aggregated for a year.
There are two ways to calculate quarterly attrition
Option1 - Simple
x = no of employees in the beginning of quarter
y = no of employees who left the company in the quarter
attrition = (y / x)*100
Option 2 - Complex
x = no of employees in the beginning of quarter
y = no of employees who left the company in the quarter
z = no of new employees who joined the company in the quarter
attrition = [y / (2x+z)/2]*100
Option 1 gives a higher figure so smart HR people use option 2.
Sales Pitch - EazeWork provides comprehensive HR solutions through a web base application EazeHR. The option2 formula is already available in reports there. Please visit our website for more details.

From India, Delhi
  • I had a second look at your excel sheet and noticed one anomaly.
  • In case of excel example given by you, Total head count at the start of the period for 2nd and 3rd quarter needs to be changed. It will be the closing balance of the earlier quarter. Accordingly I have changed the figures in attached file.
  • I am not sure taking average of attrition rate of three quarters will give us average attrition rate for the period July '10 to March '11.
  • I have calculated Attrition Rate using same formula for the period July '10 to March '11, which works out to be 15.12%.
  • I am not very sure why there is such a big variation between quarterly attrition rate and combined attrition rate of 3 quarters.
  • Experts please give your views. Correct me if I am wrong. Here I feel we need Mathematics Experts to respond and not HR experts.

From India, Pune

Attached Files
File Type: xls new attrition.xls (7.0 KB, 1605 views)

Hello Vkokamthankar
Atfirst thanks for attempting to resolve my query, your spirit to help others is really appreciable.Actually,I am in same confusion you are facing with,Why there is such a big variation between quarterly attrition rate and average attrition rate?
I,therefore, appeal to all seniors and friends to come forward and help us to solve our this query.

From India, Kolkata
Dear Athirumaran,
Lets look with some numbers
x = 100 (no of employees in the beginning of the quarter)
z = 20 (employees who joined in the quarter)
x+z = 120 which is the number which is achieved at the end of quarter
(2x+z)/2 = 110 is the number which is mid point of the quarter, in my view it is more realistic to report quarter figure on the total employee figure in the middle of the quarter.
Regards

From India, Delhi
Dear HR Fraternity,
Need attrition report sample in excel format, ours is retail industry and have monthly 20 exits minimum.
Pl do provide me on my mentioned mail ID:
Thanking you in advance
Santosh G
8971830777

From India, Chennai
This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2020 Cite.Co™