Hope this will be helpful.... {(number of attritions*100)/(actual number of employees + new joined employees)}/100
From India, Jammu
From India, Jammu
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
From India, Warangal
its same but got posted twice. both are similarthough. hey can i know how do you calculate efficiency or attendance percentage?
From India, Jammu
From India, Jammu
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 so it makes 150 + 25 =175
Now if you calculate 11.42% of 175 i.e. 175 x 0.1142 = 20
Which 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, Jammu
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 so it makes 150 + 25 =175
Now if you calculate 11.42% of 175 i.e. 175 x 0.1142 = 20
Which 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, Jammu
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
2From India, Bangalore
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
From India, Mumbai
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
From Romania, Cluj-napoca
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
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
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
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
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
What is Annualized Attrition and How to Calculate It.doc
Attrition-rate. xls