No Tags Found!

Dear All, What is the formula for calculating Attrition Report. Regards, Sree
From India, Bangalore
Acknowledge(0)
Amend(0)

Formula for Attrition is supported here by giving a suitable example.:
No of Head Counts in a Month start : 100
No of additions in a month : 50
Attrition : 20
Closing Head Counts at the end of the month : 100+50-20=130
Formula for calculation of Attrition is : 20*100/130 =15.38%
Regards
Moina

From India, Mumbai
Acknowledge(0)
Amend(0)

Attrition in an organisation means number of resignations in a particular month or year or it refers to the number of employees who leave an organization.
Formula for attrition :
Number of people leaving the organization during the period X 100
average head count
or
Attrition % = (No. of separations/Total employees) *100

From India, Madras
Acknowledge(0)
Amend(0)

Dear Sree, Formula of Attrition is as under: Total manpower During Month/Total manpower at the end of the month*100 Rgds
From India, Mumbai
Acknowledge(0)
Amend(0)

Let's understand why we need to calculate Attrition %:
Attrition % is a measure of lost productivity due to Attrition i.e employees leaving the org.
therefor Attrition % = Number of Employees Left / (Average Employee HC for that period)
Average Employee HC = (Opening HC + Closing HC)/2

From India, Mumbai
Acknowledge(0)
Amend(0)

Hi Sree & Friends, pls find attachment as required by Sree. Thanks, LawrenceK 9789063375
From India, Madras
Attached Files (Download Requires Membership)
File Type: xls Attrition.xls (15.5 KB, 2057 views)

Acknowledge(0)
Amend(0)

I would still recommend using Avarage HC as the dinominator in the attrition equation as it is a more accurate measure of the average productivity available through the month.
From India, Mumbai
Acknowledge(0)
Amend(0)

Hi Lawrence...m richa..i guess d excel sheet tht u hv attached with ur post does nt have d correct calculations as it does nt consider d the correct closing head count i.e.it does nt consider d new employees who join nd hence d clsogin head count figure goes wrong and thereby the attrition% also comes out to be wrong......

Acknowledge(0)
Amend(0)

CALCULATION OF ATTRITION RATE

The Logical approach for calculating Attrition.



Remarks: Typically this method is more oriented towards HR aspect. Recruiter do not necessarily use this method, though a good indicative, and also this does not provide the attrition numbers specifically from Recruitment view point.



Opening Balance: OB

Resignations: R

New Joinings: NJ



ATTRITION % = [(R) / (OB + NJ)] * 100



Now for example:



Opening Balance: 197

Resignations: 22

New Joinings: 36



ATTRITION % = [(22) / (197 + 36)] * 100 = [22 / 233 ] * 100 = 9.44%



To check the formula, in the above example Opening Balance is 197 & New Joinees are 36. Hence Total onboard strength is 197 + 36 = 233. Now if I say attrition is @ 9.44%, then 9.44% of 233 (that is onboard strength) should give us the Resignee count, which is 233 * 9.44% = 22. In our example also we took 22 Resignations. Hence proved that the formula is accurate.



Remarks: Internationally also this is a fairly acceptable formula, yet in my view this fails to account for negative attrition.

Rameswar Prasad

HR

From India, Pune
Acknowledge(0)
Amend(0)

Engage with peers to discuss and resolve work and business challenges collaboratively. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Register and Log In.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.