High/Low Analysis Table

The High/Low Analysis table enables you to display direct, indirect, and total hours or cost, with utilization percentage, for the organizations with either the highest or lowest direct labor hours or labor cost. Employee labor hours and cost are assigned to each employee's current home organization.

Display Options

Use the following options to specify the data that you want to display:

• Select Period or Cumulative YTD: Indicate if you want to display data for the current fiscal period or for the fiscal year to date. Your system administrator uses a Costpoint Analytics configuration setting to specify which fiscal period is the current period for labor utilization data.
• Select a Dimension: Select the level of the organization structure at which you want to display data.
• Select Hours or Cost: Indicate if you want to view, and calculate utilization percentage based on, labor hours or labor cost.
• Select Top or Bottom: Indicate if you want to see organizations with the highest direct labor hours or cost or those with the lowest. Use the field next to those options to enter the number of organizations for which you want to view utilization data.

Utilization Calculation

CFO Dashboards calculates the labor utilization percentage in one of the following ways, depending on your selection in Select Hours or Cost:

• Direct labor cost / (Total labor cost - Leave cost)
• Direct labor hours / (Total labor hours - Leave hours)

As part of Costpoint Analytics configuration, your system administrator specifies the accounts or project classification/project type combinations that represent direct labor or leave.

Export to Excel

To export the data in this table to a Microsoft® Excel® spreadsheet, click in the upper-right corner of the table.

Filter Options

Use the filter lists on the left side of the dashboard to focus the chart on...

• Utilization data for a specific company (if your firm has multiple companies in Costpoint)
• Utilization data associated with one or more specific organization codes. Use the icon at the top of the Org filter list to display organization codes for all levels of the organization structure or only the organization codes for a specific level.