bhavaj31
what is attrition formula?what does it help in? please help with these questions thank uuuuuuuuuu
From India, Mumbai
sravani
16

Hi Bhavaj,
I just signed CiteHR and came across your query. I would get back to you about the query in detail, later. Meanwhile, find the enclosed attachment that helps you to calculate attrition rate. Hope it could be useful to you.
Note: This attachment is forwarded to me by one of my friends. I appreciate the contributions / suggestions made by other readers w.r.t. the content in this attachment.
Regards
Sravani

From India, Hyderabad
Attached Files (Download Requires Membership)
File Type: xls attritionrate_revisedformula_1__216.xls (21.0 KB, 3556 views)

raminder_kainth
Hi Bhavaj,
Another formula for attrition head count is
e.x.
Manpower as on 1 March = a
Manpower as on 31 March = b
Average Manpower i.e. (a+b)/2 = X
Attrition head count in the month of March = y
Then attrition pecentage = y/x
Afterthat convert the result in percentage
Regards
RAMINDER

From India, New Delhi
Bob Gately
45

See if the attached Excel workbook helps.
From United States, Chelsea
Attached Files (Download Requires Membership)
File Type: xls to_rate_940.xls (34.0 KB, 1451 views)

ksk
10

Sravani: Thank you so much. Overall I am thankful to all cite members for sharing the information. I am learning lot of things from this website and the members. Thank you so much. Satya Hyderabad
From India, Hyderabad
prachi_singla
18

Hi,

This attrition formaula was given by one of citehr member only.

I copied it and now I am sending to you.

Attrition formula:

ATTRITION RATE

(The formula and correct logic behind calculation of ATTRITION RATE)

((no. Of attritions x 100) / (Actual Employees + New Joined)) /100.

Examples:

1) Actual Employees No. Of people left No. Of Joined Total Employees

(Opening BAL) (Attritions) (Current Headcount)

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.

2) Actual Employees No. Of people left No. Of Joined Total Employees

(Opening BAL) (Attritions) (Current Headcount)

100 50 0 50

This is the special case where we are considering attritions only keeping into mind that nobody has joined in particular month.

So according to the formula: ((50 x 100) / (100)) / 100

Which comes to 0.5 i.e. 50%

Now as you had 100 previously and now 0 joined so it makes 100 + 0 =100

Now if you calculate 50% of 100 i.e. 100 x 0.5 = 50

Which clearly shows that 100 – 50 = 50, which is your current headcount and at the same time you can say my attrition is 50% that shows you lost 50 employees of 100 and 0 joined which makes count to 50.

3) Actual Employees No. Of people left No. Of Joined Total Employees

(Opening BAL) (Attritions) (Current Headcount)

500 200 100 400

So according to the formula: ((200 x 100) / (500 +100)) / 100

Which comes to 0.3333 i.e. 33.33%

Now as you had 500 previously and now 100 joined so it makes 500 + 100 =600

Now if you calculate 33.33% of 600 i.e. 600 x 0.3333 = 200

Which clearly shows that 600 – 200 = 400, which is your current headcount and at the same time you can say my attrition is 33.33% that shows you lost 200 employees of 500 and 100 more joined which makes count to 400.

4) Actual Employees No. Of people left No. Of Joined Total Employees

(Opening BAL) (Attritions) (Current Headcount)

8000 5000 500 3500

So according to the formula: ((5000 x 100) / (8000 +500)) / 100

Which comes to 0.5882 i.e. 58.82%

Now as you had 8000 previously and now 500 joined so it makes 8000 + 500 =8500

Now if you calculate 58.82% of 8500 i.e. 8500 x 0.5882 = 5000

Which clearly shows that 8500 – 5000 = 3500, which is your current headcount and at the same time you can say my attrition is 58.82% that shows you lost 5000 employees of 8000 and 500 more joined which makes count to 3500.

Bye

Take care

Prachi

From India, Mumbai
Pankaj Hirani
6

Hi, Hmm.. wonderful. I also got the same stuffs from google.com Good contribution. U are circulating knowledge. Keep going on....! :D :D :D tc cheers- Pankaj
From United States
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.