How To Calculate Attrition Rate - Xls Download

hi,
can you give me a gist of Att.Rate calculation.
regards,
Ajay Choudhary
Tec. Consultants

Normally the thumb rule is
Attr = (Loss in HC)/(Av HC). where HC - is headcount, Av HC is (opening HC + closing HC)/2.
The period is generally a month.

Closing Balance=Opening Balance+New Joining Employees +Left Employees

Attrition Rate=((Left Employee's*100)/(Opening Balance+New Joining+Left Employee's+Closing Balance))/100

Many of our friends on citehr have given various formulas for Attrition rate calculation.. they all give different percentages, does any one know the most widely used formula... the efforts that alll have made is remarkable.. thanks

[QUOTE=shuchita limaye;901483]Many of our friends on citehr have given various formulas for Attrition rate calculation.. they all give different percentages, does any one know the most widely used formula... the efforts that alll have made is remarkable.. thanks
"People are not lazy. They simply have impotent goals - that is, goals that do not inspire them":!::!:

Many of our friends on citehr have given various formulas for Attrition rate calculation.. they all give different percentages, does any one know the most widely used formula... the efforts that alll have made is remarkable.. thanks
"People are not lazy. They simply have impotent goals - that is, goals that do not inspire them":!::!:[/QUOTE]

Hi
Formula : Attrition for the month/Total Headcount * 100
or it can be calculated as
no. of head Count of the month :
No of New Joinee/additions in the month :
Attrition :
There fore formula is :No of New Joinee/additions in the month + No of New Joinee/additions in the month - Attrition =
Regards
Smrins

I see that every organisation uses or devices its own formula to calculate attrition rate, hence making it impractical to use a standardized formula.

Hi,
I am attaching the calculation of attrition rate.
Hope this will help you.
Thanks
Anisha Mittal

Dear Friends,
Please find the attached attrition calculator, let me know if this is of help for you. It was contributed to the forum by one our friend long back. Let us appreciate and thank him for the efforts.
Regards
Vamsi