Attrition Rate Calculation - formula which gives a reliable figure?

Sanjeev.Himachali

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/)
12th December 2006 From India, Mumbai

gaurav_kh1

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 ???
4th May 2007 From India, New Delhi

Priyanka Nikumbha

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
31st July 2007

Vb_bala

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
14th November 2007

rajshakerreddy

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

24th June 2008 From India, Hyderabad

Amith R Murthy

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.
24th June 2008 From India, Bangalore

pallavi.prabhu

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]
22nd September 2008 From India, Bangalore

riank

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

, if possible....
5th October 2008 From India, Pune

ckums

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
22nd November 2008 From India, Madras

kings

hey guys can u plz explin me as to wat is opening balance in the execl sheet for attrition rate.
24th November 2008 From India, Mumbai

Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.