Using Tanglewood Case Study

INCORRECT ANSWER WAS RECEIVED BEFORE.. SO POSTING QUESTION AGAIN. PLEASE REVIEW NUMBERS AND DATA ACCORDINGLY.

a.) Currently the organization expects their forecast for labor requirements using ratio analysis. This means that the forecast for next year's labor requirements will be reduced by 10%. (EXCEL BELOW)

b.) Fill in the empty cells in the forecast of labor requirements and availability in Table 1.1 (EXCEL BELOW)

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. (EXCEL BELOW)

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.

PLEASE ANSWER A-E ABOVE AND COMPUTE CALCULATIONS FOR CELLS WITH QUESTION MARKS. THANK YOU!

Transition Probability Matrix		Current year
			Store associate	Shift leader	Department manager	Assistant store manager	Store manager	Exit
Previous	Store associate		0.56	0.05	0	0	0	0.39
	Shift leader		0	0.5	0.14	0	0	0.36
	Department manager		0	0	0.6	0.15	0	0.25
	Assistant store manager		0	0	0.08	0.5	0.1	0.32
	Store manager		0	0	0	0	0.75	0.25
			Store associate	Shift leader	Department manager	Assistant store manager	Store manager
Forecast of requirement			7650	?	?	?	?
Forecast of availability			Next year (projected)
			Store associate	Shift leader	Department manager	Assistant store manager	Store manager	Exit
Current Workforce
Previous	Store associate	8500	4760	425	0	0	0	3315
	Shift leader	1200	0	?	?	0	0	?
	Department manager	850	0	0	?	?	0	?
	Assistant store manager	160	0	0	?	?	?	?
	Store manager	50	0	0	0	0	?	?
Gap Analysis			Store associate	Shift leader	Department manager	Assistant store manager	Store manager	Exit
	Year end total		4760	?	?	?	?	?
	External hires needed		2890	?	?	?	?	?