Formula For Attrition Analysis - Xls Download - CiteHR
Rajendra Bhavsar
Manager (personnel & Administration)
Muddassir_habib
Training & Development
Jkct15
Deputy Manager - Hr
Access.ashis
Hr Generalist
Suhanidutta
Executive - Hr
Legal@hidesign.com
Legal And Payroll Manager
+4 Others

Prime Sponsor - FactoHR.com - Payroll Software with GPS Enabled Attendance, Travel, Performance Management, HRMS. Explore Features
Dear All, Can anyone please guide me on how to calculate attrition rate. What is the standard formula used for attrition analysis.
Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
hi Standard formula is no of left employees/total strength*100 will give you the attrtion percentage.
Hi Attached pl. find herewith format for calculating attrition rate. Regards Rajendra Bhavsar Manager (P&A) Afcons Infrastructure Ltd. CMRL Project, Chennai 8754543347

Attached Files
Membership is required for download. Create An Account First
File Type: xls ATTRITION___REPORT.xls (31.0 KB, 6002 views)

Hi, As per my knowledge the attrition formula shall be : No. of employees left/Average no. of employees*100 Regards
Hello All,
for attrition rate,formula is No. of left employees/average of (total employees at the starting of month & total no. of employee at the ending of month)* 100 and for employee turnover it is left employee/total employee in end of month*100 (in case if we calculate it on month basis)
Thanks
hi suhani, you can find number of formats and their clarifications from this booklet. its assured you will get fantastic knowledge out of this.
Dear Suhani,
The attrition formula is A/(B+C-A)*100
A = Nof of employees left in the Month
B = No.of employees on 01st DAY of the month
C= Newly joined during the month
Nof of employees left in the Month/ (No.of employees on 01st of the month + addition during the month - left employees)*100
If it is for year, Nof of employees left during the year/ (No.of employees on 01st January+ addition during the year upto 31st December - left employees during the year)*100
Dear Members,
Can you please guide me whether we should take the employees present for the month or should we take the actual number of positions for calculating the attrition every month.
For example if a department has 10 positions, then should the opening balance be 10 for every month or should the closing balance of the previous month be the opening balance of the next month.
Regards
K Lakshme devi
Suhanidutta, You can use attached document to calculate attrition for the desired period. Formula = Relieved members / Average( Opening headcount & Closing headcount) Thanks

Attached Files
Membership is required for download. Create An Account First
File Type: xls Attrition-Analysis.xls (19.0 KB, 2681 views)

Hii,
You can do it 2 ways.In my view attrition is 2 types,monthly attrition & annual attirtion.However,you will be always more interested for annual attrition.For that you may annualize each months actual attrition to reach at the avg. attrition at the end of the year.This will give you the correct picture & through out the year,you can have an eye on the end figure of Annual attrition.Its just like run rate per over In Cricket so that at end of 50 ovrs how much will be your total score.
One formula we may use is =
(Total employees resigned/avg. head count)*(12/no. of months you have completed in that financial year)*100
To explain,suppose after end of 4 months,total resignation no. is 200.Total head count in these 4 months being,3000,3050,3075,3065.
So the annualized attrition will be (200/3047)*(1/42)*100=19%.
That means your attrition after 4 months is & after 12 months will be 19 %..Next month,you can check considering 5 months & find if it has increased or decreased.
Prime Sponsor - Talentedge.com "Interactive Anywhere Learning". Executive courses from top reputed institutes like IIM, XLRI, MICA. View Courses

This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2019 Cite.Co™