Cost To Serve Product Details

Internal Table Name: OptimizationOutputNetworkPathsProductDetails

The Cost To Serve Product Details table is populated when you run the Cost To Serve Analysis problem type. You can use this table to review the flow quantity, production cost and inventory holding cost per Path-Site-Product.

Scenario

Table: OptimizationOutputNetworkPathsProductDetails

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

The scenario for which the summary data was generated.

Path ID

Table: OptimizationOutputNetworkPathsProductDetails

Internal Name: PathID

The path generated by Cost to Serve Analysis.

Site

Table: OptimizationOutputNetworkPathsProductDetails

Internal Name: SiteName

The name of the site that is handling the product on this network path.

Product

Table: OptimizationOutputNetworkPathsProductDetails

Internal Name: ProductName

The name of the product that the customer is served on this network path.

Flow Quantity

Table: OptimizationOutputNetworkPathsProductDetails

Internal Name: FlowQty

The quantity of product that flows through this site on the path.

Production Cost

Table: OptimizationOutputNetworkPathsProductDetails

Internal Name: ProductionCost

The production cost incurred for product at this site on the path.

Inventory Holding Cost

Table: OptimizationOutputNetworkPathsProductDetails

Internal Name: InventoryHoldingCost

The inventory cost incurred for holding product at the site.

Starting Period ID

Table: OptimizationOutputNetworkPathsProductDetails

Internal Name: StartPeriodID

The identifier of the period in which the path starts.

Ending Period ID

Table: OptimizationOutputNetworkPathsProductDetails

Internal Name: EndPeriodID

The identifier of the period in which the path end.

Scenario ID

Table: OptimizationOutputNetworkPathsProductDetails

Internal Name: ScenarioID

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

Sub-Scenario ID

Table: OptimizationOutputNetworkPathsProductDetails

Internal Name: StepNumber

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