How Do I Calculate Attrition Rate? Need Help with Formula and Steps

Could anyone help me find out the attrition rate? Please post the formula and procedure; it would be helpful to me.

Thanks & Regards,
Selva

Please find the formula to calculate the attrition rate.

Attrition Rate Formula

Attrition% = (No. of Employees Quit / Avg. Employees during that time frame) * 100

I hope this clears your query.

Thanks & Regards,
Vani

Dear friends, can anyone help me to find out the attrition rate? Please post the formula and procedure; it will be helpful to me.

Thanks & Regards,
Selva

To find out the attrition rate formula:
\[ \text{Attrition Rate} = \frac{\text{Total number who have left}}{(\text{Opening balance} + \text{Closing balance})/2} \times 100 \]

To find out the closing balance:
\[ \text{Closing balance} = \text{Opening balance} + \text{Who have joined} - \text{Who have left} \]

Regards,
Baljeet Kaur

Dear friends, can anyone help me to find out the attrition rate? Please post the formula and procedure; it will be helpful to me.

Thanks & Regards,
Selva

To find out the attrition rate formula:

Attrition Rate: Total number who have left / ((Opening balance + Closing balance) / 2) * 100

To find out the closing balance:
(Opening balance + who have joined - who have left)

Regards,
Baljeet Kaur

Annualized Attrition Calculation

Attrition is also calculated on an annualized basis. The formula for this is:

Annualized Attrition = (Total number of attrition in 'x' months / Average number of employees for 'x' months) * (12/'x' months)

For example, until July 31, 2010, you had a total of 60 employees who have attrited, and your average manpower for this period was 1212 employees (financial year considered i.e., April to March period), then your calculation shall be:

(60/1212) * (12/4)

Well, with this calculation, the attrition rate is calculated on a yearly basis only. If you want to find out the attrition rate on a monthly basis, you have to multiply it by 12. This means:

Attrition Rate Calculation

Attrition Rate = Number of Employees Left / Total Number of Employees for the same period * 100 * 12

Similarly, for a 6-month period:

Attrition Rate = Number of Employees Left / Total Number of Employees for the same period * 100 * 6

I hope this explanation helps you understand the calculation better.

Regards,
Ankit

Nice discussion. Can you provide me with the rate of attrition for the following example? Sixteen employees have left within four years in a department that has a total strength of 14 employees. For 1.5 years, the department was maintained by 12 officers.

Regards

As per your query, I think the attrition rate is 30.18. Please confirm if this is correct. If not, please clarify for me.

Regards,
Madhu.

Attrition Rate: Attrition Calculation - Formula

Ex:
- Month: Left Emp. Manpower
- APR: 10 1600
- MAY: 5 1525
- JUN: 5 1450
- JULY: 10 1550
- AUG: 10 1500

Total: 40 7625
Avg. Manpower: 1525

Attrition Rate: 0.06

In the calculation above, the attrition rate is determined by dividing the number of employees who left in a given period by the number of months, then multiplying by 12 months, and finally dividing by the average manpower, all multiplied by 100%.

Corrected and formatted the content for better readability.

Attrition Calculation - Formula

Ex:
Month | Left Emp. | Manpower
APR | 10 | 1600
MAY | 5 | 1525
JUN | 5 | 1450
JULY | 10 | 1550
AUG | 10 | 1500
Total | 40 | 7625
Avg. Manpower | 1525

Attrition rate: 0.06

Therefore: \( \frac{40}{5} \times \frac{12}{1525} \times 100\% \)

Your example is a little confusing. Could you please elaborate on it further? You have not mentioned the new joinings in your company; otherwise, I could have found out the answer.