Simulation 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

Simulation Network Summary

Internal Table Name: SimulationOutputNetworkSummary

This table provides a high-level summary of the scenario results for each scenario, replication and period combination.

Scenario

Table: SimulationOutputNetworkSummary

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

Displays the scenario for which the simulation output has been generated.

Num Reps

Table: SimulationOutputNetworkSummary

Internal Name: NumReps

Displays the number of replications run in the simulation. The default number of replications is 1. You can modify the Number of Replications on the General Tab of the Simulation Options window.

Period Length Days

Table: SimulationOutputNetworkSummary

Internal Name: EpochLengthDays

Displays the period length in days for the specific period.

Total Profit

Table: SimulationOutputNetworkSummary

Internal Name: TotalProfit

Displays the total profit (Total Revenue - Total Cost) for the specified period.

Total Cost

Table: SimulationOutputNetworkSummary

Internal Name: TotalCost

Displays the total cost incurred during this period of the simulation. Total cost is the sum of a number of costs including total fixed operating cost, total fixed startup cost, sourcing cost, consignment cost, total production cost, total warehousing cost, total transportation cost, total inventory carrying cost, total CO2 cost, and total CO2 offsets cost.

Total Revenue

Table: SimulationOutputNetworkSummary

Internal Name: TotalRevenue

Displays the total revenue generated during the simulation from product shipped to customers in this period.

Total Revenue = (Sum of all product received by customers) * (Price per product)

Total Fixed Operating Cost

Table: SimulationOutputNetworkSummary

Internal Name: TotalFixedOperatingCost

Displays the total fixed operating cost incurred by all existing facilities for the specified period.

Total Fixed Startup Cost

Table: SimulationOutputNetworkSummary

Internal Name: TotalFixedStartupCost

Not used by Simulation.

Total Inbound Warehousing Cost

Table: SimulationOutputNetworkSummary

Internal Name: TotalInboundWarehousingCost

Displays the total cost incurred moving product from dock to stock, excluding transportation costs, for all existing facilities for the specified period.

Total Outbound Warehousing Cost

Table: SimulationOutputNetworkSummary

Internal Name: TotalOutboundWarehousingCost

Displays the total cost incurred moving product from stock to dock, excluding transportation costs, for all existing facilities for the specified period.

Total Production Cost

Table: SimulationOutputNetworkSummary

Internal Name: TotalProductionCost

Displays the total cost of product production completed in the specified period.

Total Transportation Cost

Table: SimulationOutputNetworkSummary

Internal Name: TotalTransportationCost

Displays the cost incurred transporting products between facilities and to customer during this period.

Total Inventory Carrying Cost

Table: SimulationOutputNetworkSummary

Internal Name: TotalInventoryCarryingCost

Displays the cost to hold inventory incurred during this period. This is calculated by multiplying the average inventory, the product value, the Inv Carrying Cost %, and the period time divided by 365. Inventory included in this calculation is only inventory available to fill orders, not inventory in receipt or waiting for shipment.

Inventory Cost (x) = Product Value (p) x Carrying Cost % (cc) x Time Period/365 (t)

Avg Fill Rate

Table: SimulationOutputNetworkSummary

Internal Name: AvgFillRate

Displays the ratio of downstream orders immediately and completely filled when initially processed versus all downstream orders. A higher rate indicates sufficient inventory available on hand when orders arrive to completely fulfill orders.

where:

F = Downstream orders filled completely when initially processed

D = Count of downstream orders

Avg Fill Qty Rate

Table: SimulationOutputNetworkSummary

Internal Name: AvgFillQtyRate

Displays the ratio of units used to immediately fill orders when initially processed versus all units ordered. A higher rate indicates sufficient inventory on hand to fully or partially fulfill orders.

where:

P = Downstream-ordered units filled when initially processed

D = Quantity ordered from downstream

Total CO2

Table: SimulationOutputNetworkSummary

Internal Name: TotalCO2

Displays the total CO2 output of the simulation, as generated by facilities, production, and transportation in the specified period. The value is displayed in your model default weight unit of measure.

Total Carbon Offsets

Table: SimulationOutputNetworkSummary

Internal Name: TotalCarbonOffsets

Not used in Simulation.

Total Carbon Offset Cost

Table: SimulationOutputNetworkSummary

Internal Name: TotalCarbonOffsetCost

Not used in Simulation.

Carbon Offset Price

Table: SimulationOutputNetworkSummary

Internal Name: CarbonOffsetPrice

Not used in Simulation.

Model Name

Table: SimulationOutputNetworkSummary

Internal Name: ModelName

Displays the name of the model simulated.

Avg Ready Rate

Table: SimulationOutputNetworkSummary

Internal Name: AvgReadyRate

This is the percentage of no stockout in any given aggregation level; that is the fraction of time with positive stock on-hand.

Total Bills Of Materials Cost

Table: SimulationOutputNetworkSummary

Internal Name: TotalBillOfMaterialsCost

The total cost incurred for all Bills Of Material used in the Simulation.

Total Return Cost

Table: SimulationOutputNetworkSummary

Internal Name: TotalReturnCost

The total cost incurred for all returns.

Period

Table: SimulationOutputNetworkSummary

Internal Name: Period

Displays the Period number for the summary values. ALL indicates the record for the complete model horizon.

Total Demand

Table: SimulationOutputNetworkSummary

Internal Name: TotalDemand

Displays the total units of demand for the period.

Lost Demand

Table: SimulationOutputNetworkSummary

Internal Name: LostDemand

Displays the number of demand units that were canceled or lost during the specified period. See Lost Downstream Demand in Site Product Summary output for more details.

Lost Revenue

Table: SimulationOutputNetworkSummary

Internal Name: LostRevenue

Displays the lost revenue from demand units that were canceled or lost during the specified period. See Lost Downstream Demand in Site Product Summary output for more details.

Total Duty Cost

Table: SimulationOutputNetworkSummary

Internal Name: TotalDutyCost

Displays the additional duty cost incurred during this period. The duty cost is calculated by multiplying the duty from Transportation Policies by the shipment's total value. The total value is the Value from the Product table multiplied by shipment quantity.

Transportation CO2

Table: SimulationOutputNetworkSummary

Internal Name: TransportationCO2

Displays the total emissions of transportation-related CO2 in unit mass in this period based on the CO2 and CO2 Basis in Transportation Policies.

Production CO2

Table: SimulationOutputNetworkSummary

Internal Name: ProductionCO2

Displays the total emissions of production-related CO2 in unit mass in this period based on the CO2 in Production Policies.

Fixed CO2

Table: SimulationOutputNetworkSummary

Internal Name: FixedCO2

Displays the total emissions of site-related CO2 in unit mass in this period based on the Fixed CO2 Cost in the Sites table. Fixed CO2 is only calculated at the end of the Capacity Period noted in the Sites table, since the throughput of the site is required to determine what level of CO2 to use.

Avg On Time Rate

Table: SimulationOutputNetworkSummary

Internal Name: AvgOnTimeRate

Displays the ratio of orders successfully produced or received on time versus all orders produced or received at all sites across the network. If there is no Due Date, the order is counted as on time.

Avg On Time Qty Rate

Table: SimulationOutputNetworkSummary

Internal Name: AvgOnTimeQtyRate

Displays the ratio of product units successfully produced or received on time versus all product units produced or received at all sites across the network. If there is no Due Date, the units are counted as on time.

Total Expired Units

Table: SimulationOutputNetworkSummary

Internal Name: TotalExpiredUnits

Displays the total number of product units that have expired due to shelf life considerations. When you populate the Shelf Life column in the Products table, those products that are not at customer locations when the shelf life is reached will be expired and can no longer be used.

Scenario ID

Table: SimulationOutputNetworkSummary

Internal Name: ScenarioID

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

Sub-Scenario ID

Table: SimulationOutputNetworkSummary

Internal Name: StepNumber

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

Rep

Table: SimulationOutputNetworkSummary

Internal Name: Rep

Displays the replication number of the scenario that generated the summary data.

Last modified: Wednesday May 15, 2024

Is this useful?

Yes No