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

849 Views
  1 Replies

0
Vote Vote
Attrition Calculation
Sunil
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.



If,

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
Moumita Picture
1 Posts
back to top
  Rated 0 | 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 https://public.tableau.com/profile/moumitadeshmukh#!/vizhome/attritiondataanalysis/EmployeeAttritionAnalysis">Employee Attrition Report.

0
Vote Vote

Recently in HR Forums

Nijanth gave to Kartheka's reply to forum topic Standard Salary Structure
1 day ago
Nijanth gave to Kedar's reply to forum topic Standard Salary Structure
1 day ago
Jun gave to Koti's reply to forum topic Standard Salary Structure
5 days ago
Kartheka gave to the forum topic Blame game on HR
19 days ago
Avinash gave to the forum topic Blame game on HR
13-08-2017
 
Recent (10) | HR | Both
HR | Both   1 of 10