Table 1.1 Markov Analysis Information Transition probability matrix (1) Store associate (2) Shift leader (3) Department manager (4) Assistant store manager (5) Store manager Previous Forecast of availabilities Previous (1) Store associate (2) Shift leader (3) Department manager (4) Assistant store manager (5) Store manager Gap analysis Year end total (column sum) External hires needed (current workforce-total) Current Workforce 8,500 1,200 850 150 50 (1) 0.53 0.00 0.00 0.00 0.00 (1) 4505 Current year (2) (3) (4) (5) Exit 0.06 0.00 0.00 0.00 0.41 0.50 0.16 0.00 0.00 0.34 0.00 0.58 0.12 0.00 0.30 0.06 0.46 0.08 0.40 0.00 0.00 0.00 0.00 0.66 0.34 Next year (projected) (2) (3) (4) (5) Exit 510 600 0 0 0 0 0 0 192 0 0 493 102 0 9 69 0 0 3485 408 255 12 60 33 17 Next year (projected) (1) 4505 1110 694 171 3995 90 156 -21 45 5 A. What is the percentage of turnover of store associates?. B. Next year, it is estimated that how many department managers will be promoted to assistant store manager? C. Explain why the company needs only 90 more shift leaders next year. D. What is one workforce planning strategy you would advise the company to use next year for: 1. Assistant store manager II. Store associate III. Shift leader Table 1.1 Markov Analysis Information Transition probability matrix (1) Store associate (2) Shift leader (3) Department manager (4) Assistant store manager (5) Store manager Previous Forecast of availabilities Previous (1) Store associate (2) Shift leader (3) Department manager (4) Assistant store manager (5) Store manager Gap analysis Year end total (column sum) External hires needed (current workforce-total) Current Workforce 8,500 1,200 850 150 50 (1) 0.53 0.00 0.00 0.00 0.00 (1) 4505 Current year (2) (3) (4) (5) Exit 0.06 0.00 0.00 0.00 0.41 0.50 0.16 0.00 0.00 0.34 0.00 0.58 0.12 0.00 0.30 0.06 0.46 0.08 0.40 0.00 0.00 0.00 0.00 0.66 0.34 Next year (projected) (2) (3) (4) (5) Exit 510 600 0 0 0 0 0 0 192 0 0 493 102 0 9 69 0 0 3485 408 255 12 60 33 17 Next year (projected) (1) 4505 1110 694 171 3995 90 156 -21 45 5 A. What is the percentage of turnover of store associates?. B. Next year, it is estimated that how many department managers will be promoted to assistant store manager? C. Explain why the company needs only 90 more shift leaders next year. D. What is one workforce planning strategy you would advise the company to use next year for: 1. Assistant store manager II. Store associate III. Shift leader