Workforce Analytics Report - TEMPLATE

Table of Contents
Workforce Analytics Report......................................................................................................2
NOTE: The following TEMPLATE has been developed to guide you with developing your
Workforce Analytics Report. You are required to edit the examples, develop suitable
headings/sub-headings with corresponding discussions on your findings. The examples and
suggestions should be reviewed and developed to ensure a good flow of your discussions and
ideas in your final report. The examples are for guideline purposes ONLY.............................2
Analyse the workforce distribution and turn over in.................................................................2
Supply & Demand Trends and Gap Analysis Due to Forecast Retirements..........................3
Determine and discuss the following;-...............................................................................3
From your workforce profile, identify the future supply in 2018/19, 2019/2020, 2020/21. 5
Diversity Profile.........................................................................................................................6
Appendix
...............................................................................................................
...........................................
References
...............................................................................................................
.......................................
Page 1 of 17
Assessment 1: Workforce Analytics Report - TEMPLATE

Workforce Analytics Report
NOTE: The following TEMPLATE has been developed to guide you with developing your
Workforce Analytics Report. You are required to edit the examples, develop suitable
headings/sub-headings with corresponding discussions on your findings. The examples and
suggestions should be reviewed and developed to ensure a good flow of your discussions and
ideas in your final report. The examples are for guideline purposes ONLY.
The following questions are designed to help you build scenarios for your discussions
whilst performing the analysis. Read ALL instructions, pay attention to the questions,
and make sure that you address ALL the requirements. You may choose to add
headings and subheadings to your report to enable your discussions to flow. However,
ensure that all the sections of the marking criteria provided in the assessment cover-
sheet and instructions document are ALL addressed.
Question 1.
Analyse the workforce distribution and turn over in
a. Demographics (groups such as disability, gender race, sexual orientation etc.)
b. Skills
c. Jobs
d. Retirement and maternity
*For the above, identify and select the best method to calculate staff turnover and explain
your reasons.
Page 2 of 17
Assessment 1: Workforce Analytics Report - TEMPLATE

The total number of leavers in a month is divided by the average employees in a month to
calculate employee turnover. After that, multiply the amount by 100. The significant
proportion of fortnightly labour turnover is shown on the left.
Supply & Demand Trends and Gap Analysis Due to Forecast Retirements
Assuming the future demand for the senior management team (identified by the (**) on the
Audit Report) will remain unchanged for three years identify the gap due to retirements in
the figure below:
2016/17 2016/18 2016/19 2016/20
13 13 13 13
EXAMPLE
Forecast Supply Curve - Senior
Execuive Team
Demand
Financial Year
Number of Staff
Supply?
?
e. You must complete the supply curve above for 2017/18 and 2018/19, as per the
2016/17 Audit report.
Question 2.
Determine, consult and discuss the following whilst ensuring coordination between parties; -
A consultation session should be held in class between various stakeholders.
a. Supply and demand needs of Kariuki Flynn realty™,
Page 3 of 17
Assessment 1: Workforce Analytics Report - TEMPLATE