Formula to calculate attrition rate

Posted by - Akarsh Thakur

ATTRITION RATE = ((No. Of Attritions x 100) / (Actual Employees + New Joined)) /100.

Example:

  1. Actual Employees (Opening BAL) - 150
  2. No. Of people left (Attritions) - 20
  3. No. Of Joined - 25

 

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.

Categories

×