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