singhshalini1 Started The Discussion:
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

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
dear Pawan, Please tell how to claculate the attrition rate, if we have the required data? Regards, Puneet
9th August 2008 From India, Ajmer
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
Annual Attrition Rate= Total Number of Staff who hv resigned till date / Avg Headcount (Reporting Month) X 100%
11th August 2008 From India, Aurangabad
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
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
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
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
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

Please share if you have any insights for this topic page and be part of our fostered professional community at Cite.Co. Avoid "Thank You" posts to preserve the integrity and readability of this page. Instead, help someone else with your knowledgeable inputs. If you have any related query please .