Think HR Think CHRM
Friday - 15 Nov 2019

CHRMGlobal.com on LinkedIn
Username : Password: Forgot Password?
Updates
Updates
Attrition Calculation
Human Resources » Attrition and Retention


Chrm Message From: manojpalayode Total Posts: 2 Join Date: 05/08/2010
Rank: Beginner Post Date: 05/08/2010 07:04:51 Points: 10 Location: United Arab Emirates

Dear Friends,

Could anybody of you tell me, in the calculation of Attrition rates, Temporary, Part time employee's termination/ resignations?

I would highly appreciate if anybody could help me to get the answer for this??

Chrm Message From: gkhare Total Posts: 7 Join Date: 05/08/2010  
Rank: Beginner Post Date: 29/10/2010 12:06:43 Points: 35 Location: United Arab Emirates
Dear You can make a format in excel and note down the following coloumns. S. No. Capability : Software Engg Opening Headcount:23 Joined :12 Left :5 Closing Headcount: 7 Attrition % :33.33 Formula (Attrition%=LEFT/Opening Headcount+Closing Headcount/2))*100 Like wise you can calculate for all capabilities and cadre and to organizational wise you can add all in the same fashion. For details and any help you may contact me at gkhare@scsuniversal.com
Chrm Message From: ayona.demitra Total Posts: 3 Join Date: 05/08/2010  
Rank: Beginner Post Date: 03/12/2010 02:43:32 Points: 15 Location: United Arab Emirates

Hi,

We make quarterly attrition reports in our organisation. This is how we proceed:

Number of employees at the beginning of the month: 50

Left: 10

Joined: 5

Present headcount (number of employees at the end of the month): 50-10+5= 45

Attrition rate: (10/45)*100= 22%

 

Hope this helps.

Thanks and Regards,

Ayona

Chrm Message From: kalpzcool Total Posts: 1 Join Date: 05/08/2010  
Rank: Beginner Post Date: 13/01/2011 22:39:44 Points: 5 Location: United Arab Emirates

 

Hi,

Attrition%=(No. of Employees Quit) /(Avg. Employees during that time frame) %100
Inputs for computing Annualized Value is
Monthly – Multiply the Value by 12
Quarterly – Multiply the Value by 4
Half Yearly – Multiply the value by 2
Annual – Do not multiply :-)

Just to elaborate with example with respect to data shared below is:
If in a month there are 65 no. of quit cases and average no. of emp strength till date was 3012 then:
Attirition%YTD=65/3012*100=2.15% hence,monthly attrition %(YTD) for that month will be 2.15%*12=25.8%

Hope this helps.

Regards,

Kalpana

Chrm Message From: crs1973 Total Posts: 1 Join Date: 05/08/2010  
Rank: Beginner Post Date: 24/02/2011 11:21:23 Points: 5 Location: United Arab Emirates

Attrition % = No of employees Left during the period/Balance employees*100

 

Hope this will help

 

Chandrakant Shukla


1 2 Next
 
Events
 
Related Discussion
Attrition in Pharma Indus
How to Control Attrition
Turnover and Attrition
Calculation of Attrition
leave calculation procedu
Controlling & Overcoming
ROI Calculation on Traini
Clarification on Attritio
Methods to lower Attritio
Calculating Cost of Attri
 
Related Articles
The Vital Task of Stoppin
Calculation of Employee T
High Attrition : Entry Le