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.

Play around with the first page of the worksheet and estimate the rates and insert your estimates in the attached spreadsheet and estimate your company's growth rate since this can dramatically affect your hiring needs.

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 and the following conditions:

Death = 2%

Disability = 5%

Retirement = 10%

Voluntary Separation = 25%

Involuntary Separation = 10%

Promotion Rate = 5%

Growth Rate = 35%

Punch the numbers into the spreadsheet and tell us what the results imply for your company? Will it be easy to meet the needs or will it be difficult? Describe your situation and discuss your concerns and recommendations – what you think the company should be doing from an HR perspective.

Prepare a memo to the CEO which addresses your concerns and recommendations.