Q3. Headcount
a) Fill in the table below for the current employees in Mr. Macky's.
Job Titles
Number of Females Number of URM*
Assistant Manager
Manager
Non-Exempt
Employees (All)
b) Fill in appropriate data for each date
# Hired
On or
Before
Date and
Date
January 1, 2020
December 31, 2020
January 1, 2021
December 31, 2021
January 1, 2022
December 31, 2022
Average
Still
Employed
# Hired On or
Before Date but
Terminated on
or after
specified date
Year
2020
2021
2022
#
Employed
on
Specified
Date
Year
2020
2021
2022
Number of those in
Age 40 or older
# Hired
on that
Specific
Day
c) Using the information from the table above, what is the average headcount in each year?
Average
Headcount
Terminated
on Specific
Date
d) What is the average number of employees (i.e., headcount) per store unit for each year?
Medium Market
Large Market
Fig: 1
