Attrition Rate Formula Required - Xls Download

can any one give me the detail about how to find the attrition rate. i am totally confused.
Ragahavan

Hi Ragha,
Please do find what I have if this useful to you.

hi..............
i hope the following link may help you in some way..............
<link no longer exists - removed>

Dear raghav,
TO CALCULATE ATTRITION THE FORMULA IS :
ATTRITION RATE-- TOTAL NO OF EMPLOYEES LEFT DURING THAT MONTH/TOTAL NO OF EMPLOYEES*100

Attrition Formula:
(No.of employees left in the organization/ Avg employees or total employees) X 100
some organization would take total employees to calculate attrition rate & sme takes avg employees during the year or month, depends upon monthly or yearly report.
Thanks

hii,
find the attached document on attrition and retention....
if any points to be added ...kindly do it

hi,
please find the attached formula. hope this will help you to understand attrition.
rgds
jyoti negi

ATTRITION RATE
(The formula and correct logic behind calculation of Attrition Rate)
((no. Of attritions x 100) / (Actual Employees + New Joined)) /100.
Examples:
1) Actual Employees No. Of people left No. Of Joined Total Employees
(Opening BAL) (Attritions) (Current Headcount)
150 20 25 155
So according to the formula: ((20 x 100) / (150 + 25)) / 100
Which comes to 0.1142 i.e. 11%
Now as you had 150 previously and now 25 joined so it makes 150 + 25 =175
Now if you calculate 11.42% of 175 i.e. 175 x 0.1142 = 20

Which clearly shows that 175 – 20 = 155, which is your current headcount and at the same time you can say my attrition is 11.42% that shows you lost 20 employees of 150 and 25 more joined which makes count to 175.

Dear Philip,This is really helpful. May be it will be personal question, but still i would like to know, your designation, do you belong to HR? I am looking for some practical aspects of HR.Like HR Policy format for healthcare industry or any other industry, which i can customize for healthcare industry. Definitely, it is not a easy task, but will be continue touch with you all to give final shape.eagerly looking for valuable answers and postings.regards,priyanka