Flows Analysis T1 T2 Unskilled Skilled Supervisor Manager Exit Unskilled 100 50 30 20 Skilled 50 40 5 Supervisor 30 25 5 Manager 20 15 Total 200 50 70 30 20 30 Transition Rates T2 Supervisor Manager Unskilled 50% Unskilled Skilled Skilled 30% 80% Exit 20% 10% Supervisor 83.33% 16.67% Manager 75% The Flows Analysis shows the movement of employees in each job from the beginning of the year (T1) to the end of the year (T2) The numbers in red show where the employees moved. For example, the company started with year with 100 Unskilled workers. By the end of the year, 50 were still in the same job as Unskilled workers, 30 had been promoted to Skilled worker, and 20 left the company. The Transition Rates chart shows that same information in percentage form. For example, since 50 of the original 100 Unskilled workers were still in the job at the end of the year, that means the job has a Retention Rate of 50%. Since 30 of those 100 Unskilled workers were promoted to Skilled worker, that means the job has a Promotion Rate of 30% from Unskilled worker to Skilled worker. Since 20 of the original 100 workers left the company, that means the job had a Turnover rate of 20%. Retention Rate: % of employees who remain in the same job Promotion Rate: % of employees who are promoted Turnover Rate: % of employees who leave To complete this table, you need to click in each cell with grey shading and enter the correct number for the Flows Analysis (there are 3 of these cells) and the correct percentage for the Transition Rates (there are 3 of these cells)