Hr & Od Consultant
System (sap Tm/pa, Vb)& Hr
Rajat Joshi
Hr Consulting ,trainer -creative Thinking
Amith R Murthy
Hr Executive
Business Consultancy
Antony Prakash
Hr Manager
Resource Manager
Associate Hr
Sr. Hr Manager
Hr- Executive
+3 Others

Hi, I am working with a softwre firm. I need a attrition rate formula which gives a reliable figure. There are many on the web but its lil confusing which one to take....
So Please help me out with this.
Thanks & Regards,
18th March 2005 From India, Gurgaon
Welcome to
For a small s/w firm if it's totally depend upon more on intellectual wealth then the attrition rate makes the significant impact but for a skill based wealth up to a level it may not make much difference should be simply
keep a log of leaving and coming emps with exp level band and calculate the percentage.
if u r asking for BPO then a BPO guy can help on this foum.
18th March 2005 From India, Delhi
Hi Anuj,
Thanks for the reply but for calculating that percentage I need a standard formula. or I just cant take the numbers and take the percentage . we have to present this data to our Board of Directors.
If you have anything on this do let me know.
18th March 2005 From India, Gurgaon
Hi Aditi,

Am attaching the excel sheet for as a ready reckoner for the calculation of Attrition rate.

Yes, you are right that there are many formulaes available and the question arises which ones to use? well , i suggest take the one which best fits your organization and simple formula to be used is :-

Total Number of Resigns per month (Whether voluntary or forced) divided by (Total Number of employees at the beginning of the month plus total number of new joinees minus total number of resignations) multiplied by 100.

Attrition rate by itself doesn't reveal much or is rather ham handed when this topic is raised in the Management meetings. The attrition rate to be meaningful has to be analyzed well from different perspectives

Suggest that you further break up the data pertaining to attrition rate in the following manner:-

• Experienced professionals with particular proficiency like Java or C++,

• Number of people who served for x years,

• Retirement

• Forced attrition rate – people who have been asked to leave for non-performance.

• Joining competitors- further can be broken into two categories viz C&B and areas/new technologies or platforms working on

• Attrition rate department wise or city wise

If you wish to know more attrition rate & find ways to contain it – then I suggest refer the website link on a seminar for the same. - 32k

Hope this is of help to you.


18th March 2005 From India, Pune

Attached Files
Membership is required for download. Create An Account First
File Type: xls attrition-rate.xls (18.0 KB, 29061 views)

for the plain basic starting it's going to be the farmula
and can be modified considering statistical points of view.
oh again mathmatics.. for hr personal... but good to impress your boss
and ask for salary increment
18th March 2005 From India, Delhi
Click on the link below and download the MS Excel Workbook under "Free Download No. 5: Turnover Workbook".
19th March 2005 From United States, Chelsea
Dear Rajat,
I have gone through this formula, this formula is not match with narration given in the paragraph and formula is vary between first row and rest of the rows, please kindly check and explain.
Thanks and regards,
As per the statement the formula is = (No of Resignation per month/no of total employees at the beginning of the month- tot no of new comers-tot no of resignation)*100

2nd February 2006 From India, Madras
The calculation is baasically ok for calculating monthly attrition. But attrition is always measured on an annual basis. For this, you need to take in the total employees at the begining of the year and at end.and take the average manpower count. The attrition needs to be measured against this.
2nd February 2006
Dear Rajat,
The formula is not match with the statement you have given and first row formula not match with the rest of the rows. Please check the attachment of attrition rate formula and help me utilize the same for my company.
3rd February 2006 From India, Madras
Hi Rajat,
I have seen the excel sheet you sent calculating the attrition. It is very informative.
But, I could not comprehend the first row, which shows that the Attrition % in Jan =
[(Employees left * 100)/(Opening balance + No. Of employees joined + Employees left + Closing Balance)]/100.
But the subsequent formulae do not include the Employees Left and Closing Balance.
Is there any rational in this?
Please educate me on this.
12th December 2006 From India, Hyderabad
Thanks Rajat.
For others...the formula is:
(Total number of seperations in the month divided by Average Number of Employees During the Month) multipled by 100.
Here Average number of employees means:
(Number of People at the beginning of the month + Number of people at the end of the month) divided by 2.
I hope this will help.
Sanjeev Sharma
12th December 2006 From India, Mumbai
Well these formula's seems to be correct but still i have a doubt in my mind why dont they take into factors like employee experience because in industry like bpo and kpo's its the freshers who leave the firm more frequently then experinced one
So how does experience affect the attrition ???
4th May 2007 From India, New Delhi
Hi Aditi and Bob I really had a big learning experience as I was hunting for the same for the past few days. Regards Priyanka
31st July 2007
You will notice that attrition if calculated each month based on the employees on roll for that month will be misleading. We need to report it as annulaised basis. Then the data becomes meaningful as you can interpret it and take corrective actions. I agree with other comments on granularity like skill, geography,experience, reasons - Some of the attributes for which you need to map the attrition.
14th November 2007
hi any one plz mail me xact attrition formula,, iam very poor in maths yaar,,, but wt can i do,, plz mailany one ifu have formula,, for attrition as welll as aht,, i have for aht but i need for attrtion ,, plzz ,, my id is
24th June 2008 From India, Hyderabad
Dear Friends,
I have one doubt when it comes to attrition do we need to consider the opening balance of a month or closing balance or both to calculate the attrition rate. Can anyone clarify me..........
Amith R.
24th June 2008 From India, Bangalore
Hi Rajat,
I tried using th excel sheet u posted to claculate attrition but there seems to be a formula change in H7 and the rest of the attrition rate column
Can you please help me in sorting this out
22nd September 2008 From India, Bangalore
Hi Rajat,
Thanks for the information, But i'm really confused you have written the formula for attrition as :
Total Number of Resigns per month (Whether voluntary or forced) divided by (Total Number of employees at the beginning of the month plus total number of new joinees minus total number of resignations) multiplied by 100.
& the formula you are using in attached excel sheet is totally different
Please correct me if I'm worng........
Please mail me to , if possible....
5th October 2008 From India, Pune
Employees on Record at the Beginning of the Year+No. of Employees Joined during the Year+No. of Employees Left during the Year+Employees on Record at the end of Year/ 100 -C.Kums
22nd November 2008 From India, Madras
hey guys can u plz explin me as to wat is opening balance in the execl sheet for attrition rate.
24th November 2008 From India, Mumbai
thanks for providing the information.
because i get a very good gift from you as this insight and i does not take anything free so i am paying you by the return gift by sending you a link where there are 40 pages of wisdom is spread. where you find hundreds of ebooks, audio books, interviews and articles on the motivational subject, Humam Resources subject and financial subject. do not just stop at page no. 1 on successories just go beyond page 1 and see the other 39 pages where you can choose your motivational, HR and fianancial stuff according to you choice and download the material on the spot.
the link is here
and once again thanks for your insight.
janet smith
13th October 2009 From India, Madras
having looked at the formula, I'm not sure I understand why you'd multiply the number of leavers x 100 in the first part of the formula ? Can someone please explain the logic of the formula to me as I can't get my head around this particular formula that was supplied, i.e. =((F6*100)/(D6+E6+F6+G6))/100 where F6= no. of leavers; D6=opening balance; E6=no. of joiners; G6=closing balance).
Many thanks

8th July 2010 From United Kingdom, London
hello everyone, i got really good questionnaire from here.. now please help me to find out different dimension which i need to co relate with attrition to find out good result.
3rd March 2013 From India
I am HR Head at Lazyfreshers. I have one digital marketing executive position urgently.
Let me know if any one.
23rd January 2019 From India, Noida
Add Reply Start A New Discussion

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)

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2019 Cite.Co™