Appendix A: Formulae for Various Rates Discussed



Appendix A: Formulae for Various Rates DiscussedTraditional Turnover Rate (over 12 months)= # separationsavg headcount × 100= sum of separations during the past 12 monthsavg of headcount snapshots from end of each of the past 12 months × 100This rate is the most commonly used and comparable to current benchmarks.Enhanced Traditional Turnover Rate (over 365 days)= # separationsavg headcount × 100= sum of separations during the past 365 daysavg of headcount snapshots from end of each of the past 365 days × 100This rate has the benefit of being comparable to traditional turnover rates, while being slightly more accurate.Realized Turnover Rate (over 365 days)= # separations# opportunities to separate × 100= sum of separations during the past 365 days# days each employee could have separated in the past 365 days summed across all employees × 100= Enhanced Traditional Turnover Rate365This rate has the benefit of being the most accurate and easy to interpret correctly. It should also be noted that when separation and headcount numbers are large enough to yield interpretable ratios, this same rate can also be used at the month level, week level, or even day level to more closely monitor turnover. This rate also scales accurately across other levels of analysis (e.g., individual, group, organization). Notably, a similar approach can also be used to compute promotion rates, counterproductive behavior rates, and other metrics that involve a discrete set of opportunities and a subset of occurrences over a time period:= # separations in past month# opportunities to separate in past month × 100= sum of separations during the past month# days each employee could have separated in the past month summed across all employees × 100Appendix B: Turnover Rate Comparisons With Example DataData below were generated for illustrative purposes but are based on real trends and scenarios observed by the author in dozens of organizations across economic sectors and geographic regions.Example 1: After a reorganization and site closure in January 2018, a large portion of the employees at the consolidated site left the organization. The CEO’s dashboard shows the traditional turnover rate for the site at 900%. She wants to know how that is possible because the roles were not even back filled.Explanation The CEO may be thinking that the roles have each turned over nine times but that is not the correct interpretation of a traditional turnover rate. The traditional turnover rate and even the enhanced turnover rate are misleading in this case because the number of terminations is so much larger than the number of employees in the organization before and after the restructuring. The realized turnover rate most clearly depicts the situation: Of the 6,080 opportunities employees had to leave the organization in the past year, 90 (1.48%) were realized. Note: One could argue that the traditional 1-month turnover rate (93%) is sufficient here. However, a key advantage to the realized turnover rate is that it does not require the timeframe to be adjusted to make the metric look sensible; the metric and interpretation are consistently relevant.Rates:Traditional turnover rate (rolling 12 months)Enhanced traditional turnover (rolling 365 days)Realized turnover rate (rolling 12 months)As of Feb 1, 2018900.00%517.32%1.42%Data:DateHeadcountSeparationsDaily turnover rateEnhanced monthly turnover rate 1-Jan-171000%2-Jan-171000%3-Jan-171000%4-Jan-171000%5-Jan-171000%6-Jan-171000%7-Jan-171000%8-Jan-171000%9-Jan-171000%10-Jan-171000%11-Jan-171000%12-Jan-171000%13-Jan-171000%14-Jan-171000%15-Jan-171000%16-Jan-171000%17-Jan-171000%18-Jan-171000%19-Jan-171000%20-Jan-171000%21-Jan-171000%22-Jan-171000%23-Jan-171000%24-Jan-171000%25-Jan-171000%26-Jan-171000%27-Jan-171000%28-Jan-171000%29-Jan-171000%30-Jan-171000%31-Jan-171000%0.00%1-Feb-171000%2-Feb-171000%3-Feb-171000%4-Feb-171000%5-Feb-171000%6-Feb-171000%7-Feb-171000%8-Feb-171000%9-Feb-171000%10-Feb-171000%11-Feb-171000%12-Feb-171000%13-Feb-171000%14-Feb-171000%15-Feb-171000%16-Feb-171000%17-Feb-171000%18-Feb-171000%19-Feb-171000%20-Feb-171000%21-Feb-171000%22-Feb-171000%23-Feb-171000%24-Feb-171000%25-Feb-171000%26-Feb-171000%27-Feb-171000%28-Feb-171000%0.00%1-Mar-171000%2-Mar-171000%3-Mar-171000%4-Mar-171000%5-Mar-171000%6-Mar-171000%7-Mar-171000%8-Mar-171000%9-Mar-171000%10-Mar-171000%11-Mar-171000%12-Mar-171000%13-Mar-171000%14-Mar-171000%15-Mar-171000%16-Mar-171000%17-Mar-171000%18-Mar-171000%19-Mar-171000%20-Mar-171000%21-Mar-171000%22-Mar-171000%23-Mar-171000%24-Mar-171000%25-Mar-171000%26-Mar-171000%27-Mar-171000%28-Mar-171000%29-Mar-171000%30-Mar-171000%31-Mar-171000%0.00%1-Apr-171000%2-Apr-171000%3-Apr-171000%4-Apr-171000%5-Apr-171000%6-Apr-171000%7-Apr-171000%8-Apr-171000%9-Apr-171000%10-Apr-171000%11-Apr-171000%12-Apr-171000%13-Apr-171000%14-Apr-171000%15-Apr-171000%16-Apr-171000%17-Apr-171000%18-Apr-171000%19-Apr-171000%20-Apr-171000%21-Apr-171000%22-Apr-171000%23-Apr-171000%24-Apr-171000%25-Apr-171000%26-Apr-171000%27-Apr-171000%28-Apr-171000%29-Apr-171000%30-Apr-171000%0.00%1-May-171000%2-May-171000%3-May-171000%4-May-171000%5-May-171000%6-May-171000%7-May-171000%8-May-171000%9-May-171000%10-May-171000%11-May-171000%12-May-171000%13-May-171000%14-May-171000%15-May-171000%16-May-171000%17-May-171000%18-May-171000%19-May-171000%20-May-171000%21-May-171000%22-May-171000%23-May-171000%24-May-171000%25-May-171000%26-May-171000%27-May-171000%28-May-171000%29-May-171000%30-May-171000%31-May-171000%0.00%1-Jun-171000%2-Jun-171000%3-Jun-171000%4-Jun-171000%5-Jun-171000%6-Jun-171000%7-Jun-171000%8-Jun-171000%9-Jun-171000%10-Jun-171000%11-Jun-171000%12-Jun-171000%13-Jun-171000%14-Jun-171000%15-Jun-171000%16-Jun-171000%17-Jun-171000%18-Jun-171000%19-Jun-171000%20-Jun-171000%21-Jun-171000%22-Jun-171000%23-Jun-171000%24-Jun-171000%25-Jun-171000%26-Jun-171000%27-Jun-171000%28-Jun-171000%29-Jun-171000%30-Jun-171000%0.00%1-Jul-171000%2-Jul-171000%3-Jul-171000%4-Jul-171000%5-Jul-171000%6-Jul-171000%7-Jul-171000%8-Jul-171000%9-Jul-171000%10-Jul-171000%11-Jul-171000%12-Jul-171000%13-Jul-171000%14-Jul-171000%15-Jul-171000%16-Jul-171000%17-Jul-171000%18-Jul-171000%19-Jul-171000%20-Jul-171000%21-Jul-171000%22-Jul-171000%23-Jul-171000%24-Jul-171000%25-Jul-171000%26-Jul-171000%27-Jul-171000%28-Jul-171000%29-Jul-171000%30-Jul-171000%31-Jul-171000%0.00%1-Aug-171000%2-Aug-171000%3-Aug-171000%4-Aug-171000%5-Aug-171000%6-Aug-171000%7-Aug-171000%8-Aug-171000%9-Aug-171000%10-Aug-171000%11-Aug-171000%12-Aug-171000%13-Aug-171000%14-Aug-171000%15-Aug-171000%16-Aug-171000%17-Aug-171000%18-Aug-171000%19-Aug-171000%20-Aug-171000%21-Aug-171000%22-Aug-171000%23-Aug-171000%24-Aug-171000%25-Aug-171000%26-Aug-171000%27-Aug-171000%28-Aug-171000%29-Aug-171000%30-Aug-171000%31-Aug-171000%0.00%1-Sep-171000%2-Sep-171000%3-Sep-171000%4-Sep-171000%5-Sep-171000%6-Sep-171000%7-Sep-171000%8-Sep-171000%9-Sep-171000%10-Sep-171000%11-Sep-171000%12-Sep-171000%13-Sep-171000%14-Sep-171000%15-Sep-171000%16-Sep-171000%17-Sep-171000%18-Sep-171000%19-Sep-171000%20-Sep-171000%21-Sep-171000%22-Sep-171000%23-Sep-171000%24-Sep-171000%25-Sep-171000%26-Sep-171000%27-Sep-171000%28-Sep-171000%29-Sep-171000%30-Sep-171000%0.00%1-Oct-171000%2-Oct-171000%3-Oct-171000%4-Oct-171000%5-Oct-171000%6-Oct-171000%7-Oct-171000%8-Oct-171000%9-Oct-171000%10-Oct-171000%11-Oct-171000%12-Oct-171000%13-Oct-171000%14-Oct-171000%15-Oct-171000%16-Oct-171000%17-Oct-171000%18-Oct-171000%19-Oct-171000%20-Oct-171000%21-Oct-171000%22-Oct-171000%23-Oct-171000%24-Oct-171000%25-Oct-171000%26-Oct-171000%27-Oct-171000%28-Oct-171000%29-Oct-171000%30-Oct-171000%31-Oct-171000%0.00%1-Nov-171000%2-Nov-171000%3-Nov-171000%4-Nov-171000%5-Nov-171000%6-Nov-171000%7-Nov-171000%8-Nov-171000%9-Nov-171000%10-Nov-171000%11-Nov-171000%12-Nov-171000%13-Nov-171000%14-Nov-171000%15-Nov-171000%16-Nov-171000%17-Nov-171000%18-Nov-171000%19-Nov-171000%20-Nov-171000%21-Nov-171000%22-Nov-171000%23-Nov-171000%24-Nov-171000%25-Nov-171000%26-Nov-171000%27-Nov-171000%28-Nov-171000%29-Nov-171000%30-Nov-171000%0.00%1-Dec-171000%2-Dec-171000%3-Dec-171000%4-Dec-171000%5-Dec-171000%6-Dec-171000%7-Dec-171000%8-Dec-171000%9-Dec-171000%10-Dec-171000%11-Dec-171000%12-Dec-171000%13-Dec-171000%14-Dec-171000%15-Dec-171000%16-Dec-171000%17-Dec-171000%18-Dec-171000%19-Dec-171000%20-Dec-171000%21-Dec-171000%22-Dec-171000%23-Dec-171000%24-Dec-171000%25-Dec-171000%26-Dec-171000%27-Dec-171000%28-Dec-171000%29-Dec-171000%30-Dec-171000%31-Dec-171000%0.00%1-Jan-1810000%2-Jan-1810000%3-Jan-1810000%4-Jan-1810000%5-Jan-1810000%6-Jan-1810000%7-Jan-1810000%8-Jan-1810000%9-Jan-1810000%10-Jan-1810000%11-Jan-1810000%12-Jan-1810000%13-Jan-1810000%14-Jan-1810000%15-Jan-1810000%16-Jan-1810000%17-Jan-1810000%18-Jan-1810000%19-Jan-1810000%20-Jan-1810000%21-Jan-1810000%22-Jan-1810000%23-Jan-1810000%24-Jan-1810000%25-Jan-1810000%26-Jan-1810000%27-Jan-1810000%28-Jan-1810000%29-Jan-1810000%30-Jan-181009090%31-Jan-181000%92.69%1-Feb-181000%2-Feb-181000%3-Feb-181000%4-Feb-181000%5-Feb-181000%6-Feb-181000%7-Feb-181000%8-Feb-181000%9-Feb-181000%10-Feb-181000%11-Feb-181000%12-Feb-181000%13-Feb-181000%14-Feb-181000%15-Feb-181000%16-Feb-181000%17-Feb-181000%18-Feb-181000%19-Feb-181000%20-Feb-181000%21-Feb-181000%22-Feb-181000%23-Feb-181000%24-Feb-181000%25-Feb-181000%26-Feb-181000%27-Feb-181000%28-Feb-181000%0.00%Note. Daily turnover rate = (separations on day/headcount that day) * 100.Enhanced monthly turnover rate = (separations in a month/average daily headcount that month) * 100.Example 2: The leader of a sales division is building out his team for a product launch and wants to know if the turnover rate for his division is low or high compared to the rest of the organization and trending up or down over time. The traditional rolling 12-month turnover rate for the rest of the organization is 22%. ExplanationAccording to the traditional rolling 12-month turnover rates, the division’s turnover rate as of February 1, 2018 is below the rest of the organization (see table below). In contrast, the enhanced and realized turnover rates reflect the fact that the number of separations at the end of January 2018 is considerably higher than the rest of the organization’s rolling 12-month turnover pared to the traditional rolling 12-month turnover rate, on January 1, 2018 it appears that turnover in the sales division is declining (30% vs. 20%). In contrast, the enhanced and realized turnover rates indicate that turnover has gone up (e.g., 31% to 58%). The increase in the rolling 12-month realized turnover rate from 0.08% to 0.16% provides even more intuitive information, suggesting that nearly twice as many turnover opportunities have been realized in the February 2017 thru January 2018 timeframe than in the January 2017 thru December 2017 timeframe.Rates:Traditional turnover rate (rolling 12 months)Enhanced traditional turnover (rolling 365 days)Realized turnover rate (rolling 12 months)As of Jan 1, 201830.00%30.75%0.08%As of Feb 1, 201820.00%57.62%0.16%Data:DateHeadcountSeparationsDaily turnover rateEnhanced monthly turnover rate 1-Jan-171000%2-Jan-171000%3-Jan-171000%4-Jan-171000%5-Jan-171000%6-Jan-171000%7-Jan-171000%8-Jan-171000%9-Jan-171000%10-Jan-171000%11-Jan-171000%12-Jan-171000%13-Jan-171000%14-Jan-171000%15-Jan-171000%16-Jan-171000%17-Jan-171000%18-Jan-171000%19-Jan-171000%20-Jan-171000%21-Jan-171000%22-Jan-171000%23-Jan-171000%24-Jan-171000%25-Jan-171000%26-Jan-171000%27-Jan-171000%28-Jan-171000%29-Jan-171000%30-Jan-171000%31-Jan-171000%0.00%1-Feb-171000%2-Feb-171000%3-Feb-171000%4-Feb-171000%5-Feb-171000%6-Feb-171000%7-Feb-171000%8-Feb-171000%9-Feb-171000%10-Feb-171000%11-Feb-171000%12-Feb-171000%13-Feb-171000%14-Feb-171000%15-Feb-171000%16-Feb-171000%17-Feb-171000%18-Feb-171000%19-Feb-171000%20-Feb-171000%21-Feb-171000%22-Feb-171000%23-Feb-171000%24-Feb-171000%25-Feb-171000%26-Feb-171000%27-Feb-171000%28-Feb-171000%0.00%1-Mar-171000%2-Mar-171000%3-Mar-171000%4-Mar-171000%5-Mar-171000%6-Mar-171000%7-Mar-171000%8-Mar-171000%9-Mar-171000%10-Mar-171000%11-Mar-171000%12-Mar-171000%13-Mar-171000%14-Mar-171000%15-Mar-171000%16-Mar-171000%17-Mar-171000%18-Mar-171000%19-Mar-171000%20-Mar-171000%21-Mar-171000%22-Mar-171000%23-Mar-171000%24-Mar-171000%25-Mar-171000%26-Mar-171000%27-Mar-171000%28-Mar-171000%29-Mar-171000%30-Mar-171000%31-Mar-1710110%10.00%1-Apr-17900%2-Apr-17900%3-Apr-17900%4-Apr-17900%5-Apr-17900%6-Apr-17900%7-Apr-17900%8-Apr-17900%9-Apr-17900%10-Apr-17900%11-Apr-17900%12-Apr-17900%13-Apr-17900%14-Apr-17900%15-Apr-17900%16-Apr-17900%17-Apr-17900%18-Apr-17900%19-Apr-17900%20-Apr-17900%21-Apr-17900%22-Apr-17900%23-Apr-17900%24-Apr-17900%25-Apr-17900%26-Apr-17900%27-Apr-17900%28-Apr-17900%29-Apr-17900%30-Apr-171000%0.00%1-May-171000%2-May-171000%3-May-171000%4-May-171000%5-May-171000%6-May-171000%7-May-171000%8-May-171000%9-May-171000%10-May-171000%11-May-171000%12-May-171000%13-May-171000%14-May-171000%15-May-171000%16-May-171000%17-May-171000%18-May-171000%19-May-171000%20-May-171000%21-May-171000%22-May-171000%23-May-171000%24-May-171000%25-May-171000%26-May-171000%27-May-171000%28-May-171000%29-May-171000%30-May-171000%31-May-171000%0.00%1-Jun-171000%2-Jun-171000%3-Jun-171000%4-Jun-171000%5-Jun-171000%6-Jun-171000%7-Jun-171000%8-Jun-171000%9-Jun-171000%10-Jun-171000%11-Jun-171000%12-Jun-171000%13-Jun-171000%14-Jun-171000%15-Jun-171000%16-Jun-171000%17-Jun-171000%18-Jun-171000%19-Jun-171000%20-Jun-171000%21-Jun-171000%22-Jun-171000%23-Jun-171000%24-Jun-171000%25-Jun-171000%26-Jun-171000%27-Jun-171000%28-Jun-171000%29-Jun-171000%30-Jun-1710110%10.00%1-Jul-17900%2-Jul-17900%3-Jul-17900%4-Jul-17900%5-Jul-17900%6-Jul-17900%7-Jul-17900%8-Jul-17900%9-Jul-17900%10-Jul-17900%11-Jul-17900%12-Jul-17900%13-Jul-17900%14-Jul-17900%15-Jul-17900%16-Jul-17900%17-Jul-17900%18-Jul-17900%19-Jul-17900%20-Jul-17900%21-Jul-17900%22-Jul-17900%23-Jul-17900%24-Jul-17900%25-Jul-17900%26-Jul-17900%27-Jul-17900%28-Jul-17900%29-Jul-17900%30-Jul-17900%31-Jul-171000%0.00%1-Aug-171000%2-Aug-171000%3-Aug-171000%4-Aug-171000%5-Aug-171000%6-Aug-171000%7-Aug-171000%8-Aug-171000%9-Aug-171000%10-Aug-171000%11-Aug-171000%12-Aug-171000%13-Aug-171000%14-Aug-171000%15-Aug-171000%16-Aug-171000%17-Aug-171000%18-Aug-171000%19-Aug-171000%20-Aug-171000%21-Aug-171000%22-Aug-171000%23-Aug-171000%24-Aug-171000%25-Aug-171000%26-Aug-171000%27-Aug-171000%28-Aug-171000%29-Aug-171000%30-Aug-171000%31-Aug-171000%0.00%1-Sep-171000%2-Sep-171000%3-Sep-171000%4-Sep-171000%5-Sep-171000%6-Sep-171000%7-Sep-171000%8-Sep-171000%9-Sep-171000%10-Sep-171000%11-Sep-171000%12-Sep-171000%13-Sep-171000%14-Sep-171000%15-Sep-171000%16-Sep-171000%17-Sep-171000%18-Sep-171000%19-Sep-171000%20-Sep-171000%21-Sep-171000%22-Sep-171000%23-Sep-171000%24-Sep-171000%25-Sep-171000%26-Sep-171000%27-Sep-171000%28-Sep-171000%29-Sep-171000%30-Sep-1710110%10.00%1-Oct-17900%2-Oct-17900%3-Oct-17900%4-Oct-17900%5-Oct-17900%6-Oct-17900%7-Oct-17900%8-Oct-17900%9-Oct-17900%10-Oct-17900%11-Oct-17900%12-Oct-17900%13-Oct-17900%14-Oct-17900%15-Oct-17900%16-Oct-17900%17-Oct-17900%18-Oct-17900%19-Oct-17900%20-Oct-17900%21-Oct-17900%22-Oct-17900%23-Oct-17900%24-Oct-17900%25-Oct-17900%26-Oct-17900%27-Oct-17900%28-Oct-17900%29-Oct-17900%30-Oct-17900%31-Oct-171000%0.00%1-Nov-171000%2-Nov-171000%3-Nov-171000%4-Nov-171000%5-Nov-171000%6-Nov-171000%7-Nov-171000%8-Nov-171000%9-Nov-171000%10-Nov-171000%11-Nov-171000%12-Nov-171000%13-Nov-171000%14-Nov-171000%15-Nov-171000%16-Nov-171000%17-Nov-171000%18-Nov-171000%19-Nov-171000%20-Nov-171000%21-Nov-171000%22-Nov-171000%23-Nov-171000%24-Nov-171000%25-Nov-171000%26-Nov-171000%27-Nov-171000%28-Nov-171000%29-Nov-171000%30-Nov-171000%0.00%1-Dec-171000%2-Dec-171000%3-Dec-171000%4-Dec-171000%5-Dec-171000%6-Dec-171000%7-Dec-171000%8-Dec-171000%9-Dec-171000%10-Dec-171000%11-Dec-171000%12-Dec-171000%13-Dec-171000%14-Dec-171000%15-Dec-171000%16-Dec-171000%17-Dec-171000%18-Dec-171000%19-Dec-171000%20-Dec-171000%21-Dec-171000%22-Dec-171000%23-Dec-171000%24-Dec-171000%25-Dec-171000%26-Dec-171000%27-Dec-171000%28-Dec-171000%29-Dec-171000%30-Dec-171000%31-Dec-171000%0.00%1-Jan-181000%2-Jan-181000%3-Jan-181000%4-Jan-181000%5-Jan-181000%6-Jan-181000%7-Jan-181000%8-Jan-181000%9-Jan-181000%10-Jan-181000%11-Jan-181000%12-Jan-181000%13-Jan-181000%14-Jan-181000%15-Jan-181000%16-Jan-181000%17-Jan-181000%18-Jan-181000%19-Jan-181000%20-Jan-181000%21-Jan-181000%22-Jan-181000%23-Jan-181000%24-Jan-181000%25-Jan-181000%26-Jan-181000%27-Jan-181000%28-Jan-181000%29-Jan-181000%30-Jan-181000%31-Jan-1825031%16.91%Note. Daily turnover rate = (separations on day/headcount that day) * 100.Enhanced monthly turnover rate = (separations in a month/average daily headcount that month) * 100.A new hire is made at the end of every few months to replace the employees that separate. 240 new hires are made on January 31, 2018 to build out the team.Example 3: A small company with 100 employees is acquired on March 15, 2017, and they do not have accurate records of headcount or separations from before the acquisition. The leadership team of the parent company knows there was significant turnover in the first 2 months after the acquisition as well as considerable growth of the team via hiring. At the end of September, the parent company is keenly interested to know if the turnover rate is higher for the acquired company than the parent company. The traditional rolling 12-month turnover rate for the parent company is 11% but technically cannot be computed for the acquired company because they still do not have 12 months of headcount and separation data.ExplanationA traditional rolling 12-month turnover rate can be estimated based on the five and a half months of data they do have, but that would not account for seasonal fluctuations (e.g., turnover spikes at the end of the calendar year or just after bonus payouts). A traditional 1-month turnover rate can be calculated but will be misleading if it uses the typical month-end snapshot in the denominator. A more accurate comparison is accomplished using realized turnover rates. Turnover rates for each month:MonthParent company traditional 1-month turnover rateAcquired group traditional 1-month turnover rateParent company realized 1-month turnover rateAcquired group realized 1-month turnover rateMarch0.92%100.00%0.03%5.56%April1.17%25.00%0.04%0.85%May0.86%1.00%0.03%0.03%June1.05%0.67%0.04%0.03%July0.94%0.60%0.03%0.03%August1.15%0.57%0.04%0.03%Data:DateHeadcountSeparationsDaily turnover rateEnhanced monthly turnover rate 1-Jan-17---2-Jan-17---3-Jan-17---4-Jan-17---5-Jan-17---6-Jan-17---7-Jan-17---8-Jan-17---9-Jan-17---10-Jan-17---11-Jan-17---12-Jan-17---13-Jan-17---14-Jan-17---15-Jan-17---16-Jan-17---17-Jan-17---18-Jan-17---19-Jan-17---20-Jan-17---21-Jan-17---22-Jan-17---23-Jan-17---24-Jan-17---25-Jan-17---26-Jan-17---27-Jan-17---28-Jan-17---29-Jan-17---30-Jan-17---31-Jan-17----1-Feb-17---2-Feb-17---3-Feb-17---4-Feb-17---5-Feb-17---6-Feb-17---7-Feb-17---8-Feb-17---9-Feb-17---10-Feb-17---11-Feb-17---12-Feb-17---13-Feb-17---14-Feb-17---15-Feb-17---16-Feb-17---17-Feb-17---18-Feb-17---19-Feb-17---20-Feb-17---21-Feb-17---22-Feb-17---23-Feb-17---24-Feb-17---25-Feb-17---26-Feb-17---27-Feb-17---28-Feb-17----1-Mar-17---2-Mar-17---3-Mar-17---4-Mar-17---5-Mar-17---6-Mar-17---7-Mar-17---8-Mar-17---9-Mar-17---10-Mar-17---11-Mar-17---12-Mar-17---13-Mar-17---14-Mar-17---15-Mar-171005050%16-Mar-175000%17-Mar-175000%18-Mar-175000%19-Mar-175000%20-Mar-175000%21-Mar-175000%22-Mar-175000%23-Mar-175000%24-Mar-175000%25-Mar-175000%26-Mar-175000%27-Mar-175000%28-Mar-175000%29-Mar-175000%30-Mar-175000%31-Mar-175000%94.44%1-Apr-171005050%2-Apr-1720000%3-Apr-1720000%4-Apr-1720000%5-Apr-1720000%6-Apr-1720000%7-Apr-1720000%8-Apr-1720000%9-Apr-1720000%10-Apr-1720000%11-Apr-1720000%12-Apr-1720000%13-Apr-1720000%14-Apr-1720000%15-Apr-1720000%16-Apr-1720000%17-Apr-1720000%18-Apr-1720000%19-Apr-1720000%20-Apr-1720000%21-Apr-1720000%22-Apr-1720000%23-Apr-1720000%24-Apr-1720000%25-Apr-1720000%26-Apr-1720000%27-Apr-1720000%28-Apr-1720000%29-Apr-1720000%30-Apr-1720000%25.42%1-May-1720000%2-May-1720000%3-May-1720000%4-May-1720000%5-May-1720000%6-May-1720000%7-May-1720000%8-May-1720000%9-May-1720000%10-May-1720000%11-May-1720000%12-May-1720000%13-May-1720000%14-May-1720000%15-May-1720000%16-May-1720000%17-May-1720000%18-May-1720000%19-May-1720000%20-May-1720000%21-May-1720000%22-May-1720000%23-May-1720000%24-May-1720000%25-May-1720000%26-May-1720000%27-May-1720000%28-May-1720000%29-May-1720000%30-May-1720000%31-May-1720021%1.00%1-Jun-1719800%2-Jun-1719800%3-Jun-1719800%4-Jun-1719800%5-Jun-1719800%6-Jun-1719800%7-Jun-1719800%8-Jun-1719800%9-Jun-1719800%10-Jun-1719800%11-Jun-1719800%12-Jun-1719800%13-Jun-1719800%14-Jun-1719800%15-Jun-1719800%16-Jun-1719800%17-Jun-1719800%18-Jun-1719800%19-Jun-1719800%20-Jun-1719800%21-Jun-1719800%22-Jun-1719800%23-Jun-1719800%24-Jun-1719800%25-Jun-1719800%26-Jun-1719800%27-Jun-1719800%28-Jun-1719800%29-Jun-1719800%30-Jun-1730021%0.99%1-Jul-1729831%2-Jul-1729500%3-Jul-1729500%4-Jul-1729500%5-Jul-1729500%6-Jul-1729500%7-Jul-1729500%8-Jul-1729500%9-Jul-1729500%10-Jul-1729500%11-Jul-1729500%12-Jul-1729500%13-Jul-1729500%14-Jul-1729500%15-Jul-1729500%16-Jul-1729500%17-Jul-1729500%18-Jul-1729500%19-Jul-1729500%20-Jul-1729500%21-Jul-1729500%22-Jul-1729500%23-Jul-1729500%24-Jul-1729500%25-Jul-1729500%26-Jul-1729500%27-Jul-1729500%28-Jul-1729500%29-Jul-1729500%30-Jul-1729500%31-Jul-1750000%0.99%1-Aug-1750041%2-Aug-1749600%3-Aug-1749600%4-Aug-1749600%5-Aug-1749600%6-Aug-1749600%7-Aug-1749600%8-Aug-1749600%9-Aug-1749600%10-Aug-1749600%11-Aug-1749600%12-Aug-1749600%13-Aug-1749600%14-Aug-1749600%15-Aug-1749600%16-Aug-1749600%17-Aug-1749600%18-Aug-1749600%19-Aug-1749600%20-Aug-1749600%21-Aug-1749600%22-Aug-1749600%23-Aug-1749600%24-Aug-1749600%25-Aug-1749600%26-Aug-1749600%27-Aug-1749600%28-Aug-1749600%29-Aug-1749600%30-Aug-1749600%31-Aug-1770000%0.80%Note. New hires: 50 on April 1, 100 on April 2, 102 on June 30, 205 on July 31, and 204 August 31.Daily turnover rate = (separations on day/headcount that day) * 100.Enhanced monthly turnover rate = (separations in a month/average daily headcount that month) * 100.Example 4: A small organization merges with a larger one and a restructuring occurs. Five employees from the small organization separate immediately on January 1, 2017; the remaining 5 are incorporated into a group of 45 employees within the united company at the end of February 2017, and this team loses 25 members to a start-up on January 1, 2018.ExplanationThe traditional turnover rate trend diverges from the enhanced rate trend and appears to be lower on February 1, 2018 than March 1, 2018, because the February 2017 reorganization is beyond the rolling 12-month timeframe of the turnover metrics shown on March 1, 2018. The realized turnover rate adapts to handle these scenarios and can even be viewed on a finer timescale to gain a nuanced understanding of the trends.Rates:Traditional turnover rate (rolling 12 months)Enhanced traditional turnover (rolling 365 days)Realized turnover rate (rolling 12 months)Realized turnover rate (1 month)As of Feb 1, 201852.17%56.03%0.15%3.13%As of Mar 1, 201854.55%54.32%0.15%0.00% Data:DateHeadcountSeparationsDaily turnover rate Enhanced monthly turnover rate 1-Jan-1710550%2-Jan-17500%3-Jan-17500%4-Jan-17500%5-Jan-17500%6-Jan-17500%7-Jan-17500%8-Jan-17500%9-Jan-17500%10-Jan-17500%11-Jan-17500%12-Jan-17500%13-Jan-17500%14-Jan-17500%15-Jan-17500%16-Jan-17500%17-Jan-17500%18-Jan-17500%19-Jan-17500%20-Jan-17500%21-Jan-17500%22-Jan-17500%23-Jan-17500%24-Jan-17500%25-Jan-17500%26-Jan-17500%27-Jan-17500%28-Jan-17500%29-Jan-17500%30-Jan-17500%31-Jan-17500%96.88%1-Feb-17500%2-Feb-17500%3-Feb-17500%4-Feb-17500%5-Feb-17500%6-Feb-17500%7-Feb-17500%8-Feb-17500%9-Feb-17500%10-Feb-17500%11-Feb-17500%12-Feb-17500%13-Feb-17500%14-Feb-17500%15-Feb-17500%16-Feb-17500%17-Feb-17500%18-Feb-17500%19-Feb-17500%20-Feb-17500%21-Feb-17500%22-Feb-17500%23-Feb-17500%24-Feb-17500%25-Feb-17500%26-Feb-17500%27-Feb-17500%28-Feb-175000%0.00%1-Mar-175000%2-Mar-175000%3-Mar-175000%4-Mar-175000%5-Mar-175000%6-Mar-175000%7-Mar-175000%8-Mar-175000%9-Mar-175000%10-Mar-175000%11-Mar-175000%12-Mar-175000%13-Mar-175000%14-Mar-175000%15-Mar-175000%16-Mar-175000%17-Mar-175000%18-Mar-175000%19-Mar-175000%20-Mar-175000%21-Mar-175000%22-Mar-175000%23-Mar-175000%24-Mar-175000%25-Mar-175000%26-Mar-175000%27-Mar-175000%28-Mar-175000%29-Mar-175000%30-Mar-175000%31-Mar-175000%0.00%1-Apr-175000%2-Apr-175000%3-Apr-175000%4-Apr-175000%5-Apr-175000%6-Apr-175000%7-Apr-175000%8-Apr-175000%9-Apr-175000%10-Apr-175000%11-Apr-175000%12-Apr-175000%13-Apr-175000%14-Apr-175000%15-Apr-175000%16-Apr-175000%17-Apr-175000%18-Apr-175000%19-Apr-175000%20-Apr-175000%21-Apr-175000%22-Apr-175000%23-Apr-175000%24-Apr-175000%25-Apr-175000%26-Apr-175000%27-Apr-175000%28-Apr-175000%29-Apr-175000%30-Apr-175000%0.00%1-May-175000%2-May-175000%3-May-175000%4-May-175000%5-May-175000%6-May-175000%7-May-175000%8-May-175000%9-May-175000%10-May-175000%11-May-175000%12-May-175000%13-May-175000%14-May-175000%15-May-175000%16-May-175000%17-May-175000%18-May-175000%19-May-175000%20-May-175000%21-May-175000%22-May-175000%23-May-175000%24-May-175000%25-May-175000%26-May-175000%27-May-175000%28-May-175000%29-May-175000%30-May-175000%31-May-175000%0.00%1-Jun-175000%2-Jun-175000%3-Jun-175000%4-Jun-175000%5-Jun-175000%6-Jun-175000%7-Jun-175000%8-Jun-175000%9-Jun-175000%10-Jun-175000%11-Jun-175000%12-Jun-175000%13-Jun-175000%14-Jun-175000%15-Jun-175000%16-Jun-175000%17-Jun-175000%18-Jun-175000%19-Jun-175000%20-Jun-175000%21-Jun-175000%22-Jun-175000%23-Jun-175000%24-Jun-175000%25-Jun-175000%26-Jun-175000%27-Jun-175000%28-Jun-175000%29-Jun-175000%30-Jun-175000%0.00%1-Jul-175000%2-Jul-175000%3-Jul-175000%4-Jul-175000%5-Jul-175000%6-Jul-175000%7-Jul-175000%8-Jul-175000%9-Jul-175000%10-Jul-175000%11-Jul-175000%12-Jul-175000%13-Jul-175000%14-Jul-175000%15-Jul-175000%16-Jul-175000%17-Jul-175000%18-Jul-175000%19-Jul-175000%20-Jul-175000%21-Jul-175000%22-Jul-175000%23-Jul-175000%24-Jul-175000%25-Jul-175000%26-Jul-175000%27-Jul-175000%28-Jul-175000%29-Jul-175000%30-Jul-175000%31-Jul-175000%0.00%1-Aug-175000%2-Aug-175000%3-Aug-175000%4-Aug-175000%5-Aug-175000%6-Aug-175000%7-Aug-175000%8-Aug-175000%9-Aug-175000%10-Aug-175000%11-Aug-175000%12-Aug-175000%13-Aug-175000%14-Aug-175000%15-Aug-175000%16-Aug-175000%17-Aug-175000%18-Aug-175000%19-Aug-175000%20-Aug-175000%21-Aug-175000%22-Aug-175000%23-Aug-175000%24-Aug-175000%25-Aug-175000%26-Aug-175000%27-Aug-175000%28-Aug-175000%29-Aug-175000%30-Aug-175000%31-Aug-175000%0.00%1-Sep-175000%2-Sep-175000%3-Sep-175000%4-Sep-175000%5-Sep-175000%6-Sep-175000%7-Sep-175000%8-Sep-175000%9-Sep-175000%10-Sep-175000%11-Sep-175000%12-Sep-175000%13-Sep-175000%14-Sep-175000%15-Sep-175000%16-Sep-175000%17-Sep-175000%18-Sep-175000%19-Sep-175000%20-Sep-175000%21-Sep-175000%22-Sep-175000%23-Sep-175000%24-Sep-175000%25-Sep-175000%26-Sep-175000%27-Sep-175000%28-Sep-175000%29-Sep-175000%30-Sep-175000%0.00%1-Oct-175000%2-Oct-175000%3-Oct-175000%4-Oct-175000%5-Oct-175000%6-Oct-175000%7-Oct-175000%8-Oct-175000%9-Oct-175000%10-Oct-175000%11-Oct-175000%12-Oct-175000%13-Oct-175000%14-Oct-175000%15-Oct-175000%16-Oct-175000%17-Oct-175000%18-Oct-175000%19-Oct-175000%20-Oct-175000%21-Oct-175000%22-Oct-175000%23-Oct-175000%24-Oct-175000%25-Oct-175000%26-Oct-175000%27-Oct-175000%28-Oct-175000%29-Oct-175000%30-Oct-175000%31-Oct-175000%0.00%1-Nov-175000%2-Nov-175000%3-Nov-175000%4-Nov-175000%5-Nov-175000%6-Nov-175000%7-Nov-175000%8-Nov-175000%9-Nov-175000%10-Nov-175000%11-Nov-175000%12-Nov-175000%13-Nov-175000%14-Nov-175000%15-Nov-175000%16-Nov-175000%17-Nov-175000%18-Nov-175000%19-Nov-175000%20-Nov-175000%21-Nov-175000%22-Nov-175000%23-Nov-175000%24-Nov-175000%25-Nov-175000%26-Nov-175000%27-Nov-175000%28-Nov-175000%29-Nov-175000%30-Nov-175000%0.00%1-Dec-175000%2-Dec-175000%3-Dec-175000%4-Dec-175000%5-Dec-175000%6-Dec-175000%7-Dec-175000%8-Dec-175000%9-Dec-175000%10-Dec-175000%11-Dec-175000%12-Dec-175000%13-Dec-175000%14-Dec-175000%15-Dec-175000%16-Dec-175000%17-Dec-175000%18-Dec-175000%19-Dec-175000%20-Dec-175000%21-Dec-175000%22-Dec-175000%23-Dec-175000%24-Dec-175000%25-Dec-175000%26-Dec-175000%27-Dec-175000%28-Dec-175000%29-Dec-175000%30-Dec-175000%31-Dec-175000%0.00%1-Jan-18502550%2-Jan-182500%3-Jan-182500%4-Jan-182500%5-Jan-182500%6-Jan-182500%7-Jan-182500%8-Jan-182500%9-Jan-182500%10-Jan-182500%11-Jan-182500%12-Jan-182500%13-Jan-182500%14-Jan-182500%15-Jan-182500%16-Jan-182500%17-Jan-182500%18-Jan-182500%19-Jan-182500%20-Jan-182500%21-Jan-182500%22-Jan-182500%23-Jan-182500%24-Jan-182500%25-Jan-182500%26-Jan-182500%27-Jan-182500%28-Jan-182500%29-Jan-182500%30-Jan-182500%31-Jan-182500%96.88%1-Feb-182500%2-Feb-182500%3-Feb-182500%4-Feb-182500%5-Feb-182500%6-Feb-182500%7-Feb-182500%8-Feb-182500%9-Feb-182500%10-Feb-182500%11-Feb-182500%12-Feb-182500%13-Feb-182500%14-Feb-182500%15-Feb-182500%16-Feb-182500%17-Feb-182500%18-Feb-182500%19-Feb-182500%20-Feb-182500%21-Feb-182500%22-Feb-182500%23-Feb-182500%24-Feb-182500%25-Feb-182500%26-Feb-182500%27-Feb-182500%28-Feb-182500%0.00%Note. Daily turnover rate = (separations on day/headcount that day) * 100.Enhanced monthly turnover rate = (separations in a month/average daily headcount that month) * 100.Appendix C: Connection to Survival MetricsRealized turnover rates also provide information about the average length of time individuals “survive” in organizations. Relatedly, realized turnover rates can also be conceptualized as the average daily hazard rate for any given worker on any given day during the period.Realized turnover rate= # separations# opportunities to separateRealized turnover rate=# separations# people × average active daysAverage active days= 1{# people ×# separations# people ×average active days# separations}Average active days= 1[# people ×realized turnover rate# separations] ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download