|
Subcontractor Pay Summary (#315)
|
|
Why:
You need a summary listing of the rates paid contractors, by block.
This report allows you to ensure that your rates for subcontractors are set up
correctly.
Focus:
Focus of Report is to show a summary listing of contractor pay, by
phase/activity and by block. A specific subtotal is included for each
equipment unit and for each contractor (owner). The average pay rate (pay
divided by pay units) is show for each contractor and can be compared to the
rates set up for the block.
- Report covers subcontractor pay except trucking phases.
- The vendor pay calculator must be run for the report to be meaningful
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).
- Subcontractor. You can select any or all of your contractors.
- Phases: You can select any or all the phases/activities.
- Block. You can select any or all of your Blocks

Detailed Description:
The selection criteria determine the contractors and phases that appear in
the report.
The report shows for each phase, a rate calculation broken down by
contractor, equipment unit, and block. The rate calculation is based on
the total pay divided by the pay units (in the appropriate unit of measure).
This calculated rate can then be compared to the pay rate for the contract to
make sure that the correct pay rate has been used by the system.
The report shows:
- Phase: The phase/activity that is paid
- BlockEquip Code: The equipment unit
- Owner: The equipment owner/subcontractor that is paid
- : Source block of the load
- Rate: Calculated rate. This rate equals the contractor pay
divided by the pay units (e.g. M3 or MBF).
- Units paid: The total pay units (reported in the appropriate unit
of measure)
- Total Units: The total pay units for the selected phase/activity,
across all contractors and blocks
Key Notes:
- The report excludes all pay like trucking activities
- The report depends on the running of the vendor pay calculator
Report:
Example:
Example Report