Customer Sourcing Policies Multi-Period

Internal Table Name: CustomerSourcingPolicies_MultiPeriod

Period Name

Technology: NO IO S

Table: CustomerSourcingPolicies_MultiPeriod

Internal Name: PeriodName

Type: Short Text (50)

Select the Time Period in which the Sourcing Policy data changes.

Customer

Technology: NO IO S

Table: CustomerSourcingPolicies_MultiPeriod

Internal Name: SiteName

Type: Short Text (100)

Select the customer for which the Sourcing Policy changes.

Product Name

Technology: NO IO S

Table: CustomerSourcingPolicies_MultiPeriod

Internal Name: ProductName

Type: Short Text (100)

Enter the product for which the Sourcing Policy changes.

Source Name

Technology: NO IO S

Table: CustomerSourcingPolicies_MultiPeriod

Internal Name: SourceName

Type: Short Text (100)

Choose a site that can fill this sourcing order.

Policy Parameter

Technology: NO

Table: CustomerSourcingPolicies_MultiPeriod

Internal Name: CustomerSourcingPolicyParameter

Type: Short Text (100)

Used in conjunction with the "Multiple Sources" sourcing policies: Multiple Sources(Split By Ratio) and Multiple Sources(Probability).

• Multiple Sources(Split By Ratio) - Enter values to be used to establish ratios. These are used to source out to the respective sources in the percentages driven by the ratios.
• Multiple Sources(Probability) - Enter the percentages for each source. These are used to source out to the respective sources based on the percentages.

You can use this column to override the Policy Parameter in the standard Customer Sourcing Policy table. There is no Sourcing Policy column in the multi-period table, so the policy is inherited from the standard sourcing policies table.

Default: null

Unit Sourcing Cost

Technology: NO S

Table: CustomerSourcingPolicies_MultiPeriod

Internal Name: UnitSourcingCost

Type: Short Text (255)

Specifies the average cost per unit for sourcing to be used in the network optimization for this time period.

As an alternative to a simple constant cost, you can set up a cost schedule using step costs. You can define these step costs in the Step Cost Definitions and Step Costs tables. You can also define the step cost using the Step Cost Builder on the field. The builder creates values with a bracketed format, using quantity break points and different costs such as <0|1.50> <5000|1.25> <10000|1.00>. Using this example, the sourcing cost per unit is:

• 1.50 for units 0 through to 5,000
• 1.25 for units 5,000 through to 10,000
• 1.00 for units 10,000 and up.

For an order consisting of 20,000 units, the total cost is:

(5,000-0)*1.50 + (10,000-5,000)*1.25 + (20,000-10,000)*1.00 = 23,750.

When setting costs in Multi-Time Period models, for optimization:

• If Unit Sourcing Cost is not specified in the multi-period table record, the Unit Sourcing Cost from the standard Sourcing Policies table is used.
• If Unit Sourcing Cost is set for period 1 in the multi-period table, that Unit Sourcing Cost is used and not the Unit Sourcing Cost cost set in the standard table.
• For all other periods that do not have an Unit Sourcing Cost set on the multi-period table, the Unit Sourcing Cost from period 1 is used. This is either the Unit Sourcing Cost set in the multi-period table for period 1 or, if that Unit Sourcing Cost is not set, the Unit Sourcing Cost from the standard table.

Minimum Order Quantity

Technology: IO

Table: CustomerSourcingPolicies_MultiPeriod

Internal Name: MinimumOrderQuantity

Type: Short Text (100)

Enter the Minimum Order Quantity for this source. 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. This value is used when calculating the inventory for the product at the site.

Notes

Technology: NO IO S

Table: CustomerSourcingPolicies_MultiPeriod

Internal Name: CustomerPolicyPeriodNotes

Type: Memo

Enter optional descriptive notes about the sourcing policy.