Return 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

Return Flows

Internal Table Name: OptimizationOutputReturnFlows

This output table summarizes the specifics of all shipment returns from customers in the network.

Scenario

Table: OptimizationOutputReturnFlows

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

The scenario for which the summary data was generated.

Customer Name

Table: OptimizationOutputReturnFlows

Internal Name: CustomerName

The customer that shipped the return shipment.

Destination Name

Table: OptimizationOutputReturnFlows

Internal Name: DestinationName

The site that receives the return shipment.

Organization Name

Table: OptimizationOutputReturnFlows

Internal Name: OrganizationName

The Organization to which the return flow is allocated. When the Sites or Customers that define the flow belong to an Organization, the flow is attributed to the Organization as required.

Departing Period Name

Table: OptimizationOutputReturnFlows

Internal Name: DepartingPeriodName

The period in which the flow leaves the customer.

Arriving Period Name

Table: OptimizationOutputReturnFlows

Internal Name: ArrivingPeriodName

The period in which the flow arrives at the destination.

Received Product Name

Table: OptimizationOutputReturnFlows

Internal Name: ReceivedProductName

The name of the product received at the Customer.

Returned Product Name

Table: OptimizationOutputReturnFlows

Internal Name: ReturnedProductName

The name of the product returned to the destination site.

Temperature Class

Table: OptimizationOutputCustomerFlows

Internal Name: TemperatureClass

Displays the temperature class for the returned 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 returned product has been defined as hazardous in the Products table.

Mode

Table: OptimizationOutputReturnFlows

Internal Name: ModeName

The lane differentiation parameter defined in Transportation Policies.

Shipment Size

Table: OptimizationOutputReturnFlows

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: OptimizationOutputReturnFlows

Internal Name: ShipmentSizeBasis

The unit of measure for the Shipment Size.

Received Flow Units

Table: OptimizationOutputReturnFlows

Internal Name: ReceivedFlowUnits

The number of units of the product received at the Customer.

Returned Flow Units

Table: OptimizationOutputReturnFlows

Internal Name: ReturnedFlowUnits

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

Returned Flow Weight

Table: OptimizationOutputReturnFlows

Internal Name: ReturnedFlowWeight

The weight of the return units shipped over this lane in this period.

Returned Flow Weight = Returned Flow Units * Product Weight

Returned Flow Cubic

Table: OptimizationOutputReturnFlows

Internal Name: ReturnedFlowCubic

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

Returned Flow Cubic = Returned Flow Units * Product Volume Per Unit

Transportation Policy Cost

Table: OptimizationOutputReturnFlows

Internal Name: TransportationPolicyCost

The total cost for shipping this product between customer and destination sites in the network over this lane in this period.

This amount is the product of the number of returned 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, which is 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.

Return Policy Cost

Table: OptimizationOutputReturnFlows

Internal Name: ReturnPolicyCost

The total cost involved in returning this product to the destination site in this period. This amount is the number of returned flow units multiplied by the average unit cost, as specified in the Return 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.

Inbound Warehousing Policy Cost

Table: OptimizationOutputReturnFlows

Internal Name: InboundWarehousingPolicyCost

The cost incurred due to inbound warehousing for returns for product entering the destination.

Flow Duty Cost

Table: OptimizationOutputReturnFlows

Internal Name: FlowDutyCost

The additional duty cost incurred by the returns.

Intransit Inventory Holding Cost

Table: OptimizationOutputReturnFlows

Internal Name: IntransitInventoryHoldingCost

The cost from units considered as inventory due to their inaccessibility during transportation. This amount is calculated by multiplying the Intransit Inventory, the product Value, and the Inv Carrying Cost % from Model Settings, and then dividing the result by 365. 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.

In Transit Inventory Holding Cost =

((In Transit Inventory * Product Value * Inventory Carrying Cost %* Period Length) / 365) * minimum of (Model Horizon in days, Service Time in days)

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

Intransit Inventory

Table: OptimizationOutputReturnFlows

Internal Name: InTransitInventory

The amount of product that is inaccessible because it is in transit between two sites.

in transit inventory = (Flow Units) * (minimum of either Transport Time from Transportation Policies or time remaining in model horizon) / Period Length in days

Transportation Process Cost

Table: OptimizationOutputReturnFlows

Internal Name: TransportationProcessCost

The total cost incurred for the transportation processes.

Return Process Cost

Table: OptimizationOutputReturnFlows

Internal Name: ReturnProcessCost

The total cost incurred for the returns processes.

Inbound Inventory Process Cost

Table: OptimizationOutputReturnFlows

Internal Name: InboundInventoryProcessCost

The total cost incurred for the inbound inventory processes.

Total Transportation Cost

Table: OptimizationOutputReturnFlows

Internal Name: TotalTransportationCost

The total cost incurred for transportation of the returned product.

Total Return Cost

Table: OptimizationOutputReturnFlows

Internal Name: TotalReturnCost

The total cost incurred to handle the returned product.

Total Inbound Warehousing Cost

Table: OptimizationOutputReturnFlows

Internal Name: TotalInboundWarehousingCost

The total cost incurred due to warehousing for product entering the destination site.

Service Hours

Table: OptimizationOutputReturnFlows

Internal Name: ServiceHours

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

service hours = load time + transport time + unload time

Service Distance

Table: OptimizationOutputReturnFlows

Internal Name: ServiceDistance

The distance between the customer and destination.

CO2

Table: OptimizationOutputReturnFlows

Internal Name: CO2

The carbon emissions in the units of the inputs on the lanes. This value is a product of 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: OptimizationOutputReturnFlows

Internal Name: CO2Cost

The total cost incurred due to carbon emissions.

Total Cost

Table: OptimizationOutputReturnFlows

Internal Name: TotalCost

The total cost incurred for the return flow.

Total Cost = Flow Transportation Cost + Flow Return Cost + Intransit Inventory Holding Cost + CO2 Cost

Departing Period No

Table: OptimizationOutputReturnFlows

Internal Name: DepartingPeriodNum

The sequence number of the period in which the flow leaves the customer. This field is useful when supporting periods by sequence, rather than by name.

Arriving Period No

Table: OptimizationOutputReturnFlows

Internal Name: ArrivingPeriodNum

The sequence number of the period in which the flow arrives at the destination. This field is useful when supporting periods by sequence, rather than by name.

Scenario ID

Table: OptimizationOutputReturnFlows

Internal Name: ScenarioID

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

Sub-Scenario ID

Table: OptimizationOutputReturnFlows

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