Want FREE Templates on Organization, Change, & Culture? Download our FREE compilation of 50+ slides. This is an exclusive promotion being run on LinkedIn.

  Please register (it's free!) or login to view the remaining preview.
If you are logged in, your referral link [?] is automatically included below.
EMBED CODE (Copy and Paste)


Attrition has been quite an issue for practically all the employers and attrition calculation a headache for HR professionals. There are N number of ways to calculate attrition rate, many of them quite illogical, still widely used.

This Skilkit explains all the important components and aspects of the issue, so as to arrive at the most appropriate way to calculate attrition.

To quote a few lines:
First of all, let us talk of the Time Interval you should be using to calculate attrition. Consider an example. If the employee strength at the beginning of a period is 10 and 2 of them leave, the attrition is clearly 20%. However, analyzing it further, you will notice that when the first person leaves, it is 1 out of 10 (and hence 10%); but at the time of second departure, it is 1 out of 9 (therefore 11.11%). So, it all depends on what time intervals you are using for the calculation. While, a year is too long a period, it can not be on daily basis either. For all practical purpose, a month is quite a reasonable time period.

This is just one of the aspects to be considered. There are at least three more. You can read about all of them and also calculate attrition rate in your company / department (upto 5 categories and overall) using 'ready to use' Skillscape templates available in this Skilkit

Got a question about the product? Email us at [email protected] or ask the author directly by using the form to the right. If you cannot view the preview above this document description, go here to view the large preview instead.

Source: Skilkit for Attrition Calculation Excel document


Skilkit for Attrition Calculation

Sold by akgrover (view author profile)


Add to Cart

This business document is categorized under the function(s):

It applies to All Industries

File Type: Excel (xls)

File Size: 339 KB

Purchase includes lifetime product updates. After your purchase, you will receive an email to download this document.

Initial upload date (first version): Oct 12, 2013

Ask the Author a Question

Must be logged in Click here to log in



Since 2012, we have provided best practices to over 5,000 businesses and organizations of all sizes across the world—in over 130 countries. Below is just a very small sample of our customer base.

Did you know?
The average daily rate of a McKinsey consultant is $6,625 (not including expenses). The average price of a Flevy document is $65.


102-slide PowerPoint deck and supporting Excel workbook
35-slide PowerPoint deck
407-slide PowerPoint deck
Author: LearnPPT
105-slide PowerPoint deck and supporting PDF
26-slide PowerPoint deck
51-slide PowerPoint deck
79-page PDF document
2-slide PowerPoint deck
70-slide PowerPoint deck and supporting ZIP
141-slide PowerPoint deck and supporting Word
20-slide PowerPoint deck
Author: LearnPPT
131-slide PowerPoint deck



Become your organization's resident expert on...

Digital Transformation
Strategy Development
Organizational Design (OD)
Performance Management
Post-merger Integration (PMI)
Business Transformation
Organizational Culture (OC)
Change Management
Interested in something else? Browse our 350+ Business Toolkits of best practices, each focused on a specific management topic.