1. Currently the organization expects that their forecast for labor requirements is essentially constant from the previous year. Based on this assumption complete the five stages of the planning process: a. Currently the organization expects that their forecast for labor requirements is essentially constant from the previous year. This means the forecast for next year will be taken as given. b. Fill in the empty cells in the forecast of labor availabilities in Table 1.1. c. Conduct an environmental scan. Based on the environmental data, what factors in the environment suggest Tanglewood might have difficulty filling their vacancies in the future? d. Compute year end totals for each job in Table 1.1 and do a gap analysis to determine where shortages will occur in the next year. e. Develop a preliminary statement of the action plan for hiring for Washington next year. This should be an overview of the number of individuals needed to meet projected staffing levels for various positions that can be given to store managers. Make sure that your recommendations take the strategic staffing levels issues from the introductory case into account. 2. Examine the percentages of employee representation across demographic categories for Tanglewood and the available labor market for Table 1.3. Are there any particular classes or jobs where the representation within Tanglewood appears to be out of line with the available workforce? What does the pattern suggest to you? 3. Based on your analysis and the affirmative action plan, do you think the company should engage in a specific strategy to change their recruiting and promotion practices? Do you think it is realistic for the company to try to meet their affirmative action goals in this process in a single year? What are the pros and cons of using internal promotions vs. external hiring to rectify the problems with gender and ethnicity representation in supervisory positions? 4. In addition to the specific targets for employee representation for the Spokane flagship location, Tanglewood wants to use this opportunity to establish estimates for the entire chain's staffing policy regarding demographic representation of the workforce. How do you think individual stores can respond to overarching organizational objectives? Prepare a memo to be disseminated to the individual stores that gives a sense of your targets for the organization as a whole, and also gives the stores advice on how they can assist in narrowing any representation gaps you find through their recruiting, hiring, and promotion practices 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 year Current year (1) (2) (3) (5) Exit 0.43 0.06 0.00 0.00 0.00 0.51 0.00 0.54 0.16 0.00 0.00 0.30 0.00 0.00 0.64 0.06 0.00 0.30 0.00 0.00 0.06 0.52 0.08 0.34 0.00 0.00 0.00 0.00 0.66 0.34 Forecast of availabilities (1) Next year (projected) (5) Exit 0 0 0 4335 Previous year (1) Store associate (2) Shift leader (3) Department manager (4) Assistant store manager (5) Store manager Current Workforce 8,500 1,200 850 150 50 3655 510 0 0 0 Gap analysis Next year (projected) (1) (2) 3655 Year end total (column sum) External hires needed (current workforce-total) Forecasting Labor Requirements 4845 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 Current year Exit 0.06 0.00 0.00 0.00 0.51 0.54 0.16 0.00 0.00 0.30 0.00 0.64 0.06 0.00 0.30 0.00 0.06 0.52 0.08 0.34 0.00 0.00 0.00 0.66 0.34 0.43 0.00 0.00 0.00 0.00 Previous year Forecast of availabilities Next year (projected) (2) (5) Exit (1) Current Workforce 8,500 1,200 3655 510 0 0 0 4335 Previous yer (1) Store associate (2) Shift leader (3) Department manager (4) Assistant store manager (5) Store manager 850 OOO. 150 50 Gap analysis Next year (projected) (1) (2) 3655 (5) Year end total (column sum) External hires needed (current workforce-total) Forecasting Labor Requirements h 4845 1. Currently the organization expects that their forecast for labor requirements is essentially constant from the previous year. Based on this assumption complete the five stages of the planning process: a. Currently the organization expects that their forecast for labor requirements is essentially constant from the previous year. This means the forecast for next year will be taken as given. b. Fill in the empty cells in the forecast of labor availabilities in Table 1.1. c. Conduct an environmental scan. Based on the environmental data, what factors in the environment suggest Tanglewood might have difficulty filling their vacancies in the future? d. Compute year end totals for each job in Table 1.1 and do a gap analysis to determine where shortages will occur in the next year. e. Develop a preliminary statement of the action plan for hiring for Washington next year. This should be an overview of the number of individuals needed to meet projected staffing levels for various positions that can be given to store managers. Make sure that your recommendations take the strategic staffing levels issues from the introductory case into account. 2. Examine the percentages of employee representation across demographic categories for Tanglewood and the available labor market for Table 1.3. Are there any particular classes or jobs where the representation within Tanglewood appears to be out of line with the available workforce? What does the pattern suggest to you? 3. Based on your analysis and the affirmative action plan, do you think the company should engage in a specific strategy to change their recruiting and promotion practices? Do you think it is realistic for the company to try to meet their affirmative action goals in this process in a single year? What are the pros and cons of using internal promotions vs. external hiring to rectify the problems with gender and ethnicity representation in supervisory positions? 4. In addition to the specific targets for employee representation for the Spokane flagship location, Tanglewood wants to use this opportunity to establish estimates for the entire chain's staffing policy regarding demographic representation of the workforce. How do you think individual stores can respond to overarching organizational objectives? Prepare a memo to be disseminated to the individual stores that gives a sense of your targets for the organization as a whole, and also gives the stores advice on how they can assist in narrowing any representation gaps you find through their recruiting, hiring, and promotion practices 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 year Current year (1) (2) (3) (5) Exit 0.43 0.06 0.00 0.00 0.00 0.51 0.00 0.54 0.16 0.00 0.00 0.30 0.00 0.00 0.64 0.06 0.00 0.30 0.00 0.00 0.06 0.52 0.08 0.34 0.00 0.00 0.00 0.00 0.66 0.34 Forecast of availabilities (1) Next year (projected) (5) Exit 0 0 0 4335 Previous year (1) Store associate (2) Shift leader (3) Department manager (4) Assistant store manager (5) Store manager Current Workforce 8,500 1,200 850 150 50 3655 510 0 0 0 Gap analysis Next year (projected) (1) (2) 3655 Year end total (column sum) External hires needed (current workforce-total) Forecasting Labor Requirements 4845 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 Current year Exit 0.06 0.00 0.00 0.00 0.51 0.54 0.16 0.00 0.00 0.30 0.00 0.64 0.06 0.00 0.30 0.00 0.06 0.52 0.08 0.34 0.00 0.00 0.00 0.66 0.34 0.43 0.00 0.00 0.00 0.00 Previous year Forecast of availabilities Next year (projected) (2) (5) Exit (1) Current Workforce 8,500 1,200 3655 510 0 0 0 4335 Previous yer (1) Store associate (2) Shift leader (3) Department manager (4) Assistant store manager (5) Store manager 850 OOO. 150 50 Gap analysis Next year (projected) (1) (2) 3655 (5) Year end total (column sum) External hires needed (current workforce-total) Forecasting Labor Requirements h 4845