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
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
Total Number of FTES 7 21 Invol. lop. Rato 0% Death Rato 09 0% 0% 09 0% 046 Dicability Rato 0% On 09 09 04 C. Bulte Exeoutlves Middio Managers Supervisor Team Leaders Entry Lovol Workort Total Rotuit Death Retur! 0 0 0 0 o 0 0 O 0% Dicability Rotiromont Rotirement Result Rate Rocult 0 05 0 0 O 0 0 0 09 O o OS 0 09 O O O 0 Vol. Sop. Rato 0% 055 0% 09 05 Vol. Sop Result O 0 0 0 0 0 O 0 Invol. Bop. Promotion Promotion Total Turnover Rosult Rata Rosult 0 09 0 O 05 0 o 09 0 O 09 o 0 09 O 0 09 09 189 567 347 Changes 0 O 0 Obouranon Death Disability Retirement Voluntary operation Involuntary separation Promotion Rate Company Orowth Rato Rata 05 04 09 09 04 04 09 Plug in your rates in the ces to the Think about it, there really are only things that can change an employees Job status: Death Disability, Rotirement, voluntary Boparation, Involuntary Reparation, and Promotion. Estimate the rates and incort your oclimates in B11 to 816. Alco, estimate your company'e growth rato cince this on dramatically attoot your hiring neede. g 0 Look below and and you will find your retuite What will you do to improve of FTEC 7 Nood 0 0 Lovel 0.Bulte Exeoutivet Middle Managers Supervisor Team Landare Entry Layal Workers Orowth Rato Required 1004 7 1009 21 1005 63 4004 189 100% 567 847 Available 7 7 21 63 189 567 Death Dicability Retirement Voluntary Boparation Involuntary deparation Promotion Rate 189 967 347 O 0 0 0 Promotion Invol. Sep Vol. Sep. Vol. Sep Invol. Sep Promotion Total Turnover Popule TPM Danh nisability Disability Retirement Retirement har nath C-Suite Executives Middle Managers Supervisors Team Leaders Entry Level Workers Total Result Total Number of FTES 7 21 ed 63 189 587 847 Death Rate 8% 8% 8% 8 8% Death Result 0 1 5 15 45 88 Disability Disability Retirement Retirement Rate Result Rate Result 12% 0 20% 1 12% 2 2 20% 4 12% 7 20% 40 12 12% 22 20% 37 12% 68 20% 113 99 167 Vol. Sep Rate 75% 75% 75% 75% 75% Vol. Sep Result 5 15 47 141 425 633 Invol. Sep Rate 3% 3% 3% 3% 3% Invol. Sep Result 0 0 0 1 5 17 23 Promotion Rate 2% 2% 2% 2 2% Promotion Total Turnover Result 8 22 2 72 4 220 12 888 19 988 Occurance Death Disability Retirement Voluntary Separation Involuntary Separation Promotion Rate Company Growth Rate Rate 8% 12% 20% 75% 3% % 2% 50% Changes 66 99 167 633 23 Plug in your rates in the cells to the left Think about it, there really are only 6 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 B16. Also, estimate your company's growth rate since this can dramatically affect your hiring needs. 423.5 Look below and and you will find your results! Level C-Suite Executives Middle Managers Supervisors Team Leaders Entry Level Workers # of FTES 7 21 83 189 587 847 Growth Rate Required Available 150% 11 2 150% 32 1 150% 95 -5 150% 284 -19 150% 851 -82 1273 Need 9 31 100 303 933 1370 Revised Worksheet Initial Worksheet Sheet1 Vol. Sep Death Rate Total Number of FTES 7 21 Death Result 0 Disability Rate 12% Disability Result 0 2 Rate 75% 75% Retirement Rate 2015 20% 20% 20% 20 C-Suite Executives Middle Managers Supervisors Team Leaders Entry Level Workers Total Result 14 14 Retirement Result 1 4 12 37 113 167 Vol. Sep Result 5 15 47 141 425 633 Invol. Sep Rate 3% 3% 3% 34 3% 759 Invol. Sep. Result 0 0 1 5 17 23 Promotior Rate 29 2% 2% 2% 2% 8% 8% 6% 12% 189 067 847 22 5 15 45 50 75% 75% 99 Changes Rate A% 12%. 20% 75% Occurance Death Disability Retirement Voluntary Separation Involuntary Separation Promotion to Company Growth Rate Plug in your rates in the listot 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 B16. Also, estimate your company's growth rate since this can dramatically affect your hiring needs 167 Teleph 3% 24 50% 4235 Look below and and you will find your resulta! Level G-Suite Executives Middle Managers Supervisors Team Leaders Entry Level Workers of PTE 7 21 3 18 167 842 Growth Rate Required 150% 11 150% 150% 150% 2014 150 1273 Sellel Available 2 1 -5 .19 -12 Need . 31 100 303 933 1370 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 Death Rate 0% 0% 0% 0% 0% Disability Rate OX 0% 0% OX 0% 0 0 0 Invel Sep Result 0 0 Disability Result 0 0 0 0 9 0 Retirement Rate 0% 0% 094 0% 0% Retirement Result 0 0 0 0 0 0 Vol. Sep Rate ON 0% 0% ON 0% Vol. Sep Result 0 0 D 0 0 O Invol Sep Rale 0% 0% 096 0% 0% Promotion Rate 0 0% ON 0% 0% O 0 0 0 0 Rate 0% OX ox ON Changes 0 0 0 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 11 to 016. Also, estimate your company's growth rate since this can dramatically affect your hiring needs Occurance Death Disability Retirement Voluntary Separation Involuntary separation Promotion Rate Company Greath Rate Plug in your rates in the ces to 0 0 OX 0 0% 0 Look below and and you will find your resulta What will you de to improve Required 7 Lovel C-Suite Executives Middle Managers Supervisors Team Leaders Entry Level Workers of FTES 7 21 63 180 567 17 Growth Rate 100% 100% 100% 100% 100% Elle Available 7 20 63 180 Need 0 0 0 0 0 0 Death Disability Retirement Voluntary Separation Involuntary Separation Promotion Rate Total Number of FTES 7 21 Invol. lop. Rato 0% Death Rato 09 0% 0% 09 0% 046 Dicability Rato 0% On 09 09 04 C. Bulte Exeoutlves Middio Managers Supervisor Team Leaders Entry Lovol Workort Total Rotuit Death Retur! 0 0 0 0 o 0 0 O 0% Dicability Rotiromont Rotirement Result Rate Rocult 0 05 0 0 O 0 0 0 09 O o OS 0 09 O O O 0 Vol. Sop. Rato 0% 055 0% 09 05 Vol. Sop Result O 0 0 0 0 0 O 0 Invol. Bop. Promotion Promotion Total Turnover Rosult Rata Rosult 0 09 0 O 05 0 o 09 0 O 09 o 0 09 O 0 09 09 189 567 347 Changes 0 O 0 Obouranon Death Disability Retirement Voluntary operation Involuntary separation Promotion Rate Company Orowth Rato Rata 05 04 09 09 04 04 09 Plug in your rates in the ces to the Think about it, there really are only things that can change an employees Job status: Death Disability, Rotirement, voluntary Boparation, Involuntary Reparation, and Promotion. Estimate the rates and incort your oclimates in B11 to 816. Alco, estimate your company'e growth rato cince this on dramatically attoot your hiring neede. g 0 Look below and and you will find your retuite What will you do to improve of FTEC 7 Nood 0 0 Lovel 0.Bulte Exeoutivet Middle Managers Supervisor Team Landare Entry Layal Workers Orowth Rato Required 1004 7 1009 21 1005 63 4004 189 100% 567 847 Available 7 7 21 63 189 567 Death Dicability Retirement Voluntary Boparation Involuntary deparation Promotion Rate 189 967 347 O 0 0 0 Promotion Invol. Sep Vol. Sep. Vol. Sep Invol. Sep Promotion Total Turnover Popule TPM Danh nisability Disability Retirement Retirement har nath C-Suite Executives Middle Managers Supervisors Team Leaders Entry Level Workers Total Result Total Number of FTES 7 21 ed 63 189 587 847 Death Rate 8% 8% 8% 8 8% Death Result 0 1 5 15 45 88 Disability Disability Retirement Retirement Rate Result Rate Result 12% 0 20% 1 12% 2 2 20% 4 12% 7 20% 40 12 12% 22 20% 37 12% 68 20% 113 99 167 Vol. Sep Rate 75% 75% 75% 75% 75% Vol. Sep Result 5 15 47 141 425 633 Invol. Sep Rate 3% 3% 3% 3% 3% Invol. Sep Result 0 0 0 1 5 17 23 Promotion Rate 2% 2% 2% 2 2% Promotion Total Turnover Result 8 22 2 72 4 220 12 888 19 988 Occurance Death Disability Retirement Voluntary Separation Involuntary Separation Promotion Rate Company Growth Rate Rate 8% 12% 20% 75% 3% % 2% 50% Changes 66 99 167 633 23 Plug in your rates in the cells to the left Think about it, there really are only 6 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 B16. Also, estimate your company's growth rate since this can dramatically affect your hiring needs. 423.5 Look below and and you will find your results! Level C-Suite Executives Middle Managers Supervisors Team Leaders Entry Level Workers # of FTES 7 21 83 189 587 847 Growth Rate Required Available 150% 11 2 150% 32 1 150% 95 -5 150% 284 -19 150% 851 -82 1273 Need 9 31 100 303 933 1370 Revised Worksheet Initial Worksheet Sheet1 Vol. Sep Death Rate Total Number of FTES 7 21 Death Result 0 Disability Rate 12% Disability Result 0 2 Rate 75% 75% Retirement Rate 2015 20% 20% 20% 20 C-Suite Executives Middle Managers Supervisors Team Leaders Entry Level Workers Total Result 14 14 Retirement Result 1 4 12 37 113 167 Vol. Sep Result 5 15 47 141 425 633 Invol. Sep Rate 3% 3% 3% 34 3% 759 Invol. Sep. Result 0 0 1 5 17 23 Promotior Rate 29 2% 2% 2% 2% 8% 8% 6% 12% 189 067 847 22 5 15 45 50 75% 75% 99 Changes Rate A% 12%. 20% 75% Occurance Death Disability Retirement Voluntary Separation Involuntary Separation Promotion to Company Growth Rate Plug in your rates in the listot 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 B16. Also, estimate your company's growth rate since this can dramatically affect your hiring needs 167 Teleph 3% 24 50% 4235 Look below and and you will find your resulta! Level G-Suite Executives Middle Managers Supervisors Team Leaders Entry Level Workers of PTE 7 21 3 18 167 842 Growth Rate Required 150% 11 150% 150% 150% 2014 150 1273 Sellel Available 2 1 -5 .19 -12 Need . 31 100 303 933 1370 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 Death Rate 0% 0% 0% 0% 0% Disability Rate OX 0% 0% OX 0% 0 0 0 Invel Sep Result 0 0 Disability Result 0 0 0 0 9 0 Retirement Rate 0% 0% 094 0% 0% Retirement Result 0 0 0 0 0 0 Vol. Sep Rate ON 0% 0% ON 0% Vol. Sep Result 0 0 D 0 0 O Invol Sep Rale 0% 0% 096 0% 0% Promotion Rate 0 0% ON 0% 0% O 0 0 0 0 Rate 0% OX ox ON Changes 0 0 0 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 11 to 016. Also, estimate your company's growth rate since this can dramatically affect your hiring needs Occurance Death Disability Retirement Voluntary Separation Involuntary separation Promotion Rate Company Greath Rate Plug in your rates in the ces to 0 0 OX 0 0% 0 Look below and and you will find your resulta What will you de to improve Required 7 Lovel C-Suite Executives Middle Managers Supervisors Team Leaders Entry Level Workers of FTES 7 21 63 180 567 17 Growth Rate 100% 100% 100% 100% 100% Elle Available 7 20 63 180 Need 0 0 0 0 0 0 Death Disability Retirement Voluntary Separation Involuntary Separation Promotion Rate
