Inventory Process Flows

Internal Table Name: OptimizationOutputInventoryProcessFlows

This output table summarizes the specifics of all inventory process flows in the network.

Scenario

Table: OptimizationOutputInventoryProcessFlows

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

The scenario for which the summary data was generated.

Period Name

Table: OptimizationOutputInventoryProcessFlows

Internal Name: PeriodName

The period in which this flow occurs.

Site Name

Table: OptimizationOutputInventoryProcessFlows

Internal Name: SiteName

The site for the process.

Product Name

Table: OptimizationOutputInventoryProcessFlows

Internal Name: ProductName

The name of the product held in inventory.

Process Type

Table: OptimizationOutputInventoryProcessFlows

Internal Name: ProcessType

The type of process used with this inventory process flow.

Process Name

Table: OptimizationOutputInventoryProcessFlows

Internal Name: ProcessName

The name of the process.

Process Step Name

Table: OptimizationOutputInventoryProcessFlows

Internal Name: ProcessStepName

The name of this process step.

Next Process Step Name

Table: OptimizationOutputInventoryProcessFlows

Internal Name: NextProcessStepName

The process step that occurs after the Process Step Name.

Work Center Name

Table: OptimizationOutputInventoryProcessFlows

Internal Name: WorkCenterName

The name of the work center, if applicable, used by the process.

Work Resource Name

Table: OptimizationOutputInventoryProcessFlows

Internal Name: WorkResourceName

The name of the work resource, if applicable, used by the process.

Flow Units

Table: OptimizationOutputInventoryProcessFlows

Internal Name: FlowUnits

The number of units handled in this process flow.

Flow Weight

Table: OptimizationOutputInventoryProcessFlows

Internal Name: FlowWeight

The weight of all units handled in this process flow.

Flow Cubic

Table: OptimizationOutputInventoryProcessFlows

Internal Name: FlowCubic

The cubic size of all units handled in this process flow.

Flow Cost

Table: OptimizationOutputInventoryProcessFlows

Internal Name: FlowCost

The total cost involved this flow.

flow cost = total number of flow units * unit process cost

Flow Setup Cost

Table: OptimizationOutputInventoryProcessFlows

Internal Name: SetupCost

The total cost incurred in setting up this process flow.

setup cost = (total number of flow units * setup cost from Process Steps table) / lot size

Total Cost

Table: OptimizationOutputInventoryProcessFlows

Internal Name: TotalCost

The total cost incurred for the inventory process of the product in the specified period.

Process Time

Table: OptimizationOutputInventoryProcessFlows

Internal Name: ProcessTime

The time incurred for the inventory process of the product in the specified period

Changeover Time

Table: OptimizationOutputInventoryProcessFlows

Internal Name: ChangeoverTime

The time incurred during work center changeovers required for the process.

Process Time

Table: OptimizationOutputInventoryProcessFlows

Internal Name: WorkCenterUsageTime

This is the time incurred when work centers are utilized for the inventory process flows of the product at the site in the specified period.

Work Resource Usage Time

Table: OptimizationOutputInventoryProcessFlows

Internal Name: WorkResourceUsageTime

The time incurred when work resources are utilized.

Period No

Table: OptimizationOutputInventoryProcessFlows

Internal Name: PeriodNo

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

Scenario ID

Table: OptimizationOutputInventoryProcessFlows

Internal Name: ScenarioID

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

Sub-Scenario ID

Table: OptimizationOutputInventoryProcessFlows

Internal Name: StepNumber

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

Last modified: Wednesday May 15, 2024

Is this useful?