Route Summary

A new home for the Coupa Supply Chain documentation

Starting with Supply Chain 42, our documentation will be located on Coupa Compass. The help here will continue to be accessible for the foreseeable future, but will no longer be updated. If you need a Compass user account, contact your company’s Designated Support Contact (DSC).

You can access new and updated Supply Chain documentation in the following location on Compass:

https://compass.coupa.com/en-us/products/supply-chain-design-and-planning

Route Summary

Internal Table Name: VRPOutputRoutes

The Route Summary table provides information about each vehicle route generated by Transportation Optimization.

Scenario

Table: VRPOutputRoutes

Internal Name: Not Applicable (Scenario column not in table)

The scenario for which the output data was generated.

Route ID

Table: VRPOutputRoutes

Internal Name: RouteID

The identifier of the route.

Asset Name

Table: VRPOutputRoutes

Internal Name: EquipmentTypeID

The identifier of the asset used on the route.

Pool Site

Table: VRPOutputRoutes

Internal Name: PoolSite

The shipment pooling origin site for outbound consolidation or destination site for inbound consolidation. For Outbound Consolidation, this site is the origin of the shipments, typically a distribution center. For Inbound Consolidation, this site is the destination of the shipments.

Total Cost

Table: VRPOutputRoutes

Internal Name: TotalCost

The total cost calculated for the route.

Direct Shipping Cost

Table: VRPOutputRoutes

Internal Name: LTLCost

The direct shipping cost of all shipments on the route. This value is based on the Direct Shipping Cost populated on the Shipments table.

Fixed Cost

Table: VRPOutputRoutes

Internal Name: FixedCost

The Fixed Cost for the route as defined in the Rate table.

Unit Cost

Table: VRPOutputRoutes

Internal Name: UnitCost

The Unit Cost for the route as defined by the Per Unit Cost in the Rate table.

Total Stops

Table: VRPOutputRoutes

Internal Name: TotalStopCount

The total number of stops on the route. These stops include the in-transit stops, plus the initial and final stops at the pool site. It also includes stops at a domicile, if the asset is located at a site other than the pool site.

In Transit Stops

Table: VRPOutputRoutes

Internal Name: StopsCount

The number of in transit stops on the route. Stops required for charging an electric vehicle battery are counted as in transit stops. This count does not include the initial stop at the pool site, nor the final stop at the pool site for round trip routes. It also does not include stops at a domicile, if the asset is located at a site other than the pool site.

Total Distance

Table: VRPOutputRoutes

Internal Name: TotalDistance

The total distance traveled on the route.

Reposition Distance

Table: VRPOutputRoutes

Internal Name: RepositionDistance

The distance the asset travels to return to its starting location in a round trip route. The asset is usually empty for this distance.

Total Weight

Table: VRPOutputRoutes

Internal Name: TotalWeight

The total weight carried on the route.

Total Cubic

Table: VRPOutputRoutes

Internal Name: TotalCubi

The total cubic volume carried on the route.

Total Qty

Table: VRPOutputRoutes

Internal Name: TotalQty

The total quantity carried on the route.

Start Date Time

Table: VRPOutputRoutes

Internal Name: StartDateTime

The date and time at which the route started.

End Date Time

Table: VRPOutputRoutes

Internal Name: EndDateTime

The date and time at which the route ended.

Break Time

Table: VRPOutputRoutes

Internal Name: ShortBreakTime

The total break time, in minutes, from short breaks within a shift. You must define Break Time and Max Drive Time Before Break in the Transportation Asset table to incur short breaks within a shift.

Trans Mode ID

Table: VRPOutputRoutes

Internal Name: TransModeID

The mode ID for the route.

Total Time

Table: VRPOutputRoutes

Internal Name: TotalTime

The total time in minutes spent on the route.

Total Time = End Date Time - Start Date Time

Duty Time

Table: VRPOutputRoutes

Internal Name: DutyTime

The total duty time (in minutes) for the route.

Duty Time = Drive Time + Service Time (loading/unloading time) + Break Time (short breaks) + Wait Time

Drive Time

Table: VRPOutputRoutes

Internal Name: OperatingTime

The total operating time, or driving time, expressed in minutes.

Reposition Time

Table: VRPOutputRoutes

Internal Name: RepositionTime

The total operating time, in minutes, with an empty load.

Wait Time

Table: VRPOutputRoutes

Internal Name: WaitTime

The total wait time, in minutes, incurred at delivery locations. For example, wait time can be incurred when the asset arrives before opening time at a location.

Service Time

Table: VRPOutputRoutes

Internal Name: ServiceTime

The time incurred in activities such as loading and unloading shipments. You can define Fixed Service Time and Variable Service Time on the Transportation Assets table, Fixed Service Time and Variable Service Time on the Sites table, and Service Time (service time at the non-pool site location) on the Shipment itself.

Overnight Time

Table: VRPOutputRoutes

Internal Name: BreakTime

The time incurred due to Rest Time, which is defined in Transportation Assets. The shift is defined based on the Max Duty Time Before Rest Time in Transportation Assets.

Start Date Time Local

Table: VRPOutputRoutes

Internal Name: StartDateTimeLocal

The local time of the first location at the start of the route.

End Date Time Local

Table: VRPOutputRoutes

Internal Name: EndDateTimeLocal

The local time of the last location at the end of the route.

Max Qty

Table: VRPOutputRoutes

Internal Name: MaxQty

The maximum quantity that was on the route. On an outbound route, this amount is typically the total quantity loaded at the origin pool site. On an inbound route, this amount is typically the total quantity delivered at the destination pool site.

Max Cubic

Table: VRPOutputRoutes

Internal Name: MaxCubic

The maximum cubic volume that was on the route. On an outbound route, this amount is typically the total cubic loaded at the origin pool site. On an inbound route, this amount is typically the total cubic delivered at the destination pool site.

Max Weight

Table: VRPOutputRoutes

Internal Name: MaxWeight

The maximum weight that was on the route. On an outbound route, this amount is typically the total weight loaded at the origin pool site. On an inbound route, this amount is typically the total weight delivered at the destination pool site.

Comp2 Quantity

Table: VRPOutputRoutes

Internal Name: Comp2Quantity

The total quantity carried on the route in the second asset compartment.

Comp2 Weight

Table: VRPOutputRoutes

Internal Name: Comp2Weight

The total weight carried on the route in the second asset compartment.

Comp2 Cubic

Table: VRPOutputRoutes

Internal Name: Comp2Cubic

The total cubic volume carried on the route in the second asset compartment.

Duty Cost

Table: VRPOutputRoutes

Internal Name: DutyCost

The total duty cost incurred on the route. If you have specified Duty Time Cost on the Rate table:

Duty Cost = Duty Time Cost * Duty Time

If Duty Time Cost is not specified:

Duty Cost = (Drive Time Cost * Drive Time) + (Service Time Cost * (Fixed Service Time + Variable Service Time)) + (Wait Time Cost * Wait Time) + (Break Time Cost * (Break Time * number of short breaks))

Drive Time Cost

Table: VRPOutputRoutes

Internal Name: DriveTimeCost

The total in-transit drive time cost incurred on the route.

Drive Time Cost = Drive Time Cost (from Rate table) * Drive Time

Service Time Cost

Table: VRPOutputRoutes

Internal Name: ServiceTimeCost

The total service time cost incurred on the route. The Service Time Cost is calculated as:

Service Time Cost = Service Time Cost (from Rate table) * (Fixed Service Time + Variable Service Time)

Break Cost

Table: VRPOutputRoutes

Internal Name: BreakCost

The total cost incurred on the route due to short breaks that occur during a shift. The Break Cost is calculated as:

Break Time Cost * (Break Time * number of short breaks)

Overnight Cost

Table: VRPOutputRoutes

Internal Name: OvernightCost

The total cost incurred on the route due to long (overnight) breaks that occur between shifts. The Overnight Cost is calculated as:

(Variable Rest Time Cost * (Rest Time * number of overnight breaks)) + (Fixed Rest Time Cost * number of overnight breaks)

Wait Cost

Table: VRPOutputRoutes

Internal Name: WaitCost

The total wait time cost incurred on the route. The Wait Cost is calculated as:

Wait Time Cost * Wait Time

Additive Cost

Table: VRPOutputRoutes

Internal Name: AdditiveCost

The total cost added to the calculated cost on the route when Additive Cost is defined in the Transit Matrix table.

Total Stop Cost

Table: VRPOutputRoutes

Internal Name: TotalStopCost

The total cost incurred due to in-transit stops on the route. The Total Stop Cost is calculated as:

Per Stop Cost * number of In Transit Stops

Total Distance Cost

Table: VRPOutputRoutes

Internal Name: TotalDistanceCost

The total distance cost incurred on the route. The Total Distance Cost is calculated as:

((Per Distance Cost + Surcharge Per Distance) * loaded distance) * (1 + Surcharge Percentage) +

((Per Reposition Distance Cost + Surcharge Per Distance) * Reposition Distance) * (1 + Surcharge Percentage)

Total Per Reposition Distance Cost

Table: VRPOutputRoutes

Internal Name: TotalPerRepositionDistanceCost

The total reposition distance cost incurred on the route. The Total Reposition Distance Cost is calculated as:

((Per Reposition Distance Cost + Surcharge Per Distance) * Reposition Distance) * (1 + Surcharge Percentage)

Total Surcharge

Table: VRPOutputRoutes

Internal Name: TotalSurcharge

The total surcharge cost incurred on the route. The Total Surcharge is calculated as:

(Surcharge Per Distance * distance) + Surcharge Percentage

CO2 Emission

Table: VRPOutputRoutes

Internal Name: CO2Emission

Displays the total CO2 emission incurred on the route. This is the sum of the CO2 emissions calculated for all the segments on the route.

Delivered Stops

Table: VRPOutputRoutes

Internal Name: DeliveredStops

This is the number of stops at which deliveries are made. These are the outbound stops.

Delivered Qty

Table: VRPOutputRoutes

Internal Name: DeliveredQty

This is the total shipment quantity on the load that is delivered at sites.

Delivered Weight

Table: VRPOutputRoutes

Internal Name: DeliveredWeight

This is the total shipment weight on the load that is delivered at sites.

Delivered Cubic

Table: VRPOutputRoutes

Internal Name: DeliveredCubic

This is the total shipment cubic volume on the load that is delivered at sites.

Pickup Stops

Table: VRPOutputRoutes

Internal Name: PickupStops

This is the number of stops at which pickups are made. These are the inbound stops.

Pickup Qty

Table: VRPOutputRoutes

Internal Name: PickupQty

This is the total shipment quantity on the load that is picked up at sites.

Pickup Weight

Table: VRPOutputRoutes

Internal Name: PickupWeight

This is the total shipment weight on the load that is picked up at sites.

Pickup Cubic

Table: VRPOutputRoutes

Internal Name: PickupCubic

This is the total shipment cubic volume on the load that is picked up at sites.

Asset ID

Table: VRPOutputRoutes

Internal Name: AssetID

The identifier of the asset (from the Assets table) to which the route is assigned.

Asset Sequence ID

Table: VRPOutputRoutes

Internal Name: SequenceIdInAsset

The sequence number of the route on the asset.

Route Utilization

Table: VRPOutputRoutes

Internal Name: RouteUtilization

This is the percentage of total/maximum for the unit of measure most utilized on the route, calculated per route:

For example, if a vehicle has a total weight capacity of 40,000 lbs and picks up 30,000 lbs. from the distribution center for a milk run delivery route, its route utilization will be 30,000/40,000 = 75%. The unit of measure considered for this calculation is the unit of measure most utilized on the route (one of Quantity, Weight or Cubic).

This calculation is useful for assessing routes when using standard optimization (pooled inbound or outbound networks). It may not be appropriate for interleaved (continuous moves) networks where routes have several pickups and several deliveries. Please refer to the Segment Utilization formula for this type of route.

Segment Utilization

Table: VRPOutputRoutes

Internal Name: SegmentUtilization

This is the average vehicle utilization across each segment on the route, weighted by the distance of each segment:

Consider the example of a route for a vehicle with a maximum weight capacity of 40,000 lbs:

Segment [A,B]: load = 20,000 lbs., distance = 100 miles

Segment [B,C]: load = 10,000 lbs., distance = 200 miles

Segment [C,A]: load = 0 lbs., distance = 200 miles

The segment utilization is calculated as (100 * 20,000 + 200 * 10,000 + 200 * 0) / (500 * 40,000) = 20%

The unit of measure considered for this calculation is the unit of measure most utilized on the route (one of Quantity, Weight or Cubic).

This calculation is useful for assessing routes when using interleaved optimization (continuous moves). It may not be best for standard optimization (pooled inbound or outbound) networks since the vehicle gets progressively empty (outbound) or full (inbound) throughout the route. Please refer to the Route Utilization formula for this type of route.

Rate ID

Table: VRPOutputRoutes

Internal Name: RateID

The identifier for the rate that was applied to the route.

Decomposition ID

Table: VRPOutputRoutes

Internal Name: DecompositionID

Displays the decomposition value based on the selected Shipments Decomposition Field in Transportation Optimization Options. For example, if you have selected Shipment Destination Country as the Shipments Decomposition Field, shipments with destinations in Spain are not routed with shipments to France.

Dock Door ID

Table: VRPOutputRoutes

Internal Name: DockDoorID

The identifier for the dock door that serviced the route. This column is populated only if you have defined the Number of Dock Doors for Sites.

Dock Door Start Time

Table: VRPOutputRoutes

Internal Name: DockDoorStartTime

Displays the time the vehicle started use of the dock door.

Dock Door End Time

Table: VRPOutputRoutes

Internal Name: DockDoorEndTime

Displays the time the vehicle finished use of the dock door. The time between the Dock Door Start Time and Dock Door End Time includes all fixed and variable loading and unloading time. It also includes the Dock Door Reset Time as specified at the Site.

Minimum Cost

Table: VRPOutputRoutes

Internal Name: MinimumCost

This column displays the Minimum Cost as populated on the Rate table, based on the Rate used for this route.

Override Cost

Table: VRPOutputRoutes

Internal Name: OverrideCost

This column displays the sum of the Override Cost from the Transit Matrix table. For example, assume a route with three segments, where two have an Override Cost populated in Transit Matrix. The value for this column is the sum of the two Override Cost values.

Inventory Holding Cost

Table: VRPOutputRoutes

Internal Name: InventoryHoldingCost

When running Periodic Optimization, this column displays the cost incurred holding inventory. The Inventory Holding Cost in the Periodic Schedule table is applied to the quantity, weight or volume of Transportation Daily Orders as determined by the Periodic Schedule Inventory Holding Cost Basis.

Out Of Route Cost

Table: VRPOutputRoutes

Internal Name: OutOfRouteCost

This column displays the total cost incurred as a result of the Out Of Route Distance on the route. You populate the Per Distance Out Of Route Cost on the Rate table to apply a cost to out of route distance that is incurred on the route. This cost acts as a soft constraint since the solver works to minimize the total cost.

Out Of Route Distance

Table: VRPOutputRoutes

Internal Name: OutOfRouteDistance

This column displays the total out of route distance incurred on the route. The distance traveled beyond the direct distance from the route origin to the furthest stop on the route is considered out of route distance.

The out of route distance is calculated as follows:

Direct Distance - from route origin to furthest location on the route = DC -> B
Total Route Distance = DC -> A -> B -> C -> D
Out of Route Distance = Total Route Distance - Direct Distance = (DC -> A -> B -> C -> D) - (DC -> B)
Out of Route Percentage = (Total Route Distance - Direct Distance) / Total Route Distance = ((DC -> A -> B -> C -> D) - (DC -> B)) / (DC -> A -> B -> C -> D)

You can apply hard constraints to out of route distance using columns on the Transportation Assets table: Out Of Route Distance specifies an actual distance constraint, Out Of Route Distance Percentage is a percentage of the total route distance.

See Out of route calculation for additional information.

Drone Fixed Cost

Table: VRPOutputRoutes

Internal Name: DroneFixedCost

This column displays the total cost incurred from the Fixed Drone Cost for drones that were utilized in sorties.

Asset Origin

Table: VRPOutputRoutes

Internal Name: AssetOrigin

This column displays the origin location for the asset used on the route. If you are using the Route Summary table as a source for Routes to be used with driver scheduling, you can use the Asset Origin column to identify routes with the same source.

Scenario ID

Table: VRPOutputRoutes

Internal Name: ScenarioID

The identifier of the scenario for which the output data was generated.

Sub-Scenario ID

Table: VRPOutputRoutes

Internal Name: StepNumber

The identifier of the sub-scenario, if applicable, for which the output data was generated.

Last modified: Wednesday May 15, 2024

Is this useful?

Yes No