Customer Flows

Internal Table Name: OptimizationOutputCustomerFlows

This output table summarizes the specifics of all shipments to customers in the network.

Scenario

Table: OptimizationOutputCustomerFlows

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

The scenario for which the summary data was generated.

Source Name

Table: OptimizationOutputCustomerFlows

Internal Name: SourceName

The site which shipped the product.

Departing Period Name

Table: OptimizationOutputCustomerFlows

Internal Name: DepartingPeriodName

The period in which the flow leaves the source.

Customer Name

Table: OptimizationOutputCustomerFlows

Internal Name: CustomerName

The Customer location which receives the shipment.

Arriving Period Name

Table: OptimizationOutputCustomerFlows

Internal Name: ArrivingPeriodName

The period in which the flow arrives at the customer.

Product Name

Table: OptimizationOutputCustomerFlows

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

Internal Name: OrganizationName

The Organization to which the customer 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 based on the Responsible Party value in the Transportation Policies table.

Mode

Table: OptimizationOutputCustomerFlows

Internal Name: ModeName

The lane differentiation parameter defined in Transportation Policies.

Total Demand

Table: OptimizationOutputCustomerFlows

Internal Name: TotalDemand

The total customer demand for this product over this lane in this period. This is the demand that the flow is attempting to satisfy. If the Total Demand is satisfied by multiple sources, the Total Demand will not match the Total Demand Served for the specific flow.

This may represent a substituted product if product substitution is being used, even though no actual customer demand exists for the substituted product.

Total Demand Served

Table: OptimizationOutputCustomerFlows

Internal Name: TotalDemandServed

Displays the total demand that was served for this customer and product in this period by the specific source. In some cases, the Total Demand Served may not be equal to the Total Demand. For example, in Period_001, CZ_01007 has demand for 100 units of product KL2100. In the case that the demand is sourced by multiple sites, the Customer Flows may show results such as the following:

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.

Flow Units

Table: OptimizationOutputCustomerFlows

Internal Name: FlowUnits

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

Flow Weight

Table: OptimizationOutputCustomerFlows

Internal Name: FlowWeight

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

Flow Weight = Flow Units * Product Weight

Flow Cubic

Table: OptimizationOutputCustomerFlows

Internal Name: FlowCubic

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

Flow Cubic = Flow Units * Product Volume

Service Hours

Table: OptimizationOutputCustomerFlows

Internal Name: ServiceHours

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

service hours = load time + transport time + unload time

Service Distance

Table: OptimizationOutputCustomerFlows

Internal Name: ServiceDistance

The distance between the source and destination.

Flow Revenue

Table: OptimizationOutputCustomerFlows

Internal Name: FlowRevenue

The revenue generated by the units shipped over this lane in this period. The Price is from the Products table, but you can override it by specifying a Unit Price in the Customer Demand table.

Outbound Warehousing Policy Cost

Table: OptimizationOutputCustomerFlows

Internal Name: OutboundWarehousingPolicyCost

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 product of 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: OptimizationOutputCustomerFlows

Internal Name: TransportationPolicyCost

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, 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.

Sourcing Policy Cost

Table: OptimizationOutputCustomerFlows

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 Customer 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: OptimizationOutputCustomerFlows

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.

In Transit Inventory

Table: OptimizationOutputCustomerFlows

Internal Name: InTransitInventory

The amount of product that is inaccessible because it is in transit between a site and customer.

in transit inventory = customer 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 Holding Cost

Table: OptimizationOutputCustomerFlows

Internal Name: IntransitInventoryHoldingCost

The cost from units considered as inventory due to their inaccessibility during transportation. This amount is calculated by multiplying the In Transit 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 * carrying cost % * (period length/365)

where in transit inventory is

customer Flow Units * minimum of (model remaining days until the end of horizon, Transportation Policy Transport Time in days) / period length 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.

CO2

Table: OptimizationOutputCustomerFlows

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

Internal Name: CO2Cost

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

Total Cost

Table: OptimizationOutputCustomerFlows

Internal Name: TotalCost

The total cost incurred for the customer flow.

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

Lead Time Cost

Table: OptimizationOutputCustomerFlows

Internal Name: FlowLeadTimeCost

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

flow lead time cost = (the product’s Lead Time Cost/Day/Unit) * (Flow Units) * (Transport Time in days from the Transportation Policies table)

Sourcing Process Cost

Table: OptimizationOutputCustomerFlows

Internal Name: SourcingProcessCost

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

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

Transportation Process Cost

Table: OptimizationOutputCustomerFlows

Internal Name: TransportationProcessCost

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

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

Outbound Inventory Process Cost

Table: OptimizationOutputCustomerFlows

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 Outbound Warehousing Cost

Table: OptimizationOutputCustomerFlows

Internal Name: TotalOutboundWarehousingCost

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

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

Total Sourcing Cost

Table: OptimizationOutputCustomerFlows

Internal Name: TotalSourcingCost

The total sourcing cost incurred on the customer flow:

Total Sourcing Cost = Sourcing Policy Cost + Sourcing Process Cost

Total Transportation Cost

Table: OptimizationOutputCustomerFlows

Internal Name: TotalTransportationCost

The total transportation cost incurred on the customer flow:

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

Departing Period Number

Table: OptimizationOutputCustomerFlows

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

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

Internal Name: ScenarioID

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

Sub-Scenario ID

Table: OptimizationOutputCustomerFlows

Internal Name: StepNumber

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