Network Summary

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

Network Summary

Internal Table Name: OptimizationOutputNetworkSummary

Optimization output tables summarize cost, site, network flow, and demand statistics for your supply chain. The following is an explanation of how each of these metrics are measured or calculated.

The network summary summarizes total profit, costs, and revenue.

Scenario

Table: OptimizationOutputNetworkSummary

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

The scenario for which the summary data was generated.

Model Run Time

Table: OptimizationOutputNetworkSummary

Internal Name: ModelRunTime

The date and time of the optimization run.

Solve Duration

Table: OptimizationOutputNetworkSummary

Internal Name: SolveTime

The length of time required to complete the solve, in seconds.

Model Optimization Type

Table: OptimizationOutputNetworkSummary

Internal Name: ModelOptimizationType

The selected objective of the optimization, and the algorithm selected.

Solver Termination Condition

Table: OptimizationOutputNetworkSummary

Internal Name: SolverTerminationCondition

This value indicates what caused the solver to stop running. These are largely based on values on the Termination Settings tab in Network Optimization Options. The main values are:

Reached Gap - The solver reached the Relative Gap % or Absolute Gap. It will stop when either one of these is reached.
Aborted or Dynamic Termination - The solve was manually canceled, or one of the dynamic termination settings was reached as defined on the Termination Settings tab in Network Optimization Options.
Reached Memory Limit - The solve reached the system memory limit specified in the Memory Consumption Limit % option.
Reached Time Limit - The solve reached the time limit specified in the Time Limit (secs) option. If you have enabled the "Continue Until Solution Found" option, the solve time may exceed the Time Limit (secs).

Other values may be returned. These are typically codes from the underlying optimization technology and may be due to conditions such as out of memory status.

Model Period In Days

Table: OptimizationOutputNetworkSummary

Internal Name: ModelPeriodInDays

The number of days that are optimized according to the model.

Total Profit

Table: OptimizationOutputNetworkSummary

Internal Name: TotalProfit

The total profit of the optimization network and inventory structure.

Total Profit = Total Revenue - Total Cost

Total Cost

Table: OptimizationOutputNetworkSummary

Internal Name: TotalCost

The total network costs incurred after optimization.

Total Cost = total fixed startup cost + total fixed operating cost + total closing cost + total production cost + total transportation cost + total duty cost + total warehousing cost + total site inventory cost + total in transit inventory cost + total sourcing cost + total transportation asset cost + total work resource cost + total capital investment + (cost of carbon * amount of CO2 emission) + total expression based cost + total tax cost

Total Revenue

Table: OptimizationOutputNetworkSummary

Internal Name: TotalRevenue

The total revenue generated by units shipped to customers.

Total Revenue = (sum of all product demand met) * (price per product)

This value will also be equal to the following:

Network Customer Summary.Total Revenue, or
Network Product Summary.Total Revenue, or
Customer Flows.Flow Revenue, or
Customer Demand Summary.Total Revenue + Site Demand Summary.Total Revenue

Total Fixed Startup Cost

Table: OptimizationOutputNetworkSummary

Internal Name: TotalFixedStartupCost

The total cost of setting up potential facilities and work centers in the network.

Total Fixed Startup Cost = Network Site Summary.Total Fixed Startup Cost + Network Work Center Summary.Total Fixed Startup Cost

Total Fixed Operating Cost

Table: OptimizationOutputNetworkSummary

Internal Name: TotalFixedOperatingCost

The total cost to keep facilities and work centers in the network functional.

Total Fixed Operating Cost = Network Site Summary.Total Fixed Operating Cost + Network Work Center Summary.Total Fixed Operating Cost

Safety Stock Cost

Table: OptimizationOutputNetworkSummary

Internal Name: SafetyStockCost

The costs from the Inventory Policy Summary output table. If Safety Stock Optimization has not been run on this model, the value is blank.

This field is currently not implemented.

Total Ending Book Value

Table: OptimizationOutputNetworkSummary

Internal Name: TotalEndingBookValue

The sum over the Book Value of all Facilities and Work Centers in the Network Site Summary and Network Work Center Summary output tables for the last period of the model, for the specified scenario. It is NOT summed over all periods.

Total Closing Cost

Table: OptimizationOutputNetworkSummary

Internal Name: TotalClosingCost

The total cost of stopping production at facilities and work centers in the network.

Total Closing Cost = Network Site Summary.Total Closing Cost + Network Work Center Summary.Total Closing Cost

Total Capital Investment

Table: OptimizationOutputNetworkSummary

Internal Name: TotalCapitalInvestment

The sum over the Total Capital Investment values in the Network Site Summary and Network Work Center Summary output tables for the specified scenario.

Total Capital Investment = Network Site Summary.Total Capital Investment + Network Work Center Summary.Total Capital Investment

Accumulated Depreciation

Table: OptimizationOutputNetworkSummary

Internal Name: AccumulatedDepreciation

The sum over the Depreciation values in the Network Site Summary and Network Work Center Summary output tables for the specified scenario.

Total Production Cost

Table: OptimizationOutputNetworkSummary

Internal Name: TotalProductionCost

The total cost of producing units in the network.

Total Production Cost is equal to one of the following:

Network Site Summary.Total Production Cost, or
Network Product Summary.Total Production Cost, or
Production Flows.Total Production Cost

Total Inbound Warehousing Cost

Table: OptimizationOutputNetworkSummary

Internal Name: TotalInboundWarehousingCost

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

Total Inbound Warehousing Cost is equal to one of the following:

Network Site Summary.Total Inbound Warehousing Cost
InterSite Flows.Flow Inbound Warehousing Cost

Total Outbound Warehousing Cost

Table: OptimizationOutputNetworkSummary

Internal Name: TotalOutboundWarehousingCost

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

Total Outbound Warehousing Cost is equal to the following:

Network Site Summary.Total Outbound Warehousing Cost
InterSite Flows.Outbound Warehousing Cost + Customer Flows.Outbound Warehousing Cost

Total Transportation Cost

Table: OptimizationOutputNetworkSummary

Internal Name: TotalTransportationCost

The total cost of transporting units between sites in the network.

Total Transportation Cost is equal to one of the following:

Network Product Summary.Transportation Cost, or
InterSite Flows.Transportation Policy Cost + Customer Flows.Transportation Policy Cost

Total Return Cost

Table: OptimizationOutputNetworkSummary

Internal Name: TotalReturnCost

The total cost incurred for all returns.

Total Duty Cost

Table: OptimizationOutputNetworkSummary

Internal Name: TotalDutyCost

The total cost from taxes and tariffs levied on shipments.

Total Duty Cost is equal to one of the following:

Network Product Summary.Duty Cost, or
Network Site Summary.Total Duty Cost, or
InterSite Flows.Duty Cost + Customer Flows.Duty Cost

Total Warehousing Cost

Table: OptimizationOutputNetworkSummary

Internal Name: TotalWarehousingCost

The total of all warehousing costs.

Total Warehousing Cost = Total Inbound Warehousing Cost + Total Outbound Warehousing Cost

Total Sourcing Cost

Table: OptimizationOutputNetworkSummary

Internal Name: TotalSourcingCosto

The total cost of sourcing products from facilities.

Total Sourcing Cost is equal to one of the following:

Network Product Summary.Sourcing Cost, or
InterSite Flows.Sourcing Policy Cost + Customer Flows.Sourcing Policy Cost

Total Transportation Asset Cost

Table: OptimizationOutputNetworkSummary

Internal Name: TotalTransportationAssetCost

The total cost from usage of transportation assets. This is the Fixed Cost + Variable Cost in the Network Asset Summary table.

Total Work Resource Cost

Table: OptimizationOutputNetworkSummary

Internal Name: TotalWorkResourceCost

The total cost from usage of work resources. This is the Fixed Cost + Variable Cost in the Network Work Resource Summary table.

Total Expression Based Cost

Table: OptimizationOutputNetworkSummary

Internal Name: TotalExpressionBasedCost

This is the total cost incurred through the use of Expression Based Costs.

Total Unserved Demand Qty

Table: OptimizationOutputNetworkSummary

Internal Name: TotalUnservedDemandQty

The total quantity of demand that is unserved.

Gap Percent

Table: OptimizationOutputNetworkSummary

Internal Name: GapPercent

The percentage gap between best bound and best solution.

Solution Notes

Table: OptimizationOutputNetworkSummary

Internal Name: SolutionNotes

Currently not in use.

Network Risk Health

Table: OptimizationOutputNetworkSummary

Internal Name: NetworkRiskHealth

Provides the overall risk health of the network based on the risk scores determined for entities with risk profiles applied.

Total CO2

Table: OptimizationOutputNetworkSummary

Internal Name: TotalCO2

The total emissions of CO2. The value is displayed in your model default weight unit of measure.

Total CO2 = Customer Flows.CO2 + InterSite Flows.CO2 + Production Flows.CO2 + Network Site Summary.CO2

Total Carbon Cost

Table: OptimizationOutputNetworkSummary

Internal Name: TotalCarbonCost

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

Total Carbon Cost is equal to one of the following:

Network Summary.Total CO2 * Greenhouse Gases.Carbon Cost, or
InterSite Flows.CO2 Cost + Customer Flows.CO2 Cost + Production Flows.CO2 + Network Site Summary.CO2 * Greenhouse Gases.Carbon Cost

Initial Carbon Offsets

Table: OptimizationOutputNetworkSummary

Internal Name: InitialCarbonOffsets

Defines the Initial Carbon Offsets value as defined in the Greenhouse Gases table.

Optimized Carbon Offsets

Table: OptimizationOutputNetworkSummary

Internal Name: OptimizedCarbonOffsets

The number of offsets required by the optimal model.

Optimized Carbon Offset Cost

Table: OptimizationOutputNetworkSummary

Internal Name: OptimizedCarbonOffsetCost

The cost allocated to purchasing optimal carbon offsets.

Carbon Offset Price

Table: OptimizationOutputNetworkSummary

Internal Name: CarbonOffsetPrice

Displays the Carbon Offset Price value as defined in the Greenhouse Gases table.

Total Cycle Stock

Table: OptimizationOutputNetworkSummary

Internal Name: TotalCycleStock

The total amount of cycle stock held in the inventory optimization.

Total Min Inventory

Table: OptimizationOutputNetworkSummary

Internal Name: TotalMinInventory

The total safety stock held in the inventory optimization.

Total Pre Build Inventory

Table: OptimizationOutputNetworkSummary

Internal Name: TotalPreBuildInventory

The total amount of pre-build inventory held in the inventory optimization.

Total Inv Holding Cost

Table: OptimizationOutputNetworkSummary

Internal Name: TotalInvHoldingCost

This is the Total Inventory Holding Cost. It is calculated as:

Total Inventory Holding Cost (Network Summary) = In-Transit Inventory Cost (Intersite Flows) + In-Transit Inventory Cost (Customer Flows) + Total Inventory Holding Cost (Network Site Summary)

A “Closed” site is a site that does not allow product to flow in or out. If a site that is currently holding inventory is closed, the inventory is held for the remaining periods in the model and will incur any associated holding costs.

Total Tax Cost

Table: OptimizationOutputNetworkSummary

Internal Name: TotalTaxCost

This is the Period End Refundable Tax Balance + Non-Refundable Tax Credit as reported in the Tax & Duty Summary output table.

Total Demand Penalty

Table: OptimizationOutputNetworkSummary

Internal Name: TotalDemandPenalty

This is the total penalty cost incurred due unserved demand. The unserved demand incurs the Unit Penalty Cost in the Customer Demand or Customer Orders table. It represents the opportunity cost based on the unserved demand.

Objective Value

Table: OptimizationOutputNetworkSummary

Internal Name: ObjectiveValue

For standard Network Optimization, this is the Total Revenue - Total Cost. For Sequential Optimization, this is the objective value calculated for the objective with the lowest Priority. For example, if you have 3 objectives with Priority values of 1, 2, and 3, it would be for the objective with a value of 3.

Total Sequential Objective Cost

Table: OptimizationOutputNetworkSummary

Internal Name: TotalSequentialObjectiveCost

Note: This column currently returns a value of 0. This is the total penalty cost incurred when you have defined a soft constraint or penalty for a sequential solve.

Space Expansion Cost

Table: OptimizationOutputNetworkSummary

Internal Name: SpaceExpansionCost

This is the cost incurred when the floor area allocated for spaces is expanded.

Site Variable Cost

Table: OptimizationOutputNetworkSummary

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.

% Demand On-Time

Table: OptimizationOutputNetworkSummary

Internal Name: PercentDemandOnTime

This is the percentage of the total demand that was delivered on-time. It is calculated as the total units of demand across all customers/products/periods that were received in the requested period divided by the total network demand.

% Demand Late

Table: OptimizationOutputNetworkSummary

Internal Name: PercentDemandLate

This is the percentage of the total demand that was delivered late. Demand can only be delivered late if the Customer Demand table has Periods Allowed Late populated. Orders can only be delivered late if the Customer Orders table has Time Allowed Late populated. It is calculated as the total units of demand across all customers/products/periods that were received after the requested period divided by the total network demand.

% Demand Early

Table: OptimizationOutputNetworkSummary

Internal Name: PercentDemandEarly

This is the percentage of the total demand that was delivered early. Demand can only be delivered early if the Customer Demand table has Periods Allowed Early populated. Orders can only be delivered late if the Customer Orders table has Time Allowed Early populated. It is calculated as the total units of demand across all customers/products/periods that were received before the requested period divided by the total network demand.

Total Late Demand Penalty Cost

Table: OptimizationOutputNetworkSummary

Internal Name: TotalLateDemandPenaltyCost

This is the total penalty cost across all customers/products/periods from demands related to late fulfillment. You define the Late Delivery Penalty Cost in the Customer Demand/Customer Orders tables.

Total Early Demand Penalty Cost

Table: OptimizationOutputNetworkSummary

Internal Name: TotalEarlyDemandPenaltyCost

This is the total penalty cost across all customers/products/periods from demands related to early fulfillment. You define the Early Delivery Penalty Cost in the Customer Demand/Customer Orders tables.

Total Unserved Demand Penalty Cost

Table: OptimizationOutputNetworkSummary

Internal Name: TotalUnservedDemandPenaltyCost

This is the total penalty cost across all customers/products/periods from demands related to unfulfilled demand. You define the Unit Penalty Cost in the Customer Demand/Customer Orders tables.

Total Demand Penalty Cost

Table: OptimizationOutputNetworkSummary

Internal Name: TotalDemandPenaltyCost

This is the total penalty cost incurred for demand that is fulfilled late, fulfilled early, or unfulfilled. It is calculated as the sum of Total Late Demand Penalty Cost + Total Early Demand Penalty Cost + Total Unserved Demand Penalty Cost.

Aggregated Risk Score

Table: OptimizationOutputNetworkSummary

Internal Name: AggregatedRiskScore

Provides the overall weighted average aggregated risk score across all the sites in the network based on the risk profiles applied.

Scenario Run ID

Table: OptimizationOutputNetworkSummary

Internal Name: RNEStagingTaskExecutionId

The identifier of the scenario used as the Base Scenario for a Rapid Solve. For example, if you use the Baseline scenario as the Base Scenario for a Rapid Solve, Scenario Run ID will be 0.

Scenario ID

Table: OptimizationOutputNetworkSummary

Internal Name: ScenarioID

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

Sub-Scenario ID

Table: OptimizationOutputNetworkSummary

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