Scenario The company has the following goals for next year: Open three new offices across the country. Each office requires 5 directors, 15 senior managers, 30 managers, 50 associates, and 80 assistants. Discontinue the Highway Signage group, which is losing money. This will decrease staffing by 15 directors, 20 senior managers, 30 managers, 50 associates, and 150 assistants. Introduce a new computer system to increase efficiency. This system requires 5 senior managers, 10 managers, and 50 associates. Level Position Number Quit Retiring Attrition 1 CEO 1 0 0 0 2 Executive Vice-President 5 2 2 2 3 Senior Vice-President 10 5 5 4 4 Vice-President 20 10 0 5 5 Director 100 40 0 31 6 Senior Manager 200 15 0 47 7 Manager 400 50 0 87 8 Associate 500 30 0 150 9 Assistant 12,000 40 0 300 Tip: If you are not sure how to perform the calculations, review the explanation for using Markov Analysis on the Commentary page. Instructions To complete your calculations: Click the link above to open the spreadsheet and save a copy to your local computer. Fill out the table on the Positions to Fill tab of the worksheet provided. Fill out the table on the Position Movement tab of the worksheet provided. Analyze the results to answer the questions below. Questions Answer these questions in your journal: What is the number of promotions if the organization uses a promote from within policy? What is the number of employee movements if the organization uses a promote from within policy? Provide Positions to Fill and a Position Movement table for each condition to prove your answer.