Hi,

I am working with a software firm. I need a attrition rate formula whch gives a reliable figure. There are many on the web but its confusing which one to take....

So Please help me out with this.

Thanks & Regards,
Avishal

Hi Avishal,

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. Naukri.com - Search Jobs in Delhi, Mumbai, Bangalore - Career - India - 32k

Hope this is of help to you.

Cheerio
Samkapur