People Cost Data and Configuration Requirements
List of analytic objects, metrics, and concepts required to populate the People Cost Vee Board with data.
Each section in this topic corresponds to a specific row in the Vee Board and outlines the analytic objects, metrics, and concepts required to populate the charts within that row with data.
Group Bys
The visuals group data by the following dimensions and properties.
Dimensions/Properties
- Supervisory Hierarchy
- Organization
People Cost
What am I currently spending and what will I spend in the future?
Visual 1: YTD People Cost vs Plan
This visual can be populated with either Budgeted Compensation data or Actual Compensation Data. If you cannot provide Budgeted Compensation, then you can load Actual Compensation at an additional cost.
Option A - Budgeted Compensation data (preferred)
Analytic objects
- Employee Compensation Items (Multi-value property)
- Finance Budget TCOW
Metrics
- Budgeted Total YTD Rewards (Part of TCOW)
- Finance Plan Budget TCOW YTD
Concepts
-
FTE Weighted
Option B - Actual Compensation data
Note: Additional Purchase This feature requires an additional cost. If you are interested, please contact your
Analytic objects
- Finance Budget TCOW
- Compensation Payout
Metrics
- Actual Total Rewards YTD
- Finance Plan Budget TCOW YTD
Concepts
- FTE Weighted
Visual 2: Rest of Year Forecast
Analytic objects
- Employee
- Employment Start
- Employee Exit
- Future Employee Exits
Metrics
- Projected Headcount Cost
- Headcount
- External Starts Count
- Involuntary Turnover Count
- Voluntary Turnover Count
- Other Exits Count
- Employee Future Exit Count
- Employee Starts Rate
- Average Headcount
- Employee Exit Rate
- Average Headcount
- Monthly Budgeted Direct Compensation Per Employee Exit
- Employee Exit Budgeted Direct Compensation (Employee Exit Model concept > Perspectives > Actual > Measures > Budgeted Direct Compensation > Exit_Model.Budgeted_Direct_Compensation.Exit)
- Monthly Budgeted Direct Compensation Per Employee Start
- Employee Starts Budgeted Direct Compensation (Employee Starts Model concept > Perspectives > Actual > Measures > Budgeted Direct Compensation > Starts_Model.Starts_Budgeted_Direct_Compensation.Starts)
- Employee Starts Budgeted Direct Compensation (Employee Starts Model concept > Perspectives > Actual > Measures > Budgeted Direct Compensation > Starts_Model.Starts_Budgeted_Direct_Compensation.Starts)
- Budgeted Average Per Month Direct Compensation
- Budgeted Total Cost of Workforce (Total Cost of Workforce concept > Perspectives > Budgeted > Measures > Total > Total_Cost_of_Workforce.Budgeted_Sum.Total_Cost_of_Workforce_Root)
Concepts
- Current Employee
Properties/Dimensions
- Compensation Item
- Employment Start Type
- Employee Exit Reason
Visual 3: Full Year Forecast vs Plan
Analytic objects
- Employee
- Employment Start
- Employee Exit
- Future Employee Exits
- Finance Budget TCOW (Overlay)
Metrics
- Projected Headcount Cost
- Headcount
- External Starts Count
- Involuntary Turnover Count
- Voluntary Turnover Count
- Other Exits Count
- Employee Future Exit Count
- Employee Starts Rate
- Average Headcount
- Employee Exit Rate
- Average Headcount
- Employee Exit Average Budgeted Direct Compensation (TTM)*
- Employee Starts Average Budgeted Direct Compensation (TTM)*
- Finance Plan Budgeted TCOW
Note:
Concepts
- Current Employee
Variance of People Cost
Where am I over or under?
Visual 1: Headcount vs Plan
Analytic objects
- Employee
- Finance Budget Headcount
Metrics
- Headcount
- Finance Plan Budgeted Headcount
Concepts
- Current Employee
Visual 2: Net Change from Employee Budgeted Compensation Movement
Analytic objects
- Employee
- Employee Compensation Item (Multi-value property)
- Employment Start
- Employee Exit
Metrics
- Budgeted Total Direct Compensation
- Employee Starts Budgeted Direct Compensation
- Employee Exit Budgeted Direct Compensation
- Internal Movement
Note: These metrics come from the Employee Movement concept.
Concepts
- FTE Weighted
- Current Employee
- Inactive Employee
Visual 3: Variance from Pay Changes
Analytic objects
- Pay Change Events
Metrics
- Total Pay Change
Top Contributions to People Cost
Who do I need to talk to so that I can resolve this issue?
Visual 1: Table of 3 Metrics by Supervisory Hierarchy
Metric 1: Percent Change from Headcount vs. Plan
Analytic objects
- Employee
- Finance Budget Headcount
Metrics
- Headcount
- Finance Plan Budgeted Headcount
Concepts
- Current Employee
Metric 2: Budgeted Total Rewards
Analytic objects
- Employee
- Employee Compensation Item (Multi-value property)
Metrics
- Budgeted Total Rewards
Concepts
- FTE Weighted
Metric 3: Median Pay Change
Analytic objects
- Pay Change Events
Metrics
- Median Pay Change