sreearyan
Dear All, What is the formula for calculating Attrition Report. Regards, Sree
From India, Bangalore
moina.memon
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
pat123
1

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
bhagwan_07
51

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
Prasanna_J
9

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
LawrenceK
13

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)

Prasanna_J
9

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
Richa Srivastava
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......

rameswar.prasad
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
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.