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 Customer Success Manager.

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)
    • 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:  

  • Employee Exit Average Budgeted Direct Compensation (TTM) is based on the Employee Exit Budgeted Direct Compensation metric.
  • Employee Starts Average Budgeted Direct Compensation (TTM) is based on the Employee Starts Budgeted Direct Compensation metric.

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