In: Accounting
AVERAGE EMPLOYMENT LEVELS FOR SEAT OF KNOWLEDGE
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Machining/Fabricating 47 47 50 49 51 51 52 51 51 50 52 53
Shipping/Receiving 24 23 25 25 25 23 24 24 24 24 24 24
Welding 30 31 34 34 33 32 32 33 33 38 43 43
Paint/Assembly 26 30 30 30 29 36 34 33 36 37 36 35
TURNOVER
Date Department Reason
04/12 Machining/Fabricating Other Job
05/23 Machining/Fabricating Other Job
06/08 Machining/Fabricating Other Job
06/13 Machining/Fabricating No reason given
7/12 Machining/Fabricating Other Job
08/09 Machining/Fabricating Personal
08/17 Machining/Fabricating Personal
08/28 Machining/Fabricating Other Job
09/14 Machining/Fabricating Other Job
10/15 Machining/Fabricating Retired
10/15 Machining/Fabricating Temp. LF*
10/15 Machining/Fabricating Temp. LF
11/01 Machining/Fabricating Temp. LF
11/14 Machining/Fabricating Other Job
12/03 Machining/Fabricating Discharged
12/03 Machining/Fabricating Temp. LF
12/03 Machining/Fabricating Temp. LF
12/06 Machining/Fabricating Other Job
04/26 Paint/Assembly Other Job
05/18 Paint/Assembly Medical reasons
07/05 Paint/Assembly Other Job
07/27 Paint/Assembly Moving
07/31 Paint/Assembly Other Job
09/05 Paint/Assembly Other Job
04/27 Shipping/Receiving Decline in work load
05/25 Shipping/Receiving Retired
06/28 Shipping/Receiving Personal
07/12 Shipping/Receiving Discharged
07/20 Shipping/Receiving No reason given
07/23 Shipping/Receiving No reason given
08/30 Shipping/Receiving Other Job
01/12 Welding Other Job
12/03 Welding Discharged
12/03 Welding Temp. LF
12/03 Welding Temp. LF
12/03 Welding Temp. LF
12/03 Welding Temp. LF
12/17 Welding Discharged
12/17 Welding Temp. LF
12/17 Welding Temp. LF
12/17 Welding Temp. LF
12/17 Welding Temp. LF
*LF = Layoff
Which department has the highest turnover rate?
DEPT. |
AVG. EMPLOYMENT |
TURNOVER |
TurnOver RATE |
Machining |
|||
Shipping |
|||
Welding |
|||
Paint/Assembly |
|||
Department/Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Avg Empl. (Jan+Feb+Mar +…+Dec)/12 | Turnover | Turnover Rate (%) |
Machining/Fabricating | 47 | 47 | 50 | 49 | 51 | 51 | 52 | 51 | 51 | 50 | 52 | 53 | 50 | 10 | 19.87 |
Shipping/Receiving | 24 | 23 | 25 | 25 | 25 | 23 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 5 | 20.76 |
Welding | 30 | 31 | 34 | 34 | 33 | 32 | 32 | 33 | 33 | 38 | 43 | 43 | 35 | 3 | 8.65 |
Paint/Assembly | 26 | 30 | 30 | 30 | 29 | 36 | 34 | 33 | 36 | 37 | 36 | 35 | 33 | 4 | 12.24 |
As given in the table above, the shipping & receiving department has the highest turnover rate (20.76%). Machining/Fabricating is the close second with 19.87% turnover rate.
Note: As against attrition, since employee turnover only includes employees who leave the company due to termination, taking a better job, or because they felt there was no room for growth and similar events; the following events have been excluded from the turnover figures for each department:
'No reasons given' has been included as a turnover event.