Labour Utilisation by Pay Rate
Ref: AG3_302
Description
Similar to the labour utilisation report this shows the total time an employee has worked, but analysed by the pay rate, using weekly or monthly intervals.
A calculation showing what percentages of the overall available hours were recorded at normal rate is also included.
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)
Six Labour rate columns
• Normal Working Hours
• Overtime at time and a half
• Overtime at double time
• Weekend working
• Holiday Working
• Call out
• Other (Other labour transactions not covered by rates)
• Total (Total recorded time/cost for the selected job types)
• Shift (Total available hours from shift pattern)
• % (Percentage of time booked at normal rate against overall recorded time)
Operational Criteria
The report will return work order data for each employee based upon the selected filter criteria, for the selected job types, and 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.
• Period
o This determines the interval between dated subtotals on the report
Calculations
Labour Rates
Labour time
This is the sum of all labour transactions that occurred within the selected work date range that are of the labour rate specified in the column header.
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 labour rate specified in the column header.
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)
Total Time
This is the total overall sum of all labour transactions that occurred within the selected date range for all labour rates.
It is calculated by;
Sum (labour time + travel time + lost time)
Total Cost
This is the total overall sum of all labour transaction costs that occurred within the selected date range for all labour rates.
It is calculated by;
Sum (labour cost + travel cost + lost cost)
Aims
This report aims to provide the user with utilisation figures for employees analysed by the labour rates with associated costing on a week by week or month by month basis.
This provides a view of the amount of time worked and the cost for each labour rate within the given period.
Results Analysis
The report primarily provides labour cost analysis for a given period, i.e. first quarter. This also provides a good way of looking at how much work was done outside of normal working hours and at what cost.
A large amount of overtime could indicate insufficient labour resource available to undertake current workload and such circumstances should be investigated further.