AVERAGE EMPLOYMENT LEVELS FOR SEAT OF KNOWLEDGE Jan Feb Mar Apr May Jun Jul Aug
ID: 329672 • Letter: A
Question
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
Calculate the average monthly rate of turnover for the Machining Department. Follow the example for January to calculate the remaining 11 months.
Jan Feb Mar Apr May Jun Jul
Machining 0/47=0%
Aug Sep Oct Nov Dec
Explanation / Answer
A) Formula for average monthly rate of turnover is as follows:
Average Monthly Turnover ={ (Number of Turnover in given month) / (Average Employement level for that month) } * 100
First we will analyze the given solved example from question.
For January Month,
Number of turnover in January (Machining)= 0 ..................( From Turnover Table)
Average Employement Level(Machining) = 47 ...................( From Employment Table)
Thus Average monthly Turnover (Machining)= 0/47 = 0% .....( From the formula)
Note: For counting Number of turnover for machining, we need to keep one thing in mind that we will count only those turnover which are in only Machining/Fabricating Department but not from any other department.
Thus, we can calculate Average Monthly Turnover for each Month for Machining Department as follows:
B) February
Number of turnover in January (Machining)= 0 ..................( From Turnover Table)
Average Employement Level(Machining) = 47 ...................( From Employment Table)
Thus Average monthly Turnover (Machining)= 0/47 = 0% .....( From the formula)
C) March
Number of turnover in January (Machining)= 0 ..................( From Turnover Table)
Average Employement Level(Machining) = 50 ...................( From Employment Table)
Thus Average monthly Turnover (Machining)= 0/50 = 0% .....( From the formula)
D) April
Number of turnover in January (Machining)= 1 ..................( From Turnover Table)
Average Employement Level(Machining) = 49 ...................( From Employment Table)
Thus Average monthly Turnover (Machining)= 1/49 = 0.0204 = 2.04% .....( From the formula)
E) May
Number of turnover in January (Machining)= 1 ..................( From Turnover Table)
Average Employement Level(Machining) = 51 ...................( From Employment Table)
Thus Average monthly Turnover (Machining)= 1/51 = 0.0196 = 1.96% .....( From the formula)
F) June
Number of turnover in January (Machining)= 2 ..................( From Turnover Table)
Average Employement Level(Machining) = 51 ...................( From Employment Table)
Thus Average monthly Turnover (Machining)= 2/51 = 0.0392 = 3.92% .....( From the formula)
G) July
Number of turnover in January (Machining)= 1 ..................( From Turnover Table)
Average Employement Level(Machining) = 52 ...................( From Employment Table)
Thus Average monthly Turnover (Machining)= 1/52 = 0.0192 = 1.92% .....( From the formula)
H) August
Number of turnover in January (Machining)= 3 ..................( From Turnover Table)
Average Employement Level(Machining) = 51 ...................( From Employment Table)
Thus Average monthly Turnover (Machining)= 3/51 = 0.0588 = 5.88% .....( From the formula)
I) September
Number of turnover in January (Machining)= 1 ..................( From Turnover Table)
Average Employement Level(Machining) = 51 ...................( From Employment Table)
Thus Average monthly Turnover (Machining)= 1/51 = 0.0196 = 1.96% .....( From the formula)
J) October
Number of turnover in January (Machining)= 3 ..................( From Turnover Table)
Average Employement Level(Machining) = 50 ...................( From Employment Table)
Thus Average monthly Turnover (Machining)= 3/50 = 0.06 = 6.00% .....( From the formula)
K) November
Number of turnover in January (Machining)= 2 ..................( From Turnover Table)
Average Employement Level(Machining) = 52 ...................( From Employment Table)
Thus Average monthly Turnover (Machining)= 2/52 = 0.0384 = 3.84% .....( From the formula)
L) December
Number of turnover in January (Machining)= 4 ..................( From Turnover Table)
Average Employement Level(Machining) = 53 ...................( From Employment Table)
Thus Average monthly Turnover (Machining)= 4/53 = 0.0754 = 7.54% .....( From the formula)
Hence Summing up all the answers , we can draw below table as follows:
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.