How Do I Calculate My Company's Annual Attrition Rate with These Numbers?

Dear All,

I want to calculate the attrition rate for my company. The total number of employees in July 2007 was 277, and in July 2008, it was 234. The total number of employees who resigned was 45.

Please help.

Regards,
Shalini

Hi Shalini,

If you are referring to attrition, that's okay. However, you should provide details about the joinings in 2007 and 2008, as well as the employees who left in 2007. This information is necessary for us to assist you effectively.

Think about it. 🤔

Thank you.

Dear Pawan,

Please tell me how to calculate the attrition rate if we have the required data.

Regards,
Puneet

Hi,

Please let me know how to calculate attrition with the 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 2008) = 67.

Regards,
Shalini

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

Shalini,

The headcount you have quoted is as of July 08, right? If yes, then the (headcount as of July 07 + new joinees - resignees) should give you your headcount as of July 08. Based on the numbers you have provided, it doesn't tally.

If all other information except for the new joinees is correct, then please apply the formula Vaibhav has mentioned: Average number of employees = (July 07 + July 08) / 2.

Hope this information is useful to you.

Best Regards,
Aarthi

Hello Shalini,

If my maths is correct, the total number of employees in July 2007 was 277. There were 67 new joiners from July 2007 to [insert cool date here]. The total number of employees from July 2007 to 2008 was 344, with 45 employees resigning during that period. Therefore, the total number of employees in July 2008 should be 299.

Your figure for the same period shows the total number of employees in July 2008 as 234. Could you please explain the discrepancy? What happened to the rest of the employees?

Have a nice day.

Narasimhan

Dear All,

I need to calculate the attrition rate for the period between July 2007 to July 2008 with the following data:

Total Number of Employees in July 2007 - 277
Total Number of Employees in July 2008 - 234
Resigned Employees from July 2007 to July 2008 - 45
New Joiners from July 2007 to July 2008 - 67

Please let me know if the attrition rate between July 2007 and July 2008 can be calculated with this information.

Please advise.

Regards,
Shalini

Dear Shalini,

As I have mentioned in my previous email, the numbers regarding either the new joiners or your headcount seem to be incorrect. However, if you are confident that your figures for:
- Headcount (July 07 and July 08)
- Exits (Resignees)

are accurate, then please proceed with using Vaibhav's formula to calculate the attrition percentage. Nevertheless, I recommend that you review the numbers you provided before moving forward with this calculation.

Best Regards,
Aarthi

Attrition formula is: Total attrited / average(Opening strength + closing strength).

So, to calculate the attrition rate, you have to mention the opening and closing strength of 2007 and 2008.