Hi All,
I am working for an IT company with 400+ employees. As we all are aware, IT companies face the maximum rate of attrition. I want to calculate the attrition rate for my company and just want your inputs on my queries mentioned below:
1. While calculating the attrition rate, do we need to consider only the confirmed employees during that period?
2. Do we need to count absconding employees for the attrition rate as well?
3. What is the popular formula used for calculating the Attrition Rate?
Requesting your help.
Thanks & Regards,
Sapana
From India, Mumbai
Acknowledge(0)
Amend(0)
1I am working for an IT company with 400+ employees. As we all are aware, IT companies face the maximum rate of attrition. I want to calculate the attrition rate for my company and just want your inputs on my queries mentioned below:
1. While calculating the attrition rate, do we need to consider only the confirmed employees during that period?
2. Do we need to count absconding employees for the attrition rate as well?
3. What is the popular formula used for calculating the Attrition Rate?
Requesting your help.
Thanks & Regards,
Sapana
From India, Mumbai
Acknowledge(0)Amend(0)
Dear Sapna,
The formula for attrition rate is:
(Number of attritions x 100) / (Actual Employees + New Joiners) / 100.
Yes, you need to count the absconding employees as they have joined the organization and left due to various reasons, possibly related to the company culture. You should also include the employees who have not been confirmed.
Thank you.
From India, Pune
Acknowledge(0)Amend(0)
The formula for attrition rate is:
(Number of attritions x 100) / (Actual Employees + New Joiners) / 100.
Yes, you need to count the absconding employees as they have joined the organization and left due to various reasons, possibly related to the company culture. You should also include the employees who have not been confirmed.
Thank you.
From India, Pune
Acknowledge(0)Amend(0)
Hi Sapana,
While calculating the attrition formula, both confirmed and probationary employees are considered. Yes, absconding employees are also included. Attrition is calculated for all employees who leave the organization, regardless of the reason, whether absconded or terminated, etc.
There are three formulae used for attrition calculation: Monthly Attrition Rate, Annual Attrition Rate, and Annualized Attrition Rate.
Monthly Attrition = (No. of Employees left in Current Month / Avg Headcount) * 100
(Average HC = (Employee Strength at the Start of the month + Employee Strength at the end of the month) / 2)
Annualized Attrition: In the case of annualized attrition calculation, based on the current attrition trend, the prospective annual attrition is calculated. For example, if we are calculating annualized attrition for June, then,
Annualized Attrition = (Sum of employees left in the last 6 months) * (12 / N) / (Avg HC of last 6 months)
N is the number of months, here it is 6 since June is the 6th month of the year.
When the above formula is used at the end of the year, the rate is called Annual Attrition as it gives the actual attrition of the specific year.
Regards,
Satpreet Kaur
From India
Acknowledge(0)Amend(0)
While calculating the attrition formula, both confirmed and probationary employees are considered. Yes, absconding employees are also included. Attrition is calculated for all employees who leave the organization, regardless of the reason, whether absconded or terminated, etc.
There are three formulae used for attrition calculation: Monthly Attrition Rate, Annual Attrition Rate, and Annualized Attrition Rate.
Monthly Attrition = (No. of Employees left in Current Month / Avg Headcount) * 100
(Average HC = (Employee Strength at the Start of the month + Employee Strength at the end of the month) / 2)
Annualized Attrition: In the case of annualized attrition calculation, based on the current attrition trend, the prospective annual attrition is calculated. For example, if we are calculating annualized attrition for June, then,
Annualized Attrition = (Sum of employees left in the last 6 months) * (12 / N) / (Avg HC of last 6 months)
N is the number of months, here it is 6 since June is the 6th month of the year.
When the above formula is used at the end of the year, the rate is called Annual Attrition as it gives the actual attrition of the specific year.
Regards,
Satpreet Kaur
From India
Acknowledge(0)Amend(0)
Hello all,
I am doing CHRMP course where I learned the attrition formula. It is the number of employees leaving in a month divided by the total number of employees at mid-month, multiplied by 100. Is there not a particular formula for calculating attrition? Please help me.
From India, Hyderabad
Acknowledge(0)Amend(0)
I am doing CHRMP course where I learned the attrition formula. It is the number of employees leaving in a month divided by the total number of employees at mid-month, multiplied by 100. Is there not a particular formula for calculating attrition? Please help me.
From India, Hyderabad
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.
Attrition Rate formula.pdf
SAMPLE Employee Attrition Calculation sheet for FY 09-10 .xls
Calculation of Attrition Rate.doc