Network Site Summary

Internal Table Name: OptimizationOutputSiteSummary

This output table summarizes throughput and cost per site.

Scenario

Table: OptimizationOutputSiteSummary

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

The scenario for which the summary data was generated.

Site Name

Table: OptimizationOutputSiteSummary

Internal Name: SiteName

The name of the site.

Site Type

Table: OptimizationOutputSiteSummary

Internal Name: SiteType

The type of this site, which is either potential site or existing site.

Initial Status

Table: OptimizationOutputSiteSummary

Internal Name: InitialStatus

The status of this site before making the optimization run (either include or consider).

Organization Name

Table: OptimizationOutputSiteSummary

Internal Name: OrganizationName

The Organization to which the site is allocated. When Sites are assigned to the Organization, the Network Site Summary record is attributed to the Organization as required.

Period Name

Table: OptimizationOutputSiteSummary

Internal Name: PeriodName

The name of the period these site statistics apply to.

Optimized Status

Table: OptimizationOutputSiteSummary

Internal Name: OptimizedStatus

The status of this site after optimization.

Throughput Level

Table: OptimizationOutputSiteSummary

Internal Name: ThroughputLevel

The amount of product shipped from a site in this period. It is a summation over the outflow from the site. In a simple example, there is one manufacturer, 2 DCs and 4 customers. DC1 serves CZ1 and CZ2. DC2 serves CZ3 and CZ4:

Customer Demand

The product can be produced by the MFG, DC1 and DC2. There is a Unit Sourcing Cost of 1 from the MFG to DC1 and DC2. There are also Production Constraints at the DC sites:

In the Network Site Summary, the Throughput Levels match the outflow:

If the Fixed Operating Cost is applied to the horizon, the total throughput output is associated with the first period in the model, and no throughput is displayed for the remaining periods.

Throughput Basis

Table: OptimizationOutputSiteSummary

Internal Name: ThroughputBasis

The units of measure for throughput level, which is determined by the following inputs in order:

• the Fixed Operating Cost in Sites.
  • If a step cost is applied, the Step Basis in the Step Cost Definitions table determines the Throughput Basis.
  • If a numeric value is entered for the Fixed Operating Cost, the Throughput Basis defaults to "Quantity". Keep in mind that 0 is a numeric value and will result in a basis of "Quantity". If you want to report utilization in terms of volume, you can define the Fixed Operating Cost in a format such as <0 CMTR, 10000> or enter the name of a Step Cost Definition that uses Volume.
• If there is no Fixed Operating Cost applied:
  • the unit of measure applied to the Maximum Capacity column in the Sites table.
• If there is no Maximum Capacity applied:
  • the unit of measure applied to the Minimum Capacity column in the Sites table.

If none of these values are defined, the Throughput Basis defaults to "Quantity".

Total Cost

Table: OptimizationOutputSiteSummary

Internal Name: TotalCost

The total cost incurred by the site.

total cost = total fixed startup cost + total fixed operating cost + total closing cost + total production cost + total sourcing cost + total transportation cost + total warehousing cost + total duty cost + total inventory holding cost

Total Fixed Startup Cost

Table: OptimizationOutputSiteSummary

Internal Name: TotalFixedStartupCost

The total one time costs of beginning operations at this site in this period.

Total Fixed Operating Cost

Table: OptimizationOutputSiteSummary

Internal Name: TotalFixedOperatingCost

The total cost to keep shipping products from this site during this period.

Total Closing Cost

Table: OptimizationOutputSiteSummary

Internal Name: TotalClosingCost

The total cost for closing this site during this period.

Total Capital Investment

Table: OptimizationOutputSiteSummary

Internal Name: TotalCapitalInvestment

The total capital investment for the site in the period for the specified scenario.

Depreciation

Table: OptimizationOutputSiteSummary

Internal Name: Depreciation

The depreciation for the site in the period for the specified scenario.

Current Book Value

Table: OptimizationOutputSiteSummary

Internal Name: CurrentBookValue

The book value for the site in the period for the specified scenario.

Total Production Cost

Table: OptimizationOutputSiteSummary

Internal Name: TotalProductionCost

The total costs from producing units at this site during this period. This total cost includes the costs where one or more Make process(es) exist for a product at the site, such as the Flow Production Cost and Flow Setup Cost from the Production Process Flows table, and the costs for Production Policies, such as the InterSite Flows Flow Sourcing Cost. If piecewise costs are used for Unit Production Cost in the Production Policies table, their values are based on whether you are using All Item Discounts or the default of Incremental Discounts.

Total Sourcing Cost

Table: OptimizationOutputSiteSummary

Internal Name: TotalSourcingCost

The total sourcing costs of this site during this period.

Total Sourcing Cost = Total Sourcing Cost from InterSite Flows table

Total Inbound Transportation Cost

Table: OptimizationOutputSiteSummary

Internal Name: TotalInboundTransportationCost

The total cost of bringing goods to this site during this period.

Total Inbound Transportation Cost = sum of incoming Transportation Cost from InterSite Flows table

Total Outbound Transportation Cost

Table: OptimizationOutputSiteSummary

Internal Name: TotalOutboundTransportationCost

The total cost of shipping goods from this site during this period.

Total Outbound Transportation Cost = sum of outgoing Transportation Cost from InterSite Flows table + sum of outgoing Transportation Cost from Customer Flows table

Total Warehousing Cost

Table: OptimizationOutputSiteSummary

Internal Name: TotalWarehousingCost

The total inbound and outbound warehousing cost for this site during this period.

Total Inbound Warehousing Cost

Table: OptimizationOutputSiteSummary

Internal Name: TotalInboundWarehousingCost

The total costs involved in bringing goods from dock to stock for this site during this period.

Total Inbound Warehousing Cost = sum of incoming Inbound Warehousing Cost from the InterSite Flows table

Total Outbound Warehousing Cost

Table: OptimizationOutputSiteSummary

Internal Name: TotalOutboundWarehousingCost

The total costs involved in bringing goods from stock to dock for this site during this period.

Total Outbound Warehousing Cost = sum of outgoing Outbound Warehousing Cost from InterSite Flows table + sum of outgoing Outbound Warehousing Cost from Customer Flows table

Total Duty Cost

Table: OptimizationOutputSiteSummary

Internal Name: TotalDutyCost

The total costs due to taxes and tariffs levied on shipments from this site during this period.

total duty cost = (number of shipped units from the InterSite Flows table + number of shipped units from Customer Flows table) * duty costs * product value

Total Inventory Holding Cost

Table: OptimizationOutputSiteSummary

Internal Name: TotalInventoryHoldingCost

The cost for inventory of the product at the end of the period at this site. This field is only listed for multi-time period models.

The Total Inventory Holding Cost is calculated as:

=Total Facility Inventory Cost + Total WIP In-Transit Inventory Cost, or

= (Total Ending Inventory + Cycle Stock + Turn Estimated Inventory + Transportation Safety Stock + WIP In-Transit Inventory) * Unit Inventory Cost

where:

Unit Inventory Cost = Product Unit Value * Inv Carrying Cost % * (Period Length / 365) + Unit Storage Cost

The WIP In-Transit Inventory is work in progress inventory based on Production only.

If the Inv Carrying Cost % is populated in Inventory Policies, this value is used; otherwise the Inventory Carrying Cost % from Model Settings is used.

Total Return Cost

Table: OptimizationOutputSiteSummary

Internal Name: TotalReturnCost

The total cost incurred based on returns to this site.

Total CO2 Cost

Table: OptimizationOutputSiteSummary

Internal Name: TotalCO2Cost*

The total cost incurred from carbon emissions. In a multi-period model, the Fixed CO2 cost is incurred only in the period that the site is opened.

Total CO2

Table: OptimizationOutputSiteSummary

Internal Name: TotalCO2

The carbon emissions emanating from the CO2 as defined in the Production Policies table and the Fixed CO2 as defined in the Sites table.

Total Demand

Table: OptimizationOutputSiteSummary

Internal Name: TotalDemand

If the site has demand (as defined in the Site Demand table), this is the total demand for the site in the period.

Total Revenue

Table: OptimizationOutputSiteSummary

Internal Name: TotalRevenue

If the site has demand (as defined in the Site Demand table), this is the total revenue for the site in the period based on product Price.

Throughput Quantity

Table: OptimizationOutputSiteSummary

Internal Name: ThroughputQuantity

The throughput at the site by quantity. This value is displayed in the current Quantity Unit of Measure as defined in Model Settings > Units and Currency.

Throughput Weight

Table: OptimizationOutputSiteSummary

Internal Name: ThroughputWeight

The throughput at the site by weight. This value is displayed in the current Weight Unit of Measure as defined in Model Settings > Units and Currency.

Throughput Cubic

Table: OptimizationOutputSiteSummary

Internal Name: ThroughputCubic

The throughput at the site by cubic volume. This value is displayed in the current Volume Unit of Measure as defined in Model Settings > Units and Currency.

Step Capacity

Table: OptimizationOutputSiteSummary

Internal Name: StepCapacity

The site's fixed operating capacity step used to accommodate the throughput. You define this in the Fixed Operating Cost column of the Sites table. To use a step cost, the value will need to be either: 1) the name of a Step Cost Definition with a Type of "Fixed Operating Cost", or 2) a value in the format <x1|y1> <x2|y2>... where x is the step quantity and y is the associated cost. The comma (,) and semi colon (;) are also supported as value separators. For example, for a step cost with two Step Costs records such as shown below, the Step Capacity will be 500:

The equivalent value format is <0|150000><5000|175000>.

Step Remaining Capacity

Table: OptimizationOutputSiteSummary

Internal Name: StepRemainingCapacity

The remaining capacity based on the Step Capacity minus the Throughput.

Step Capacity Utilization

Table: OptimizationOutputSiteSummary

Internal Name: StepCapacityUtilization

The portion of the step capacity used to accommodate the throughput.

For a one-step constraint, assume a Fixed Operating Step Cost Definition on a site has been defined as:

And create the associated Step Cost records:

If the throughput is 150,000:

• Step Remaining Capacity is 250,000 – 150,000 = 100,000
• Step Capacity Utilization is 150,000 / 250,000 = 0.60

For a two-step constraint, assume a Fixed Operating capacity constraint has been defined on a site as:

Assume there is a Maximum Throughput of 400000.

This defines two steps:

• 0 to 250,000
• 250,000 to 400,000, with a hard constraint of 400,000)

If the throughput is 300,000, the capacity is calculated as follows:

• The step size of the second step = 400,000 – 250,000 = 150,000
• The amount of the second step used = 300,000 – 250,000 = 50,000
• The Step Capacity Utilization = 50,000 / 150,000 = 0.33

Total Capacity

Table: OptimizationOutputSiteSummary

Internal Name: TotalCapacity

The site's total fixed operating capacity, which is the final capacity specified. For example, if you define a Maximum Capacity in the Sites table, this is the value that is reported.

Total Remaining Capacity

Table: OptimizationOutputSiteSummary

Internal Name: TotalRemainingCapacity

The remaining capacity.

Total Remaining Capacity = Total Capacity - Throughput

Total Capacity Utilization

Table: OptimizationOutputSiteSummary

Internal Name: TotalCapacityUtilization

The portion of the total capacity used to accommodate the throughput.

Period No

Table: OptimizationOutputSiteSummary

Internal Name: PeriodNo

The sequence number for the period. This value is useful in sorting periods sequentially rather than by name.

Space Expansion Cost

Table: OptimizationOutputSiteSummary

Internal Name: SpaceExpansionCost

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

Site Variable Cost

Table: OptimizationOutputSiteSummary

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.

Site Variable CO2

Table: OptimizationOutputSiteSummary

Internal Name: SiteVariableCO2

This is the variable CO2 incurred for spaces defined at the site.

Scenario ID

Table: OptimizationOutputSiteSummary

Internal Name: ScenarioID

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

Sub-Scenario ID

Table: OptimizationOutputSiteSummary

Internal Name: StepNumber

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