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.
• Equipment.  You can select any or all of your Equipment Units. 
• Activities:  You can select one or activities to include in the report. (The report will show data only for those activities for which you track equipment units on the back tab of the load slip.)
• Block: You select the block(s) for which you want turn around times.  You can select any or all of the blocks
• The "Summary View" option generates a summary version of the report that does not show the load-by-load detail.

The selection criteria determine the date range and equipment units that appear in the report.  The report is based on your load slip entries and shows the loads associated with the equipment units captured in your selection criteria.

The detail version of the report has the following columns:

• Activity:  Shows the Activity Associated with each of the subsequent loads.  Again, this activity is entered on the back tab of each load slip.
• Equipment Code:  Code (not description) of the equipment unit entered on the back tab of the load slip for the activity shown.
• Block:  Block associated with the load ticket.
• Date: Date of the load. 
• Ticket: Load ticket number
• Time In: Entry time of the truck into the yard for the load ticket
• Time Out: Exit time of the truck out of the yard for the load ticket
• Destination: Destination of the load
• Net:  Net (Gross less Tare) truck weight
• Pay Weight:  Revenue basis for the load -- e.g. Tonnes, Tons, M3, etc. 
• Pay Rate:  Revenue rate applied against the pay weight
• Revenue:  Pay weight multiplied by pay rate.

In summary mode, certain of the report columns are omitted.  (See Example 1 below.)  In addition, the summary mode contains a grand total for the entire report.  If you select multiple activities when you run the report, the same loads will appear multiple times.  In order to avoid double-counting loads in the grand total, the system displays the total for the activity whose "Production Indicator" flag is checked.

 

• Report covers all loads matching the selection criteria you chose, as long as the activities and equipment are entered on the back tab of the load ticket.
• Revenue is based on the Loadslip_Revenue table (not the Invoice Details Table).  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 (which is generally the case for Canadian users), the invoice calculator must be run in order for load revenue to appear in this report. 
• The report treats 'split' loads as individual loads. The report does not use the load count field on the load slip.  Rather, it treats each ticket as a load.  If the activity on the load ticket was split between two equipment units (say 50/50), the ticket will be treated as two tickets rather than one.
• The report does not differentiate between header 'H'  and detail 'D' records.
• In order for this report to be useful for you, you must follow two business practices: 

  One:  You must enter revenue rates for each of the phases of operation for which you want to track the revenue earned by each piece of equipment.  For example, if the mill pays you $30 per tonne for logging, but you want to track revenue for four different phases within logging, you must break the logging rate into its component phases so that you have a revenue rate for each phase within logging for which you care to track revenue.

  Two:  You must track equipment units involved in each phase of operation on your load slips.  For example, if you break your overall logging revenue rate up into a processing, loading, and skidding rate (as described in (1) above), and you enter the processor, loader, and skidder unit numbers on each load ticket, this report will allow you to monitor how much revenue each of the equipment units is earning.

   

Example Report 1 shows the report run in summary mode for all equipment units on a particular block.

	Summary View

Sample Report 2 shows the report in detailed mode for one of the activities (Process/Bucking) and for one block (BL 27723) from the summary version.  The detail view shows each ticket that lies behind the summary information presented in Example 1. 

	Detail View