Understanding Attrition Rate: What's the Easiest Way to Calculate It?

Hi friends,

To calculate the attrition rate, there are different ways to find out. Here is one method that makes it easy to determine the rate.

Dear Radhika,

Please find the calculation for the attrition rate below:
Total number of resignations per month (whether voluntary or forced) divided by (total number of employees at the beginning of the month plus the total number of new joiners minus the total number of resignations) multiplied by 100.

Take care,
Savitri

How would you calculate YTD attrition percentage in the middle of the year? Using headcount only for that time period would ignore any drastic changes in the headcount and may just skew the attrition percentage.

For example, if the headcount was stable until March, but rose from April up to September, calculating the attrition percentage in September based on the September headcount would give a much lower attrition percentage. So, which headcount should be taken?

This was a great help. I am in the private equity business and currently seconded to one of the assets that the fund has acquired. The asset just happens to be about 45 hotels. This will come in handy.

William

YTD stands for year-to-date. By a YTD calculation, I meant calculating attrition not only for a specified time period like a week or a month but rather for the whole year up to that date. For example, YTD attrition for June 1st would take into account all the exits that happened up to June 1st from January 1st.

Hi, guys. I am Jagat. I just got to know about the method for finding the attrition rate and went searching for it, but I couldn't find any information. Can you please provide me with details on how to find out the methods and calculations?

Some of you might want to use this Excel tracker to calculate attrition rate.

Regards, Girish