Answer questions 1-6 and show all calculations. Questions 1-5 will require that
ID: 369666 • Letter: A
Question
Answer questions 1-6 and show all calculations. Questions 1-5 will require that you use the data provided in the tables on the following page.
1. Calculate the average employment level for each department.
2. Calculate the average employment level for the organization.
3. Calculate the average monthly rate of turnover for Maintenance.
4. Calculate the annual rates of voluntary, involuntary, and total turnover (if “no reason given, calculate in voluntary turnover).
5. Which department has the highest turnover rate?
Use the following tables to answer questions 1-5 AVERAGE EMPLOYMENT LEVELS FOR HARRIS CONTSTRUCTION
AVERAGE EMPLOYMENT LEVELS FOR HARRIS CONTSTRUCTION
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Maintenance 47 47 50 49 51 51 52 51 51 50 52 53
Plumbing 24 23 25 25 25 23 24 24 24 24 24 24
HVAC 30 31 34 34 33 32 32 33 33 38 43 43
Electrical 26 30 30 30 29 36 34 33 36 37 36 35
TURNOVER
Date Department Reason
04/12 Maintenance Other Job
05/23 Maintenance Other Job
06/08 Maintenance Other Job
06/13 Maintenance No reason given
7/12 Maintenance Other Job
08/09 Maintenance Personal
08/17 Maintenance Personal
08/28 Maintenance Other Job
09/14 Maintenance Other Job
10/15 Maintenance Retired
10/15 Maintenance Temp. LF
10/15 Maintenance Temp. LF
11/01 Maintenance Temp. LF
11/14 Maintenance Other Job
12/03 Maintenance Fired
12/03 Maintenance Temp. LF
12/03 Maintenance Temp. LF
12/06 Maintenance Other Job
04/26 Electrical Other Job
05/18 Electrical Medical reasons
07/05 Electrical Other Job
07/27 Electrical Moving
07/31 Electrical Other Job
09/05 Electrical Other Job
04/27 Plumbers Decline in work load
05/25 Plumbers Retired
06/28 Plumbers Personal
07/12 Plumbers Fired
07/20 Plumbers No reason given
07/23 Plumbers No reason given
08/30 Plumbers Other Job
01/12 HVAC Other Job
12/03 HVAC Fired
12/03 HVAC Temp. LF
12/03 HVAC Temp. LF
12/03 HVAC Temp. LF
12/03 HVAC Temp. LF
12/17 HVAC Fired
12/17 HVAC Temp. LF
12/17 HVAC Temp. LF
12/17 HVAC Temp. LF
12/17 HVAC Temp. LF
Explanation / Answer
1. average employment level in each department=
maintanance= 604/12= 50.33
plumbering= 249/12= 24.2
HVAC= 373/12= 31
electrical= 392/12= 32.66
2. average employment level of the organization= 604+249+373+392/12= 134.83 or rounded it as 135
3. average monthly rate of turnover in maintanace department= total changing jobs/12 months
= 18/12= 1.5 is the rate of turnover
4. there are three people who have not given any reason, the turnover rate is= 3/12= 0.25
5. the total turnovers in maintanance is 18, which is higher than any other department.