|
Trucks, Load Revenue (#606)
|
|
Why:
You need a report on the revenue earned by each truck. Revenue is
the amount that your mill(s) pay you for the Trucking or 'Is Pay Like Trucking'
Activities.
Focus:
Focus of Report is to show the revenue earned for each truck on a
load-by-load basis. The report also summarized loads and load revenue (for
trucking) by day and and by truck number.
This report is for revenue earned by you for the trucking activity paid to
you by the mill. This is not the amount that you pay for trucking to
either your employees or subcontractors. This report only covers revenue
from the Trucking or or 'Is Pay Like Trucking' activity. For
example, if you receive a fuel adjustment from your mill, this report will show
a row for trucking and a separate row for the fuel adjustment (see example
report #5 below).
- Report covers all loads delivered by each truck
- Revenue is based on the Loadslip_Revenue table (not the Invoice Details
Table).
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. The second
column shows the truck description and owner's name in parentheses.
- Block: You select the block(s) for which you want turn around times.
You can select any or all of the blocks
- The "Summary Data" option generates a summary version of the
report with only subtotals and totals.
- 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
truck (see Example Report 1) or by truck first and then by date.
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
- Truck Code: Truck code (number) for the load
- 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
- Destination: Destination of the load
- Net: Net (Gross less Tare) truck weight
- Pay Weight: Pay basis for the load -- e.g. Tonnes, Tons, M3,
etc. Note: the pay weight will take into account (subtract) any
overload weight deduction
- Pay Rate: Revenue rate applied against the pay weight
- Revenue: Pay weight multiplied by pay rate.
Key Notes:
- Report covers all loads delivered by each truck
- Depending on the software configuration, Load Revenue may be (1) entered
manually as settlements are received or (2) calculated when invoices are
processed. If option (1) is in effect, revenue must be entered for
each load for it to appear in the report, otherwise it will be reported as
zero. If option (2) is in effect, the invoice calculator must be run
in order for load revenue to appear in this report. This report only
covers revenue from the Trucking or or 'Is Pay Like Trucking' activity.
- 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:
Example Report 1 shows the report sorted first by date and then by
truck. It shows all loads grouped on a daily basis.
|
Example Report 1 |
|
|
 |
|
|
|
|
Example 2:
Sample Report 2 shows the report sorted first by truck and then by
date. It shows all loads for each truck over the selected date range.
|
Example Report 2 |
|
|
 |
|
|
|
|
Example 3:
Sample Report 3 shows the summary view of the report when the loads are
sorted by date. The pay rate is the average (calculated) pay rate based on
the total revenue and total pay weight for each day.
|
Example Report 3 |
|
|
 |
|
|
|
|
Example 4:
Sample Report 4 shows the summary view of the report when the loads are
sorted by truck. The pay rate is the average (calculated) pay
rate based on the total revenue and total pay weight for each truck over the
selected date range.
|
Example Report 4 |
|
|
 |
|
|
|
|
Example 5:
Sample Report 5 shows the report where there are two activities (Trucking and
Fuel Adj). The report includes a separate line for each activity for each
load.
|
Example Report 5 |
|
|
 |
|
|
|
|