Risk Exposure Summary

Internal Table Name: OptimizationOutputRiskExposureSummary

The Risk Exposure Summary optimization output table provides counts, averages, weighted averages and other details of network metrics that you can use to assess risk in your supply chain. For example, the table reports the number and percent of customers with demand served by a single source.

Scenario

Table: OptimizationOutputRiskExposureSummary

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

The scenario for which the risk summary data was generated.

Number of Customers

Table: OptimizationOutputRiskExposureSummary

Internal Name: NumberOfCustomers

Displays the count of customers in the solution.

Number of Components

Table: OptimizationOutputRiskExposureSummary

Internal Name: NumberOfComponents

Displays the count of unique BOM components.

Number of Production Sites

Table: OptimizationOutputRiskExposureSummary

Internal Name: NumberOfProductionSites

Displays the count of unique locations at which production occurs.

Number of BOMs Used

Table: OptimizationOutputRiskExposureSummary

Internal Name: NumberOfBOMsUsed

Displays the count of unique BOMs (Bills Of Materials) used.

Number of End Products

Table: OptimizationOutputRiskExposureSummary

Internal Name: NumberOfEndProducts

Displays the count of unique demanded products.

Number of Transportation Modes Available

Table: OptimizationOutputRiskExposureSummary

Internal Name: NumberOfTransportationModesAvailable

Displays the count of unique transportation modes available in the model, across all echelons.

Number of Transportation Modes Used

Table: OptimizationOutputRiskExposureSummary

Internal Name: NumberOfTransportationModesUsed

Displays the count of unique transportation modes used in the solution.

Average Number of Stocking Sites per Product

Table: OptimizationOutputRiskExposureSummary

Internal Name: AvgNumberOfStockingSitesPerProduct

Displays the average number of facilities holding each product in inventory across all products. For example, if Product 1 is held at 3 sites and Product 2 is held at 5, the average number of stocking locations per product is 4.

Average Number of Products per Site

Table: OptimizationOutputRiskExposureSummary

Internal Name: AvgNumberOfProductsPerSite

Displays the average number of products leaving each facility across all periods.

Average Number of Production Sites per Product

Table: OptimizationOutputRiskExposureSummary

Internal Name: AvgNumberOfProductionSitesPerProduct

Displays the average number of production facilities across all products. For example, if Product 1 is produced at 2 sites and Product 2 is produced at 3, the average number of production locations per product is 2.5.

Weighted Average Site Utilization

Table: OptimizationOutputRiskExposureSummary

Internal Name: WeightedAverageSiteUtilization

Displays the quantity weighted average of all capacitated facilities (those with a Fixed Operating Cost Capacity). For example, MFG_A is utilized 20% for 100 units and DC_B is utilized 40% for 200 units. This value is calculated as:

(0.2*100 + 0.4*200)/(100 + 200) = 0.333

Weighted Average Work Center Utilization

Table: OptimizationOutputRiskExposureSummary

Internal Name: WeightedAverageWorkCenterUtilization

Displays the quantity weighted average of all capacitated work centers (those with a Fixed Operating Cost Capacity). For example, WC_A is utilized 20% for 100 units and WC_B is utilized 40% for 200 units. This value is calculated as:

(0.2*100 + 0.4*200)/(100 + 200) = 0.333

Weighted Average Distance Customer Flows

Table: OptimizationOutputRiskExposureSummary

Internal Name: WeightedAverageDistanceCustomerFlows

Displays the quantity weighted average distance (by lane) on Customer Flows. This value is calculated as:

Flow Units * Distance (by lane) / Total Flow Units

Weighted Average Distance InterSite Flows

Table: OptimizationOutputRiskExposureSummary

Internal Name: WeightedAverageDistanceInterfacilityFlows

Displays the quantity weighted average distance (by lane) on InterSite Flows. This value is calculated as:

Flow Units * Distance (by lane) / Total Flow Units

Max Distance to Customer

Table: OptimizationOutputRiskExposureSummary

Internal Name: MaxDistanceToCustomer

Displays the maximum of the distances from facilities to customers.

Number of Customers Single Sourced

Table: OptimizationOutputRiskExposureSummary

Internal Name: NumberOfCustomersSingleSourced

Displays the number of unique customers where demand is served by a single facility source.

Percentage of Customers Single Sourced

Table: OptimizationOutputRiskExposureSummary

Internal Name: PercentageOfCustomersSingleSourced

Displays the percentage of customers where demand is served by a single facility source.

Percentage of Demand Single Sourced

Table: OptimizationOutputRiskExposureSummary

Internal Name: PercentageOfDemandSingleSourced

Displays the percentage of demand that is served by a single facility source.

Amount of Revenue Single Sourced

Table: OptimizationOutputRiskExposureSummary

Internal Name: AmountOfRevenueSingleSourced

Displays the total revenue for customer demand that is served by a single facility source.

Number of Products with a Single Manufacturer

Table: OptimizationOutputRiskExposureSummary

Internal Name: NumberOfProductsWithASingleManufacturer

Displays the number of products where production occurs at a single manufacturer.

Percentage of Products with a Single Manufacturer

Table: OptimizationOutputRiskExposureSummary

Internal Name: PercentageOfProductsWithASingleManufacturer

Displays the percentage of products where production occurs at a single manufacturer. This is the number of products with a single manufacturer / count of unique manufactured products.

Number of Sites Handling Majority of Demand

Table: OptimizationOutputRiskExposureSummary

Internal Name: NumberOfSitesHandlingMajorityOfDemand

Displays the count of facilities that handle greater than 50% of the total demand quantity. Handling product in this case means the throughput of the facility; that is, flow going out of the facility.

Number of Single Sourced BOM Components

Table: OptimizationOutputRiskExposureSummary

Internal Name: NumberOfSingleSourcedBOMComponents

Displays the count of products used as components in bills of materials that are sourced from a single site source.

Number of Sites at Capacity

Table: OptimizationOutputRiskExposureSummary

Internal Name: NumberOfSitesAtCapacity

Displays the number of sites that are at their defined Maximum Capacity, or have reached the hard capacity if defined in the Fixed Operating Cost. If both the Maximum Capacity and a hard constraint on the Fixed Operating Cost are entered, the smaller of the two capacities is used to determine the site's capacity limit.

Example 1:

If the site has Maximum Capacity = 5000 and no Fixed Operating Cost, the site will be at capacity when the throughput reaches 5000.

Example 2:

If the site has Maximum Capacity = 5000 and a Fixed Operating Cost with step costs of

the site will be at capacity when the throughput reaches 5000. The Fixed Operating Cost does not include a hard constraint.

Example 3:

If the site has Maximum Capacity = 5000 and a Fixed Operating Cost with step costs of

the site will be at capacity when the throughput reaches 3000.

Example 4:

If there is no Maximum Capacity nor a hard constraint on the Fixed Operating Cost, the site will never be at capacity. For example, if the site has no Maximum Capacity and a Fixed Operating Cost with step costs of

this site never reaches capacity.

Percentage of Sites at Capacity

Table: OptimizationOutputRiskExposureSummary

Internal Name: PercentageOfSitesAtCapacity

Displays the number of sites at the highest capacity level available / (total facility count). This metric only considers a sites to be at capacity if there is a Maximum Capacity defined or a hard constraint on the Fixed Operating Cost, or both. See Number of Sites at Capacity for examples.

Number of Work Centers at Capacity

Table: OptimizationOutputRiskExposureSummary

Internal Name: NumberOfWorkCentersAtCapacity

Displays the number of work centers that are at their defined Maximum Capacity, or have reached the hard capacity if defined in the Fixed Operating Cost. If both the Maximum Capacity and a hard constraint on the Fixed Operating Cost are entered, the smaller of the two capacities is used to determine the site's capacity limit.

Example 1:

If the work center has Maximum Capacity = 500 and no Fixed Operating Cost, the work center will be at capacity when the throughput reaches 500.

Example 2:

If the work center has Maximum Capacity = 500 and a Fixed Operating Cost with step costs of

the work center will be at capacity when the throughput reaches 500. The Fixed Operating Cost does not include a hard constraint.

Example 3:

If the work center has Maximum Capacity = 500 and a Fixed Operating Cost with step costs of

the work center will be at capacity when the throughput reaches 400.

Example 4:

If there is no Maximum Capacity nor a hard constraint on the Fixed Operating Cost, the work center will never be at capacity. For example, if the work center has no Maximum Capacity and a Fixed Operating Cost with step costs of

this work center never reaches capacity.

Percentage of Work Centers at Capacity

Table: OptimizationOutputRiskExposureSummary

Internal Name: PercentageOfWorkCentersAtCapacity

Displays the number of work centers at the highest capacity level available / (total facility count). This metric only considers a work centers to be at capacity if there is a Maximum Capacity defined or a hard constraint on the Fixed Operating Cost, or both. See Number of Work Centers at Capacity for examples.

Scenario ID

Table: OptimizationOutputRiskExposureSummary

Internal Name: ScenarioID

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

Sub-Scenario ID

Table: OptimizationOutputRiskExposureSummary

Internal Name: StepNumber

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