The Economic Times: "Arthos helps its customers set realistic retirement goals" --> FREE Limited time offer: Sign Up Now
HR Zone » Recruitment and Staffing » Attrition Calculation

  1 Replies

Vote Vote
Attrition Calculation
Sunil Picture
1 Posts
back to top
Posted 12-04-2017Reply

Dear HR Folks,

Can anybody explain me the attrition rate calculations?

We are following the below formula.


F6 = Left Employees in a month

D6 = Opening Balance (Head count in the start of month)

E6 = New Joinees

G6 = Closing Balance (Head count at the end of month)

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.

My question is why in the first month the calculation is different?

Why we have to add closing balance and resignees in the 1st Month.

Moumita Picture
1 Posts
back to top
  Rated +1 | Posted 07-07-2017

You can calculate Attrition Rate = Number of Employees Left/Average Number of Employees *100.

Take an instance where in total employee strength is 150 as of April 1, 2015. In the same month, 20 employees left the organisation. Also, 25 new employees were hired.

Firstly we need to calculate the average employee strength. Opening balance was 150. If 20 people left and 25 people were hired, then the closing balance was 155.

Average Employee Strength for that month = {(150+155)/2=152.5}.

Finally, we will calculate attrition rate:-{ (20/152.5)*100=.1311*100=13.11}

So, we get the attrition rate for the month of April, 2015 was 13.11 percent.

You can also visit following link to see how to generate!/vizhome/attritiondataanalysis/EmployeeAttritionAnalysis">Employee Attrition Report.

Vote Vote

Recently in HR Forums

Rahul gave to the forum topic Movement at the top level.
21 hours ago
21 hours ago
Recent (10) | HR | Both
HR | Both   1 of 10