Transport Attributes
Stepwise costing is only available in the Network Design Advanced Module.
Speed
- Sheets on which it appears
- Possible inputs
Any number greater than 0 (0 means no speed defined)
- How it affects the model
The average speed (distance/hour) of the give transportation type. It is used to calculate duration data if it is not given in the template.
Wiggle Factor
- Sheets on which it appears
- Possible inputs
Any number greater than 0 (0 means not defined) in percentage
- How it affects the model
Wiggle factor is used when the model calculates the straight distance between two locations.
Roundtrip
Roundtrip is only available in the Network Design Advanced and in the Sustainability and Risk Modules.
- Sheets on which it appears
- Possible inputs
Binary, 0 (empty) or 1
- How it affects the model
Indicates if the transport mode is used for roundtrip, you can read more about how roundtrip works in Roundtrip Functionality.
Maximum Road Distance To Retrieve
- Sheets on which it appears
- Possible inputs
Any positive number in unit of distance
- How it affects the model
When a lane is using a mode of transport for which maximum road distance to retrieve has been specified and the straight line distance between two points for the lane is greater than the maximum road distance to retrieve, then the ‘Retrieve Distance’ flag will automatically be set to 0 for those lanes, and straight line distances will be used instead.
Retrieve Distance
- Sheets on which it appears
- Possible inputs
Binary, 0 (empty) or 1
- How it affects the model
Indicate that the distance and duration needs to be retrieved from Location IQ (if this attribute is 1). If this attribute is active, then the Distance Data page will be visible and the distance can be calculated. Note that the distance and duration by road will be retrieved when this attribute is active. This attribute should be left inactive if road distances and durations are not desired, or the path between two locations cannot be calculated by road.
Average Load Size
- Sheets on which it appears
- Possible inputs
Any number greater than 0 (0 means not defined)
- How it affects the model
The average load size that can fit in a Mode of Transport at a lane and a product during a period. The Average Load size is used as a divisor to calculate the lane’s variable cost.
Transport
Mode
From
Location
To
Location
Distance
Cost Per
Distance
Cost Per
Trip
Average
Load Size
Minimum Cost
Per Trip
Cost
Truck
location_1
Location_2
10
0
3
2
0
(10*3)/2=15
Truck
location_1
Location_2
10
0
20
2
0
20/2=10
Truck
location_1
Location_2
10
0
0
2
10
10/2=5
Cost Per UOM
- Sheets on which it appears
- Possible inputs
Any number greater than 0 (0 means not defined)
- How it affects the model
The cost per unit of measurement for a Mode of Transport at a lane and a product during a period. It is independent of the distance, the total value only depends on the volume. It works with the same logic as Variable Cost. It can be defined for each step for a lane on the Stepwise Transportation Cost sheet.
Cost Per Distance
- Sheets on which it appears
- Possible inputs
Any number greater than 0 (0 means not defined)
- How it affects the model
The cost per unit of distance for a Mode of Transport at a lane and a product during a period. When both Cost Per Distance is defined in the template and Retrieve High-level Cost Data is selected the specified Cost Per Distance value will be used instead of the high-level cost data. For more details on Retrieve High-level Cost data, see the Transport Cost page.
Retrieve High-level Cost Data
- Sheets on which it appears
- Possible inputs
Binary, 0 (empty) or 1
- How it affects the model
For lanes where the attribute is set to 1 and no lane-specific Cost Per Distance data is available, the model uses generalized high-level cost data. This generalized data represents typical Cost Per Distance values between two countries or states. For more details see the Transport Cost page.
Request Detailed Cost Data
- Sheets on which it appears
- Possible inputs
Binary, 0 (empty) or 1
- How it affects the model
For lanes where the attribute is set to 1 and no lane-specific Cost Per Distance data exists, the model generates an Excel file containing the relevant lanes. This Excel is used to request detailed Cost Per Distance data via email. For more details see the Transport Cost page.
Cost Per Trip
- Sheets on which it appears
- Possible inputs
Any number greater than 0 (0 means not defined)
- How it affects the model
The cost per trip of this Mode of Transport at a lane and a product during a period.
Minimum Cost Per Trip
- Sheets on which it appears
- Possible inputs
Any number greater than 0 (0 means not defined)
- How it affects the model
The minimum transportation cost of this lane.
Calculate the lane basic cost
The transportation basic cost calculated by the following the volume of the lane * tranportation unit cost. There is two case when calculate the Transportation unit cost, in the first case, there is no Minimum Cost Per Trip defined (first row in the table below) and the second case is when Minimum Cost Per Trip defined. In the second case the transportation unit cost is the maximum of the Minimum Cost Per Trip and Variable+Fixed costs.
Transport Mode |
From Location |
To Location |
Average Load Size |
Cost Per UOM |
Cost Per Distance |
Cost Per Trip |
Minimum Cost Per Trip |
Distance |
Transportation Unit cost |
|---|---|---|---|---|---|---|---|---|---|
Truck |
location_1 |
Location_2 |
2 |
10 |
4 |
20 |
0 |
15 |
10+((4*15)/2)+(20/2)=50 |
Truck |
location_1 |
Location_2 |
2 |
10 |
4 |
20 |
60 |
15 |
50 (Fixed and Variable) > 30 (Minimum Cost Per Trip (60/2)) |
Truck |
location_1 |
Location_2 |
2 |
10 |
4 |
20 |
120 |
15 |
60 (Minimum Cost Per Trip (120/2)) > 50 (Fixed and Variable) |
Take Or Pay Volume
This attribute is only available in the Network Design Advanced Module.
- Sheets on which it appears
- Possible inputs
Any number greater than 0 (0 means not defined)
- How it affects the model
The volume of a Take or Pay contract. The “Take or Pay” cost is used when a customer/warehouse/production has a type of contract through which the customer/warehouse/production is forced to “take” a certain volume from a supplier/warehouse/production at a given cost or to “pay” the supplier if the agreed volume is not taken. Take or pay unit is calculated as the round up of the ratio of the Volume of the Lane and the Take or Pay Volume.
Take Or Pay Fixed Cost
This attribute is only available in the Network Design Advanced Module.
- Sheets on which it appears
- Possible inputs
Any number greater than 0 (0 means not defined)
- How it affects the model
The cost of a Take or Pay contract. It is intended to model Take or Pay contracts, where a fixed price is paid regardless of the exact volume. A typical example is a rail car, where you pay for transporting the car itself, regardless of its load.
Take or Pay works as follows:
Transport
Mode
From
Location
To
Location
Take or Pay
Volume
Take or Pay
Fixed Cost
Volume
of the Lane
Calculated
Units
Calculated
Total Cost
Rail
location_1
Location_2
100,000
9,000
250,000
round up: 250,000/100,000=2.5 (3)
3*9,000=27,000
In contrast, in Stepwise Transport Costing, min and max capacities determine the cost. Cost bands are defined, with each band having a variable cost that is multiplied by the volume within that interval. Read more about Stepwise Transport Cost here: Transportation Stepwise Costing Data Table.
Base Case Lane
- Sheets on which it appears
- Possible inputs
Binary, 0 (empty) or 1
- How it affects the model
This transportation lane is active in base case. When you want to use the base case lanes, the Enforce Base Case Constraints on Control Panel option should be selected.
Base Case Volume
- Sheets on which it appears
- Possible inputs
Any number greater than 0 (0 means not defined)
- How it affects the model
The volume of this transportation lane in base case. When you want to use the base case lanes, the Enforce Base Case Constraints on Control Panel option should be selected.
Value
This attribute is only available in the Network Design Advanced and Sustainability and Risk Modules.
- Sheets on which it appears
- Possible inputs
Any number greater than 0 (0 means not defined)
- How it affects the model
This attribute represents a base value to which the percentage Rate will be applied. It is only used when the Percentage Based option is checked for the respective Custom Objective on the Custom Objective sheet. When enabled, this allows the objective to act as a Tariff, Tax, or Duty (Custom Objectives Sheet).
Rate
This attribute is only available in the Network Design Advanced and Sustainability and Risk Modules.
- Sheets on which it appears
- Possible inputs
Any number greater than 0 (0 means not defined)
- How it affects the model
This defines the percentage to be applied to the Value and Volume. It is also only considered when the Percentage Based setting is enabled for the Custom Objective on the Custom Objective sheet (Custom Objectives Sheet).
When the Percentage Based attribute is enabled, the Custom Objective cost is calculated as Volume * Value * Rate + Volume * Cost per UOM.
Transport
Mode
From
Location
To
Location
Volume
Custom
Objective
Rate
Custom
Objective
Value
Custom
Objective
Cost Per UOM
Calculated
Total Cost
Rail
location_1
Location_2
10
0.2
8
15
10*8*0.2+10*15=166
Distance
- Sheets on which it appears
- Possible inputs
Any number greater than 0 (0 means not defined)
- How it affects the model
The travel distance (miles or km depending on the input) for this lane.
Duration
- Sheets on which it appears
- Possible inputs
Any number greater than 0 (0 means not defined)
- How it affects the model
The travel duration (in hours) for this lane.
Max Difference
- Sheets on which it appears
- Possible inputs
Any number greater than 0 (0 means not defined) in percentage
- How it affects the model
The maximum transported volume difference from the other roundtrip lanes of the transport type. You can read more about how roundtrip works in Roundtrip Functionality.