Step Costs

Internal Table Name: AdvancedCosting_StepCosts

You can use step costs to set up cost lookups based on pairs of values representing the step and associated cost. For example, you may have a throughput step cost where the cost varies based on the throughput quantity. Throughput 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 IO S TO

Table: AdvancedCosting_StepCosts

Internal Name: StepCostName

Type: Short Text (100)

Select the step cost from the Step Cost Definitions.

Minimum Quantity

Technology: NO IO S TO

Table: AdvancedCosting_StepCosts

Internal Name: MinimumThroughput

Type: Short Text (100)

Enter the throughput value that is the minimum for the step. If the Step Basis in the Step Cost Definition is Weight, Volume, Distance or Time, select a unit of measure (for example, 100 LB). The unit of measure must match the selected basis. For a basis of Quantity, selecting the unit of measure is optional, as the default Quantity Unit Of Measure from Model Settings is used when no unit of measure is selected.

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:

For step costs where the Step Type is "All Item" and the Step Period is a value other than "Shipment", keep in mind that each step includes both boundary values. The Step Basis is continuous, allowing the solver to pick the best bound. 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.

When the Step Period is "Shipment", the Step Basis is fixed based on the shipment size.

It the Step Type is "Incremental", the higher step cost is selected for values at step quantity + 1.

Cost

Technology: NO IO S TO

Table: AdvancedCosting_StepCosts

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 step cost, a cost of 9999 will be incurred. This is the case if the step cost is used for Fixed Shipment Cost or Variable Transportation Cost.