Labour Utilisation by Work Order

Ref: AG3_304

 

Description

 

This report returns a tabular grid showing the actual time recorded by an employee against individual work orders using either weekly or monthly intervals, a utilisation percentage based upon work order time is displayed for each employee.

 

The Report Returns

 

Employee Code

Employee Name

Date (Dependant on selected period this will either be at weekly or monthly intervals from the start date)

Total (Total recorded time/cost for the selected job types)

Shift (Total available hours from shift pattern)

% Util (Utilisation Percentage)

Job Code (work order number)

Job Description (Work order description)

Time (Time recorded against the specific work order)

Cost (Labour cost of specific work order, dependant on report options selected)

 

 

Operational Criteria

 

The report returns work order data based upon the selected filter criteria and then performs the required calculations.

 

Filters

 

•    Work date range (Located in report options)

o  This will include any work order data where the labour transaction is within the specified date range

•    Labour

o  This is a single or all employee selection. (Highlighting an employee will select that single employee, leave un-highlighted to select all)

•    Crafts

o  This is a single or all craft selection. (Highlighting a craft will select that single craft, leave un-highlighted to select all)

•    Employed by

o  This is a single or all employed by selection. (Highlighting an employed by option will select that employer, leave un-highlighted to select all)

 

Report Options

 

•    Show Costs

o  If checked an additional line will appear for each employee showing the labour costs, if unchecked this line will remain hidden

•    Period

o  This determines the interval between dated subtotals on the report

 

 

Calculations

 

% Util

 

The percentage utilisation is calculated in the following way.

 

(Labour Time / Shift Time) x 100

 

 

 

Aims

 

This report is designed to provide the user with an utilisation figure for each employee based upon normal time for a given period.

 

Results Analysis

 

This report is design an operational tool to assist with scheduling and work load balancing.