Yahoo! Finance: "Redefining personal finance for India's middle class" --> FREE Limited time offer: Sign Up Now
HR Zone » Recruitment and Staffing » Attrition Calculation

449 Views
  0 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.

 
0
Vote Vote

Recently in HR Forums

15 days ago
Arun posted a new forum topic HUMUOR #@#@@#@#@#@ in Humor
23 days ago
Arun posted a new forum topic MASK @#@##@#@ in Humor
23 days ago
Arun posted a new forum topic Just @@@@ for ##### FUN $$$%%@@@ in Humor
23 days ago
Arun shared forum topic ONE - LINERS ::):):):):):):) with Gina, Sheetal and 1100 other contacts
27 days ago
 
Recent (10) | HR | Both
HR | Both   1 of 10
27 days ago
Arun
Arun
Read this topic:
Joke ####@@@####
27 days ago
28 days ago
03-04-2017
27-03-2017
27-03-2017
26-02-2017
12-09-2016
07-09-2016
02-09-2016