Think about it, there really 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.

Will it be easy to meet the needs or will it be difficult?

Describe the situation, discuss your concerns, and make at least three recommendations which you think could make the situation better.

What you think the company should be doing from an HR perspective to improve the situation?

Total Number Death Disability Retirement Vol. Sep Invol. Sep. Invol. Sep. Promotion Promotion of FTES Rate Rate Rate Rate Rate Result ** Rate Result C-Suite Executives 7 94% 7 94% 7 70% 5 40% 2 97% 2 5% 3 Middle Managers 21 94% 20 94% 19 70% 14 40% 6 97% 6 5% 1 6 Supervisors 63 94% 60 94% 57 70% 40 40% 16 97% 16 5% 1 18 Team Leaders 189 94% 178 94% 168 70% 118 40% 48 97% 47 5% 3 51 Entry Level Workers 567 94% 533 94% 502 70% 352 40% 141 97% 137 5% 7 130 847 798 753 529 213 208 12 208 Occurance Rate Changes Death 6% -49 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. Disability 6% -45 Plug in your rates in the cells to the left. Retirement 30% -224 Voluntary Separation 60% -316 Involuntary Separation 3% -5 One the next Sheet, I have included some rates for you to plug in to see what could happen under different scenarios. Promotion Rate 5% 12 40% Company Growth Rate 338.8 Look below and and you will find your results! Level # of FTES Growth Rate Required Available Need C-Suite Executives 7 140% 10 3 7 Middle Managers 21 140% 30 6 24 Supervisors 63 140% 89 18 71 Team Leaders 189 140% 265 51 214 567 Entry Level Workers 140% 794 130 664 847 1188 208 980 Total Number Death Disability Retirement Vol. Sep Invol. Sep. Invol. Sep. Promotion Promotion of FTES Rate Rate Rate Rate Rate Result ** Rate Result C-Suite Executives 7 94% 7 94% 7 70% 5 40% 2 97% 2 5% 3 Middle Managers 21 94% 20 94% 19 70% 14 40% 6 97% 6 5% 1 6 Supervisors 63 94% 60 94% 57 70% 40 40% 16 97% 16 5% 1 18 Team Leaders 189 94% 178 94% 168 70% 118 40% 48 97% 47 5% 3 51 Entry Level Workers 567 94% 533 94% 502 70% 352 40% 141 97% 137 5% 7 130 847 798 753 529 213 208 12 208 Occurance Rate Changes Death 6% -49 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. Disability 6% -45 Plug in your rates in the cells to the left. Retirement 30% -224 Voluntary Separation 60% -316 Involuntary Separation 3% -5 One the next Sheet, I have included some rates for you to plug in to see what could happen under different scenarios. Promotion Rate 5% 12 40% Company Growth Rate 338.8 Look below and and you will find your results! Level # of FTES Growth Rate Required Available Need C-Suite Executives 7 140% 10 3 7 Middle Managers 21 140% 30 6 24 Supervisors 63 140% 89 18 71 Team Leaders 189 140% 265 51 214 567 Entry Level Workers 140% 794 130 664 847 1188 208 980