|
Improving Work-Life Fit in Hourly Jobs
The Center for WorkLife Law
a
PPENDix
c
t
urnover
W
orksHeet
Begin by selecting a particular job for analysis. It is also useful to calculate turnover and retention rates
separately for specific subgroups of workers such as newly hired workers, workers in part-time and full-time
jobs, and higher and lower performing employees.
Can be fiscal or annual year
Monthly Turnover Rate
Cumulative Turnover Rate
MONTH
Number of employees
("EEs") who left
during the month
Number of EEs at
beginning of month
C/D (number of EEs who left
divided by number of EEs at
beginning of month)
Sum of monthly turnover
month 1
6
30
20%
20%
month 2
3
24
13%
33%
month 3
4
28
14%
47%
month 4
2
32
6%
53%
month 5
4
31
13%
66%
month 6
4
30
13%
79%
month 7
5
28
18%
97%
month 8
2
26
8%
105%
month 9
1
24
4%
109%
month 10
3
27
11%
120%
month 11
3
32
9%
130%
month 12
6
35
17%
147%
Annual Cumulative Turnover Rate
Monthly Retention Rate
MONTH *
EEs in job in Month 1
Number of EEs in job in
Month 1 still working in
Month `X'
Number of EEs from Month 1
still working at Month `X' divided by
Number of EEs in Month 1
month 1
200
200
100%
month 2
200
198
99%
month 3
200
186
93%
month 4
200
174
87%
month 5
200
167
84%
month 6
200
165
83%
month 7
200
154
77%
month 8
200
142
71%
month 9
200
135
68%
month 10
200
134
67%
month 11
200
122
61%
month 12
200
118
59%
Annual Cumulative Retention Rate **
* Can start at any month in year. Useful to calculate retention rates using several different starting months.
** You do not need to calculate monthly retention rates to get the Annual Cumulative Retention Rate. All you needis the Month 12 retention rate.
Summary :
Can be fiscal or annual year Monthly Turnover Rate Cumulative Turnover Rate MONTH Number of employees ("EEs") who left during the month Number of EEs at beginning of month C/D (number of EEs who left divided by number of EEs at beginning of month) Sum of monthly turnover month 1 6 30 20% 20% month 2 3 24 13% 33% month 3 4 28 14% 47% month 4 2 32 6% 53% month 5 4 31 13% 66% month 6 4 30 13% 79% month 7 5 28 18% 97% month 8 2 26 8% 105% month 9 1 24 4% 109% month 10 3 27 11% 120% month 11 3 32 9% 130% month 12 6 35 17% 147% Annual Cumulative Turnover Rate Monthly Retention Rate MONTH * EEs in job in Month 1 Number of EEs in job in Month 1 still working in Month `X' Number of EEs from Month 1 still working at Month `X' divided by Number of EEs in Month 1 month 1 200 200 100% month 2 200 198 99% month 3 200 186 93% month 4 200 174 87% month 5 200 167 84% month 6 200 165 83% month 7 200 154 77% month 8 200 142 71% month 9 200 135 68% month 10 200 134 67% month 11 200 122 61% month 12 200 118 59% Annual Cumulative Retention Rate ** * Can start at any month in year.
Tags :
ees,number,retention,rate,turnoer,cumulatie,annual,monthly,month,job,calculate,rates,workers