|
Trucks, BC Fuel Rebate (#610)
|
|
Why:
You need to file for your fuel rebate refund.
Focus:
Focus of Report is to provide the detailed calculations needed to apply for
the British Columbia fuel rebate. The summary data can be used to complete
the "Off-Highway Worksheet" that is used to estimate the Litres used
in off-highway uses.
- Report covers all loads
- Distances between blocks and destinations are entered in the block
setup. Distances should be entered as one-way distances -- this report
multiplies them by 2.0 in order to calculate the round trip distance.
- Self-loading trucks are identified by their configuration -- There is a
flag on each configuration to identify it as being self-loading or not.
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
- Destination: You can select any or all of your destinations.
- Owners. You select one or more owners. Your own company also
appears in this list and will most often be your only selection. You
might select another owner if you are preparing the mileage data on behalf
of a subcontractor.
- Summary Data Only: Provides output (See Example Report 1) that can
be used directly to fill out the Off-Highway Worksheet.
Detailed Description:
The selection criteria determine the date range, the blocks, and the
destinations for the loads that appear in the report. The owner selection
determines which trucks will appear in the report. All the loads that have
a trucks owned by a selected owner will be included in the report.
The
report columns are:
- Block: Source Block of the Loads
- Destination: Destination of the Loads
- Timber Mark: Timber Mark for the Loads
- Loads: Load Count
- Self Loader: The counts of loads where the truck configuration was
coded as a self-loading truck
- On Highway Round Trip: Round trip distance between the block and
destination. Note: distances setup on the block are One-Way distances
and this report multiplies that distance by 2.0 in order to calculate the
round trip distance.
- Off Highway Round Trip: Round trip distance between the block and
destination. Note: distances setup on the block are One-Way distances
and this report multiplies that distance by 2.0 in order to calculate the
round trip distance.
- On Highway Distance: Load Count multiplied by On Highway Round Trip
- Off Highway Distance: Load Count multiplied by Off Highway Round
Trip
The totals are supplied for each block/destination combination and for all blocks.
Key Notes:
- The report treats 'split' loads as individual loads
- The report does not differentiate between header 'H' and detail 'D'
records
- You do not need to run any calculators for the report.
- The report uses
the distances on each block. Do not be confused. The report does
not use the distance (if entered) on the load slip.
Report:
Example One:
Example Report 1 shows the report where the selection "Summary Data
Only" has been selected.
|
Example Report 1 |
|
|
 |
|
|
|
|
Example Two:
Example Report 2 shows the report "Summary Data Only" has been NOT
been selected. The report show the load-by-load detail underlying the
summary report. This report can be used as your backup audit detail for
your fuel rebate filing. In this case there are additional columns for:
- Date: Date of the Load
- Ticket: Ticket number for the load
- Truck No: Truck Number for the load
- Truck Type: The truck type (configuration) for the load
- Self Loader: A checkbox for whether the truck type (configuration)
is flagged as a self loading truck
|
Example Report 2 |
|
|
 |
|
|
|
|
