Hi, Can anybody help on Attrition Rate? Please explain the attached Excel
From India, Delhi
Acknowledge(0)
Amend(0)
1From India, Delhi
Acknowledge(0)Amend(0)
Suppose on the 1st of any month, the number of employees is 250. Employees joined during the month are 20, and employees who left during the month are 5. The total number of employees excluding those who left is 250 + 20 = 270. The attrition rate is calculated as 5 / 270 x 100 = 1.85%. In my opinion, the calculation shown in the Excel sheet is wrong.
From United States, Chicago
Acknowledge(1)
Amend(0)
From United States, Chicago
Acknowledge(1)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
SAMPLE Employee Attrition Calculation sheet for FY 09-10 .xls
Calculation of Attrition Rate.doc