Cost To Serve Details

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

Cost To Serve Details

Internal Table Name: OptimizationOutputNetworkPathsDetails

The Cost To Serve Details table is populated when you run the Cost To Serve Analysis problem type. You can use Cost To Serve to review the landed cost of the overall flow of product from production to customer receipt for Network Optimization. The results are provided with the lane by lane flow per Customer-Product-Period.

Scenario

Table: OptimizationOutputNetworkPathsDetails

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

The scenario for which the summary data was generated.

Customer

Table: OptimizationOutputNetworkPathsDetails

Internal Name: CustomerName

The name of the customer being served on this network path. In some cases, the Customer column in the Cost To Serve Details table can be populated with Site names. If a Site is displayed in the Customer column, this is an indication that this Site had flow that never reached a Customer. This can occur if flow ends up as inventory instead of being shipped to the Customer. These types of paths are categorized as “Incomplete Paths” in the log file.

Finished Good

Table: OptimizationOutputNetworkPathsDetails

Internal Name: FinishedGood

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

Mode

Table: OptimizationOutputNetworkPathsDetails

Internal Name: Mode

The mode used to serve the customer for the product on this network path.

Start Period

Table: OptimizationOutputNetworkPathsDetails

Internal Name: StartPeriodName

The period in which the lane starts.

Start Period Number

Table: OptimizationOutputNetworkPathsDetails

Internal Name: StartPeriodNum

The period number in which the lane starts.

End Period

Table: OptimizationOutputNetworkPathsDetails

Internal Name: EndPeriodName

The period in which the lane ends.

End Period Number

Table: OptimizationOutputNetworkPathsDetails

Internal Name: EndPeriodNum

The period number in which the lane ends.

Path ID

Table: OptimizationOutputNetworkPathsDetails

Internal Name: PathID

The unique identifier for the network path.

Lane ID

Table: OptimizationOutputNetworkPathsDetails

Internal Name: LaneID

The unique identifier of the lane.

Start Location Name

Table: OptimizationOutputNetworkPathsDetails

Internal Name: StartLocationName

The source location for the lane.

End Location Name

Table: OptimizationOutputNetworkPathsDetails

Internal Name: EndLocationName

The destination location for the lane.

Product

Table: OptimizationOutputNetworkPathsDetails

Internal Name: ProductName

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

Total Quantity

Table: OptimizationOutputNetworkPathsDetails

Internal Name: TotalQuantity

The total quantity of product that moves on this lane.

For production involving Bills of Material, the end product quantity is equally distributed across the components. For instance, X units of component 1, Y units of component 2, and Z units of component 3 make 1 unit of the end product. In this case, the flow quantity assigned to each component is 1/3 unit.

Total Cost

Table: OptimizationOutputNetworkPathsDetails

Internal Name: TotalCost

The total cost incurred for this lane. In addition to the various cost categories, such as Production Cost, Transportation Cost and others, the Site Variable Cost from the Sites table is included in the Total Cost value.

Fixed Startup Cost

Table: OptimizationOutputNetworkPathsDetails

Internal Name: FixedStartupCost

The one-time cost incurred for starting operations at the location. This includes both site and work center costs.

Fixed Operating Cost

Table: OptimizationOutputNetworkPathsDetails

Internal Name: FixedOperatingCost

The cost incurred handling product at the location. This includes both site and work center costs.

Closing Cost

Table: OptimizationOutputNetworkPathsDetails

Internal Name: ClosingCost

The cost incurred when a location is closed. This includes both site and work center costs.

Site Variable Cost

Table: OptimizationOutputNetworkPathsDetails

Internal Name: SiteVariableCost

This is the cost incurred for throughput units at the site regardless of the product, based on the Site Variable Cost and Site Variable Cost Basis defined in the Sites table.

Space Expansion Cost

Table: OptimizationOutputNetworkPathsDetails

Internal Name: Space Expansion Cost

The cost incurred at the site when the floor area allocated for spaces is expanded.

Production Cost

Table: OptimizationOutputNetworkPathsDetails

Internal Name: ProductionCost

The cost incurred based on production.

Transportation Cost

Table: OptimizationOutputNetworkPathsDetails

Internal Name: TransportationCost

The cost of transporting product between the Start Location and the End Location.

Facility Inventory Holding Cost

Table: OptimizationOutputNetworkPathsDetails

Internal Name: FacilityInventoryHoldingCost

The inventory cost incurred for holding product at a site.

In-transit Inventory Holding Cost

Table: OptimizationOutputNetworkPathsDetails

Internal Name: IntransitInventoryHoldingCost

The inventory cost incurred for items in transit, based on the travel time and units of product.

Sourcing Cost

Table: OptimizationOutputNetworkPathsDetails

Internal Name: SourcingCost

The cost of sourcing products from facilities.

Inbound Warehousing Cost

Table: OptimizationOutputNetworkPathsDetails

Internal Name: InboundWarehousingCost

The cost of bringing units into facilities, from dock to stock, excluding transportation costs in the network.

Outbound Warehousing Cost

Table: OptimizationOutputNetworkPathsDetails

Internal Name: OutboundWarehousingCost

The cost of moving units out of facilities, from stock to dock, excluding transportation costs in the network.

Capital Investment

Table: OptimizationOutputNetworkPathsDetails

Internal Name: CapitalInvestment

The capital investment cost incurred for sites and work centers.

Facility CO2 Cost

Table: OptimizationOutputNetworkPathsDetails

Internal Name: FacilityCO2Cost

The total cost attributed to carbon emissions, based on the Carbon Cost from the Greenhouse Gases table, due to Production.

Transportation CO2 Cost

Table: OptimizationOutputNetworkPathsDetails

Internal Name: TransportationCO2Cost

The cost attributed to carbon emissions, based on the Carbon Cost from the Greenhouse Gases table, due to InterSite Flows and Customer Flows.

Work Resources Cost

Table: OptimizationOutputNetworkPathsDetails

Internal Name: WorkResourcesCost

The cost from usage of work resources. This is the Fixed Resource Cost + Hourly Cost.

Duty Cost

Table: OptimizationOutputNetworkPathsDetails

Internal Name: DutyCost

The cost incurred for duty levied on shipments based on the Duty Rate in the Transportation Policies input table. The Duty Rate is a percentage that is multiplied by the Unit Value in the Product table multiplied by the shipment quantity. This determines the Duty Cost.

Costs incurred using the Duty Rate and Tax And Duty Regions tables will be included as part of the Other Cost column in the Cost To Serve Details table.

Refundable Tax

Table: OptimizationOutputNetworkPathsDetails

Internal Name: RefundableTax

This is the total refundable tax based on the flow of product for the network path.

Non-Refundable Tax

Table: OptimizationOutputNetworkPathsDetails

Internal Name: NonRefundableTax

This is the total non-refundable tax based on the flow of product for the network path.

Demand Penalty

Table: OptimizationOutputNetworkPathsDetails

Internal Name: DemandPenalty

The penalty cost when total demand Quantity is not satisfied.

Other Cost

Table: OptimizationOutputNetworkPathsDetails

Internal Name: OtherCost

This includes the following costs: Transportation Asset Cost, Expression Based Cost, Return Cost, Carbon Offset Cost, Tax Cost and Production Costs with no outbound flows. It also includes duty costs incurred based on entries in the Duty Rate and Tax And Duty Regions tables. Expansion costs, the Fixed Operating Space Expansion Cost from Sites and the Floor Expansion Cost from Site Storage Spaces and Site Shipping Spaces, are included. Costs that have "No path found" are also included in the Other Cost column. This can include costs such as Fixed Operating Cost that fails to be allocated to a path.

An example of the production costs is Site A makes 10 units of a product, but still has 10 units of that product in inventory at the end of the horizon. The production costs in this case are included in Other Cost .

Service Hours

Table: OptimizationOutputNetworkPathsDetails

Internal Name: ServiceHours

The time, in hours, required for the product to leave the Start Location and arrive at the End Location.

Service Distance

Table: OptimizationOutputNetworkPathsDetails

Internal Name: ServiceDistance

The distance between the Start Location and the End Location.

Scenario ID

Table: OptimizationOutputNetworkPathsDetails

Internal Name: ScenarioID

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

Sub-Scenario ID

Table: OptimizationOutputNetworkPathsDetails

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