Why:
You need to know your trucking costs on a load-by-load basis.
Trucking costs are for your own trucks (driver and truck standard costs) and for
those paid to contractors (trucks and/or drivers)
Focus:
Focus of Report is to show your consolidated truck costs, by block (or day),
from all sources. Costs include (1) amounts paid to your own drivers, (2)
amounts paid to subcontractors either in their role as drivers or in their role
as truck owners, and (3) internal charges for the use of your own trucks (based
on their standard cost).
- Report covers all loads delivered by each truck
- Report only covers the trucking activity
- Report only covers pay based on load slips (hourly or production pay for
the trucking activity is excluded)
- Calculators for Vendors and Employees must be run for truck costs to be
reported in the report, otherwise costs will be reported as zero.
- Payroll costs are only reported as direct payroll costs (no option for
employee fully loaded cost).
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).
- Block. You can select any or all of your blocks
- The "Only Print Raw Data" option generates a report with the
report detail, but with no subtotals or totals.
- Sort By: The report can either be sorted by date first and then
block (see Example Report 1) or by block first and then by date (see Example
Report 2)..
Detailed Description:
The selection criteria determine the date range and trucks that appear in
the report. The report is based on your loadslip entries.
The report shows the loads delivered by each truck
For each load, the columns are:
- Date: Date of the load. If a date repeats, it is left blank
- Block Code: Source Block of the load. If the block is repeated for
entries, it is left blank.
- Ticket: Load ticket number
- 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
- Driver: Worker code for the truck driver
- Net: Net (Gross less Tare) truck weight
- Driver Pay: Driver payroll for your own drivers
- Own Truck Cost: Internal charge for the use of your own trucks
- Contractor cost: The sum of payments to contractors for (1) the use
of contractor-owned trucks and (2) contractor drivers.
- Total cost: The sum of Driver Pay, Own Truck Cost and Contractor
Cost
Key Notes:
- The report is only for the Trucking activity. It does not account for
any other activities, including 'IS_PAY_LIKE_TRUCKING' activities.
- The report only calculates the costs for your own trucks where you have your
trucking based on loads (not hourly)
- The report treats 'split' loads as individual loads
- The report does not differentiate between header 'H' and detail 'D'
records
- You will need to run both the employee (for drivers) and vendor (for
contractors) calculators in order to have your correct truck costs show up in the report.
Report:
Example 1:
Example Report 1 shows the report sorted first by date and then by block. It shows all loads grouped on a daily basis.
It is useful to look at three different cases shown in the report:
Case 1: Contractor-owned truck; contractor driver (see line 2).
In this case, the truck (T10002) is owned by a contractor and we see $480.87 is
paid to the contractor. Because the full payment is made to the truck
owner, the driver is irrelevant (at least in terms of pay) and has been entered
by the default value of 'NONE'.
Case 2: Company-owned truck; employee driver (see line 3). In
this case, the truck (HL6004) is company owned and we see $298.64 is incurred as
an internal charge for the use of the truck. The driver 'JB' (who is an
employee) is paid $56.00 (under driver pay) to drive the truck. In this
case, contractor cost is $0.00.
Case 3: Company-owned truck; contractor driver (see line 4). In
this case, the truck (HL6001) is company owned and we see $298.00 is incurred as
an internal charge for the use of the truck. The driver 'GS' (who is a
contract driver) is paid $147.80 (under contractor cost) to drive the truck.
|
Example Report 1 |
|
|
 |
|
|
|
|
Example 2:
Sample Report 2 shows the report sorted first by block and then by
date. It shows all loads for each block over the selected date range.
The data are summed by block to provide a total trucking cost for the block over
the selected date range.
|
Example Report 2 |
|
|
 |
|
|
|
|
