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: Friday May 12, 2023