#query {background: #ebf5fd; color: #4f4f4f; letter-spacing: 1px; padding: 5px; border: 1px #001b31 solid; text-indent: 3%; font-size: small;} form#search_query { color: #FDFCFB; text-align: left; margin: 0px; }
Vkokamthankar
Asst. General Manager - Hr
+2 Others

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.
31st March 2011 From India, Kolkata

Attached Files
 Membership is required for download. Create An Account First Attrition Rate.xls (27.5 KB, 3217 views)

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

Attached Files
 Membership is required for download. Create An Account First attrition calculator.xls (22.0 KB, 2196 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.
2nd April 2011 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.

2nd April 2011 From India, Pune

Attached Files
 Membership is required for download. Create An Account First new attrition.xls (7.0 KB, 1443 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.
4th April 2011 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
5th April 2011 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:
Santosh G
8971830777
7th May 2019 From India, Chennai

Cite.Co - is a repository of information created by your industry peers and experienced seniors. Register Here and help by adding your inputs to this topic/query page.
Prime Sponsor: TALENTEDGE - Certification Courses for career growth from top institutes like IIM / XLRI direct to device (online digital learning)