From "singhshalini1" : Dear All
I want to calculate attrition rate for my company.
Total No. of Employees in July 2007 = 277
Total Number of Employees in July 2008 = 234
Total no. of employees resigned = 45
Regards
Shalini
9th August 2008 From India, Pune

pawan.krish 1
Hai Shalini You want to Attrition Its ok Then you need to mention Joinings - 2007 & 08 and Left Employees - 2007 Then only we can help you. :idea: Think about it.
9th August 2008 From India, Hyderabad
puneetashokjain
dear Pawan, Please tell how to claculate the attrition rate, if we have the required data? Regards, Puneet
9th August 2008 From India, Ajmer
singhshalini1 31
Hi
Please let me know how to calculate attrition with following attributes:-
Total No. of Employees in July 2007 = 277
Total Number of Employees in July 2008 = 234
Total no. of employees resigned = 45
New Joinees(July 2007 to 08) = 67
Regards
Shalini

11th August 2008 From India, Pune
vaibhav.tal 3
Annual Attrition Rate= Total Number of Staff who hv resigned till date / Avg Headcount (Reporting Month) X 100%
11th August 2008 From India, Aurangabad
Rtsa
shalini,
The head count u have quoted is as on July 08 right?, if yes, then the ( headcount as on july 07 + new joinees - resignees) should give you your headcount as on July 08. As per the numbers you have given it doesn't tally.
If all other info except for the new joinees is correct, then pls apply the formula Vaibhav has quoted. Avg number of employees = ( july 07 + july 08 ) / 2
Hope this is of some use to you.
Best Regards
Aarthi
11th August 2008 From India, Gurgaon
nashbramhall 1501
Hello Shalini,
If my maths is correct
Total No. of Employees in July 2007 = 277
New Joinees(July 2007 to 0:cool: = 67
Total no. of employees July 2007 -2008 = 344
Less total no. of employees resigned = 45
Total Number of Employees in July 2008 = 299
Your figure for the same is
Total Number of Employees in July 2008 = 234
So what happened to the rest?
Have a nice day.
Narasimhan
11th August 2008 From United Kingdom
singhshalini1 31
Dear All
Well I have to calculate attrition rate for the period between July 2007 to July 2008 with following data.
Total No. Of Employees in July 2007 - 277
Total No. Of Employees in July 2008 - 234
Resigned Employees in July 2007 - July 2008 = 45
New Joinees in July 2007 - July 2008 = 67
Please let me know with these above informations can the attrition rate between July 2007 to July 2008 can be calculated or not.
Regards
Shalini
11th August 2008 From India, Pune
Rtsa
Dear Shalini,
As I have quoted in my previous mail. Your numbers on either the new joinees or your head count seems to be wrong. However, if you are sure that your numbers with respect to :
Head count ( July 07 and July 08 )
Exits ( Resignees )
is correct, then please go ahead and use Vaibhav's formula. That will give u the attrition %. However, I suggest you revisit the numbers you have mentioned before you go ahead with this.
Best Regards
Aarthi
12th August 2008 From India, Gurgaon
saifahmed_10
Attrition formula is : Total attried /average(Opening strength+closing strength) So to calculate the attrition rate you have to mention the opening and closing strength of 2007 and 2008.
15th August 2008 From India
To be part of this and many other peer to peer discussions, Register at CITE which provides insights into real world issues and fosters community support and learning.

Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction towards the actions necessary. The advice should be validated by proper consultation with a certified professional. The network or the members providing advice cannot be held liable for any consequences, under any circumstances.