How To Calculate Attrition - Xls Download

How to calculate Attrition ? what is its formula?

Hope this will be helpful....
{(number of attritions*100)/(actual number of employees + new joined employees)}/100

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

its same but got posted twice. both are similarthough. hey can i know how do you calculate efficiency or attendance percentage?

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.

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

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

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,

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