Question
Using Tanglewood Case Study a.) Currently the organization expects their forecast for labor requirements using ratio analysis. This means that the forecast for next year's
Using Tanglewood Case Study
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 | ? | ? | ? | ? | ? | ||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Ethical Obligations and Decision Making in Accounting Text and Cases
Authors: Steven M. Mintz, Roselyn E. Morris
5th edition
1259969460, 73403997, 1260480852, 978-1259969461
