Network Organization Summary

Internal Table Name: OptimizationOutputOrganizationSummary

This output table provides summary information that applies to Organizations you have set up.

Scenario

Table: OptimizationOutputOrganizationSummary

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

The scenario for which the summary data was generated.

Organization Name

Table: OptimizationOutputOrganizationSummary

Internal Name: OrganizationName

The organization for which the summary data was generated.

Total Cost

Table: OptimizationOutputOrganizationSummary

Internal Name: TotalCost

The total cost incurred for all activity for this organization.

Total Revenue

Table: OptimizationOutputOrganizationSummary

Internal Name: TotalRevenue

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

Total Fixed Startup Cost

Table: OptimizationOutputOrganizationSummary

Internal Name: TotalFixedStartupCost

The total one time costs of beginning operations at this organization.

Total Fixed Operating Cost

Table: OptimizationOutputOrganizationSummary

Internal Name: TotalFixedOperatingCost

The total cost to keep shipping products from this organization.

Safety Stock Cost

Table: OptimizationOutputOrganizationSummary

Internal Name: SafetyStockCost

The costs from the Inventory Policy Summary output table that apply to this organization. The Safety Stock Cost is included in the Total Cost value. If a Safety Stock Optimization has not been run on this model, the value is blank.

Total Closing Cost

Table: OptimizationOutputOrganizationSummary

Internal Name: TotalClosingCost

The total cost for closing this organization.

Total Capital Investment

Table: OptimizationOutputOrganizationSummary

Internal Name: TotalCapitalInvestment

The total capital investment for the organization for the specified scenario.

Total Production Cost

Table: OptimizationOutputOrganizationSummary

Internal Name: TotalProductionCost

The total costs from producing units for the organization. This total cost includes the costs where one or more Make process(es) exist for a product, 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 Inbound Warehousing Cost

Table: OptimizationOutputOrganizationSummary

Internal Name: TotalInboundWarehousingCost

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

total inbound warehousing cost = (number of organization’s inbound units from InterSite Flows table) * (organization’s inbound cost)

Total Outbound Warehousing Cost

Table: OptimizationOutputOrganizationSummary

Internal Name: TotalOutboundWarehousingCost

The total costs involved in bringing goods from stock to dock for this organization.

total outbound warehousing cost = (number of organization’s outbound units from InterSite Flows table) * (organization’s oubound cost)

Total Transportation Cost

Table: OptimizationOutputOrganizationSummary

Internal Name: TotalInboundTransportationCost

The total cost of bringing goods to this organization or shipping from this organization.

total transportation cost = (flow quantity from InterSite Flows table + flow quantity from Customer Flows table) * (average unit cost in Transportation Policies table)

Total Duty Cost

Table: OptimizationOutputOrganizationSummary

Internal Name: TotalDutyCost

The total costs due to taxes and tariffs levied on shipments from this organization.

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 Warehousing Cost

Table: OptimizationOutputOrganizationSummary

Internal Name: TotalWarehousingCost

The total inbound and outbound warehousing cost for this organization.

Total Sourcing Cost

Table: OptimizationOutputOrganizationSummary

Internal Name: TotalSourcingCost

The total sourcing costs of this organization.

total sourcing cost = (flow quantity from InterSite Flows table) * (average unit cost in Sourcing Policy)

where the Sourcing Policy average unit cost is for this organization to obtain product from the source site.

Total Transportation Asset Cost

Table: OptimizationOutputOrganizationSummary

Internal Name: TotalTransportationAssetCost

The total cost incurred for Transportation Assets that are used by this organization.

Total Work Resource Cost

Table: OptimizationOutputOrganizationSummary

Internal Name: TotalWorkResourceCost

The total cost incurred for Work Resources that are used by this organization.

Total Expression Based Cost

Table: OptimizationOutputOrganizationSummary

Internal Name: TotalExpressionBasedCost

The total expression based cost incurred by this organization.

Total Bills Of Materials Cost

Table: OptimizationOutputOrganizationSummary

Internal Name: TotalBillOfMaterialsCost

The total cost incurred for all Bills Of Material that are used by this organization.

Total Return Cost

Table: OptimizationOutputOrganizationSummary

Internal Name: TotalReturnCost

The total cost incurred for all returns for this organization.

Total Unserved Demand Qty

Table: OptimizationOutputOrganizationSummary

Internal Name: TotalUnservedDemandQty

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

Total CO2

Table: OptimizationOutputOrganizationSummary

Internal Name: TotalCO2

The carbon emissions involved in the production process and transportation for this organization. This value is the product of the lane distances, flow weights, and CO2 settings as defined in the Transportation Policies table.

Total Carbon Cost

Table: OptimizationOutputOrganizationSummary

Internal Name: TotalCarbonCost

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

Total Inv Holding Cost

Table: OptimizationOutputOrganizationSummary

Internal Name: TotalInvHoldingCost

The total costs due to holding inventory during the optimization run for this organization. This is the product of the number of units shipped out of the organization sites, the product value, the run time, and the Inv Carrying Cost %, the result of which is divided by 365.

Total Inventory Holding Cost = Site Inv Holding Cost + InterSite Flows In Transit Inventory Holding Cost

Space Expansion Cost

Table: OptimizationOutputOrganizationSummary

Internal Name: SpaceExpansionCost

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

Site Variable Cost

Table: OptimizationOutputOrganizationSummary

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: OptimizationOutputOrganizationSummary

Internal Name: PercentDemandOnTime

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

% Demand Late

Table: OptimizationOutputOrganizationSummary

Internal Name: PercentDemandLate

This is the percentage of the total demand for the Organization 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 by organization across all customers/products/periods that were received after the requested period divided by the total network demand for the organization.

% Demand Early

Table: OptimizationOutputOrganizationSummary

Internal Name: PercentDemandEarly

This is the percentage of the total demand for the Organization 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 by organization across all customers/products/periods that were received before the requested period divided by the total network demand for the organization.

Total Late Demand Penalty Cost

Table: OptimizationOutputOrganizationSummary

Internal Name: TotalLateDemandPenaltyCost

This is the total penalty cost by organization 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: OptimizationOutputOrganizationSummary

Internal Name: TotalEarlyDemandPenaltyCost

This is the total penalty cost by organization 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: OptimizationOutputOrganizationSummary

Internal Name: TotalUnservedDemandPenaltyCost

This is the total penalty cost by organization 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: OptimizationOutputOrganizationSummary

Internal Name: TotalDemandPenaltyCost

This is the total penalty cost incurred for demand for the Organization 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.

Scenario ID

Table: OptimizationOutputOrganizationSummary

Internal Name: ScenarioID

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

Sub-Scenario ID

Table: OptimizationOutputOrganizationSummary

Internal Name: StepNumber

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