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
From India, Pune
Acknowledge(0)
Amend(0)
34I 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
From India, Pune
Acknowledge(0)Amend(0)
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.
From India, Hyderabad
Acknowledge(0)Amend(0)
From India, Hyderabad
Acknowledge(0)Amend(0)
dear Pawan, Please tell how to claculate the attrition rate, if we have the required data? Regards, Puneet
From India, Ajmer
Acknowledge(0)Amend(0)
From India, Ajmer
Acknowledge(0)Amend(0)
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
From India, Pune
Acknowledge(0)Amend(0)
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
From India, Pune
Acknowledge(0)Amend(0)
Annual Attrition Rate= Total Number of Staff who hv resigned till date / Avg Headcount (Reporting Month) X 100%
From India, Aurangabad
Acknowledge(0)Amend(0)
From India, Aurangabad
Acknowledge(0)Amend(0)
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
From India, Gurgaon
Acknowledge(0)Amend(0)
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
From India, Gurgaon
Acknowledge(0)Amend(0)
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
From United Kingdom
Acknowledge(0)Amend(0)
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
From United Kingdom
Acknowledge(0)Amend(0)
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
From India, Pune
Acknowledge(0)Amend(0)
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
From India, Pune
Acknowledge(0)Amend(0)
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
From India, Gurgaon
Acknowledge(0)Amend(0)
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
From India, Gurgaon
Acknowledge(0)Amend(0)Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
SAMPLE Employee Attrition Calculation sheet for FY 09-10 .xls
Calculation of Attrition Rate.doc