Network Work Center Summary

Internal Table Name: OptimizationOutputWorkCenterSummary

This output table summarizes throughput and cost per work center.

Scenario

Table: OptimizationOutputWorkCenterSummary

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

The scenario for which the summary data was generated.

Work Center Name

Table: OptimizationOutputWorkCenterSummary

Internal Name: WorkCenterName

The name of the Work Center.

Work Center Type

Table: OptimizationOutputWorkCenterSummary

Internal Name: WorkCenterType

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

Site Name

Table: OptimizationOutputWorkCenterSummary

Internal Name: SiteName

The site where the work center is located.

Initial Status

Table: OptimizationOutputWorkCenterSummary

Internal Name: InitialStatus

The status of this work center before optimization.

Organization Name

Table: OptimizationOutputWorkCenterSummary

Internal Name: OrganizationName

The Organization to which the work center is allocated. When the work center is associated with Sites that belong to the Organization, the work center is attributed to the Organization as required.

Period Name

Table: OptimizationOutputWorkCenterSummary

Internal Name: PeriodName

The name of the period to which these work center statistics apply.

Optimized Status

Table: OptimizationOutputWorkCenterSummary

Internal Name: OptimizedStatus

The status of this work center after optimization.

If you have defined a Work Center Maximum Capacity in terms of time, you must populate the Unit Process Time column in the Production Process Steps table. If not, the throughput will be based on quantity. The Optimized Status and Throughput Level will indicate the Work Center has not been used, since there was no time to incur.

Throughput Level

Table: OptimizationOutputWorkCenterSummary

Internal Name: ThroughputLevel

The amount of product processed by this work center during this period. 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. If the Throughput Basis is Time, this value is displayed in HOURS.

Throughput Basis

Table: OptimizationOutputWorkCenterSummary

Internal Name: ThroughputBasis

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

• the Fixed Operating Cost in Work Centers.
  • 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 time, you can define the Fixed Operating Cost in a format such as <0 HR, 10000> or enter the name of a Step Cost Definition that uses Time.
• If there is no Fixed Operating Cost applied:
  • the unit of measure applied to the Maximum Capacity column in the Work Centers table.
• If there is no Maximum Capacity applied:
  • the unit of measure applied to the Minimum Capacity column in the Work Centers table.

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

Total Cost

Table: OptimizationOutputWorkCenterSummary

Internal Name: TotalCost

The total cost incurred by the work center.

total cost = total fixed startup cost + total fixed operating cost + total closing cost + total production cost

Total Fixed Startup Cost

Table: OptimizationOutputWorkCenterSummary

Internal Name: TotalFixedStartupCost

The total one-time costs of beginning operations by this work center in this period.

Total Fixed Operating Cost

Table: OptimizationOutputWorkCenterSummary

Internal Name: TotalFixedOperatingCost

The total cost to keep producing products by this work center during this period.

Total Closing Cost

Table: OptimizationOutputWorkCenterSummary

Internal Name: TotalClosingCost

The total cost of closing this work center during this period.

Total Capital Investment

Table: OptimizationOutputWorkCenterSummary

Internal Name: TotalCapitalInvestment

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

Depreciation

Table: OptimizationOutputWorkCenterSummary

Internal Name: Depreciation

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

Current Book Value

Table: OptimizationOutputWorkCenterSummary

Internal Name: CurrentBookValue

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

Total Production Cost

Table: OptimizationOutputWorkCenterSummary

Internal Name: TotalProductionCost

The total production costs of this work center during this period. This amount is also displayed in the Production Process Flows table.

Throughput Quantity

Table: OptimizationOutputWorkCenterSummary

Internal Name: ThroughputQuantity

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

Throughput Weight

Table: OptimizationOutputWorkCenterSummary

Internal Name: ThroughputWeight

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

Throughput Cubic

Table: OptimizationOutputWorkCenterSummary

Internal Name: ThroughputCubic

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

Throughput Time

Table: OptimizationOutputWorkCenterSummary

Internal Name: ThroughputTime

The throughput at the work center based on time. This value includes both the Unit Process Time and the Average Changeover Time from the Production Process Steps table. The Unit Process Time is incurred per unit of throughput and the Average Changeover Time is incurred per lot. This value is displayed in the current Time Unit of Measure as defined in Model Settings > Units and Currency.

Step Capacity

Table: OptimizationOutputWorkCenterSummary

Internal Name: StepCapacity

The work center's fixed operating capacity step used to accommodate the throughput. You define this in the Fixed Operating Cost column of the Work Centers 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 for the value separator. 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 HR|1200><500 HR|1575>.

Step Remaining Capacity

Table: OptimizationOutputWorkCenterSummary

Internal Name: StepRemainingCapacity

The remaining capacity.

Step Remaining Capacity = Step Capacity - Throughput

Step Capacity Utilization

Table: OptimizationOutputWorkCenterSummary

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 work center 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 on a work center is defined as:

Assume a Max 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: OptimizationOutputWorkCenterSummary

Internal Name: TotalCapacity

The work center's total fixed operating capacity, based on the Maximum Capacity in the Work Centers table.

Total Remaining Capacity

Table: OptimizationOutputWorkCenterSummary

Internal Name: TotalRemainingCapacity

The remaining capacity:

Total Remaining Capacity = Total Capacity - Throughput

Total Capacity Utilization

Table: OptimizationOutputWorkCenterSummary

Internal Name: TotalCapacityUtilization

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

Period No

Table: OptimizationOutputWorkCenterSummary

Internal Name: PeriodNo

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

Scenario ID

Table: OptimizationOutputWorkCenterSummary

Internal Name: ScenarioID

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

Sub-Scenario ID

Table: OptimizationOutputWorkCenterSummary

Internal Name: StepNumber

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