Cost To Serve Network Summary

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 Network Summary

Internal Table Name: OutputCostToServeNetworkSummary

This output table provides scenario-level metrics about the paths created by Cost To Serve, including path lengths, costs, revenue, and profit values.

Scenario

Table: OutputCostToServeNetworkSummary

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

The scenario for which the summary data was generated.

Run Time

Table: OutputCostToServeNetworkSummary

Internal Name: RunTime

The date and time of the optimization run.

Peak Memory Usage

Table: OutputCostToServeNetworkSummary

Internal Name: PeakMemoryUsage

The maximum amount of memory used by the solver process.

Total Paths

Table: OutputCostToServeNetworkSummary

Internal Name: TotalPath

The total number of network paths generated by Cost To Serve Analysis.

Total Reported Paths

Table: OutputCostToServeNetworkSummary

Internal Name: TotalReportedPath

The total number of network paths that are included in the Cost To Serve Analysis output. Some paths may be filtered out based on insignificant flow percentage.

Total Cross Period Paths

Table: OutputCostToServeNetworkSummary

Internal Name: TotalCrossPeriodPath

The number of network paths that start in one period but end in another.

Max Path Length

Table: OutputCostToServeNetworkSummary

Internal Name: MaxPathLength

The maximum length of a network path based on the number of lanes (or arcs) that make up the path. A lane is defined for each movement from a source to destination, and when a product is held at a location for more than one period (each period the product is held is a lane).

Min Path Length

Table: OutputCostToServeNetworkSummary

Internal Name: MinPathLength

The minimum length of a network path based on the number of lanes (or arcs) that make up the path. A lane is defined for each movement from a source to destination, and when a product is held at a location for more than one period (each period the product is held is a lane).

Average Path Length

Table: OutputCostToServeNetworkSummary

Internal Name: AveragePathLength

The average length of a network path based on the number of lanes (or arcs) that make up the path. A lane is defined for each movement from a source to destination, and when a product is held at a location for more than one period (each period the product is held is a lane).

Total Revenue

Table: OutputCostToServeNetworkSummary

Internal Name: TotalRevenue

The total revenue generated by product units shipped to customers. This is the (sum of all product demand met) * (price per product)

Total Cost

Table: OutputCostToServeNetworkSummary

Internal Name: TotalCost

The total network cost incurred after optimization. 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.

Total Profit

Table: OutputCostToServeNetworkSummary

Internal Name: TotalProfit

The total profit of the optimization network. This is Total Revenue - Total Cost.

Total Lane Cost

Table: OutputCostToServeNetworkSummary

Internal Name: TotalLaneCost

The total transportation cost incurred for all the lanes generated for the network paths. This is the cost summed over:

InterSite Flows - Total Sourcing Cost, Total Inbound Warehousing Cost, Total Transportation Cost, CO2 Cost, Duty Cost, In Transit Inventory Holding Cost.
Customer Flows - Total Sourcing Cost, Total Outbound Warehousing Cost, Total Transportation Cost, CO2 Cost, Duty Cost, In Transit Inventory Holding Cost. This includes disposal flows (the destination/customer name is "Trash" and the mode name is "EXPIRED PRODUCT") and trash flows (the destination/customer name is "Trash" and the mode name is "UNUSED BYPRODUCT").
Return Flows - Total Return Cost, Total Inbound Warehousing Cost, Total Transportation Cost

Total Site Cost

Table: OutputCostToServeNetworkSummary

Internal Name: TotalSiteCost

The total cost incurred for site-related activity, including operating cost, startup cost, and closing cost. This is the cost summed over:

Sites - Total Fixed Startup Cost, Total Fixed Operating Cost, Total Closing Cost, Site Variable Cost, Total Capital Investment, Total CO2 Cost.
Customers - Total Demand Penalty Cost.
Work Centers - Total Fixed Startup Cost, Total Fixed Operating Cost, Total Closing Cost.
Work Resources - Variable Cost.

Total Site Product Cost

Table: OutputCostToServeNetworkSummary

Internal Name: TotalSiteProductCost

The total cost incurred for product-related activity at sites, including inventory holding cost and production cost. This is the cost summed over:

Production - Total Production Cost.
Inventory - Total Inv Holding Cost.

Total Other Cost

Table: OutputCostToServeNetworkSummary

Internal Name: TotalOtherCost

This includes the following costs: Transportation Asset Cost, Expression Based Cost, Return Cost, Carbon Offset Cost, and Production Costs with no outbound flows. It also includes duty costs incurred based on entries in the Duty Rate table. 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 .

Total Flow Rate

Table: OutputCostToServeNetworkSummary

Internal Name: TotalFlowRate

The Total Flow Rate is calculated as the total flow quantity (final product) / service time.

Total Revenue Rate

Table: OutputCostToServeNetworkSummary

Internal Name: TotalRevenueRate

The Total Revenue Rate is calculated as the total revenue / service time. For additional information, see Cost to serve revenue and profit rates.

Total Profit Rate

Table: OutputCostToServeNetworkSummary

Internal Name: TotalProfitRate

The Total Revenue Rate is calculated as the total revenue / service time. For additional information, see Cost to serve revenue and profit rates.

Total Weighted Service Time

Table: OutputCostToServeNetworkSummary

Internal Name: TotalWeightedServiceTime

The Total Weighted Service Time is calculated as (path1 service time * path1 revenue / total revenue) + (path2 service time * path2 revenue / total revenue) + ... (pathn service time * pathn revenue / total revenue). For additional information, see Cost to serve revenue and profit rates.

Scenario ID

Table: OutputCostToServeNetworkSummary

Internal Name: ScenarioID

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

Sub-Scenario ID

Table: OutputCostToServeNetworkSummary

Internal Name: StepNumber

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

Last modified: Monday July 29, 2024

Is this useful?

Yes No