$1.$ Fill in table $1.$

$1\mathrm{.}1.$ In Current staffing put the workforce compliment from table $1.$

$1\mathrm{.}2.$ Estimate the change for each level based on the information provided in items $2($SVP and VP$),$

$3($directors$,$ senior managers, managers, associates and assistants for $3$ new offices$),$ and $4($implementation of the new IT system$).$

Please consider that increase in productivity for assistants means you need to plan staff reduction for assistants.

Use brackets for estimated decrease, e$.$g$.$ for $3$ positions to be outsources use $(3).$

$1\mathrm{.}3.$Calculate Total HR Demand: Total demand $=$ Current staffing $+$ Total changes

$1\mathrm{.}4.$ Fill in losses and calculate total losses.

$1\mathrm{.}5.$ Calculate Total HR Supply: Total supply$=$ Current staffing $$ Total losses

$1\mathrm{.}6.$ Forecast the number of vacancies:

$1\mathrm{.}7.$ Positions to be filled $=$ Total HR Demand $-$ Total HR Supply

$2.$ Fill in tables $2$ and $3-$ external supply table for external hiring considering two options:

$$ Internal hiring only

$$ Mixture of internal and external hiring as described in item $7$b of the case.

Please consider at this stage of planning that internal promotions possible only from the previous level of positions $($e$.$g$.,$ from level $4$ to level $5).$

This means that to calculate Outflows for the level you need to add $$positions to be filled$$ for this level and $$promotions into the level$$ for the next higher level.

Please also consider that 'internal hiring only' means that you promote all the internal candidates you have available, but need to hire externaly for all the rest of vacances.

Table $1$ See sample in table $6\mathrm{.}2$ p$\mathrm{.}153$

Level Current staffing Changes in needs Losses Total demand $=$ Current staffing $+$ Total changes Total supply$=$ Current staffing $$ Total losses Positions to be filled

New positions Outsources positions IT system outcomes Total changes Quits Dismissals Retirements Total losses

$1$ CEO $1$

$2$ EVP $5$

$3$ SVP $10$

$4$ VP $20$

$5$ Director $100$

$6$ Sr$.$ Manager $200$

$7$ Manager $400$

$8$ Associate $500$

$9$ Assistant $1,200$

Total

Table $2$ External Hiring if exclusively promote from within $($see sample table $6\mathrm{.}4,$ p$\mathrm{.}154)$

Level Number of the start of the year Positions to be filled Promotions into the level Level outflows External hiring

$1$ CEO

$2$ EVP

$3$ SVP

$4$ VP

$5$ Director

$6$ Sr$.$ Manager

$7$ Manager

$8$ Associate

$9$ Assistant

Table $3$ External Hiring if external and internal supply mix

Level Number of the start of the year Positions to be filled Promotions into the level Level outflows External hiring

$1$ CEO

$2$ EVP

$3$ SVP

$4$ VP

$5$ Director

$6$ Sr$.$ Manager

$7$ Manager

$8$ Associate

$9$ Assistant