Hope this will be helpful.... {(number of attritions*100)/(actual number of employees + new joined employees)}/100
From India, Jammu
Acknowledge(0)
Amend(0)
From India, Jammu
Acknowledge(0)Amend(0)
one more clarification is that the actual number of employees means does it include the employees till date or employees till last financial year? can you explain the formula please
From India, Warangal
Acknowledge(0)Amend(0)
From India, Warangal
Acknowledge(0)Amend(0)
Employee till date...
Example:
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, 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. At the same time, you can say your attrition is 11.42%, which shows you lost 20 employees out of 150, and 25 more joined, making the count 175.
From India, Jammu
Acknowledge(0)Amend(0)
Example:
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, 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. At the same time, you can say your attrition is 11.42%, which shows you lost 20 employees out of 150, and 25 more joined, making the count 175.
From India, Jammu
Acknowledge(0)Amend(0)
Monthly Basis: (No. of Attrition in that month/Total no. of employees in that month)*100 Yearly Basis: (No. of Attrition in that year/Toatl No. of employees in that years)*100
From India, Bangalore
Acknowledge(0)Amend(0)
2From India, Bangalore
Acknowledge(0)Amend(0)
hi i want to know tht attrition means the people who left in tht particular year.can u explain in much better way regards amit
From India, Mumbai
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
Attrition rate: Total number of people who left the organization in a given period / (Headcount at the start of the period + people recruited during the period) Regards,
From Romania, Cluj-napoca
Acknowledge(0)Amend(0)
From Romania, Cluj-napoca
Acknowledge(0)Amend(0)
ATTRITION RATE CALCULATION: (Apr '08 to Jun '08)
MONTH
Op. Balance
Left
Joined
Cl. Balance
Average
Att. Rate
(A+D) / 2
(B / E)*100
(A)
(B)
(C)
(D)
(E)
(F)
APRIL
117
4
1
114
115.50
3.46
MAY
115
5
5
115
115.00
4.35
JUNE
116
2
6
120
118.00
1.69
JULY
120
6
3
117
118.5
5.06
AUGUST
119
3
2
118
118.5
2.53
SEPTEMBER
118
2
2
118
118
1.69
1st Quarter
117.5
25
19
117
117.25
3.13
From India, Delhi
Acknowledge(0)Amend(0)
MONTH
Op. Balance
Left
Joined
Cl. Balance
Average
Att. Rate
(A+D) / 2
(B / E)*100
(A)
(B)
(C)
(D)
(E)
(F)
APRIL
117
4
1
114
115.50
3.46
MAY
115
5
5
115
115.00
4.35
JUNE
116
2
6
120
118.00
1.69
JULY
120
6
3
117
118.5
5.06
AUGUST
119
3
2
118
118.5
2.53
SEPTEMBER
118
2
2
118
118
1.69
1st Quarter
117.5
25
19
117
117.25
3.13
From India, Delhi
Acknowledge(0)Amend(0)
Hi,
This is the formula for attrition rate calculation.
MEASUREMENT OF ATTRITION RATE:-
Accession Rate = No. of employees joining during
the period
X 100
Average no .of employees during
the period
Seperation Rate = No. of employees leaving
X 100
Average no .of employees during
the period
Flux Method Attrition Rate = Additions + Seperation
X 100
Average no .of employees during
the period
Replacement method Attrition Rate =Accession – Seperation
X100
Average no .of employees during
the period
Stability Index = No. of workers with one year's service (or more) now
X100
No. of workers with one year's service (or more) one year ago
From India, Tirunelveli
Acknowledge(0)Amend(0)
This is the formula for attrition rate calculation.
MEASUREMENT OF ATTRITION RATE:-
Accession Rate = No. of employees joining during
the period
X 100
Average no .of employees during
the period
Seperation Rate = No. of employees leaving
X 100
Average no .of employees during
the period
Flux Method Attrition Rate = Additions + Seperation
X 100
Average no .of employees during
the period
Replacement method Attrition Rate =Accession – Seperation
X100
Average no .of employees during
the period
Stability Index = No. of workers with one year's service (or more) now
X100
No. of workers with one year's service (or more) one year ago
From India, Tirunelveli
Acknowledge(0)Amend(0)
Hi,
Attrition Calculation: Number of Resignations divided by total number of Employees in the organization multiplied by 100. At any given point in time, this will give you the Attrition rate.
Seniors: Please correct me if I am wrong.
Regards,
Lakshmi N
From India
Acknowledge(0)Amend(0)
Attrition Calculation: Number of Resignations divided by total number of Employees in the organization multiplied by 100. At any given point in time, this will give you the Attrition rate.
Seniors: Please correct me if I am wrong.
Regards,
Lakshmi N
From India
Acknowledge(0)Amend(0)
Dear Lakhmi,
Please correct your formula. It should be:
(No. of employees resigned during the period / Average head count during the period) * 100
where Average head count = (Head count at the start of the period + Head count at the end of the period) / 2
Thanks & Regards,
S. Narendra Nath
From India, Hyderabad
Acknowledge(0)Amend(0)
Please correct your formula. It should be:
(No. of employees resigned during the period / Average head count during the period) * 100
where Average head count = (Head count at the start of the period + Head count at the end of the period) / 2
Thanks & Regards,
S. Narendra Nath
From India, Hyderabad
Acknowledge(0)Amend(0)
Dear All,
I believe there should be three types of attrition calculation methods:
1) Monthly Attrition: To understand the status of a specific month
= (separations in the month) / (opening of the month + closing of the month) / 2
2) Year-to-Date Attrition: To know the YTD status
= similarly as above, but the period has to be specific. For example, if we consider the period from April 09 to December 09, then the opening balance should be for April 09 and the closing balance should be for December 09.
3) Annual Attrition: This will help us monitor the attrition trend and take timely measures. It serves as a forecasting tool.
= (total number of separations) / (average of opening balances) / number of months considered for calculation * 12
For instance, if we want to analyze the attrition trend in the year 2009 and it's April 09, the calculation will be as follows:
Jan 09: Opening - 120, Left - 5
Feb 09: Opening - 115, Left - 7
Mar 09: Opening - 121, Left - 6
Apr 09: Opening - 123, Left - 3
Then our annual attrition will be = (5 + 7 + 6 + 3) / (average of (120 + 115 + 121 + 123)) / 4 * 12
This calculation will indicate our year-end status if the trend of losing people continues in the last 4 months.
I hope this explanation is helpful to all of us.
Bye
From India, Mumbai
Acknowledge(0)Amend(0)
I believe there should be three types of attrition calculation methods:
1) Monthly Attrition: To understand the status of a specific month
= (separations in the month) / (opening of the month + closing of the month) / 2
2) Year-to-Date Attrition: To know the YTD status
= similarly as above, but the period has to be specific. For example, if we consider the period from April 09 to December 09, then the opening balance should be for April 09 and the closing balance should be for December 09.
3) Annual Attrition: This will help us monitor the attrition trend and take timely measures. It serves as a forecasting tool.
= (total number of separations) / (average of opening balances) / number of months considered for calculation * 12
For instance, if we want to analyze the attrition trend in the year 2009 and it's April 09, the calculation will be as follows:
Jan 09: Opening - 120, Left - 5
Feb 09: Opening - 115, Left - 7
Mar 09: Opening - 121, Left - 6
Apr 09: Opening - 123, Left - 3
Then our annual attrition will be = (5 + 7 + 6 + 3) / (average of (120 + 115 + 121 + 123)) / 4 * 12
This calculation will indicate our year-end status if the trend of losing people continues in the last 4 months.
I hope this explanation is helpful to all of us.
Bye
From India, Mumbai
Acknowledge(0)Amend(0)
Attrition calculation per year =No.of eexits/Total headcount * 100 Attrition calculation per month = No.of exits/Total headcount *100 * 12 Regards Charvka Reddy
From India, Hyderabad
Acknowledge(0)Amend(0)
From India, Hyderabad
Acknowledge(0)Amend(0)
Hi, Attrition can be calculated like: (Total attrition / Average of Opening & Closing Headcount) * No. of months data taken from Regards... Abhi
From India, Calcutta
Acknowledge(0)Amend(0)
From India, Calcutta
Acknowledge(0)Amend(0)
Attrition = total number of resign per month(whether voluntary or forced)/ (total no. of employees at the begining of the month + total no. of new joinees - total no. of resignation) * 100
From India, Gurgaon
Acknowledge(0)Amend(0)
From India, Gurgaon
Acknowledge(0)Amend(0)
Dear Piyush suggest me for any site which provide the proper material for pf calculation vijay
From India
Acknowledge(0)Amend(0)
From India
Acknowledge(0)Amend(0)
hi, Giving herewith one attachment.hope this will be helpful to you. Thanks, minal
From India, Vadodara
Acknowledge(0)Amend(0)
From India, Vadodara
Acknowledge(0)Amend(0)
Dear Friends, Pls clarify whether attrition to be calculated on monthly basis or annually? Regards, Sujith
From India, Bangalore
Acknowledge(0)Amend(0)
From India, Bangalore
Acknowledge(0)Amend(0)
i need minimum payment amount for PF & ESI, also need calcualtion sheet if you have for calculating PF & ESI. which of the component of salary or wages we take for calculating PF or ESI. thanks
From India, Delhi
Acknowledge(0)Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)
Hi, Attrition = Total empl. leftX100 devided by Avg. of opening and closing streingth. Kashi
From India, Benaulim
Acknowledge(0)Amend(0)
From India, Benaulim
Acknowledge(0)Amend(0)
Gentlemen,
In my company, the attrition formula is based on the preceding 12-month joiners and leavers. For example, the opening manpower is always in April. Attrition for the month of November 2009 is calculated as follows:
OM in April 09: 50
The number of employees who left in the 12 months from December 08 to November 09, divided by the opening manpower plus the joiners from December 08 to November 09:
18 / (50 + 26) * 100 = 24% (Attrition in Nov 09)
Usuf Ali - Chennai
From India, Madras
Acknowledge(0)Amend(0)
In my company, the attrition formula is based on the preceding 12-month joiners and leavers. For example, the opening manpower is always in April. Attrition for the month of November 2009 is calculated as follows:
OM in April 09: 50
The number of employees who left in the 12 months from December 08 to November 09, divided by the opening manpower plus the joiners from December 08 to November 09:
18 / (50 + 26) * 100 = 24% (Attrition in Nov 09)
Usuf Ali - Chennai
From India, Madras
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
ATTRITION CALCULATION.pdf