Truck Statistics
Why:
You need summary report to evaluate your trucking performance.
Focus:
Focus of Report is to provide a summary of your trucking performance.
This report produces several statistics that can be used to see how well your
trucks and driver and working. For each truck, these statistics include:
- The average loads per day
- The average weight hauled per load
- The average 'short' weight per load. The short weight is the
difference between the actual weight hauled and the maximum weight, It
is the weight that could of been hauled without exceeding the maximum (which
might have triggered an overload deduction or fine).
- The revenue earned by day. This is the revenue earned by the truck
(where the mills split out pay specifically for hauling), divided by the
days worked.
- The estimated hours worked per day. The estimated hours are based
on the average cycle time specified for each /destination combination.
Thus, it is not the actual hours worked, but the hours that the truck would
have worked if it met the average /destination cycle time.
- Revenue per hour. This is an estimate of your earnings per hour.
In essence this statistic converts your load pay into an equivalent hourly
pay rate.
By comparing these statistics across your trucks (both your own and
contractor trucks), you can assess each truck's relative economic
performance. You can specifically compare how your own trucks compare with
those of your subcontractors.
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).
- Truck. You can select any or all of your Trucks. In the second
column, the truck owner is displayed so that you can select by truck owners
or bay truck.

Detailed Description:
The selection criteria determine the date range of loads that are included in
the report. The report then groups all the loads by truck, block and
destination. One row is reported for each combination.
For each load, the columns are:
- Truck/Driver: The truck code and driver
- . All s worked by the truck
- Loads. The total loads hauled over the date range selected
- Days. Number of days worked. For any day that at least one
load is hauled (based on the date out), one day is counted.
- The average loads per day. This equals the load count divided by
the number of days.
- The average net weight hauled per load
- The average 'short' weight per load. The short weight is the
difference between the actual weight hauled and the maximum weight, It
is the weight that could of been hauled without exceeding the maximum (which
might have triggered an overload deduction or fine).
- Revenue. Revenue earned by the truck. This is only available
if the mills for which you work specifically pay the trucking phase as a
separate activity. Truck revenue is based on the Loadslip Revenue
table.
- The revenue earned by day. This is the revenue earned by the truck
(where the mills split out pay specifically for hauling), divided by the
days worked.
- The estimated hours worked per day. The estimated hours are based
on the average cycle time specified for each /destination combination.
Thus, it is not the actual hours worked, but the hours that the truck would
have worked if it met the average /destination cycle time.
- Revenue per hour. This is an estimate of your earnings per hour.
In essence this statistic converts your load pay into an equivalent hourly
pay rate.
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.
- The report only handles the Trucking phase. Any other activity
(including those tagged as
'IS_PAY_LIKE_TRUCKING') are excluded.
- You must run the invoice calculator for your load revenue to be displayed.
If you are manually entering your load revenue, then you must enter your
trucking revenue in order for the revenue columns to be relevant.
Report:
Example 1: Detailed View.
|
Example Report 1 |
|
|
 |
|
|
|
|