Multi-Stop Estimation Cost Matrix

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 Cost Matrix

Internal Table Name: OwnVehicleCostMatrix

The Multi-Stop Estimation Cost Matrix table is populated with the drop size bands, distance breakpoints and time values as calculated when you turn on the Run Multi-Stop Estimation With NO function on the Multi-Stop Estimation tab in Network Optimization Options.

Scenario

Table: OwnVehicleCostMatrix

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

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

Vehicle Type ID

Table: OwnVehicleCostMatrix

Internal Name: VehicleTypeID

This field displays the type of vehicle to which the multi-stop estimation matrix applies.

Mode

Table: OwnVehicleCostMatrix

Internal Name: ModeName

This field displays the name of the Mode that references the Multi-Stop Estimation Vehicle Cost record in the Fixed Shipment Cost column.

Drop Size Bands

Table: OwnVehicleCostMatrix

Internal Name: DropSizeBands

This field displays the average drop size for each band in the matrix. These bands are based on demand Quantity for the products that can be moved on the vehicle. The bands are the same for each of the distance breakpoints defined in the matrix. You control the number of drop size bands using the Number Of Cost Function Drop Size Points option.

Distance Breakpoints

Table: OwnVehicleCostMatrix

Internal Name: DistanceBreakpoints

This field displays the distance for each distance breakpoint in the matrix. You control the number of distance breakpoints using the Number Of Cost Function Distance Points.

Apportioned Time

Table: OwnVehicleCostMatrix

Internal Name: ApportionedTime

This field displays the time apportioned to the drop size band-distance breakpoint combination in the matrix.

Apportioned Distance

Table: OwnVehicleCostMatrix

Internal Name: ApportionedDistance

This field displays the distance apportioned to the drop size band-distance breakpoint combination in the matrix.

Cost

Table: OwnVehicleCostMatrix

Internal Name: Cost

This field displays the cost apportioned to the drop size band-distance breakpoint combination in the matrix.

Unit of Measure ID

Table: OwnVehicleCostMatrix

Internal Name: UnitOfMeasureID

This field displays the identifier for the unit of measure used when multi-cost estimation is run for the drop size band-distance breakpoint combination in the matrix.

Transportation Region ID

Table: OwnVehicleCostMatrix

Internal Name: TransportationRegionID

This field displays the identifier of the Transportation Region to which customer were assigned for the drop size band-distance breakpoint combination in the matrix.

Calendar Period ID

Table: OwnVehicleCostMatrix

Internal Name: CalendarPeriodID

This field displays the identifier of the calendar period to which customer demand was assigned for the drop size band-distance breakpoint combination in the matrix.

Scenario ID

Table: OwnVehicleCostMatrix

Internal Name: ScenarioID

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

Sub-Scenario ID

Table: OwnVehicleCostMatrix

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