Annual Attrition Rate calculation

singhshalini1 · #1 (**permalink**) 09-08-2008, 03:52 PM

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

Please help

Regards
Shalini

pawan.krish · #2 (**permalink**) 09-08-2008, 04:33 PM

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.

Think about it.

puneetashokjain · #3 (**permalink**) 09-08-2008, 05:19 PM

dear Pawan,

Please tell how to claculate the attrition rate, if we have the required data?
Regards,
Puneet

singhshalini1 · #4 (**permalink**) 11-08-2008, 12:35 PM

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 0

= 67

Regards
Shalini

Quote:

Originally Posted by pawan.krish

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.

Think about it.

vaibhav.tal · #5 (**permalink**) 11-08-2008, 01:18 PM

Annual Attrition Rate= Total Number of Staff who hv resigned till date /
Avg Headcount (Reporting Month) X 100%

Rtsa · #6 (**permalink**) 11-08-2008, 01:30 PM

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

nashbramhall · #7 (**permalink**) 11-08-2008, 02:51 PM

Hello Shalini,

If my maths is correct
Total No. of Employees in July 2007 = 277

New Joinees(July 2007 to 0

= 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

singhshalini1 · #8 (**permalink**) 11-08-2008, 06:30 PM

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.

Please advise.

Regards
Shalini

Rtsa · #9 (**permalink**) 12-08-2008, 11:39 AM

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

saifahmed_10 · #10 (**permalink**) 15-08-2008, 07:56 PM

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.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode