InterSite Shipment Flows

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

InterSite Shipment Flows

Internal Table Name: SimulationOutputInterfacilityShipmentFlows

Available only in Classic Simulation. This table displays the flows between facilities per period for a product on a specific mode.

Scenario

Table: SimulationOutputInterfacilityShipmentFlows

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

Displays the name of the scenario which generated the intersite shipment flows data.

Source Name

Table: SimulationOutputInterfacilityShipmentFlows

Internal Name: SourceName

Displays where the product is shipped from.

Destination Name

Table: SimulationOutputInterfacilityShipmentFlows

Internal Name: DestinationName

Displays where the product is shipped to.

Product Name

Table: SimulationOutputInterfacilityShipmentFlows

Internal Name: ProductName

Displays the item that is being shipped.

Mode

Table: SimulationOutputInterfacilityShipmentFlows

Internal Name: Mode

Displays the transportation lane that is being used in case of multiple modes.

Flow Units

Table: SimulationOutputInterfacilityShipmentFlows

Internal Name: FlowUnits

Displays the number of products shipped.

Flow Weight

Table: SimulationOutputInterfacilityShipmentFlows

Internal Name: FlowWeight

Displays the total weight of all units shipped.

Flow Cubic

Table: SimulationOutputInterfacilityShipmentFlows

Internal Name: FlowCubic

Displays the total cubic volume of all units shipped.

Flow Revenue

Table: SimulationOutputInterfacilityShipmentFlows

Internal Name: FlowRevenue

Displays the total revenue generated by product being shipped on this InterSite flow. The revenue is the Product Price multiplied by the units of demand served.

Flow Inbound Warehousing Cost

Table: SimulationOutputInterfacilityShipmentFlows

Internal Name: FlowInboundWarehousingCost

Displays the cost incurred by the specified path when entering the destination site in the specified period. This is based on the Fixed Inbound Shipment Cost and Inbound Unit Cost in the Inventory Policies table.

(Fixed Inbound Shipment Cost * Number of Shipments) + (Inbound Unit Cost * Flow Units)

Flow Outbound Warehousing Cost

Table: SimulationOutputInterfacilityShipmentFlows

Internal Name: FlowOutboundWarehousingCost

Displays the outbound warehousing cost incurred by the network path by leaving the source site. This is based on the Fixed Outbound Shipment Cost and Outbound Unit Cost in the Inventory Policies table.

(Fixed Outbound Shipment Cost * Number of Shipments) + (Outbound Unit Cost * Flow Units)

Flow Transportation Cost

Table: SimulationOutputInterfacilityShipmentFlows

Internal Name: FlowTransportationCost

Displays the total cost of shipping the units.

Flow Duty Cost

Table: SimulationOutputInterfacilityShipmentFlows

Internal Name: FlowDutyCost

Displays the additional duty cost incurred by the network path. The duty cost is calculated by multiplying the duty from Transportation Policies by the shipment’s total value. The total value is the Value from the Product table multiplied by shipment quantity.

Flow Total Cost

Table: SimulationOutputInterfacilityShipmentFlows

Internal Name: FlowTotalCost

The total cost incurred for the intersite flow (for each source - destination - product - mode - period combination):

Total Cost = Flow Inbound Warehousing Cost + Flow Outbound Warehousing Cost + Flow Transportation Cost + Flow Sourcing Cost + Flow Duty Cost + Flow Intransit Inventory Holding Cost + CO2 Cost

Flow Intransit Inventory Holding Cost

Table: SimulationOutputInterfacilityShipmentFlows

Internal Name: FlowIntransitInventoryHoldingCost

The cost incurred for holding inventory in transit for the shipment. This inventory is inaccessible because it is in transit between the source and destination.

Intransit Inventory

Table: SimulationOutputInterfacilityShipmentFlows

Internal Name: IntransitInventory

Displays the inventory that is held in transit for this shipment. Intransit inventory is inaccessible because it is in transit between the source and destination.

CO2

Table: SimulationOutputInterfacilityShipmentFlows

Internal Name: CO2

Displays the CO2 emissions of the flow. The value is displayed in your model default weight unit of measure.

Period

Table: SimulationOutputInterfacilityShipmentFlows

Internal Name: Period

Displays the Period number for the summary values. ALL indicates the record for the complete model horizon.

Expired Units

Table: SimulationOutputInterfacilityShipmentFlows

Internal Name: ExpiredUnits

Displays the number of product units that have expired in transit due to shelf life considerations. When you populate the Shelf Life column in the Products table, those products still in transit when the shelf life is reached will be expired.

Outbound Average Age

Table: SimulationOutputInterfacilityShipmentFlows

Internal Name: OutboundAverageAge

This is the weighted average age of a product batch when it leaves the source. Since aging does not begin until production is complete, products shipped immediately upon completion of production will incur no Outbound Average Age from the manufacturer.

Inbound Average Age

Table: SimulationOutputInterfacilityShipmentFlows

Internal Name: InboundAverageAge

This is the weighted average age of a product batch when it arrives at the destination. This column takes into consideration the transit times from the production site to this destination. For example, if you have a path from MFG -> Hub -> DC, the Inbound Average Age when it reaches the DC includes both the travel time from MFG to Hub and from Hub to DC.

Scenario ID

Table: SimulationOutputInterfacilityShipmentFlows

Internal Name: ScenarioID

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

Sub-Scenario ID

Table: SimulationOutputInterfacilityShipmentFlows

Internal Name: StepNumber

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

Rep

Table: SimulationOutputInterfacilityShipmentFlows

Internal Name: Rep

Displays the replication number that the data on this row apply to.

Last modified: Wednesday May 15, 2024

Is this useful?

Yes No