Utilization % Summary Analysis Table

The Utilization % Summary Analysis table provides a high-level overview of the labor utilization's details for the direct or available cost or hours for the Organizations, Managers, Employees, and Employee GLCs to which you have access. This information is displayed by the designated analysis period, and you can select different filters and analysis periods to adjust as needed.

The table defaults to display details for the top organization or reorganization level to which you have access. Click , in the first column, to drill-down to detailed employee name or detailed job title records as needed.

In this topic

Display the Table

Table Data

Available or Direct

Utilization % Based On

User Options That Affect the Table

Maximize the Table

Focus the Table

Send the Table Data to Excel

Other Table Actions

Display the Table

If the Utilization % Summary Analysis table is not visible, click the Summary Analysis tab.

Table Data

The following data displays on this table:  

Table Item

Description

If Hours is selected as the Utilization % Based On option...

Direct Hours Util %

 

This column is calculated as follows:

(Direct Hours/Total Hours)

Direct Budget %

This column is calculated as follows:

(Direct Budget Hours/Total Budget Hours)

Direct Target %

 

This column displays the direct target percentage.

Available Hours Util %

This column is calculated as follows:

(Direct Hours/(Total Hours – Leave Hours))

Available Budget %

This column is calculated as follows:

(Direct Budget Hours/(Total Budget Hours – Leave Budget Hours))

Available Target %

This column displays the available target percentage.

If Cost is selected as the Utilization % Based On option...

Direct Cost Util %

This column is calculated as follows:

(Direct Cost/Total Cost)

Direct Budget %

This column is calculated as follows:

(Direct Budget Cost/Total Budget Cost)

Direct Target %

This column displays the direct target percentage.

Available Cost Util %

This column is calculated as follows:

(Direct Cost/(Total Cost – Leave Cost))

Available Budget %

This column is calculated as follows:

(Direct Budget Cost/(Total Budget Cost – Leave Budget Cost))

Available Target %

This column displays the available target percentage.

Available or Direct

There are two ways to view the type of labor used: Available or Direct. These options impact the Utilization % Analysis and the Utilization % Comparison charts. Direct labor utilization is based on total labor, while available labor utilization subtracts employee leave from the total labor. These options ensure that you can track the efficiency of your labor force.

This table displays data for both Available and Direct labor.

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

Period or YTD

To switch the labor utilization view...

  1. Locate the Utilization % Based On options.

  1. 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.

  2. 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:

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:

Maximize the Table

Click at the top right of the chart to display the chart at its maximum size. Click to restore the chart to its original size and location on the tab.

Focus the Table

You can narrow the focus of this table by selecting a row in the table. Costpoint Analytics removes all data from the table except for that row.

If you focus the table by selecting a row, Costpoint Analytics applies the same change, as appropriate, to all other analytic objects.

Send the Table Data to Excel

Click to send the data underlying the chart to Microsoft Excel. More...

Other Table Actions

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

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