Labor Analysis report (v104 and later)

Edit online

◆ Applies to: Planning and Costing Standard on TBM Studio 12.3 and later, with Template v104 and later

Use cases

  • Perform ad hoc analyses of labor costs
  • View granular data for specific roles, locations, and cost centers

The Labor Analysis 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

Display the report

  1. Log in to Apptio and navigate to Planning > Costing Standard.

  2. On the Home page, click Labor.

    The Labor Review report opens.

  3. In the report collection tabs (element 1, below), click Labor Analysis.
  1. Log in to Apptio and navigate to Costing Standard.

  2. On the Home page, click Labor.

    The Labor Review report opens.

  3. In the report collection tabs (element 1, below), click Labor Analysis.

The report contains the following elements.

(1) Report Collection

This report collection provides the details you need to review your labor resources:

  • IT Towers report (v104)
  • Labor Review report (v104)
  • Labor Analysis report (v104)
  • ITP - Labor Review report (v104)
  • Fixed Assets report (v104)
  • ITP - Asset Review report (v104)

(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, account group, and organizational accountability, including cost center, 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 see a detailed, cross-organizational category spend analysis for that group.

(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, above) to customize the table with the metrics you want to see.

In the Trend column, click View to open a dialog with month-over-month detail for the item you click.

(4) Slicer by Employee, Role Type, or Cost Center

Use these additional slicers to refine report by employee type, role type, and cost center accountability.

Questions answered

You can use this report to answer the following questions:

  • 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 the 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?