Hi Seniors,
Can you please provide the formula to calculate the average annual attrition rate? I have searched on CiteHR but could only find the annual attrition rate, which differs from the one we are using.
Below is the formula that we are using to calculate the Annual Attrition Rate:
Annual Attrition Rate: (Employees left in the Current Month * (12/No. of Months)) / ((Current employee strength + Employees at the start of the month) / 2)
Regards,
Satpreet Kaur
From India
Acknowledge(0)
Amend(0)
36Can you please provide the formula to calculate the average annual attrition rate? I have searched on CiteHR but could only find the annual attrition rate, which differs from the one we are using.
Below is the formula that we are using to calculate the Annual Attrition Rate:
Annual Attrition Rate: (Employees left in the Current Month * (12/No. of Months)) / ((Current employee strength + Employees at the start of the month) / 2)
Regards,
Satpreet Kaur
From India
Acknowledge(0)Amend(0)
Hello Satpreet, You would want to try - Monthly attrition*12/Average manpower for the month Regards, Tara
From India, Sirsa
Acknowledge(0)Amend(0)
From India, Sirsa
Acknowledge(0)Amend(0)
Hi Tara,
Thanks for your response, but again, the formula you have mentioned above is to calculate the average monthly attrition. Can you please help me with the average annual attrition rate.
Hi Seniors,
67 views but still I have not been able to get the answer for my query. Can anybody please help me?
Regards,
Satpreet Kaur
From India
Acknowledge(0)Amend(0)
Thanks for your response, but again, the formula you have mentioned above is to calculate the average monthly attrition. Can you please help me with the average annual attrition rate.
Hi Seniors,
67 views but still I have not been able to get the answer for my query. Can anybody please help me?
Regards,
Satpreet Kaur
From India
Acknowledge(0)Amend(0)
Good Evening,
I believe that this is what you want: Labor Turnover/Attrition = Avg no. of employees left during the period / Total no. of employees during the year * 100. Annual turnover is computed by adding up the monthly turnover for a 12-month period. Monthly turnover is first calculated as the number of employee separations during one month divided by the average number of active employees during the same period.
Monthly Turnover Rate = Number of separations during the month / Average number of employees during the month * 100.
Mahesh Das - HR
Binani Zinc
From India, Kozhikode
Acknowledge(0)Amend(0)
I believe that this is what you want: Labor Turnover/Attrition = Avg no. of employees left during the period / Total no. of employees during the year * 100. Annual turnover is computed by adding up the monthly turnover for a 12-month period. Monthly turnover is first calculated as the number of employee separations during one month divided by the average number of active employees during the same period.
Monthly Turnover Rate = Number of separations during the month / Average number of employees during the month * 100.
Mahesh Das - HR
Binani Zinc
From India, Kozhikode
Acknowledge(0)Amend(0)
Hi Satpreet kaur, Please find herewith attached Attrition report calculation for your information. Hope meet your requirement. Reach me for any specific queries. Regards, Karthick Eswar
From India, Dindigul
Acknowledge(0)Amend(0)
From India, Dindigul
Acknowledge(0)Amend(0)
Everyone has a different formula that suits them. I will try to give you the generic formula.
Let me first explain the terms. Monthly attrition rate is the rate of attrition for that month. It can be calculated as:
Number of people left during the month / Average number of people employed during the month.
The average number of people employed can be calculated by adding (opening headcount + closing headcount) / 2.
Annualized attrition is a term used to describe the projected attrition on an annual basis if the current trend continues. In this case, you multiply the above with 12 to get the "Annualised attrition." This is a projected figure only. If you are comparing this month over month, you can use the actual data from past months.
Let's consider an example where we are computing on May 31st, and the calendar starts from January. We will:
- Sum the average people employed in Jan, Feb, Mar, Apr, and May.
- Sum the people who left in Jan, Feb, Mar, Apr, and May.
- Apply the same formula, but before multiplying by 12, divide by 5 to get the annualized number.
You can obtain the actual number for the last 12 months if you have data for the past 12 months. When you have data for the last 12 months, it is called "Annual Attrition." This figure is actual and does not have any projected element. To calculate this, you do not multiply by 12 because you have the actual data for the last 12 months.
I hope you understand the difference between annualized vs. annual attrition as well.
If you still need help, you can contact me at tayals@live.com.
From India, Bangalore
Acknowledge(0)Amend(0)
Let me first explain the terms. Monthly attrition rate is the rate of attrition for that month. It can be calculated as:
Number of people left during the month / Average number of people employed during the month.
The average number of people employed can be calculated by adding (opening headcount + closing headcount) / 2.
Annualized attrition is a term used to describe the projected attrition on an annual basis if the current trend continues. In this case, you multiply the above with 12 to get the "Annualised attrition." This is a projected figure only. If you are comparing this month over month, you can use the actual data from past months.
Let's consider an example where we are computing on May 31st, and the calendar starts from January. We will:
- Sum the average people employed in Jan, Feb, Mar, Apr, and May.
- Sum the people who left in Jan, Feb, Mar, Apr, and May.
- Apply the same formula, but before multiplying by 12, divide by 5 to get the annualized number.
You can obtain the actual number for the last 12 months if you have data for the past 12 months. When you have data for the last 12 months, it is called "Annual Attrition." This figure is actual and does not have any projected element. To calculate this, you do not multiply by 12 because you have the actual data for the last 12 months.
I hope you understand the difference between annualized vs. annual attrition as well.
If you still need help, you can contact me at tayals@live.com.
From India, Bangalore
Acknowledge(0)Amend(0)
Karthick made a good speadsheet. I added an extra line to show the total attrition rate for the year. You can change the dates as needed for whatever 12 month total you need. Safetyforall
From United States, Grand Prairie
Acknowledge(0)Amend(0)
From United States, Grand Prairie
Acknowledge(0)Amend(0)
HI, wat u use is correct. (Employees left in Current Month * (12/No. of Month))/((Current employee strenghth+Employees at start of the month)/2) Thanks, Karthik
From India, Madras
Acknowledge(0)Amend(0)
From India, Madras
Acknowledge(0)Amend(0)
Hello Satpreet,
Attrition calculation is always annualized. The shared formula gives you the annualized percentage for the respective month. When instead of 12, you make it 4, it gives the annualized percentage for a quarter.
Thank you!
Tara
From India, Sirsa
Acknowledge(0)Amend(0)
Attrition calculation is always annualized. The shared formula gives you the annualized percentage for the respective month. When instead of 12, you make it 4, it gives the annualized percentage for a quarter.
Thank you!
Tara
From India, Sirsa
Acknowledge(0)Amend(0)
ATTRITION ANALYSIS or ATTRITION RATE
Attrition = ((no. of attrition/left emp.*100)/(actual emp. + new joinee))/100
Formulas: =((F6*100)/(D6+E6+F6+G6))/100 this is for first month.
= ((F7*100)/(D7+E7))/100 this is for second month.
= ((F8*100)/(D8+E8))/100 continues like this.
(The formula and correct logic behind calculation of ATTRITION RATE)
=((no. Of attritions x 100) / (Actual Employees + New Joined)) /100.
Examples:
1) Actual Employees No. Of people left No. Of Joined Total Employees
(Opening BAL) (Attritions) (Current Headcount)
150 20 25 155
So according to the formula: ((20 x 100) / (150 + 25)) / 100
Which comes to 0.1142 i.e. 11%
Now as you had 150 previously and now 25 joined so it makes 150 + 25 =175
Now if you calculate 11.42% of 175 i.e. 175 x 0.1142 = 20
This clearly shows that 175 – 20 = 155, which is your current headcount and at the same time you can say my attrition is 11.42% that shows you lost 20 employees of 150 and 25 more joined which makes count to 175.
From India, Visakhapatnam
Acknowledge(0)Amend(0)
Attrition = ((no. of attrition/left emp.*100)/(actual emp. + new joinee))/100
Formulas: =((F6*100)/(D6+E6+F6+G6))/100 this is for first month.
= ((F7*100)/(D7+E7))/100 this is for second month.
= ((F8*100)/(D8+E8))/100 continues like this.
(The formula and correct logic behind calculation of ATTRITION RATE)
=((no. Of attritions x 100) / (Actual Employees + New Joined)) /100.
Examples:
1) Actual Employees No. Of people left No. Of Joined Total Employees
(Opening BAL) (Attritions) (Current Headcount)
150 20 25 155
So according to the formula: ((20 x 100) / (150 + 25)) / 100
Which comes to 0.1142 i.e. 11%
Now as you had 150 previously and now 25 joined so it makes 150 + 25 =175
Now if you calculate 11.42% of 175 i.e. 175 x 0.1142 = 20
This clearly shows that 175 – 20 = 155, which is your current headcount and at the same time you can say my attrition is 11.42% that shows you lost 20 employees of 150 and 25 more joined which makes count to 175.
From India, Visakhapatnam
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.