Work Centers Multi-Period

Internal Table Name: WorkCenters_MultiPeriod

Period Name

Technology: NO IO S

Table: WorkCenters_MultiPeriod

Internal Name: PeriodName

Type: Short Text (50)

Select the Period for which the changes occur.

Name

Technology: NO IO S

Table: WorkCenters_MultiPeriod

Internal Name: WorkCenterName

Type: Short Text (100)

Select the name of the work center which changes during this time period.

Site

Technology: NO IO S

Table: WorkCenters_MultiPeriod

Internal Name: SiteName

Type: Short Text (100)

Select the Site where this work center is located during this time period.

Fixed Operating Cost

Technology: NO IO S

Table: WorkCenters_MultiPeriod

Internal Name: WorkCenterFixedOperatingCost

Type: Short Text (255)

Defines the relationship between operating capacity and operating costs for this time period. In this field, select the step cost that defines the relationship between startup capacities and startup cost. You create the step cost using the Step Cost Definition and Step Costs tables.

For example, create a Step Cost Definition such as the following:

Name Step Type Step Period Step Basis
FixedOperating_NA All Item Horizon Quantity

And create the associated Step Cost records:

Name Minimum Quantity Cost
FixedOperating_NA 0 1000000
FixedOperating_NA 500000 2000000
FixedOperating_NA 750000 2500000

This step cost definition indicates that there is an initial operating cost of $1,000,000 before any product is produced. When the capacity is more than 500,000, the operating cost increases to $2,000,000. To set a maximum capacity on the Work Center, enter a value for Maximum Throughput. You can use "INF" when creating the step cost using the Step Cost Definitions and Step Costs tables, or entering the value directly in Fixed Operating Cost (such as <0|85000><50000|INF>. This effectively acts as a maximum capacity and is a hard constraint. Please note that when creating a step cost in Supply Chain Guru X using the Step Cost builder on the Fixed Operating Cost value, a value of "INF" is not valid as the Cost value on the last step.

For Work Centers, the capacity is often limited in terms of time, such as 1600 HR. The units of measure for throughput level are 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". 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>. The comma (,) and semi colon (;) are also supported for the value separator.
  • 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".

Fixed Closing Cost

Technology: NO

Table: WorkCenters_MultiPeriod

Internal Name: WorkCenterClosingCost

Type: Number Short Text (25)

Enter the monetary cost of shutting down the operations of this work center in this period. Closing costs are applied if a work center with the type Existing Work Center is closed during this period.

Minimum Capacity

Technology: NO

Table: WorkCenters_MultiPeriod

Internal Name: MinimumThroughput

Type: Short Text (100)

RNE Eligible

Enter the minimum throughput that must be handled by the work center in this period. This is a minimum constraint, not a conditional minimum. Enter a value, then optionally select a quantity, weight or volume unit of measure. If you do not select a unit of measure, the default Quantity Unit Of Measure from Model Settings is used.

Maximum Capacity

Technology: NO

Table: WorkCenters_MultiPeriod

Internal Name: MaximumThroughput

Type: Short Text (100)

RNE Eligible

Enter the maximum throughput that can be handled by the work center in this period. Enter a value, then optionally select a quantity, weight or volume unit of measure. If you do not select a unit of measure, the default Quantity Unit Of Measure from Model Settings is used.

Notes

Technology: NO IO S

Table: WorkCenters_MultiPeriod

Internal Name: WorkCenterPeriodNotes

Type: Memo

Enter optional descriptive notes about the work center.

Last modified: Wednesday May 15, 2024

Is this useful?