Attrition Rate Calculation - formula which gives a reliable figure?

Thanks Rajat.
For others...the formula is:
(Total number of seperations in the month divided by Average Number of Employees During the Month) multipled by 100.
Here Average number of employees means:
(Number of People at the beginning of the month + Number of people at the end of the month) divided by 2.
I hope this will help.
Regards
Sanjeev Sharma
(blog: http://sanjeevhimachali.blogspot.com/)

Well these formula's seems to be correct but still i have a doubt in my mind why dont they take into factors like employee experience because in industry like bpo and kpo's its the freshers who leave the firm more frequently then experinced one
So how does experience affect the attrition ???

Hi Aditi and Bob I really had a big learning experience as I was hunting for the same for the past few days.
Regards
Priyanka

Hi
You will notice that attrition if calculated each month based on the employees on roll for that month will be misleading. We need to report it as annulaised basis. Then the data becomes meaningful as you can interpret it and take corrective actions. I agree with other comments on granularity like skill, geography,experience, reasons - Some of the attributes for which you need to map the attrition.
Cheers
Bala

hi any one plz mail me xact attrition formula,, iam very poor in maths yaar,,, but wt can i do,, plz mailany one ifu have formula,, for attrition as welll as aht,, i have for aht but i need for attrtion ,, plzz ,, my id is [Login to view]

Dear Friends,
I have one doubt when it comes to attrition do we need to consider the opening balance of a month or closing balance or both to calculate the attrition rate. Can anyone clarify me..........
Regards
Amith R.

Hi Rajat,
I tried using th excel sheet u posted to claculate attrition but there seems to be a formula change in H7 and the rest of the attrition rate column
Can you please help me in sorting this out
Regards,
Pallavi[prabhu.pallavi@gmail.com]

Hi Rajat,
Thanks for the information, But i'm really confused you have written the formula for attrition as :
Total Number of Resigns per month (Whether voluntary or forced) divided by (Total Number of employees at the beginning of the month plus total number of new joinees minus total number of resignations) multiplied by 100.
& the formula you are using in attached excel sheet is totally different
((F7*100)/(D7+E7+F7+G7))/100
Please correct me if I'm worng........
Please mail me to [Login to view], if possible....

[ No. of Employees Left during the Year*100 ] /
[Employees on Record at the Beginning of the Year+No. of Employees Joined during the Year+No. of Employees Left during the Year+Employees on Record at the end of Year]/ 100
-C.Kums

hey guys can u plz explin me as to wat is opening balance in the execl sheet for attrition rate.