How To Calculate Attrition - Xls Download

Hi,

Attrition Calculation: Number of Resignations divided by total number of Employees in the organization multiplied by 100. At any given point in time, this will give you the Attrition rate.

Seniors: Please correct me if I am wrong.

Regards,
Lakshmi N

Dear Lakhmi,

Please correct your formula. It should be:

(No. of employees resigned during the period / Average head count during the period) * 100

where Average head count = (Head count at the start of the period + Head count at the end of the period) / 2

Thanks & Regards,

S. Narendra Nath

Dear All,

I believe there should be three types of attrition calculation methods:

1) Monthly Attrition: To understand the status of a specific month
= (separations in the month) / (opening of the month + closing of the month) / 2

2) Year-to-Date Attrition: To know the YTD status
= similarly as above, but the period has to be specific. For example, if we consider the period from April 09 to December 09, then the opening balance should be for April 09 and the closing balance should be for December 09.

3) Annual Attrition: This will help us monitor the attrition trend and take timely measures. It serves as a forecasting tool.
= (total number of separations) / (average of opening balances) / number of months considered for calculation * 12

For instance, if we want to analyze the attrition trend in the year 2009 and it's April 09, the calculation will be as follows:
Jan 09: Opening - 120, Left - 5
Feb 09: Opening - 115, Left - 7
Mar 09: Opening - 121, Left - 6
Apr 09: Opening - 123, Left - 3

Then our annual attrition will be = (5 + 7 + 6 + 3) / (average of (120 + 115 + 121 + 123)) / 4 * 12
This calculation will indicate our year-end status if the trend of losing people continues in the last 4 months.

I hope this explanation is helpful to all of us.

Bye

Go to the following webpage #109924 and download my free Excel workbook "to_rate.xls".

Attrition calculation per year = No. of exits / Total headcount * 100

Attrition calculation per month = No. of exits / Total headcount * 100 * 12

Regards,
Charvka Reddy

Hi,

Attrition can be calculated as follows:
(Total attrition / Average of Opening & Closing Headcount) * Number of months data is taken from.

Regards,
Abhi

Attrition is calculated as the total number of resignations per month (whether voluntary or forced) divided by the total number of employees at the beginning of the month plus the total number of new joiners minus the total number of resignations, all multiplied by 100.

Dear Piyush,

Could you suggest a site that provides the proper material for PF calculation?

Vijay

Hi,

I am attaching one file herewith. I hope this will be helpful to you.

Thanks,
Minal

Dear Friends,

Please clarify whether attrition is to be calculated on a monthly basis or annually.

Regards,
Sujith