Products Multi-Period

Internal Table Name: Products_MultiPeriod

Period Name

Technology: NO IO S

Table: Products_MultiPeriod

Internal Name: PeriodName

Type: Short Text (50)

Select the Period Name in which the product information changes.

Name

Technology: NO IO S

Table: Products_MultiPeriod

Internal Name: ProductName

Type: Short Text (100)

Select a unique Name from the drop-down menu to represent the product or Stock Keeping Unit (SKU) number.

Unit Value

Technology: NO IO S

Table: Products_MultiPeriod

Internal Name: ProductCost

Type: Short Text (50)

Enter a monetary value for each unit for this Period. Similar to an accounting valuation, this field is used to calculate the inventory investment and inventory holding costs.

For optimization:

• If a Unit Value is not specified in the multi-period table record, the Unit Value from the standard Products table is used.
• If a Unit Value is set for period 1 in the multi-period table, that Unit Value is used instead of the value set in the standard table.
• In all other periods that do not have a Unit Value set in the multi-period table, the Unit Value from period 1 is used. This is either the Unit Value set in the multi-period table for period 1 or, if that Unit Value is not set, the Unit Value from the standard table.

Unit Price

Technology: NO IO S

Table: Products_MultiPeriod

Internal Name: ProductPrice

Type: Short Text (50)

Enter the revenue generated from the sale of a single unit of this product. The product price is used to calculate revenue statistics.

For optimization:

• If a Unit Price is not specified in the multi-period table record, the Unit Price from the standard Products table is used.
• If a Unit Price is set for period 1 in the multi-period table, that Unit Price is used instead of the Unit Price set in the standard table.
• In all other periods that do not have a Unit Price set in the multi-period table, the Unit Price from period 1 is used. This is either the Unit Price set in the multi-period table for period 1 or, if that Unit Price is not set, the Unit Price from the standard table.

Lead Time Cost/Day/Unit

Technology: NO

Table: Products_MultiPeriod

Internal Name: ProductLeadTimeCost

Type: Short Text (50)

Use this field to specify the cost of 1 day of lead time per unit of product. It is used in lead time optimization. This field accepts positive values.

Max-Lead Time x Flow

Technology: NO

Table: Products_MultiPeriod

Internal Name: ProductMaxLeadTimeTimesFlow

Type: Short Text (50)

Use this field to specify the maximum limit when the lead time is multiplied by the flow. It is used in lead time optimization.

Notes

Technology: NO IO S

Table: Products_MultiPeriod

Internal Name: ProductPeriodNotes

Type: Memo

Enter optional descriptive notes about the product.