Driver Hours
Why:
You need an estimate of your drivers' hours because you pay them by the load and they do not keep time sheets.
Government tax authorities often require the hours worked as part of payroll
reporting.
Focus:
Focus of Report is to calculate the hours worked by your truck drivers based on your load tickets.
The report takes the loads for each driver and multiplies the count by the average trip (cycle) time that you have set up for each block.
This is an estimate of the hours worked by each specific driver.
Selection Window:
The selection window allows you to filter the report by:
- Date Range: You can either select a pay period, or you can simply enter the start and end date directly into the selection criteria window. The Period selection is merely a short-cut for entering a date range, so you can always edit the start and end dates to be any date you choose. For example, you can pick a period defined as 8/1/2004 to 8/12/2004, and then extend the end date by three days to 8/15/2004. If you leave the end time blank, the program will assume you want the entire day for the end date. In the example below, the start date/time is 8/1/2004 00:00:00 (a blank is assumed to be time 00:00:00) and the end date/time is 8/15/2004 00:00:00. Because the end date time is blank (or 00:00:00), the program assumes you want the whole day of the 15th and makes the end date/time 8/16/2004 00:00:00. In the selection query, the program returns records whose start date/time is greater than OR equal to the start/date time and strictly less than the end date/time.
- Note: for report information that is based on load tickets, the report uses the Date Out (not the Date In).
- Driver. You can select any or all of your Drivers. The first
column shows the driver's code; the second
column shows the driver's full name.
- The Summary Data Only allows you to generate the report showing only the
subtotals by Driver.
Detailed Description:
The selection criteria determine the date range drivers that appear in
the report. The report is based on your loadslip entries and the average
trip (cycle) times that you have set up for each block. The average cycle
times are those that you set up when you open a block:
The trip time is the round trip time.
The report shows the loads delivered by each driver and the average trip
times.
For each load, the columns are:
- Driver: Truck Driver
- Date: Date of the load
- Ticket: Load ticket number
- Block: Source Block
- Destination: Destination of the load
- Time In: Entry time of the truck out of the yard of the current load
- Time Out: Exit time of the truck out of the yard of the current load
- Truck Code: Truck code (number) for the load
- Route: Route code of the load
- Net: net weight of the load
- Volume: Volume of the load
- Trip time: Average trip time as identified for the
block/destination combination
Key Notes:
- The report treats 'split' loads as individual loads. The report does not use the load count field on the load slip.
- The report does not differentiate between header 'H' and detail 'D'
records.
Report:
Example 1: Detailed View.
|
Example Report 1 |
|
|
 |
|
|
|
|
Example 2: Summary View.
|
Example Report 2 |
|
|
 |
|
|
The summary view shows the hours totals for each driver,
grouped by block/destination combination. |
|
