Individual Assignment I – Chapter 12 Turnover Calculations Use the following tab
ID: 368866 • Letter: I
Question
Individual Assignment I – Chapter 12
Turnover Calculations
Use the following table to answer questions 1-5. Be sure to include your arithmetic so that the instructor can see how you determined your answers.
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
1.Calculate the annual rates of voluntary, involuntary, and total turnover.
Explanation / Answer
Calculation of Monthly turnover is no of employees left during the month divided by total employees for the month.
Follwing Table shows the Employee Turnover on Monthly Basis for Machining Department
Month
jan
feb
mar
apr
may
jun
jul
aug
sep
oct
nov
dec
Emp Left in Machining
0
0
0
1
1
2
1
3
1
3
2
4
Total Employes
127
131
139
138
138
142
142
141
144
149
155
155
Turnover Percentage
0
0
0
0.72
0.72
1.41
0.70
2.13
0.69
2.01
1.29
2.58
To Calculate the annual rate, we need to calculate the average employees, average of no of employees at start and end of the year. We then divide the number of voluntary , involuntary and total employees left during the year by average employees to get the annual rates.
Average employees = 127+155 / 2 = 141
Voluntary left = 25
Involuntary left = 17
Total Employees Left = 42
So Annual rate of Voluntary Left = 25/141 * 100 % = 17.73% Turnover
Annual rate of Involuntary Left = 17/141 * 100% = 12.05%
Total Annual Turnover = 42/141*100% = 30.00%
Month
jan
feb
mar
apr
may
jun
jul
aug
sep
oct
nov
dec
Emp Left in Machining
0
0
0
1
1
2
1
3
1
3
2
4
Total Employes
127
131
139
138
138
142
142
141
144
149
155
155
Turnover Percentage
0
0
0
0.72
0.72
1.41
0.70
2.13
0.69
2.01
1.29
2.58