As the route cover sheets come back from the drivers, the information needs to be entered in to each Route Costing Log. Go to the Productivity Menu – From the i-Pak Master Menu, select ‘Productivity Functions’ (option #8).
Select Route Costing Update (option #7) to access the Route Costing Logs. The Route Log scan screen will be displayed.
FIELD DEFINITIONS - Route Log Scan
The logs are listed by date (newest on top), then by company, then by route, vehicle and driver.
Date
The date of the Route Costing Log - corresponds to the 'create cost file for date' field on the Route List Selection screen.
Co
Company / Master Company ID the log was created under. If file sharing for Residential/Commercial route costing is set up (in the Company Master) this will be the Master Company ID.
Route
Route ID/Code for the log.
Vehl
Vehicle ID?Code for the log (if the Route Code is set up with a default Vehicle in the Route Code Master, this will be filled in with the default).
Drvr
Driver ID/Code for the log (if the Route Code is set up with a default Driver in the Route Code Master, this will be filled in with the default).
Day
The Day associated with the log (1=Monday, 2=Tuesday, etc 7=Sunday).
Description
The Description of the Route Code.
#Stops
The number of stops calculated by the route list program.
#Lifts
The number of lifts calculated by the route list program.
Cmpltd
If the Route log has been completed, there will be a 'Y' in this column.
Posted
If the Route log has been posted, there will be a 'Y' in this column.
Select the appropriate route log to be updated by double clicking on the line, or highlight the line and click on ‘Select’ at the bottom. This will display the Route Log Entry/Update screen.
The Route Log Entry/Update “Header” is used to capture information specific to the entire Route for the indicated combination Date, Company, Route, Vehicle and Driver. This includes
% Load Start
/End, Fuel Gallons,
Extra Stops
/Lifts, Extra Revenue, Start & End times for the Driver and Helper(s).
To begin entering information, the screen must be in ‘Update’ mode. When the Route Log Entry/Update screen is first displayed, it is in ‘Inquiry’ mode. To go in to ‘Update’ mode, click on the black ‘Update’ button on the left-hand tool bar. You can also go in to ‘Update’ mode by using F13 on your keyboard (press and hold the Shift button and press the F1 key).
Once in update mode, begin entering information off of the Route Cover Sheets – all times must be entered in Military (24 hour clock) time; i.e. 4:00pm is entered as 1600.
FIELD DEFINITIONS – Route Log Header:
Date
Display Only – the date for the route log
Company
Display Only – the company/master company id Company / Master Company id the log was created under. If file sharing for Residential/Commercial route costing is set up (in the Company Master) this will be the Master Company id.
Route
Display Only - Route ID/Code for the log.
Vehl
Vehicle ID/Code for the log (if the Route Code is set up with a default Vehicle in the Route Code Master, this will be filled in with the default).
Driver
Driver ID/Code for the log (if the Route Code is set up with a default Driver in the Route Code Master, this will be filled in with the default).
Day
The Day associated with the log (1=Monday, 2=Tuesday, etc, 7=Sunday).
% Load Start
Percentage of the load left in the vehicle at the start of the route.
% Load End
Percentage of the load left in the vehicle at the end of the route.
Fuel Gal #1 / #2
Gallons of Fuel added during re-fuel stops for the route. This is a (1) decimal position field-enter 21 gallons as 21.0.
Sched Stops
The number of stops calculated by the route list program.
Sched Lifts
The number of lifts calculated by the route list program.
Extra Stops
The number of extra stops for the route.
Extra Lifts
The number of extra lifts for the route.
Extra Rev$
The amount of extra revenue from the extra stops/lifts.
Driver Hours: In / Out
The time the driver ‘punched in’ & ‘punched out’ for the day (out). Any times for lunch, breaks, etc should also be entered.
Helper1: In / Out
The time Helper1 ‘punched in’ & ‘punched out’ for the day (out). Any times for lunch, breaks, etc should also be entered.
Helper2: In / Out
The time Helper2 ‘punched in’ & ‘punched out’ for the day (out). Any times for lunch, breaks, etc should also be entered.
Revenue Estimate
Display Only – The amount of revenue generated by the route for the scheduled stops & lifts
Total units
Display Only – Total number of disposal units for all loads.
Total miles
Display Only – Total number of miles driven.
Total drive time
Display Only – Total drive time on route.
Once the Route log ‘header’ information is entered, press Enter or click on the Enter button on the left hand tool bar. The system will give you a message that ‘Data has been changed…Press ENTER to continue.’ Press Enter or click on the Enter button on the left hand tool bar to confirm your changes. The Route Log Entry/Update "Detail" screen will be displayed. This is where route start information, delay information, disposal information and route end information is entered. Each piece of information is entered as an individual line item.
FIELD DEFINITIONS – Route Log Detail:
Date
Display Only – the date for the route log
Company
Display Only – the company/master company id Company / Master Company id the log was created under. If file sharing for Residential/Commercial route costing is set up (in the Company Master) this will be the Master Company id.
Route
Display Only - Route ID/Code for the log.
Vehl
Display Only - Vehicle ID/Code for the log (if the Route Code is set up with a default Vehicle in the Route Code Master, this will be filled in with the default).
Driver
Display Only - Driver ID/Code for the log (if the Route Code is set up with a default Driver in the Route Code Master, this will be filled in with the default).
Day
Display Only - The Day associated with the log (1=Monday, 2=Tuesday, etc, 7=Sunday).
D/T Code
Used for any ‘down time’ or delays. Select the appropriate code from the look up screen by pressing F4 or clicking on the blue arrow
to display choices for this field.
Start Time
The time the driver started the route. This can be up to your company’s discretion – either the time the driver leaves the yard, or the time the driver arrives at the first customer. The important thing is to be CONSISTENT. MUST be entered in military (24 hour) time.
Arrive L/F
The time arrived at the disposal site.
Depart L/F
The time departed from the disposal site.
Stop Time
The time the driver ended the route. This can be up to your company’s discretion – either the time the driver pulls in to the yard, or the time the driver leaves the last customer. The important thing is to be CONSISTENT. MUST be entered in military (24 hour) time.
Odometer Start
The odometer reading at the start of the Route.
Odometer End
The odometer reading at the end of the Route.
Landfill
The Landfill/Disposal site code. Enter the appropriate code for the Disposal facility or look up by pressing F4 or clicking on the blue arrow
to display choices for this field.
Ticket#
The ticket # for the load from the disposal facility.
Material
The Material code. Enter the appropriate code for the Material or look up by pressing F4 or clicking on the blue arrow
to display choices for this field.
Unit of Measure
The unit of measurement for the load (TN, YD, etc). Enter the appropriate code for the unit of measure or look up by pressing F4 or clicking on the blue arrow
to display choices for this field.
Units
The actual number of units for the load (actual tons, yards, etc).
Cost
The cost for the load from the ticket. If the landfill master is set up with material codes and cost, this amount will automatically be calculated and a message will be displayed:
If left 0 a warning message will be displayed:
Once all the information for the line is keyed in, press enter and the line will be displayed above.
If the driver has ‘dumped out’ more than once, the times will be a little different. The ‘end’ time for the first line should be the same as the depart l/f time. The start time for the next line (the additional dump) should be the same as the ‘end’ time for the first line.
For example: Route C1 starts at 6:30am and goes to ‘dump out’ at 10:45am. They are finished at the disposal facility at 11:15am (odometer at 175) and continue on with the route. They ‘dump out’ a second time at the end of the day at 1:30pm (odometer at 250) and finish at the disposal facility at 2:00pm. The disposal facility is at their yard, so they then park the truck and the route is complete for the day. This is how the route costing log should look:
Once all detail lines have been entered for the route, review the entries on the screen and complete the route by pressing F5 or clicking on the Complete/Incom button on the left hand tool bar. This will change the status of the log from INCOMPLETE to COMPLETE.
Go back to the scan screen to select the next log by pressing F1 (for main) or by clicking the Main button on the left hand tool bar. Select the next log on the scan screen and continue updating all logs for the day.
When finished, exit the Route Log Entry/Update by pressing F2 for back or clicking on the Back button on the left hand tool bar. This will bring you back to the i-Pak Productivity Functions menu. The next step is to run an Edit list. (Note – you can also run an edit list for each log by pressing F15 or clicking on the Print Edit button on the left hand tool bar on the Route Log/Entry header screen).
to display choices for this field.
