PROJ12 — Labour Utilisation

Operational Reports > Project

Who would use this report?

Project managers and operational staff

What is in this report?

proj12Comparison of entered timesheets to expected worked hours, and returns employee utilisation percentages with colour coding or filteringSelectively remove data from view., to identify potential problem areas.

The Expected Hours value is only displayed in the report when the Sort By is Employee. The value is calculated as follows:

• Base Normal Hours * Total Working Days

• Base Normal Hours are per day, and calculated based on the employee’s Normal Working Hours and pay frequency

  For example if an employee has normal working hours of 38 and the pay frequency is weekly then the Base Normal Hours is 38/5 = 7.6. If the pay frequency is fortnightly then denominator is 10, or if the frequency is monthly then the denominator is 21.666667.

• Total Working Days is the count of days in the date range selected for the report that are week days

  For the purposes of this report a week day is Monday to Friday.

Employee Utilisation % = Total Hours for Employee/Expected Hours.

This version of the report does not take the employee start date into consideration when determining available hours within a selected time frame.

How do I use it?

Select Summary or Detail to view the summary or detail version of the report.

Sort options:

• Sort By — sortArrange elements of a list in a certain order. The most-used orders are numerical order and lexicographical order. by employee, department, project, parent project, project manager, cost centre, or work category

• Secondary Sort By — specify a secondary sort order

Filters include:

• Expected Hours % Threshold — colour code employees and filter the report

• Threshold applies above/below Expected Hours % — applies the previous threshold in reverse

  This enables filtering to those exceeding or those not meeting the threshold using the Apply Threshold as a Filter promptA report element that asks for prompt values on which to filter or sort a report..

• Date Worked Selection — select from a wide range of activity time frames

• Employees — enter a single employee code, a range of codes, or search for employee codes

• Project Level — specify whether you want to see the projectIn Framework Manager, a set of models, packages, and related information for administration, and for sharing model information.In Metric Studio, a project is a task or set of tasks undertaken by a team and monitored on a scorecard. A project tracks the dates, resources and status of the project.In Metric Designer, a project is a group of extracts. Each extract contains the metadata that is used to populate the Metric Studio data store or to create applications. or parentA member of a hierarchy to which the child members belong. The “Parent” function is part of the family set of functions and returns the parent member of the specified member. For example: SELECT Parent( [Time].[Year].[Period].[July 2010] ) ON Rows FROM [General Ledger] Result: 2010 (the year 2010 is the parent of [July 2010]) project for the following filters:

  • Project/Parent Project prompt provides search options:

    • Project Code Entry — enter either a single project code, or a range

    • Project Code Search — search by project code and multi select

Other project master related filters include Project Manager, Project Branch, or Parent Project Manager and Parent Project Branch.

What can I do in the report?

Select Summary or Detail to view the summary or detail version of the report.

You can sort by sort by employee, department, project, parent project, project manager, cost centre, or work category.

You can filter by Expected Hours % Threshold, Threshold applies above/below Expected Hours %, and Apply Threshold as a Filter.

Right-click any of the drill-down links and select Open link in new tab to view the data in pxiPronto Xi.