To run the Residential & Commercial Productivity Reports, select option #13 or 14 from the Productivity Reports menu. The Productivity Report selection screen will be displayed:
Note: due to the amount of detail on the report, it will only fit on 14” wide paper. In addition, the printer must be able to print a font size (CPI) of 16.7 or 17 – most pc printers will require you manually set the CPI before printing.
Enter the selection criteria for the report. Columns 1-5 indicate up to 5 different selection criteria during any one report run (i.e.: multiple companies, drivers, etc).
|
Field |
Definition |
|
Master companies
|
The company/master company id. To include all companies, leave blank.
|
|
Vehicles
|
The vehicle(s) id for to be included in the report. Leave blank for all vehicles.
|
|
Drivers
|
The driver(s) id for to be included in the report. Leave blank for all driver.
|
|
Route types |
The route types to be included in the report. This is useful when printing the report for ‘all commercial’ instead of listing each individual route.
|
|
Routes |
The route id(s) to be included in the report. Leave blank for all routes. For a group of similar routes (ie: all front load, resi trash, etc) use the Route type field.
|
|
Days of service |
Click on the box to the left of the days to be included in the report. For all days, leave blank.
|
|
Date range |
Enter the specific date or range of dates to be included in the report.
|
|
Detail/Summary Option |
Click on Detail or Summary depending on the presentation of the report. |
Once the selection criteria is filled in, press Enter (or click on the Enter button on the left hand tool bar). A message to verify and continue will be displayed on the bottom of the screen.
Verify the selection criteria and press F5 or click on the Verify/Continue button on the left hand tool bar. A message indicating the batch has been submitted to batch will be displayed.
Press Enter or click on the Enter button on the left hand tool bar to continue. The report will then be sent to the spool file and printed.
The list below indicates the column on the report and where/how the information is generated.
|
Column Heading |
Where From/How Calculated |
|
Route |
Route List Selection / Create Route Costing ‘Y’
|
|
Day |
Route List Selection / Create Route Costing ‘Y’
|
|
Date |
Route List Selection / Create Route Costing ‘Y’ - Date
|
|
Driver |
Entered in to Route Costing Log
|
|
Vehicle (Truck) |
Entered in to Route Costing Log
|
|
# of Emp |
Driver + Helper(s) (if applicable)
|
|
# of Stops |
Route List Selection – Total # of Route Stops (Addresses)
|
|
# of Lifts |
Route List Selection – Total # of Lifts (based upon # of stops – Qty)
|
|
Yards |
Route List Selection – Calculation from the Capacity field of the SZ/CG (only LY, CY, GL)
|
|
Total Miles |
Entered in to Route Costing Log – Calculated on the 1st Odometer reading to the last
|
|
Total Route Miles |
Entered in to Route Costing Log – Calculated on the 1st Odometer reading to the last
|
|
Total Fuel Gals |
Entered in to Route Costing Log (both fields)
|
|
Total Hours |
Entered in to Route Costing Log – Calculation based upon the ‘Driver’ Hours ONLY!
|
|
Total Route Hours |
Entered in to Route Costing Log – Calculation is same as Total Hours
|
|
Down Time |
Entered in to Route Costing Log– Calculated on Start - End
|
|
L/F (dump) Yards |
Vehicle Master Capacity
|
|
L/F Tons |
Entered in to Route Costing Log– Total of all tons entered
|
|
L/F Cost |
Entered in to Route Costing Log– Total of all cost entered
|
|
# L/F Loads |
Entered in to Route Costing Log – Calculation on # of times a Landfill Code is entered
|
|
Total Route Revenue |
Route List Selection / Create Route Costing ‘Y’
Note: if ‘G’ operand is used, then Qty=’1’ regardless of actual Quantity
Note: the default frequency is 52.00, unless otherwise specified in the Route Pickup Frequency master
|
|
Total Oper Costs |
Labor + L/F Cost + Fuel + Vehicle cost
Labor=Driver Total Hrs x Driver Hrly Rate + Helper(s) Total Hrs x Hrly Rate
|
|
Net Revenue |
Total Revenue – Total Oper Costs
|
|
Oper Margin |
New Revenue / Total Revenue
|
|
Rte Stops per Hour |
# Stops / Route Hours
|
|
Rte Stops per Mile |
# Stops / Route Miles
|
|
New Revenue per Hour |
New Revenue / Total Hours
|
|
Lbs per Lift |
Total Tonnage x 2000 / # of lifts
|
|
Avg Tons per Load |
Total Tons / # of L/F Trips
|
|
Milers per Gallon |
Total Miles / Total Gallons
|
|
Miles per Stop |
Total Miles / Total Stops
|