Multi-Stop Estimation Summary

Supply Chain Guru X Help

Home >

Submit Search

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

Multi-Stop Estimation Summary

Internal Table Name: OptimizationOutputPseudoRoutingSummary

The Multi-Stop Estimation Summary provides information such as the cost, apportioned time and apportioned distance for flows from source to customer.

Scenario

Table: OptimizationOutputPseudoRoutingSummary

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

Displays the name of the scenario which generated the multi-stop estimation output data.

Source

Table: OptimizationOutputPseudoRoutingSummary

Internal Name: SourceName

This column displays the Source from the Transportation Policies table for this flow.

Customer

Table: OptimizationOutputPseudoRoutingSummary

Internal Name: CustomerName

This column displays the Destination customer from the Transportation Policies table for this flow.

Customer Transportation Region

Table: OptimizationOutputPseudoRoutingSummary

Internal Name: CustomerTransportRegion

This column displays the Transportation Region to which the Customer is assigned.

Product

Table: OptimizationOutputPseudoRoutingSummary

Internal Name: ProductName

This column displays the Product that is on the flow.

Vehicle

Table: OptimizationOutputPseudoRoutingSummary

Internal Name: VehicleName

This column displays the type of vehicle from the multi-stop estimation matrix.

Mode

Table: OptimizationOutputPseudoRoutingSummary

Internal Name: ModeName

This column displays the name of the Mode to which the Vehicle is assigned. This mode has a Multi-Stop Estimation Vehicle Cost value populated as the Fixed Shipment Cost.

Cost Used in Network Optimization

Table: OptimizationOutputPseudoRoutingSummary

Internal Name: CostUsed

If the Mode using the multi-stop vehicle is used by Network Optimization for the Source-Customer-Product, this column displays "Yes"; otherwise it displays "No". In other words, if a Customer Flow for the Source-Customer-Product uses this Mode, the cost is identified as used ("Yes").

Departing Period Name

Table: OptimizationOutputPseudoRoutingSummary

Internal Name: DepartingPeriodName

The period in which the flow leaves the source.

Arriving Period Name

Table: OptimizationOutputPseudoRoutingSummary

Internal Name: ArrivingPeriodName

The period in which the flow arrives at the customer.

Transport Cost Per Movement

Table: OptimizationOutputPseudoRoutingSummary

Internal Name: TransportCost

This column displays the cost apportioned to the lane per movement based on the multi-stop estimation matrix.

Total Transport Cost

Table: OptimizationOutputPseudoRoutingSummary

Internal Name: TotalTransportCost

This column displays the Transport Cost Per Movement * Number Of Movements. It is equivalent to the Transportation Policy Cost in the Customer Flows output table.

Transport Time

Table: OptimizationOutputPseudoRoutingSummary

Internal Name: ProductApportionedRouteTime

This column displays the time apportioned to the lane based on the multi-stop estimation matrix.

Transport Distance

Table: OptimizationOutputPseudoRoutingSummary

Internal Name: ProductApportionedRouteDistance

This column displays the distance apportioned to the lane based on the multi-stop estimation matrix.

Number Of Vehicles

Table: OptimizationOutputPseudoRoutingSummary

Internal Name: NumberOfVehicles

This is the number of vehicles used on this lane.

Shipment Size

Table: OptimizationOutputPseudoRoutingSummary

Internal Name: ShipmentSize

This column displays the shipment size used for the lane.

Flow Units

Table: OptimizationOutputPseudoRoutingSummary

Internal Name: FlowUnits

This column displays the number of product units to flow on this lane.

Number Of Movements

Table: OptimizationOutputPseudoRoutingSummary

Internal Name: NumberOfMovements

The number of individual movements on the lane.

Service Hours

Table: OptimizationOutputPseudoRoutingSummary

Internal Name: ServiceHours

The time, in hours, required for the product to leave the source and arrive at the customer.

Service Distance

Table: OptimizationOutputPseudoRoutingSummary

Internal Name: ServiceDistance

The distance between the source and the customer.

Departing Period Number

Table: OptimizationOutputPseudoRoutingSummary

Internal Name: DepartingPeriodNum

The sequence number for the period when the flow leaves the source. This value is useful in sorting periods sequentially rather than by name.

Arriving Period Number

Table: OptimizationOutputPseudoRoutingSummary

Internal Name: ArrivingPeriodNum

The sequence number for the period when the flow arrives at the customer. This value is useful in sorting periods sequentially rather than by name.

Scenario ID

Table: OptimizationOutputPseudoRoutingSummary

Internal Name: ScenarioID

Displays the identifier of the scenario for which the summary data was generated.

Sub-Scenario ID

Table: OptimizationOutputPseudoRoutingSummary

Internal Name: StepNumber

Displays the identifier of the sub-scenario, if applicable, for which the summary data was generated.

Last modified: Wednesday May 15, 2024

Is this useful?

Yes No