Direct Detailed Analysis Table (Labor Utilization)

Direct Detailed Analysis Table

Use this table to view detailed information for Direct Hours and Cost. This information is displayed by employee and charge-based attributes for all Home Organizations, Home Reorganizations, Managers, Employees, Employee GLCs, and Job Titles that you have access to.

The table defaults to display details for the top organization or reorganization level to which you have access. Click in the first and second columns to drill-down to detailed employee name or detailed job title records as needed. You can continue to click in the third column to view more granular details about the selected organization/reorganization, manager, employee GLC, employee name, or detail job title.

This table is not impacted by the Labor Type setting.

In this topic

Display the Table

Table Data

Utilization % Based On

User Options That Affect the Table

Change the Analyzed Attribute

Maximize the Table

Focus the Table

Sort the Table

Send the Table Data to Excel

Other Table Actions

If the Direct Detailed Analysis table is not visible, click the Direct Detailed Analysis tab.

Table Data

Utilization % Based On

You can select different ways to view labor utilization: by Cost or Hours, and by Period or Year-to-Date (YTD).

Cost or Hours

Cost allows you to view the total cost of labor utilization while hours only allows you to view the number of hours charged. These options ensure that each employee can only access the appropriate labor information.
Your security rights determine access to select Cost or Hours. Your system administrator may configure your application to only allow Hours. Contact your system administrator for further information.
Direct labor utilization defaults to Hours when used initially, but you can switch the chart type at any time.

Period or YTD

Period is data for the current analysis period while YTD provides a cumulative, rolling perspective within a given year. For example, February = January + February, March = January + February + March, and so on.
Labor Utilization defaults to YTD when used initially, but you can switch the chart type at any time.

To switch the labor utilization view...

Locate the Utilization % Based On options.

Click Cost or Hours. The selected option's button turns green, and the pertinent information on the charts and tables updates to reflect your selection.
Click Period or YTD. The selected option's button turns green, and the pertinent information on the charts and tables updates to reflect your selection.

User Options That Affect the Table

The following options on the User Options tab affect this chart:

Budget Type
Org or Reorg

For descriptions of how each option affects Labor Utilization Analytics, see User Options That Affect Labor Utilization.

Change the Analyzed Attribute

By default, this table displays the labor utilization by top-level organization or reorg, depending on your User Options selection, but you have the option to display the data by any of the following:

To change the analyzed attribute, do either of the following in the first column of the table:

If an organization/reorganization level is selected in the first column, click

the second column to drill-down to manager, GLC, employee name, or detail job title records as needed. You can continue to click

in the third column to view more details about the charge details (project, project type, project class, account, organization, GLC, or PLC).

Maximize the Table

Focus the Table

Sort the Table

Send the Table Data to Excel

Other Table Actions

In addition to the actions described above, you can also do the following:

Print the chart.
Email the chart.
Export chart data to a CSV file.
Attach a note to the chart.

For more on these actions, see Print, Email, or Export Analytic Data and Attach Notes to Analytics.

Chart Item	Description
Direct Hours	This column displays the direct hours. Direct labor utilization (hours) = Direct labor hours / Total labor hours
Direct Cost	This column displays the direct cost. Direct labor utilization (hours) = Direct labor hours / Total labor hours
Direct Hours Budget	This column displays the Baseline Budget or Forecast Hours, depending on the selected User Option.
Direct Cost Budget	This column displays the Baseline Budget or Forecast Cost, depending on the selected User Option.
Direct Hours Variance %	This column displays the percentage of variance for the direct hours. A negative variance can trigger a cautionary or urgent alert, depending on your configuration settings: Cautionary alert — The Variance % cell displays in yellow to indicate the alert is cautionary. Urgent alert — The Variance % cell displays in red to indicate the alert is urgent. See Alerts for more information.
Direct Cost Variance %	This column displays the percentage of variance for the direct cost. A negative variance can trigger a cautionary or urgent alert, depending on your configuration settings: Cautionary alert — The Variance % cell displays in yellow to indicate the alert is cautionary. Urgent alert — The Variance % cell displays in red to indicate the alert is urgent. See Alerts for more information.