need clarification of the solution!

10 1. Workforce complement at M&K as of the end of this year is as follows: CEO Level 1 1 Executive Vice-President Level 2 5 Senior Vice-President Level 3 Vice-President Level 4 20 Director Level 5 100 Senior Manager Level 6 200 Manager Level 7 400 Associate Level 8 500 Assistant Level 9 1,200 2. The staffing levels for CEO and EVPs are to remain unchanged next year. The number of SVP and VPs required are dependent on annual revenues. Staffing levels for SVPs and VPs are considered to be optimal in this year Revenue generated for the year 2011 was $2 billion with 10 SVPs and 20 VPThe revenue level for next year is expected to reach 53 billion. 3. The company is planning to open three additional offices across the country next year. Each office requires directors, 15 senior managers, 30 managers, 50 associates, and 80 assistants. 4. The company will also be outsourcing its payroll and benefits adminis- tration to DS next year. The company is also getting rid of its donut business because they are not good for you. Currently, 15 directors, 20 senior managers, 30 managers , 50 associates, and 150 assistants are involved in these activities. 5. Introduction of a new computer system will increase the productivity of the assistants by 50 percent but will require hiring a team of technical staff, which will include 5 senior managers, 10 managers, and so associates. 6. Forecasted losses for next year are as follows: Quits (%) Dismissals (%) Retirements (X) Level 1 Level 2 20 Level 3 Level 4 Level 5 Level 6 10 Level 7 5 Level 8 10 Level 9 5 7 M&K has two HR supply policies, as follows: a. Exclusively promote from within b. A combination of internal promotion and external hires, as follows: Inside (5) Outside (%) Level 1 0 Level 2 80 20 Level 3 70 30 Level 4 40 Level 5 0 20 0 0 0 10 10 0 5 40 15 50 30 40 OOOOOO880 100 S 8 10 0 0 5 9.OOOOO the assistants by 50 percent but will require hiring a team of technical stat it will include 5 senior managers, 10 managers, and 50 2006 6. Forecasted losses for next year are as follows: Duits (%) Dismissals Retirements Level 1 0 0 0 Level 2 20 0 Level 3 10 10 Level 4 10 Level 5 40 Level 6 15 10 Level 7 50 5 Level 8 30 10 Level 9 40 5 7 M&K has two HR supply policies, as follows: a. Exclusively promote from within b. A combination of internal promotion and external hires, as follows: Inside (6) Outside (6) Level 1 100 0 Level 2 80 20 Level 3 70 30 Level 4 60 40 Level 5 50 50 Level 6 40 60 Level 7 30 70 Level 8 20 80 Level 9 0 100 & According to information stored on M&K's comprehensive HRIS system annual employee movements between levels 5 to 9 in last year are as follows: Level 4 Level 5 Level 6 Level 7 Level 8 Level 9 Exit Total Level 5 10 80 5 5 100 Level 6 10 160 30 200 Level 7 20 360 20 400 Level 8 70 455 175 700 Level 9 300 500 200 1000 9. M&K has also been tracking its revenues against the number of managers on staff. Below is the information obtained from McK's ERP: Year No. of Managers Revenues (58) This year (year 400 2 Year X-1 320 1.8 Year X-2 250 1.5 Year X-3 200 13 Year X-4 150 1.0 QUESTIONS 1. Estimate the total HR demand for M&K for next year, by job level (15 marks) Level 1 100 0 Level 2 80 20 Level 3 70 30 Level 4 60 Level 5 50 50 Level 6 40 60 Level 7 30 70 Level 8 20 80 Level 9 0 100 & According to information stored on M&K's comprehensive HRIS system, annual employee movements between levels 5 to 9 in last year are as follows Level 4 Level 5 Level 6 Level 7 Level 8 Level 9 Exit Total Level 5 10 805 5 100 Level 6 10 160 30 200 Level 7 20 360 20 Level 8 70 455 175 700 Level 9 300 500 200 1000 9. M&K has also been tracking its revenues against the number of managers on staff. Below is the information obtained from McK's ERP: No. of Managers Revenues (58) This year (year 400 2 Year X-1 320 18 Year Year X-2 Year X-3 Year X-4 250 200 15 13 1.0 150 QUESTIONS 1. Estimate the total HR demand for M&K for next year, by job level. (15 marks) 2. Estimate changes in HR supply for M&K for next year, by job level. (15 marks) 3. Calculate the number of employee movements if M&K uses: a. Exclusively a "promote from within" policy, or (15 marks) b. A mix of internal and external supply as detailed in item 7b As HR Director, what do you see as some of the talent strategies and plans that have to be in place to facilitate each of the above options? (15 marks)