Assignment

This assignment is worth 10% of your final grade
This assignment is due March 18th
Please hand in your assignment at the beginning of class. Include a cover page indicating (at a minimum):
Your name
The course
My name
Please show all of your work if you want part marks

Part 1 – HR Demand (5 marks each/10 marks total)

Perform a trend analysis for the following two sets of data (note: forecasted years are bold and italicized).

Scenario one

You are working for the Georgian College dating service. Customer service representatives sign prospective service users to contracts. In five years there has been substantial growth and your boss has requested that you estimate staffing levels for the next three years based on his estimate of future contracts.

Year Number of Contracts signed
(000’s) Customer service representatives 06 1.5 9 07 2.0 14 08 3.0 21 09 3.8 25 10 4.2 27 11 4.8 12 5.3 13 5.5

Scenario 2

You work for a manufacturing company that paints Easter Eggs. Each March the company hires factory staff to paint the eggs to sell around Easter weekend in April. The president has come to you asking how many people he should hire in March to work in the plant. He would like you to estimate staffing levels for the next two years as well.

Year Units Produced
(000’s) Workers required 07 2.3 10 08 2.6 11 09 3.3 13 10 3.9 16 11 4.5 12 4.75 13 5.0
Part 2 – HR Supply (5 marks each/10 marks total)

As a result of the high mark you achieved in your HR Planning class at Georgian College, you have been hired as an HR consultant by a local company to calculate their vacancy model and movement analysis for next year’s HR forecast.

You have been provided with the following information:

Workforce compliment at the beginning of the period:
Salary Level 1 = 1
Salary Level 2 = 5
Salary Level 3 = 25
Salary Level 4 = 100

There will be no organizational growth.

HR losses are expected…