InterSite Flows

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 Flows

Internal Table Name: OptimizationOutputInterfacilityFlows

This output table summarizes the specifics of all shipments between sites in the network.

Scenario

Table: OptimizationOutputInterfacilityFlows

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

The scenario for which the summary data was generated.

Source Name

Table: OptimizationOutputInterfacilityFlows

Internal Name: SourceName

Site where the product originated.

Departing Period Name

Table: OptimizationOutputInterfacilityFlows

Internal Name: DepartingPeriodName

The period in which this flow leaves the source.

Destination Name

Table: OptimizationOutputInterfacilityFlows

Internal Name: DestinationName

Site to where the product is shipped.

Arriving Period Name

Table: OptimizationOutputInterfacilityFlows

Internal Name: ArrivingPeriodName

The period in which this flow arrives at the destination.

Product Name

Table: OptimizationOutputInterfacilityFlows

Internal Name: ProductName

The name of the product being shipped.

Temperature Class

Table: OptimizationOutputCustomerFlows

Internal Name: TemperatureClass

Displays the temperature class for the product as defined in the Products table. This is one of Standard, Refrigerated, Frozen or Heated.

Hazardous Goods

Table: OptimizationOutputCustomerFlows

Internal Name: HazardousGoods

Displays whether or not the product has been defined as hazardous in the Products table.

Organization Name

Table: OptimizationOutputInterfacilityFlows

Internal Name: OrganizationName

The Organization to which the intersite flow is allocated. When the Sites that define the flow belong to an Organization, the flow is attributed to the Organization as required based on the Responsible Party value in the Transportation Policies table.

Shipment Size

Table: OptimizationOutputCustomerFlows

Internal Name: AverageShipmentSize

The shipment size based on the Shipment Size as defined for the transportation lane. When a Mode value is populated for the transportation policy, the Shipment Size from the Modes table is used. If the Transportation Policy also has Shipment Size populated, that value overrides the one from the Modes table.

Shipment Size Basis

Table: OptimizationOutputCustomerFlows

Internal Name: ShipmentSizeBasis

The unit of measure for the Shipment Size.

Mode

Table: OptimizationOutputInterfacilityFlows

Internal Name: ModeName

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

Flow Units

Table: OptimizationOutputInterfacilityFlows

Internal Name: FlowUnits

The number of units shipped over this lane in this period.

Flow Weight

Table: OptimizationOutputInterfacilityFlows

Internal Name: FlowWeight

The weight of all units shipped over this lane in this period.

Flow Cubic

Table: OptimizationOutputInterfacilityFlows

Internal Name: FlowCubic

The cubic volume of all units shipped over this lane in this period.

Service Hours

Table: OptimizationOutputInterfacilityFlows

Internal Name: ServiceHours

The time, in hours, required for the product to leave the source and arrive at the destination. This time includes the load time, the transport time, and the unload time.

Service Distance

Table: OptimizationOutputInterfacilityFlows

Internal Name: ServiceDistance

The distance between the source and destination. This is the Distance populated in Transportation Policies, or if that column is not populated, it is the Distance as defined in the Transit Matrix table. If neither column is populated, it is the calculated distance between the source and destination.

Inbound Warehousing Policy Cost

Table: OptimizationOutputInterfacilityFlows

Internal Name: InboundWarehousingCost

The sum of all costs involved in bringing goods from dock to stock at the destination. This amount is the number of flow units multiplied by the Unit Inbound Cost for the Inventory Policy at the destination site. If piecewise costs are used, their values are based on whether you are using All Item Discounts or the default of Incremental Discounts.

Outbound Warehousing Policy Cost

Table: OptimizationOutputInterfacilityFlows

Internal Name: OutboundWarehousingCost

The sum of all costs involved in bringing goods from stock to dock at the source over this lane in this period. This amount is the number of flow units multiplied by the Unit Outbound Cost for the inventory policy at the sourcing site. If piecewise costs are used, their values are based on whether you are using All Item Discounts or the default of Incremental Discounts.

Transportation Policy Cost

Table: OptimizationOutputInterfacilityFlows

Internal Name: TransportationCost

The total cost for shipping this product between source and destination sites in the network over this lane in this period. This amount is the product of the number of flow units, the average unit cost as specified in the Transportation Policies table, and the number of units as determined by the Transportation Policy Variable Cost Basis, such as Distance, Quantity, Weight, and so on. It also considers the Min Charge value if defined. If piecewise costs are used, their values are based on whether you are using All Item Discounts or the default of Incremental Discounts.

Sourcing Policy Cost

Table: OptimizationOutputInterfacilityFlows

Internal Name: SourcingPolicyCost

The total cost involved in sourcing this product from the Source Site in this period.

Sourcing Policy Cost = Flow Units * Unit Sourcing Cost specified in Site Sourcing Policies table

If piecewise costs are used, their values are based on whether you are using All Item Discounts or the default of Incremental Discounts.

Duty Cost

Table: OptimizationOutputInterfacilityFlows

Internal Name: DutyCost

The total costs due to taxes and tariffs levied on shipments over this shipment lane in this period. This amount is the product of the number of flow units, the Duty Cost in Transportation Policies, and the Product Value in the Products table.

Replenishment Frequency

Table: OptimizationOutputInterfacilityFlows

Internal Name: ReplenishmentFrequency

The calculated days between shipments used for inventory optimization. This is calculated as:

(2 *(Cycle Stock * Period Length))/Flow Units

where the Flow Units are per Source, Destination, Product, Mode, Period combination.

Cycle Stock

Table: OptimizationOutputInterfacilityFlows

Internal Name: CycleStock

The cycle stock allocated for the specific InterSite flow.

In Transit Inventory

Table: OptimizationOutputInterfacilityFlows

Internal Name: InTransitInventory

The amount of product that is inaccessible because it is in transit between two sites. The outbound flow per day is the Flow Units multiplied by the minimum of either the Transport Time (from Transportation Policies) or the time remaining in the model horizon, the result of which is divided by the Period Length in days.

in transit inventory = intersite Flow Units * minimum of (model remaining days until the end of horizon, Transportation Policy Transport Time in days) / period length in days

In Transit Inventory in InterSite Flows includes only Transportation-based in transit inventory and not production-based in transit inventory

In Transit Inventory Holding Cost

Table: OptimizationOutputInterfacilityFlows

Internal Name: IntransitInventoryHoldingCost

The total cost involved in products being in transport over this lane in this period.

in transit inventory holding cost = in transit inventory * product value * carrying cost % * (period length/365)

where in transit inventory is

intersite Flow Units * minimum of (model remaining days until the end of horizon, Transportation Policy Transport Time in days) / period length in days

For the Transportation Time used to calculate In Transit Inventory, the minimum of the transport time or the sum of all period lengths in Days is used. It does not go past the end of the model horizon.

If the Inv Carrying Cost % is populated in Inventory Policies, this value is used; otherwise the Inventory Carrying Cost % from Model Settings is used.

CO2

Table: OptimizationOutputInterfacilityFlows

Internal Name: CO2

The carbon emissions in the units of the inputs on the lanes. This value is the CO2 and CO2 Basis for the lane as specified in Transportation Policies, multiplied by the number of units flowing on the lane.

For example, if you have set the CO2 Basis to Weight-Distance, then the CO2 here is expressed as:

(Product Weight * Distance * CO2) * FlowUnits

CO2 Cost

Table: OptimizationOutputInterfacilityFlows

Internal Name: CO2Cost

The total cost incurred due to carbon emissions. The Carbon Cost is available in the Greenhouse Gases table.

Total Cost

Table: OptimizationOutputInterfacilityFlows

Internal Name: TotalCost

The total cost incurred for the intersite flow.

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

Lead Time Cost

Table: OptimizationOutputInterfacilityFlows

Internal Name: LeadTimeCost

The cost incurred on the InterSite flow due to lead time.

Lead Time Cost = (product’s Lead Time Cost/Day/Unit) * Flow Units * (Transport Time in Days from Transportation Policies table)

Sourcing Process Cost

Table: OptimizationOutputInterfacilityFlows

Internal Name: SourcingProcessCost

The total cost incurred for all sourcing processes associated with this flow:

Sourcing Process Cost = Flow Units * Unit Process Cost specified in the Sourcing Process Steps table

Transportation Process Cost

Table: OptimizationOutputInterfacilityFlows

Internal Name: TransportationProcessCost

The total cost incurred for all transportation processes associated with this flow:

Transportation Process Cost = Flow Units * Unit Process Cost specified in the Transportation Process Steps table

Inbound Inventory Process Cost

Table: OptimizationOutputInterfacilityFlows

Internal Name: InboundInventoryProcessCost

The total cost incurred for all inventory processes associated with the flow into the destination:

Inbound Inventory Process Cost = Flow Units * Unit Process Cost specified in the Inventory Process Steps table associated with the destination

Outbound Inventory Process Cost

Table: OptimizationOutputInterfacilityFlows

Internal Name: OutboundInventoryProcessCost

The total cost incurred for all inventory processes associated with the flow out of the source:

Outbound Inventory Process Cost = Flow Units * Unit Process Cost specified in the Inventory Process Steps table associated with the source

Total Sourcing Cost

Table: OptimizationOutputInterfacilityFlows

Internal Name: TotalSourcingCost

The total sourcing cost incurred on the intersite flow:

Total Sourcing Cost = Sourcing Policy Cost + Sourcing Process Cost

Total Inbound Warehousing Cost

Table: OptimizationOutputInterfacilityFlows

Internal Name: TotalInboundWarehousingPolicyCost

The total cost incurred due to inbound warehousing on the intersite flow:

Total Inbound Warehousing Cost = Inbound Inventory Warehousing Cost + Inbound Inventory Process Cost

Total Outbound Warehousing Cost

Table: OptimizationOutputInterfacilityFlows

Internal Name: TotalOutboundWarehousingPolicyCost

The total cost incurred due to outbound warehousing on the intersite flow:

Total Outbound Warehousing Cost = Outbound Inventory Warehousing Cost + Outbound Inventory Process Cost

Total Transportation Cost

Table: OptimizationOutputInterfacilityFlows

Internal Name: TotalTransportationCost

The total transportation cost incurred on the intersite flow:

Total Transportation Cost = Transportation Policy Cost + Transportation Process Cost.

Departing Period Number

Table: OptimizationOutputInterfacilityFlows

Internal Name: DepartingPeriodNum

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

Arriving Period Number

Table: OptimizationOutputInterfacilityFlows

Internal Name: ArrivingPeriodNum

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

Scenario ID

Table: OptimizationOutputInterfacilityFlows

Internal Name: ScenarioID

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

Sub-Scenario ID

Table: OptimizationOutputInterfacilityFlows

Internal Name: StepNumber

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