Warning: preg_replace(): Empty regular expression in [path]/showthread.php on line 2381

Warning: preg_replace(): Empty regular expression in [path]/showthread.php on line 2381

Warning: preg_replace(): Empty regular expression in [path]/showthread.php on line 2381
Attrition Rate Calculation - Doubt!! - XLS Download - CiteHR

No Tags Found!

SH

Shai89308

Executive Hr

AS

Ammu Shanvi

Human Resource

GS

G SHASHI KRISHNA

Senior Manager - Hr

AH

Aizant HR

Human Resources

MA

MARSHAL

Safety Officer

AK

Anish Katoch

Hr Executive

PR

PranjalR

Hr Recruiter

AP

Alka Pal

Hr Executive

Karthikeyan8195

Management Consultant

MK

Mohit Kumar Puri

Head Marketing

AU

Austex

Accounts Manager


chandan2ykpankaj
11

Hi,

Will you please let me know the exact formula of attrition rate calculation. I am confused because I have found more than 5 formulas from different sources.

Please help me out I shall be highly thankful. An early reply is highly appreciated.

Regards

Pankaj Chandan

From India, New delhi
vikrampaneri
24

Hi ,Pankaj plz find yearly & monthly Attrition Rate Calculation
From India, Udaipur
Attached Files (Download Requires Membership)
File Type: xls ATTRITION 1.xls (21.0 KB, 1756 views)

vikrampaneri
24

what u really want i not getting for yearly attrition rate totel employy on apr 08 new joining till mar 09 & net left till mar 09 then it calculate automaticaly
From India, Udaipur
chandan2ykpankaj
11

suppose employee opening balance is = 200 new joinings = 20 left employees = 40 closing balance = 180 now how we calculate attrition rate per month??????
From India, New delhi
lijesh.lakshman
{No. of seperation for month / (Opening Head Count of the Month + Closing Head Count of the Month) / 2} *12*100
From United Arab Emirates, Dubai
vikrampaneri
24

pankej ur ans. is in .xls(monthly)
From India, Udaipur
Attached Files (Download Requires Membership)
File Type: xls ATTRITION 1.xls (21.5 KB, 506 views)

apanicker
Dear Pankaj,

Hope this formula gives you a clear idea.
(The formula and correct logic behind calculation of ATTRITION RATE) :

((No. Of Attritions x 100) / (Actual Employees + New Joined)) /100.

Example:

1) Actual Employees /No. Of people left / No. Of people Joined/ Total Employees
150 20 25 155
So according to the formula: ((20 x 100) / (150 + 25)) / 100
Which comes to 0.1142 i.e. 11%
Now as you had 150 previously and now 25 joined so it makes 150 + 25 =175
Now if you calculate 11.42% of 175 i.e. 175 x 0.1142 = 20
Which clearly shows that 175 - 20 = 155, which is your current headcount and at the same time you can say my attrition is 11.42% that shows you lost 20 employees of 150 and 25 more joined which makes count to 175.


chandan2ykpankaj
11

Thank you very much to Vicky and Lakshman and hearty thanks to Apanicker for clearing all doubts very nicely.

Once again thank you very much for your prompt replies.

God Bless you.

Regards

Pankaj Chandan :p

From India, New delhi
dasp06
25

Dear Pankaj,
While calculating attrition, the first thing that strikes our mind is "kitney gaye?" However, more often than not, it is a common mistake to take all separations into account to arrive at a rate of attrition. Please take care not to include following cases while determining "kitney gaye" for the purpose of attrition:
1. Those who are asked to leave
2. Those who have retired
3. Those who have died
Merely calculating the attrition rate is a job half done. Find out the trend in other companies in the same industry and then compare your own to see whether you need to 'relax' or 'panic' at the rate of attrition that you have in your company.
Good luck.
Prashant

From India, Delhi
cb_somashekhar
4

Hi All, This Attrition formula is wrong, don’t mistake me, it is honest feedback. regards Som
From India, Bangalore
Find answers from people who have previously dealt with business and work issues similar to yours - Please Register and Log In to CiteHR and post your query.





About Us Advertise Contact Us Testimonials
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.