Question

Q4. Turnover

a) Using the Past and Current Employees tab, summarize the nature and total amount of

turnover in each of the following years:

Year

2020

2021

2022

b) What is the overall turnover rate in each year?

Unit

#

20

40

60

80

100

120

140

Discharged

Number of

Individuals

Employed on

January 1,

2022

Year

2020

2021

2022

c) Report the requested information, ultimately so that you can compute the unit turnover

rate in 2022, for the stores listed below.

Quit

Number of

Individuals

Employed on

December 31,

2022

Turnover Rate

Total Number Who

Left the Company

Average 2022

Headcount

Number of people

who left unit in 2022

(i.e., turnover count)

Unit

Turnover

Rate/n

Question image 1Question image 2