Attrition Report - Xls Download

Dear All,
What is the formula for calculating Attrition Report.
Regards,
Sree

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

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

Dear Sree,
Formula of Attrition is as under:
Total manpower During Month/Total manpower at the end of the month*100
Rgds

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

Hi Sree & Friends,
pls find attachment as required by Sree.
Thanks,
LawrenceK
9789063375

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.

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

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