New to HR? Here's How You Can Easily Calculate the Attrition Rate

Hi, I'm a new member of Cite HR. I found it very beneficial for all fresher. I want to know how to calculate the attrition rate.

Hi friend,

Retaining employees is a very important function of HR. In the present day, outside job opportunities are more abundant, making it very difficult to retain employees.

Attrition Rate = Number of employees who left the organization / Total number of employees in the organization * 100

Regards,
Satya

Dear Sandeep,

To calculate the attrition rate, the formula is:
Attrition rate = No. of resigned / Available Manpower * 100.

For example, suppose at the start of the month of May, you had a manpower of 10, and during the same month, the number of resignations was only 1. The available manpower after the end of the month of May would be 9. Therefore:
Attrition rate = 1 / 9 * 100.

If there are any new joinings, they will be added to the current manpower, and at the end of the month, the available manpower will be adjusted accordingly.

Regards,
Amit Seth

Dear Sandeep,

Please find the attached attrition template for your perusal. This has been posted by one of the members of this site.

Regards,
Pradeep Kumar V

Hi Pradeep,

Thanks for sending the format. I am working in Real Estate, which has nearly 600 executives. Therefore, the attrition rate is high. I am new to this field.

Regards,
Sandeep G.

I am an MBA student working on employee retention and I am in dire need of data on Thomas profiling and attrition. Please help.

Hi!

I too am using the formula (# of Employees Left / Total # of Employees) * 100. If you are aware of or have been using any other simpler option for calculating the attrition rate, please share it with me. You can reach me at [Login to view].

Swati.

Hi dear all,

What should be the standard attrition rate for a company that will not affect the organization's operations?

Balkrishna

Normally, the calculation here is a ratio: the number of employees who quit divided by the average number of employees in a given period of time, multiplied by 100. This formula may be used for monthly, yearly, or quarterly calculations. It is advisable to calculate monthly so that a line graph could be created for a year or so.

Dr. Chandra Sekhar SF

Hi Fay,

Please find attached the calculations in Excel for the same.

Best regards

Fay

Hi Friends,

Can anyone forward me the Attrition Calculator with different methods of calculating, like Rolling Attrition, etc.?

Wishes,
Chandu

Dear Sonia,

That's a very good question you have asked. People generally say, "attrition rate is very high in that organization," but few people know how to calculate the attrition rate of an organization. I am also one of them. I have two years of experience in the HR field, but still, I don't know how to calculate attrition rate.

I request you to share with me if you get any information about the captioned subject.

Regards,

Rajesh Officer - HR Tata Projects Ltd. 011 - 6616 9033

Dear Sonia,

Welcome to CiteHR! I'm pleased to hear that you find it beneficial, especially for all the freshers. Your question about calculating the attrition rate is quite insightful. While many mention that the attrition rate is high in certain organizations, the actual calculation method is not widely known. I, too, am in the same boat. Despite having two years of experience in the HR field, I am still unsure about how to calculate the attrition rate.

If you come across any information on this topic, I would greatly appreciate it if you could share it with me.

Best regards,

Rajesh
Officer - HR
Tata Projects Ltd.
011-6616 9033

The calculation of attrition rate is fairly simple. Identify the base date and the employee count on that day - X. Determine the new joinings in the organization after the base date - J. Determine the resignations in the organization after the base date - R. (If you want to identify reasons related to attrition, use the Date of resignation of the employee. However, for accurate attrition data for calculation for productivity, the usage of 'Last Working Day' is preferred. If you are not sure of the reason, use 'Last working day' as criteria.)

Now, what you have is the current employee count in the organization - Y. So, Attrition rate = R / ((X+Y)/2). (X+Y)/2 averages out the employee count in the organization during the period. To annualize the attrition, Annual Attrition = (12/Duration (in months)) * (R / (X+Y)/2). Hope this solves the attrition problem. You can build your own calculator in Excel using the above formula.

Regards, Anup.

Hi all,

Attached is the Excel sheet to calculate attrition rate.

Regards,
Jmoktali

There is no thumb rule to calculate the attrition rate, but logically it should be calculated like this:

No. of employees as on the date = x
No. of employees left in one year = n
Annualized % of attrition = n * 100 / (x + n)

However, if you only have data for less than 12 months, say 8 months, then it should be calculated like this:

No. of employees as on the date = x
No. of employees left in 8 months = n
Annualized % of attrition = n * 12 * 100 / 8 * (n + x)

Kindly forward me the same. How to calculate attrition rate monthly as well as yearly.

Thanks :)

Hi Sonia,

The formula to calculate attrition is:

Number of Employees Left During the Month / Total Number of Employees * 100

Katyana

Dear All,

Following is the formula of attrition with an example and proven logic.

[ ((text{no. Of attritions} times 100) / (text{Actual Employees} + text{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, it makes 150 + 25 = 175. Now if you calculate 11.42% of 175, i.e., 175 x 0.1142 = 20.

This clearly shows that 175 - 20 = 155, which is your current headcount, and at the same time, you can say your attrition is 11.42%. This shows you lost 20 employees of 150, and 25 more joined, making the count 175.

2) Actual Employees No. Of people left No. Of Joined Total Employees (Opening BAL) (Attritions) (Current Headcount) 100 50 0 50

This is a special case where we are considering attritions only, keeping in mind that nobody has joined in a 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, it makes 100 + 0 = 100. Now if you calculate 50% of 100, i.e., 100 x 0.5 = 50. This clearly shows that 100 - 50 = 50, which is your current headcount, and at the same time, you can say your attrition is 50%. This shows you lost 50 employees of 100, and 0 joined, making the count 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, it makes 500 + 100 = 600. Now if you calculate 33.33% of 600, i.e., 600 x 0.3333 = 200. This clearly shows that 600 - 200 = 400, which is your current headcount, and at the same time, you can say your attrition is 33.33%. This shows you lost 200 employees of 500, and 100 more joined, making the count 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, it makes 8000 + 500 = 8500. Now if you calculate 58.82% of 8500, i.e., 8500 x 0.5882 = 5000. This clearly shows that 8500 - 5000 = 3500, which is your current headcount, and at the same time, you can say your attrition is 58.82%. This shows you lost 5000 employees of 8000, and 500 more joined, making the count 3500.

Regards, Sharad

Hi,

We are using this formula to calculate attrition:

Attrition = number of employees left in the month * 100 / total number of employees in the month.

Is this the correct formula? If you are using a different formula, please email me at: [meenakshi12581@yahoo.com](mailto:meenakshi12581@yahoo.com).

I have calculated the attrition rate by using the formula below:

[ text{Attrition Rate} = left( frac{text{Total no. of employees who left}}{text{Total employees on the 1st day of the month}} right) times 100 ]

However, this doesn't seem to be working out. Can anybody please help me?

Regards,
Anuja

Hi,

This is for information to all.

- Attrition: Number of employees who left in the year / average employees in the year x 100. Thus, if the company had 1,000 employees in April 2004, 2,000 in March 2005, and 300 quit in the year, then the average employee strength is 1,500 and attrition is 100 x (300/1500) = 20 percent. A graded system can probably depict the true picture.

- Fresher attrition: the number of freshers who left within one year. It tells you how many are using the company as a springboard.

- Infant mortality: percentage of people who left within one year. This indicates the ease with which people adapt to the company.

- Critical resource attrition: key men exit.

- Low performance attrition: those who left due to poor performance.

MINESH PANDYA

Number of people left divided by the number of people recruited plus the actual number of people in the organization multiplied by the number of months. If you want to calculate for 12 months for a year, the formula is multiplied by 12.

Ra Sinha

Hi,

The attrition rate for the year is calculated using the following formula:
No. of attrites in a year / Average Headcount
Avg Headcount = (Headcount at the starting of the year + Headcount at the end of the year) / 2

I have corrected the spelling and grammar errors in the text and formatted the paragraphs accordingly. If you have any further questions or need additional assistance, feel free to ask.

Dear,

Please find the attrition calculator.

Aashit Srivastava

Dear Aashitsrivastava,

There is something I don't quite understand about this template.

Attrition Rate = Employees Termed / Average HC for the time period.

The template gives a very deflated value of attrition. Let's consider an example:

Opening HC = 100

New Joinees = 10

Resignations = 2

Attrition Rate = 2 / ((100 + 108) / 2) = 1.9%

Rationale for the same: On average, the number of employees I had during a month is approximately the average of my opening and closing headcounts, and not their sum.

The template returns a value of 0.91% (not accurate).

I have attached a modified template.

There is something odd about the data in my template. It may look odd, but it is accurate.

If you want to calculate the Attrition Rate for a particular month, you can calculate it as follows:

(Total number of resignations) / (total number of employees at the beginning of the month + total number of new joiners - total number of resignations in that month) * 100

Please ensure to use the correct formula for accurate calculation. Thank you.

Hi Friends,

Thank you for providing such valuable information. I would be highly grateful if anyone could provide me with data on the attrition rate in a manufacturing company. I am working on a project in a manufacturing company, and it would be of great help if I could access this data.

This is my email id: bansari97@yahoo.com

Regards,
Bansari

This is the formula to calculate the attrition rate. First, decide for which period you want to calculate the said rate. Then:

1. Take the opening manpower available for that period.
2. Take the closing manpower available for that period.
3. Add these two numbers.
4. Divide that by 2.
5. Take the total resignations during that period and divide this total by the number obtained in step 4.
6. Multiply the answer by 100, and this is your attrition rate.

Hi,

Can I also please get the attrition calculator?

ID: [IMG]https://www.citehr.com/misc.php?do=email_dev&email=cHVuYW1fZ2VtQH lhaG9vLmNvLmlu[/IMG]

Thanks

a) Opening Manpower
b) Resignations
c) Month you are currently in.

Annualized attrition = (b / a) * (12 / c)

Amit Bhatia

[IMG]https://www.citehr.com/misc.php?do=email_dev&email=YWJoYXRpYUBhcm liYS5jb20=[/IMG]

Hi, I am Swayam, conducting attrition analysis for our field staff every month. As per the existing system:

Attrition Rate = (Exit employees / Total employees) * 100

Please let me know if you have any other methods.

Swayam

Here is goes:
ATTRITION RATE
(No: Of attritions x 100) / (Actual Employees + New Joined)) /100.
Examples:
1) Actual Employees= (Opening BAL) =150
2) No. Of people left= (Attritions) =20
3) No. Of Joined= (Current Headcount) =25
4) Total Employees=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.

Hi,

The attrition rate is calculated based on the number of resigned employees and the total manpower available as of the 1st of the month. The formula to calculate the attrition rate is: Attrition rate = (resigned employees / total manpower) * 100.

Regards,

Amit Seth.

Dear Soni,

Please forward that "CALCULATE ATTRITION RATE" email to me as well.

[IMG]https://www.citehr.com/misc.php?do=email_dev&email=ZGl2eWFockB5bW FpbC5jb20=[/IMG]

Dear Friends,

I received this "Attrition sheet" from this site only. I am reposting it here for your reference.

If it serves your purpose, please acknowledge.

Regards,
Manoj

Guys,

It's very simple... you must have done the same during your MBA.

Its

TOTAL NO OF EMPLOYEES LEFT (YTD)

DIVIDED BY

TOTAL NO. OF EMPLOYEES

MULTIPLIED BY 100

WOULD GIVE YOU THE PERCENTAGE OF ATTRITION

Hi,

Could you please send me the details of the Attrition Cal register? I'm a new member and just saw the post regarding the same.

Dear,

As per your query, the Attrition Rate is calculated as follows:
Attrition Rate = Number of Resigned employees of the month / Total Manpower * 100.

If you have any queries, feel free to ask...

Hey Monika,

Please do not ask such generic questions. I'm not trying to be rude here. But you know every company has its own salary structure/breakups according to their policies, bands, levels, structure, etc. factors. So please ask specific queries in the future.

Thanks.
Nayonika :)

Hi friends,

Can I know if there are any rough attrition rates surveyed for different sectors in Indian industries? :icon5:

Hey,

Calculating attrition rate is very simple. There is no need to be so panicky. Kindly find the sheet attached. Hope this will help you. Simply put, it is the number of people left divided by the total number of people hired, multiplied by 100 for a given time period.

Thanks,
Vineet Saini

I am amazed... all people here can't read. I've pasted the Excel file above. Still, all of you are asking to email. Can't really understand.

Hi,

Can you give me a gist of Att. Rate calculation?

Regards,
Ajay Choudhary
Tec. Consultants

Normally, the thumb rule is:

Attr = (Loss in HC) / (Av HC), where HC is headcount, Av HC is (opening HC + closing HC) / 2.

The period is generally a month.

Closing Balance = Opening Balance + New Joining Employees + Left Employees

Attrition Rate = ((Left Employees * 100) / (Opening Balance + New Joining + Left Employees + Closing Balance)) / 100

In the provided text, I have corrected the spelling and formatting errors. I have also adjusted the paragraph formatting to ensure clarity and readability.

Many of our friends on citehr have given various formulas for attrition rate calculation. They all provide different percentages. Does anyone know the most widely used formula? The efforts that all have made are remarkable. Thanks.

[QUOTE=shuchita limaye;901483]

Many of our friends on citehr have given various formulas for attrition rate calculation. They all provide different percentages. Does anyone know the most widely used formula? The efforts that all have made are remarkable. Thanks.

People are not lazy. They simply have impotent goals - that is, goals that do not inspire them.

Many of our friends on citehr have given various formulas for attrition rate calculation. They all give different percentages. Does anyone know the most widely used formula? The efforts that all have made are remarkable. Thanks.

"People are not lazy. They simply have impotent goals - that is, goals that do not inspire them!"

Hi,

Formula: Attrition for the month/Total Headcount * 100 or it can be calculated as the number of headcount of the month: No of New Joinee/additions in the month: Attrition: Therefore, the formula is: No of New Joinee/additions in the month + No of New Joinee/additions in the month - Attrition =

Regards,
Smrins

I see that every organization uses or devises its own formula to calculate the attrition rate, hence making it impractical to use a standardized formula.

I am attaching the calculation of the attrition rate. I hope this will help you.

Thanks,
Anisha Mittal

Attrition Calculator Contribution

Please find the attached attrition calculator. Let me know if this is helpful for you. It was contributed to the forum by one of our friends a long time ago. Let us appreciate and thank him for his efforts.

Regards,
Vamsi