Labour Utilisation by Job Type
Ref: AG3_301
Description
The report returns a tabular style grid showing for each employee in weekly or monthly bands the total time spent working on up to 3 different user selectable job types, the report also shows for comparison the total available hours from the shift pattern and the utilisation as a percentage of time recorded against the core shift time. Dependant on selected report options the report can also display the labour costs.
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)
Job Type 1 – Based upon user selection (Total time/cost for specified job type)
Job Type 2 – Based upon user selection (Total time/cost for specified job type)
Job Type 3 – Based upon user selection (Total time/cost for specified job type)
Other (Time not booked to selected job types)
Total (Total recorded time/cost for the selected job types)
Shift (Total available hours from shift pattern)
% (Utilisation Percentage)
Operational Criteria
The report will return work order data based upon the selected filter criteria, for the selected job types, then perform 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
• Show totals only
o If checked the period subtotals will be supressed and only the employee totals will be displayed, this is shown below.
Show costs checked, show totals only unchecked
Show costs unchecked, show totals only checked
• Period
o This determines the interval between dated subtotals on the report
• Job Type 1 / Job Type 2 / Job Type 3
o This is where the user selects which job types are to be used in the analysis, select the ‘Null’ option if no job type is desired. Please note that at least one job type must be selected in order for totals to be generated.
Calculations
Job Type 1, 2 and 3
Labour time
This is the sum of all labour transactions that occurred within the selected work date range that are of the selected job type.
Each labour transaction includes labour time, travel time and lost time.
Sum (labour time + travel time + lost time)
Labour Cost
This is the sum of all labour costs that occurred within the selected work date range that are of the selected job type.
Each labour cost includes labour costs, travel costs and lost cost.
Sum (labour cost + travel cost + lost cost)
Other Time
This is the amount, if any, of remaining recorded time that was not recorded against the selected job types it is calculated in the following way for each employee for the selected date range.
Total Recorded Labour Transactions – (job type 1 total time + job type 2 total time + job type 3 total time)
Other Cost
This is the amount, if any, of remaining recorded costs that were not recorded against the selected job types it is calculated in the following way for each employee for the selected date range.
Total Recorded Labour Costs – (job type 1 total time + job type 2 total time + job type 3 total time)
Shift time
This is the total of available hours from the employee shift pattern.
%
The percentage utilisation is calculated in the following way.
(Labour Time + Other Time / Shift Time) x 100
Total Time
This is the total of all recorded labour transactions within the selected date range.
Sum (labour time + travel time + lost time)
Total Cost
This is the total of all recorded labour cost transactions within the selected date range.
Sum (labour cost + travel cost + lost cost)
Aims
This report aims to provide the user with utilisation figures for employees and specific types of work along with associated costing on a week by week or month by month basis.
Results Analysis
From this report a user can determine how effectively labour resources are being used and the types of work consuming the most time and cost.
It also allows comparison to be made between weeks and month for individual employee to see if they are being utilised more or less which can be an indicator of busy periods.
Low utilisation percentages could reflect an unproductive employee and this can assist in scheduling and balancing work load between employees.