HR Workforce Metrics
& Analytics Toolkit
Creating Quality
Management
Reporting that Drives
Continuous
Workforce
Improvement
©2015 Optimum Performance HR Consultants
Fact:
In almost every organisation we have
worked with over the past 19 years annual
labour costs constitute one of the top three
operating expenditures incurred each year
Fact:
In these same organisations little if
anything has ever been done to consistently
measure, report and evaluate how
effectively this cost is being managed,
where performance is effective, and where
intervention and improvement is required
Fact:
When properly developed and
executed, HR Workforce Metrics and
Analytics enable the CEO/SMT, Department
Heads, Line Managers and the HR Team to
systematically review and evaluate those
areas
where
current
workforce
performance
is acceptable and those
where intervention and improvement are
required. There are many areas that can be
reported,
dependent
upon
your
• Facilitated
reporting
process
• Cross
functional
steering
committee
• Professional
acumen &
depth of
knowledge
• Common
vision,
understanding
& appetite
Human
Resources
Synergy
Competent
Facilitator
Software
Capability
Governance
Structure
Dispelling the Myths…….
Despite what many HR professionals might think,
quality workforce metrics & reporting can be
achieved without the need for systems integration
and/or a large up-front software investment
What it does require however is:
-•
A knowledgeable, capable and engaged Human
Resources Department;
•
An assigned resource, albeit not necessarily on a
full-time basis or at a senior level;
•
A well-structured, cross-functional project team
incorporating all key-stake-holders;
•
An integrated set of Excel Spreadsheets that can
produce quality data and graphics reporting at
prescribed reporting intervals;
Our High Quality, Low Cost Solution….
Welcome to our totally re-vamped
HR Workforce Metrics & Analytics
Toolkit.
A comprehensive software package that enables every HR
Department to facilitate effective workforce reporting in their organisations
at a price that they can afford!
For just
$2,495
you will receive:
-•
A comprehensive Instruction Manual that will enhance your HR Metrics
& Analytics knowledge, understanding and professional acumen;
•
An integrated set of 10 Excel Spreadsheets that will create and produce
detailed data and graphics reports by designated departments and your
corporation as a whole;
•
An introductory on-line tutorial program that will get you started and
headed in the right direction;
•
Free updates for 12 months following your purchase;
•
Unlimited access and usage throughout your organisation at no extra
cost; (I.e. No additional licencing or usage fees);
Software re-programming can also
be provided at additional
Objectives, logic, formulas, definitions and costing models are provided for each Key Performance
Indicator
Workforce
Absenteeism
Workforce
Flexibility
Workforce
Knowledge
Management
Workforce
Satisfaction
Workforce
Training &
Development
Workforce
Corporate
Governance
Workforce
Headcount
Workforce
Performance
Effectiveness
Workforce
Sourcing
Workforce
Turnover
Workforce
Demographics
Workforce
Health &
Safety
Workforce
Recruitment
Workforce
Succession
Planning
Workforce
Utilisation
Workforce
Diversity
Involvement
Workforce
Remuneration
Workforce
Workforce
Talent
Management
HR
Department
Effectiveness
Our Instruction
Manual
More than 130
pages in length,
our HR Metrics &
Analytics
Instruction
Manual
incorporates 20
Key Performance
Indicators
containing more
than 250 specific
performance
metrics for you to
choose from…plus
our ten essential
pre-requisites for
Corporate Reports
Getting Started
Creating Your
Departments
Departmental Reports
Populating Your
Corporate Reports
Accessing Your
HR Workforce Metrics and Analytics Toolkit
Initially insert your desired
reporting departments
(Maximum 12)
Then nominate your
desired reporting start
date each year
Your Departments
Your Department Names
Your Starting Date
Department 1:
Manufacturing
Jan-14
Department 2:
Distribution
Feb-14
Department 3:
Quality
Mar-14
Department 4:
Sales
Apr-14
Department 5:
Finance
May-14
Department 6:
HR
Jun-14
Department 7:
Marketing
Jul-14
Department 8:
Risk Management
Aug-14
Department 9:
Logistics
Sep-14
Department 10:
Warehouse
Oct-14
Department 11:
Payroll
Nov-14
Demographics
Satisfaction
Training & Development
Turnover
Absenteeism
Corporate Governance
Utilisation
Headcount
Health & Safety
Recruitment
Succession Planning
Corporate Reports
Getting Started
Creating Your
Departments
Departmental Reports
Populating Your
Corporate Reports
Accessing Your
HR Workforce Metrics and Analytics Toolkit
Select which of our 10 Key Performance Indicators you wish to use
for each of your designated Departments
Determine your desired reporting frequency for each selected Key
Performance Indicator (I.e. Monthly, quarterly, half-yearly)
Periodic Turnover Report
Department: Manufacturing
Key Performance Indicator Jan-14 Feb-14 Mar-14 Apr-14 May-14 Jun-14 Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Year To Date This Time Last Year Against This Variation Time Last Year
Projected
Year End Target/Budget Variation Against Target/ Budget Nbr of Unplanned turnovers 23.0 45.0 34.0 34.0 44.0 44.0 224.0 200.0 24.0 448.0 400.0 48.0 Nbr of Planned turnovers 2.0 3.0 4.0 2.0 2.0 2.0 15.0 15.0 0.0 30.0 45.0 -15.0 Total nbr of Workforce Turnovers (combined) 25.0 48.0 38.0 36.0 46.0 46.0 0.0 0.0 0.0 0.0 0.0 0.0 239.0 215.0 24.0 478.0 445.0 33.0 % Workforce Turnovers -Combined) 20.00% 23.00% 24.00% 32.00% 21.00% 22.00% 23.67% 22.00% 1.67% 23.67% 21.00% 2.67% Nbr of Unplanned Turnovers- Management 2.0 3.0 2.0 2.0 3.0 1.0 13.0 12.0 1.0 26.0 25.0 1.0 Nbr of Unplanned Turnovers- Staff 23.0 45.0 36.0 34.0 43.0 45.0 226.0 222.0 4.0 452.0 400.0 52.0 Nbr of Unplanned Turnovers - High Performers 3.0 2.0 3.0 4.0 4.0 4.0 20.0 19.0 1.0 40.0 42.0 -2.0 Nbr of Unplanned Turnovers - Low Performers 6.0 5.0 7.0 2.0 4.0 9.0 33.0 34.0 -1.0 66.0 66.0 0.0 Nbr of Unplanned
Turnovers - Talent Pool participants
7.0 8.0 6.0 4.0 5.0 10.0 40.0 48.0 -8.0 80.0 81.0 -1.0 Total $ replacement cost
to the organization -Management
$375,000 $375,000 $525,000 $300,000 $375,000 $675,000 $2,625,000 $2,175,000 $450,000 $5,250,000 $5,666,000 -$416,000 Total $ replacement cost
to the organization - Staff
$675,000 $375,000 $525,000 $300,000 $375,000 $675,000 $2,925,000 $2,175,000 $750,000 $5,850,000 $5,666,000 $184,000
Total $ replacement cost to the organization -Combined
$1,050,000 $750,000 $1,050,000 $600,000 $750,000 $1,350,000 $0 $0 $0 $0 $0 $0 $5,550,000 $4,350,000 $1,200,000 $11,100,000 $11,332,000 -$232,000
Commentary:
Getting Started Creating Your Departments Departmental Reports Populating Your Accessing Your Corporate Reports Corporate Reports
HR Workforce Metrics and Analytics Toolkit
Cells shaded
in blue are all
automatically
populated for
you
Hide cells that you do not require, or amend our definitions
Periodic Turnover Report
Department: Manufacturing
Key Performance Indicator Jan-14 Feb-14 Mar-14 Apr-14 May-14 Jun-14 Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Year To Date This Time Last Year Against This Variation Time Last Year
Projected
Year End Target/Budget Variation Against Target/ Budget Nbr of Unplanned turnovers 23.0 45.0 34.0 34.0 44.0 44.0 224.0 200.0 24.0 448.0 400.0 48.0 Nbr of Planned turnovers 2.0 3.0 4.0 2.0 2.0 2.0 15.0 15.0 0.0 30.0 45.0 -15.0 Total nbr of Workforce Turnovers (combined) 25.0 48.0 38.0 36.0 46.0 46.0 0.0 0.0 0.0 0.0 0.0 0.0 239.0 215.0 24.0 478.0 445.0 33.0 % Workforce Turnovers -Combined) 20.00% 23.00% 24.00% 32.00% 21.00% 22.00% 23.67% 22.00% 1.67% 23.67% 21.00% 2.67% Nbr of Unplanned Turnovers- Management 2.0 3.0 2.0 2.0 3.0 1.0 13.0 12.0 1.0 26.0 25.0 1.0 Nbr of Unplanned Turnovers- Staff 23.0 45.0 36.0 34.0 43.0 45.0 226.0 222.0 4.0 452.0 400.0 52.0 Nbr of Unplanned Turnovers - High Performers 3.0 2.0 3.0 4.0 4.0 4.0 20.0 19.0 1.0 40.0 42.0 -2.0 Nbr of Unplanned Turnovers - Low Performers 6.0 5.0 7.0 2.0 4.0 9.0 33.0 34.0 -1.0 66.0 66.0 0.0 Nbr of Unplanned
Turnovers - Talent Pool participants
7.0 8.0 6.0 4.0 5.0 10.0 40.0 48.0 -8.0 80.0 81.0 -1.0 Total $ replacement cost
to the organization -Management
$375,000 $375,000 $525,000 $300,000 $375,000 $675,000 $2,625,000 $2,175,000 $450,000 $5,250,000 $5,666,000 -$416,000 Total $ replacement cost
to the organization - Staff
$675,000 $375,000 $525,000 $300,000 $375,000 $675,000 $2,925,000 $2,175,000 $750,000 $5,850,000 $5,666,000 $184,000
Total $ replacement cost to the organization -Combined
$1,050,000 $750,000 $1,050,000 $600,000 $750,000 $1,350,000 $0 $0 $0 $0 $0 $0 $5,550,000 $4,350,000 $1,200,000 $11,100,000 $11,332,000 -$232,000
Commentary:
Getting Started Creating Your Departments Departmental Reports Populating Your Accessing Your Corporate Reports Corporate Reports
HR Workforce Metrics and Analytics Toolkit
Use our
traffic light
facility to
interpret
your results
Getting Started Creating Your Departments Departmental Reports Populating Your Accessing Your Corporate Reports Corporate Reports
HR Workforce Metrics and Analytics Toolkit
Complimentary graphics
are automatically
created for each of our
10 KPI’s (Minimum of
two)
Getting Started Creating Your Departments Departmental Reports Populating Your Accessing Your Corporate Reports Corporate Reports
HR Workforce Metrics and Analytics Toolkit