LakshmiGanesh
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

From India
narendra.swarna
92

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

From India, Hyderabad
rudsan
3

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

From India, Mumbai
Bob Gately
45

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

From United States, Chelsea
charvaka
4

Attrition calculation per year =No.of eexits/Total headcount * 100 Attrition calculation per month = No.of exits/Total headcount *100 * 12 Regards Charvka Reddy
From India, Hyderabad
citemaninggn
Hi, Attrition can be calculated like: (Total attrition / Average of Opening & Closing Headcount) * No. of months data taken from Regards... Abhi
From India, Calcutta
tanejarimpy
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
From India, Gurgaon
vijay.joshi11
Dear Piyush suggest me for any site which provide the proper material for pf calculation vijay
From India
minalsoni
hi, Giving herewith one attachment.hope this will be helpful to you. Thanks, minal
From India, Vadodara
Attached Files (Download Requires Membership)
File Type: xls Attrition Calculator and Register(1).xls (23.5 KB, 323 views)

sujith
2

Dear Friends, Pls clarify whether attrition to be calculated on monthly basis or annually? Regards, Sujith
From India, Bangalore
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.






Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.