Lane Cost Definitions

Internal Table Name: AdvancedCosting_LaneCostDefinitions

You can use Lane Cost Definitions to create transportation cost lookups for combinations of Sites and/or Customers. This is similar to Zone Costs, but simplified to have a single lookup, rather than using a set of zones.

If a lookup cannot be found for the Source - Destination combination, a cost of 9999 will be incurred. This is the case if the lane cost is used for Fixed Shipment Cost or Variable Transportation Cost.

Name

Technology: NO

Table: AdvancedCosting_LaneCostDefinitions

Internal Name: LaneCostName

Type: Short Text (100)

Enter the name for the Lane Cost.

Source Definition

Technology: NO

Table: AdvancedCosting_LaneCostDefinitions

Internal Name: SourceGrouping

Type: Short Text (100)

Select the group level that is used to define the origin for the lane cost. This is one of:

• Organization
• Country
• State
• City
• Zip Code
• 3 Digit Zip

Destination Definition

Technology: NO

Table: AdvancedCosting_LaneCostDefinitions

Internal Name: DestinationGrouping

Type: Short Text (100)

Select the group level that is used to define the origin for the lane cost. This is one of:

• Organization
• Country
• State
• City
• Zip Code
• 3 Digit Zip

Step Basis

Technology: NO

Table: AdvancedCosting_LaneCostDefinitions

Internal Name: ThroughputBasis

Type: Short Text (100)

Choose the unit of measure basis on which lane costs are based:

• Quantity
• Weight
• Volume

Default: Weight

Step Period

Technology: NO

Table: AdvancedCosting_LaneCostDefinitions

Internal Name: ThroughputPeriod

Type: Short Text (100)

One of Period Length, Horizon, Day, Week, Month (30 day), Quarter (91 day), Year, Shipment

Choose the time period (such as Day, Week, Month (30 day), Quarter (91 day), or Year) over which the Step Cost is applied. Alternately, if the Step Period is Shipment, the cost will be applied based on the size of the Shipment.

When the Step Period is based on time, the Minimum Quantity is adjusted as:

Minimum Quantity * (time period/Step Period)

where:

time period is the model horizon in a single period model or the period length in a multi-period model.

Default: Shipment

Step Type

Technology: NO

Table: AdvancedCosting_LaneCostDefinitions

Internal Name: StepTreatment

Type: Short Text (100)

One of All Item, Incremental.

• Incremental – Piecewise costs are calculated based on the break points you create with Step Size. For example, assume you have set up the Steps and Costs as:

  0	2	4	6
  1.5	1.3	1.25	1.1

and the size is 9, the total cost will be:

(2 - 0) * 1.5 + (4 - 2) * 1.3 + (6 - 4) * 1.25 + (9 - 6) * 1.1 = 11.4

• All Item – The cost will be based on the break in which the total occurs. Given the same example from above, for a size of 9, the total cost will be:

9 * 1.1 = 9.9

Default: All Item

Notes

Technology: NO

Table: AdvancedCosting_LaneCostDefinitions

Internal Name: Notes

Type: Memo

Enter optional descriptive notes about the lane cost definition.