How To Calculate Attrition Rate - Xls Download

Dear,
Plz do the need full for me by providing this calculator..
[IMG]https://www.citehr.com/misc.php?do=email_dev&email=RGlsaXBfMDgwNUB5YWhvby 5jby5pbg==[/IMG]

Hai I am Swayam, doing attrition analysis for our field staff in every month. As per the existing system,
Attrition Rate = (Exit mployees / Total employees)*100
Please send me if you have any other method.
Swayam

Hi,
I would really appreciate if someone forward the same to me also at [IMG]https://www.citehr.com/misc.php?do=email_dev&email=RGl2eWFhbmdlbGV5ZXNAcm VkaWZmbWFpbC5jb20=[/IMG].
Regards
Divya

Here is goes:
ATTRITION RATE
(No: Of attritions x 100) / (Actual Employees + New Joined)) /100.
Examples:
1) Actual Employees= (Opening BAL) =150
2) No. Of people left= (Attritions) =20
3) No. Of Joined= (Current Headcount) =25
4) Total Employees=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.

i am also new member on this site and not conversant about its properties.
can u mail me the same " How to calculate attrition rate?"
I will be vary much thankful to u if u do it so?
My email id - [Login to view]:-D

Hi All,
Attrition rate calculator!!
This topic is already posted in this site way back by our Cite HR members, and if you search you can find some methods of calculations in that links!!!
Regars
Vamsi.....:-P.....

Hi,
Attrition rate is calculated on the basis of resigned employees and manpower available on 1st of the month.
Attrition rate = resigned employees/manpower *100
Regards,
Amit Seth.

Dear Soni,
Please forward that CALCULATE ATTRITION RATE mail to me also.
[IMG]https://www.citehr.com/misc.php?do=email_dev&email=ZGl2eWFockB5bWFpbC5jb2 0=[/IMG]

Dear Friends,

I got this "Attrition sheet" from this cite only. I am posting it again for your reference....

If it solves you purpose please acknowledges.

Regards,
Manoj

WHAT WILL HAPPEN TO THIS COUNTRY?:icon10:
YOU MADE YOUR HR CERTIFICATION IS WASTE PAPER..........:idea:
I SEE GREAT OPPORTUNITIES FOR GOOD HR BRAIN IN THIS FIELD..........:-P
IF PEOPLE COULD NOT EVEN WORKOUT ON SIMPLE ARITHMETICS EQUATIONS ON AVERAGES WHAT YOU EXCEPT THESE PEOPLE CAN DO IN LIFE AND SPECIALLY IN CHALLENGING FIELD LIKE HR...:confused:
BADLU