In this technique, you will calculate the staffing requirements for Home Hardware Canada. Use the numbers in the staffing table below as your starting point for the current complement of personnel. Then factor in the changes anticipated for the coming year. As the final step, calculate the supply, demand, and total vacancies for each level of staffing.

For your calculations, click the Home Hardware Canada Requirements link and the use the spreadsheet provided.

The company has the following goals for next year:

• Open three new stores across the country. This will require 1 new regional manager. Each store requires 1 store manager, 2 assistant store managers, and 100 store associates.
• Outsource the administration of benefits and payroll to Ceridian Canada. This will decrease staffing by 1 manager, 2 assistant-manager, and 10 associates.
• Introduce a new SAP computer system to increase the efficiency of head office staff by 50 percent. This system will be staffed by 1 manager, 1 assistant-manager, and 5 associates.

Level	Position	Number	Quit	Retiring	New Stores	Cerdian	Sap	Attrition
1	CEO	1	0	0	0	0	0	0
2	Vice-President	5	0	2	0	0	0	2
3	Assistant Vice-President	15	1	3	0	0	0	4
4	Regional Manager	30	4	3	1	0	0	5
5	Manager	300	15	7	3	-1	1	47
6	Assistant Manager	900	97	21	6	-2	1	87
7	Associate	30,000	473	0	300	-10	5	300

For this technique, points are assigned to each of the following categories:

1. Identify the Number of Staff in each level (2 points).
2. Identify the Total Change for coming year (2 points).
3. Identify the Total Vacancies by level of staffing (2 points).
4. Identify the Estimated Supply (2 points).
5. Identify the Estimated Demand (2 points).