Cost Bands

Internal Table Name: AdvancedCosting_CostBands

Cost Bands define the minimum throughput for each step and the cost incurred for that step. You can use cost bands to set up cost lookups based on pairs of values representing the step and associated cost. For example, you may have a transportation cost band 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:

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_CostBands

Internal Name: CostBandName

Type: Short Text (100)

Select the name of the cost band from the Cost Band Definitions table.

Band Minimum

Technology: NO

Table: AdvancedCosting_CostBands

Internal Name: BandLevel

Type: Short Text (100)

Enter the minimum for the distance band for which you are defining a cost.

Minimum Quantity

Technology: NO

Table: AdvancedCosting_CostBands

Internal Name: SizeLevel

Type: Short Text (100)

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

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_CostBands

Internal Name: Cost

Type: Short Text (100)

Enter the cost that will be applied to the size within the band for this cost band. If a lookup cannot be found for the cost band, a cost of 9999 will be incurred. This is the case if the cost band is used for Fixed Shipment Cost or Variable Transportation Cost.

Notes

Technology: NO

Table: AdvancedCosting_CostBands

Internal Name: Notes

Type: Memo

Enter optional descriptive notes about the cost band.