Lane Costs

Internal Table Name: AdvancedCosting_LaneCosts

Lane Costs define the minimum throughput for each step and the cost incurred for that step. You can use lane costs to set up cost lookups based on pairs of values representing the step and associated cost. For example, you may have a transportation lane cost where the cost varies based on the flow quantity. Flow less than or equal to 200 units is 1.5 per unit, greater than or equal to 200 and less than or equal to 500 is 1.25, and greater than or equal to 500 is 1.0:

Minimum Quantity Cost
0 1.5
200 1.25
500 1.0

Keep in mind that each step includes both boundary values. In the example above a quantity of 200 could incur a cost of either 1.5 or 1.25. The lower cost will be used.

Step Costs define the Minimum Quantity for each step and the cost incurred for that step.

Name

Technology: NO

Table: AdvancedCosting_LaneCosts

Internal Name: LaneCostName

Type: Short Text (100)

Select the lane cost from the Lane Cost Definitions.

Source

Technology: NO

Table: AdvancedCosting_LaneCosts

Internal Name: Source

Type: Short Text (100)

Enter the Source for the specific Lane Cost value.

Destination

Technology: NO

Table: AdvancedCosting_LaneCosts

Internal Name: Destination

Type: Short Text (100)

Enter the Destination for the specific Lane Cost value.

Minimum Quantity

Technology: NO

Table: AdvancedCosting_LaneCosts

Internal Name: MinimumThroughput

Type: Short Text (100)

Enter the throughput value that is the minimum for the step. 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.

Throughput greater than or equal to Minimum Quantity and less than or equal to the minimum for the next step can incur the Cost at this level. The steps are inclusive at their boundaries. For example:

Minimum Quantity Cost
0 1.5
200 1.25
500 1.0

Keep in mind that each step includes both boundary values. In the example above, a quantity of 200 could incur a cost of either 1.5 or 1.25. The lower cost (1.25) will be used.

Cost

Technology: NO

Table: AdvancedCosting_LaneCosts

Internal Name: Cost

Type: Short Text (100)

Enter the cost to be incurred at this step level. 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.

Notes

Technology: NO

Table: AdvancedCosting_LaneCosts

Internal Name: Notes

Type: Memo

Enter optional descriptive notes about the lane cost.

Last modified: Wednesday May 15, 2024

Is this useful?