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
7th January 2010 From India

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
7th January 2010 From India, Hyderabad

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
7th January 2010 From India, Mumbai

Go to the following web page
#109924
and download my free Excel workbook "to_rate.xls"
7th January 2010 From United States, Chelsea

Attrition calculation per year =No.of eexits/Total headcount * 100 Attrition calculation per month = No.of exits/Total headcount *100 * 12 Regards Charvka Reddy
7th January 2010 From India, Hyderabad

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

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
8th January 2010 From India, Gurgaon

Dear Piyush suggest me for any site which provide the proper material for pf calculation vijay
8th January 2010 From India

hi, Giving herewith one attachment.hope this will be helpful to you. Thanks, minal
8th January 2010 From India, Vadodara

Attached Files (Download Requires Membership)

Attrition Calculator and Register(1).xls (23.5 KB, 323 views)

Dear Friends, Pls clarify whether attrition to be calculated on monthly basis or annually? Regards, Sujith
8th January 2010 From India, Bangalore