How To Calculate Attrition - Xls Download

HI
Attrition Calculation: No. of Resignations divided by total no. of Employees in the oraganisation Into 100.
At any given point of 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 is: (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,
As per me there should be 3 types of attrition calculation methods :
1) Monthly Attrition : To understand specific month status
= ( separation in the month) / ( openg of mth + closg of mth)/2

2) Year till date attrition : to know YTD status

= similarly like above but period has to be proper like if i said for the period apr 09 to dec 09 then opng should be of Apr 09 and clsg should be of Dec 09

3) Annual Attrition : This will help us to keep an eye on the attrition trend and take appropriate measures in time. This helps us as a forecasting tool.

= (total no. of separations) / (avg of opng balances) / no. of mths considered for calculation * 12

e.g. If we want to know the attrition trend in the year 2009 and we are in apr 09, it will work as follows:
Jan 09 : opg - 120, Left - 5
Feb 09 : Opg - 115, Left - 7
Mar 09 : Opg - 121, left - 6
Apr 09 : Opg - 123, left - 3

then our annual attrition will be = (5+7+6=3)/ ( avg of (120+115+121+123))/4 * 12
This will tell us our status in the year end if we continue to loose the people in last 4 mths.

Hope this will help all of us.
Bye

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

Attrition calculation per year =No.of eexits/Total headcount * 100
Attrition calculation per month = No.of exits/Total headcount *100 * 12
Regards
Charvka Reddy

Hi,
Attrition can be calculated like:
(Total attrition / Average of Opening & Closing Headcount) * No. of months data taken from
Regards... Abhi

Attrition = total number of resign per month(whether voluntary or forced)/ (total no. of employees at the begining of the month + total no. of new joinees - total no. of resignation) * 100

Dear Piyush suggest me for any site which provide the proper material for pf calculation
vijay

hi,
Giving herewith one attachment.hope this will be helpful to you.
Thanks,
minal

Dear Friends,
Pls clarify whether attrition to be calculated on monthly basis or annually?
Regards,
Sujith