Site Product Criticality Summary

Internal Table Name: SiteProductCriticalitySummary

The Site Product Criticality Summary 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 Site Product Criticality Summary provides a network criticality score for each finished good at the site based on the number of finished goods the site contributes to, as well as factors contributing to the score.

Scenario

Table: SiteProductCriticalitySummary

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

The scenario for which the summary data was generated.

Site

Table: SiteProductCriticalitySummary

Internal Name: Site

The name of the site for which criticality is being determined.

Finished Good

Table: SiteProductCriticalitySummary

Internal Name: FinishedGood

The name of the finished good for which criticality is being determined.

Flow Units

Table: SiteProductCriticalitySummary

Internal Name: FlowUnits

The number of units of product served by the site.

Unit Value

Table: SiteProductCriticalitySummary

Internal Name: UnitValue

The value per unit of the product being served.

Total Value

Table: SiteProductCriticalitySummary

Internal Name: TotalValue

The total value of this finished good being served by this site in the network paths.

Unit Price

Table: SiteProductCriticalitySummary

Internal Name: UnitPrice

The price per unit of the product being served.

Total Revenue

Table: SiteProductCriticalitySummary

Internal Name: TotalRevenue

The total revenue for this product being served by this site in the network paths.

Total Cost

Table: SiteProductCriticalitySummary

Internal Name: TotalCost

The total cost incurred for this product at this site in the network paths.

Total Demand

Table: SiteProductCriticalitySummary

Internal Name: TotalDemand

The total demand for the finished good served by this site.

Percentage Of Total Demand

Table: SiteProductCriticalitySummary

Internal Name: PercentageOfTotalDemand

The percentage of demand this finished good served by this site compared to the total demand for all finished goods at all sites. This value determines the criticality of the site-product combination. The value ranges from 0 to 1, with 1 being the most critical. It is the Flow Units / Total Demand.

Scenario ID

Table: SiteProductCriticalitySummary

Internal Name: ScenarioID

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

Sub-Scenario ID

Table: SiteCriticalitySummary

Internal Name: StepNumber

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