How To Find Out The Attrition Rate - Xls Download

Dear friends
My name is karthic , iam working in TVS Group.Can any one help me out in finding the attrition rate.

Dear Karthic,
pls find below the Attriition calaculator
Attrition%=No of employees moved out of the company during the period / No of employee's in the organisation * 100
will get you the percentage of attrition.
Warm Regards
Shroff M

Attrition rate is number of employees left divided by number of employees as a percentage. Here you have to take the average number of employees in the denominator( opening balance+closing balance divided by 2).

Hey Dear Friend,
Please find the attached copy of attrition rate of calculation
Regards,
ac_prabha

hai karthik i hev sme material chk whether it can be any usse for u

Hi,
There are two practices being followed by organizations to calculate the attrition rate:
1) No of Exit in the month/(no of employees at beginning of the month+ New joinings) *100
2) No of Exit in the month/ {(no of emp at beginning+no of emp at end of month)/2} *100
In both the cases, you will find very little difference in the attrition rate. Just for your info, many MNC and big companies follows S.No 2 formula to know their attrition rate.
Regards,
Anup

Hi Anup,
You are absolutely right when you say both the formulae are correct. My doubt is that the first formula which is relatively less used in organizations gives more accurate results. Please refer to this word doc for further explanations. And please let me know about your views. Kindly reply on my e-mail id : [Login to view].
Regards
Priyanka

Here is the document.

Hello Kartik,
Attrition rate for a month . (head count in the begining of the month / head count at the end of the month) * 100

Hello Kartik,
Please find enclosed an attchment.
You can calculate Attrition rate, with the help of this attachment.
Regards,