Labor Analysis

Edit online

This report provides an aggregate, ad hoc view into all of the data related to your labor spending. You can filter the report and select specific metrics in many combinations so you can focus on the data you need.

Add filters and metrics for a more granular view; remove filters and metrics for a higher-level view. The report can give you visibility into labor spending per cost center, compare hourly rates to average monthly rates, and compare rates per role across a variety of locations.

This report is designed for use by the following roles:

  • Financial analyst
  • Business analyst

The report contains the following elements:

Key element Description
(1) Report Collection

This report collection provides the details you need to review your resource (labor and IT tower) spend, trends, and usage:
(2) Slicers

Use the local and global slicers to refine the data in your report. Slicers in this report let you see your cost data by region and organizational accountability, including cost center and ID, cost center owner, and owner (for example, CIO -1).

The following roles can use the slicers in this report for a more personalized view:

  • IT Financial Controller or CIO: Without setting any slicers, you can see the overview of the spend across all cost centers in the organization. You can drill down into cost pools, cost center owners, and individual accounts.
  • Cost Center Owner or CIO -1: Set the Cost Center slicer to filter for your areas of responsibility.
  • Financial Analyst: Set the Cost Center slicer for areas you support, or set a specific account group to enable a detailed, cross-organizational category spend analysis.
(3) Labor Interactive Analysis

This table contains a complete view of labor spend across all cost centers per role, internal and external headcount, OpEx, OpEx budget, budget variance, and average rate by default. In the table, the following codes are used:

  • (E-xxx) = Employee
  • (C-xxx) = Contractor
  • (CC-xxx) = Planned headcount budget per department

Select items in the Select Additional Metrics panel (element 5) to customize the table with the metrics you want to see.

In the Trend column, select View to open a dialog with month-over-month detail for the item you click.
(4) Slicer by Employee or Role Type Use these additional slicers to refine report by employee type and role type.

Questions answered:

  • Are we meeting our hiring and spending plan for labor?
  • What skills and roles are supporting my applications? How many are DBAs, developers, etc.?
  • Where are my labor costs coming from---internal FTEs, contractors, or some other service provider?
  • What is the composition of our labor costs?
  • How do the costs of similar skill sets vary by region and contractor?
  • What is the mix of internal and external labor that supports each IT function?
  • Which GL accounts contribute to the labor for a given role (such as system administrator)?
  • Which departments have the highest number headcount openings in the hiring plan? Which ones exceed the headcount plan?