Think about it, there are only 6 things that can

change an employee's job status: Death,

Disability, Retirement, Voluntary Separation,

Involuntary Separation, and Promotion.

For the exercise, you are an HR consultant who

has been brought in to work with the company on

their HR planning. Think about this as a 3-year

planning scenario.

Plug in the following percentages: Death =6%,

Disability = 8%, Retirement = 20%, Voluntary

Separation = 60%, Involuntary Separation = 3%,

and Promotion = 6%. The Growth Rate is

estimated to be 50% over the next 3 years.

Punch the numbers into the spreadsheet and tell

us what the results imply for your company.

Questions:

1) Will it be easy to meet the needs or will it be

difficult?

2) Describe the situation and discuss your

concerns and recommendations - what you think

the company should be doing from an HR

perspective?

3) What rates are too high and what rates are too

low? What should the organization do to lower

some of the rates and increase other rates?

4) What rates do you recommend which would

be more realistic and help the organization

succeed in the long run?

Once you do your analysis in Excel, examine the

before and after cost of turnover estimate and

the impact on turnover cost using Bonusly's

Turnover Calculator

Example - the Death rate is far too high and the organization should do what it can to lower the rate to no more than 3% by 1) Introducing a Wellness Plan which gives employees an incentive to go to their doctor for their annual wellness check and blood work. This is 100% paid for by the company's insurance. 2) Do a comprehensive safety assessment and safety training to decrease the number of workplace deaths, 3) Reimbursing the employees for gym memberships up to $50 per month if the membership is used at least 10 times per month, and 4) Give all employees a Fitbit Fitness Tracker and encourage the employees to walk at least 10,000 steps per month by giving them prizes and incentives.

Revised Worksheet Initial Worksheet Sheet1 Vol. Sep Death Rate 8% Disability Rate 12% Total Number of FTES 7 20 63 189 067 847 C-Suite Executives Middle Managers Supervisors Team Leaders Entry Level Workers Total Result Death Resu 0 1 5 15 45 60 Disability Result 0 2 7 22 GA 99 Retirement Rate 206 2016 2015 2015, 20% Retirement Result 1 4 12 37 113 167 Vol. Sep Result 5 15 47 141 425 Rale 75% 75% 75% 75 75% Invol. Sep Rate 3% 34 3% 34 3% Invel. Sep Result 0 0 1 5 17 23 Promotior Rate 2% 2% 2% 2% 2% 8% 12% 12% 12% 6% lalalal Changes Occurance Death Disability Retirement Voluntary Separation Involuntary Separation Promotion to Company Growth Rate Rate 0% 12" 20 75% Think about it, there really are only things that can change an employees job status: Death, Disability, Retirement. Voluntary Separation, Involuntary Separation, and Promotion. Estimate the rates and insert your estimates in 811 to B16. Also, estimate your company's growth rate since this can dramatically affect your hiring needs Plug in your rates in the clis to the leelale II 3% 24 50 Look below and and you will find your results! Need Level G-Suite Executives Middle Managers Supervisors Team Leaders Entry Level Workers of PTE 7 21 03 100 567 Growth Rate Required 150 11 150% 150% 1509 150 sellel Available 2 1 -5 -10 -2 31 100 303 99 1370 Death Death Result 0 C-Suite Executives Middle Managers Supervisors Team Leaders Entry Level Workers Total Result Total Number of FTES 7 21 63 189 567 847 Rate 0% 0% 0% 0% 0% Disability Rate ON 0% ON ON 0% Invel Sep Result 0 0 0 0 D Disability Result 0 0 0 0 O 0 Retirement Rate 0% 0% 09 0% 0% Retirement Result 0 0 0 0 0 0 Vol. Sep Rate ON 0% 0% ON 0% Vol. Sep Result 0 0 O O 0 D Invol Sep Rale 0% 0% 094 09% 0 Promotion Rate ON 0% ON 0% 0% 0 0 0 0 0 Rate Changes Think about it, there really are only things that can change an employees job status: Death Disability. Retirement, Voluntary Separation, Involuntary Separation, and Promotion. Estimate the rates and insert your estimates in B11 to 16. Aho, estimate your company's growth rate since this can dramatically affect your hiring needs, 0% D 0 Plug in your rates in the cesto Occurace Death Disabaty Retirement Voluntary Separation Involuntary Separation Promotion Rate Company Growth Rate ON 0 0 OW 0% 0% 0 Look below and and you will find your results What will you do to improve of FTE 7 21 Required 7 21 Suite Executives Mind Manager Supervisors Team Leaders Entry Level Workers Growth Rate 100% 100% 100% 100% 100% Available 7 21 63 180 167 Need 0 0 0 0 0 0 Death Disability Retirement Voluntary Separation Involuntary Separation Promotion Rate 1 180 567 147 17 Revised Worksheet Initial Worksheet Sheet1 Vol. Sep Death Rate 8% Disability Rate 12% Total Number of FTES 7 20 63 189 067 847 C-Suite Executives Middle Managers Supervisors Team Leaders Entry Level Workers Total Result Death Resu 0 1 5 15 45 60 Disability Result 0 2 7 22 GA 99 Retirement Rate 206 2016 2015 2015, 20% Retirement Result 1 4 12 37 113 167 Vol. Sep Result 5 15 47 141 425 Rale 75% 75% 75% 75 75% Invol. Sep Rate 3% 34 3% 34 3% Invel. Sep Result 0 0 1 5 17 23 Promotior Rate 2% 2% 2% 2% 2% 8% 12% 12% 12% 6% lalalal Changes Occurance Death Disability Retirement Voluntary Separation Involuntary Separation Promotion to Company Growth Rate Rate 0% 12" 20 75% Think about it, there really are only things that can change an employees job status: Death, Disability, Retirement. Voluntary Separation, Involuntary Separation, and Promotion. Estimate the rates and insert your estimates in 811 to B16. Also, estimate your company's growth rate since this can dramatically affect your hiring needs Plug in your rates in the clis to the leelale II 3% 24 50 Look below and and you will find your results! Need Level G-Suite Executives Middle Managers Supervisors Team Leaders Entry Level Workers of PTE 7 21 03 100 567 Growth Rate Required 150 11 150% 150% 1509 150 sellel Available 2 1 -5 -10 -2 31 100 303 99 1370 Death Death Result 0 C-Suite Executives Middle Managers Supervisors Team Leaders Entry Level Workers Total Result Total Number of FTES 7 21 63 189 567 847 Rate 0% 0% 0% 0% 0% Disability Rate ON 0% ON ON 0% Invel Sep Result 0 0 0 0 D Disability Result 0 0 0 0 O 0 Retirement Rate 0% 0% 09 0% 0% Retirement Result 0 0 0 0 0 0 Vol. Sep Rate ON 0% 0% ON 0% Vol. Sep Result 0 0 O O 0 D Invol Sep Rale 0% 0% 094 09% 0 Promotion Rate ON 0% ON 0% 0% 0 0 0 0 0 Rate Changes Think about it, there really are only things that can change an employees job status: Death Disability. Retirement, Voluntary Separation, Involuntary Separation, and Promotion. Estimate the rates and insert your estimates in B11 to 16. Aho, estimate your company's growth rate since this can dramatically affect your hiring needs, 0% D 0 Plug in your rates in the cesto Occurace Death Disabaty Retirement Voluntary Separation Involuntary Separation Promotion Rate Company Growth Rate ON 0 0 OW 0% 0% 0 Look below and and you will find your results What will you do to improve of FTE 7 21 Required 7 21 Suite Executives Mind Manager Supervisors Team Leaders Entry Level Workers Growth Rate 100% 100% 100% 100% 100% Available 7 21 63 180 167 Need 0 0 0 0 0 0 Death Disability Retirement Voluntary Separation Involuntary Separation Promotion Rate 1 180 567 147 17