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                     

                                                                                                                       

Answer 1

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:

January   0% February 0% March 0% April 2.04% May 1.96% June 3.92% July 1.92% August 5.88% September 1.96% October 6.00% November 3.84% December 7.54%