Dear All,

Find the below mentioned formula and correct logic behind calculation of "ATTRITION RATE"



Actual Employees(Opening BAL) - 8000

No. Of people left(Attritions) - 5000

No. Of Joined - 500

Total Employees(Current Headcount) - 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 attrition is 58.82% that shows you lost 5000 employees of 8000 and 500 more joined which makes count to 3500



Any changes do let me know. Thanks and have a great day :)



Regards

Pradeep