Transportation Assets

Internal Table Name: TransportationAssets

Name

Technology: NO TO S

Table: TransportationAssets

Internal Name: TransportationAssetName

Type: Short Text (100)

Enter a unique name for each asset in your model.

Units

Technology: NO S

Table: TransportationAssets

Internal Name: Units

Type: Short Text (25)

Enter the number of units of this asset that are available for use in the network. Units must be a whole number (i.e., you cannot have half a truck). When optimizing, the number of units entered in this field will act as a max number of asset units. Optimization automatically determines the optimal number of transportation assets. The results will be in the Asset Summary Optimization Output table.

Be sure to specify the asset being used in the Asset field of the Modes data table.
When specifying the number of assets for use with Transportation Optimization, use the Available Units field on the Asset Availability table.

Default: 1

Type

Technology: NO S

Table: TransportationAssets

Internal Name: TransportationAssetType

Type: Short Text (30)

One of Vehicle, Container, or Convoy.

Select the type of asset:

  • Vehicle – This asset is able to move from one node to another, such as a Truck, Boat, Plane or Train.
  • Container – This asset can be loaded with product, but cannot move between sites on its own, such as a pallet or railcar.
  • Convoy – This asset is like a container, but it is made up of assets with type = Vehicle, indicating that these vehicles travel together from one location to another.

Default: Vehicle

Fixed Asset Cost

Technology: NO TO S

Table: TransportationAssets

Internal Name: UnitFixedCost

Type: Short Text (50)

Enter the total cost of owning or using each unit of this asset. Fixed Asset Cost is the fixed cost of using this asset. For example, this could be the cost of maintaining a vehicle in the fleet, or yearly administrative costs for operating it.

If you do not specify a Fixed Asset Cost on Transportation Assets, the optimized number of units will always equal the number of Units set on the Transportation Assets input table. The Transportation Asset Utilization in the Transportation Asset Summary optimization output table will therefore be reported as 1 (fully utilized).

Fixed Asset Cost is reflected in the Total Transportation Asset Cost in the Network Summary output table.

Transportation Optimization: Enter the cost incurred each time this asset it used. If Optimize Fleet Cost is not used, the Fixed Asset Cost is added to the cost of each route. If Optimize Fleet Cost is selected, the Fixed Asset Cost is added to the set of routes with the same Asset ID.

Hourly Cost

Technology: NO

Table: TransportationAssets

Internal Name: HourlyCapCost

Type: Short Text (50)

The hourly cost is the cost of using this asset. This can be used, for example, for driver wages that are based on how many hours a vehicle is in use. Specify the capacity and cost structure per hour for this asset. You must populated at least one of Fill Level (Quantity), Fill Level (Weight) or Fill Level (Volume) for the Hourly Cost to be incurred. Use the Capacity/Fixed Cost Period column to control the period to which the Hourly Cost applies.

If you do not specify a Fixed Asset Cost on Transportation Assets, the optimized number of units will always equal the number of Units set on the Transportation Assets input table. The Transportation Asset Utilization in the Transportation Asset Summary optimization output table will therefore be reported as 1 (fully utilized).

Hourly Cost is reflected in the Total Transportation Asset Cost in the Network Summary output table.

Expansion Only

Technology: NO

Table: TransportationAssets

Internal Name: ExpansionOnly

Type: Bit

One of Yes, No. (Actual database values are 1,0.)

If set to Yes, then the available number of assets cannot be less than in any previous period.

Default: No

Is Round Trip

Technology: TO

Table: TransportationAssets

Internal Name: IsRoundTrip

Type: Bit

One of Yes, No. (Actual database values are 1,0.)

Set this field to Yes when the asset must return to the asset location at the end of a trip.

Default = No

Rate Type

Technology: TO

Table: TransportationAssets

Internal Name: RateType

Type: Short Text (100)

This field defines how entries on rate table are applied to specific origin-destination segments where this asset is used.

The value can be one of the following:

  • Location Independent (Scenario value of 0)

    The rate is based only on the asset, and all assets of that type used will incur the same rate structure regardless of origin or destination.

    For example, a route originates in Atlanta, stops in Savannah, and has a final destination of Jacksonville. If the asset being used has a flat rate of $1.5/mile, then the entire route is $1.5/mile.

  • Origin Dependent (Scenario value of 1)

    The rate is based solely on the origin of the route.

    For example, a route originates in Atlanta, stops in Savannah, and has a final destination of Jacksonville. If all routes from Atlanta have a flat rate of $1.5/mile, then the entire route is $1.5/mile.

  • Origin/Furthest Destination Dependent (Scenario value of 2)

    The entire route is based on the origin and the destination on the route that is furthest from the pool site.

    For example, a route originates in Atlanta, stops in Jacksonville, and has a final destination of Savannah. If the cost to FL is $1.8/mile, and the cost to GA is $1.5/mile, then the entire route is $1.8/mile.

This option is not supported for Interleaved Optimization.
  • Origin/Last Destination Dependent (Scenario value of 3)

    The entire route is based on the origin and the last destination on the route.

    As in the previous example, a route originates in Atlanta, stops in Jacksonville, and has a final destination of Savannah. The cost to FL is $1.8/mile, and the cost to GA is $1.5/mile. The entire route is $1.5/mile.

This selection helps the program to determine the most appropriate algorithm, and the choices are listed in order by their relative speed in solving, with Location independent being the fastest.

To set this option in a scenario, select the “Rate Type” field and enter 0, 1, 2, or 3 as the value.

Capacity (Quantity)

Technology: NO TO S

Table: TransportationAssets

Internal Name: QuantityCapacity

Type: Short Text (50)

Enter the maximum number of products that this asset can transport. Enter a value, then optionally select a quantity unit of measure. If you do not select a unit of measure, the default Quantity Unit Of Measure from Model Settings is used. Not used in Network Optimization.

Capacity (Quantity) must be greater than or equal to the Fill Level (Quantity). These fields work hand-in-hand when you create your Modes and Transportation Policies. If Capacity (Quantity) and Fill Level (Quantity) are the same number, your asset will only be dispatched when it is 100% full. On the other hand, if your Fill Level (Quantity) is 100 ft cubed and your Capacity (Quantity) is 200 ft cubed, then your asset will be dispatched when it is 50% full.

Simulation: Capacity (Quantity) is only used in Simulation for tracking individual assets.

Transportation Optimization: This is the maximum quantity that can be loaded on the asset.

Capacity (Weight)

Technology: NO TO S

Table: TransportationAssets

Internal Name: WeightCapacity

Type: Short Text (50)

Enter the maximum weight your asset is capable of holding. Enter a value, then optionally select a weight unit of measure. If you do not select a unit of measure, the default Weight Unit Of Measure from Model Settings is used. Not used for Network Optimization.

Capacity (Weight) must be greater than or equal to the Fill Level (Weight). These fields work hand-in-hand when you create your Modes and Transportation Policies. If Capacity (Weight) and Fill Level (Weight) are the same number, your asset will only be dispatched when it is 100% full. On the other hand, if your Fill Level (Weight) is 100 pounds and your Capacity (Weight) is 200 pounds, then your asset will be dispatched when it is 50% full.

Simulation: Capacity (Weight) is only used in Simulation for tracking individual assets.

Transportation Optimization: This is the maximum weight that can be loaded on the asset.

Capacity (Volume)

Technology: NO TO S

Table: TransportationAssets

Internal Name: CubicCapacity

Type: Short Text (50)

Enter the maximum volume your asset is capable of holding. Enter a value, then optionally select a volume unit of measure. If you do not select a unit of measure, the default Volume Unit Of Measure from Model Settings is used. Not used in Network Optimization.

Capacity (Volume) must be greater than or equal to the Fill Level (Volume). These fields work hand-in-hand when you create your Modes and Transportation Policies. If Capacity (Volume) and Fill Level (Volume) are the same number, your asset will only be dispatched when it is 100% full. On the other hand, if your Fill Level (Volume) is 100 ft cubed and your Capacity (Volume) is 200 ft cubed, then your asset will be dispatched when it is 50% full.

Simulation: Capacity (Volume) is only used in Simulation for tracking individual assets.

Transportation Optimization: This is the maximum volume that can be loaded on the asset.

Max Duty Time Before Rest Time

Technology: TO

Table: TransportationAssets

Internal Name: MaxDutyTimePerShift

Type: Short Text (50)

Specifies the maximum allowed duty time before rest time. Duty time includes drive time, non-drive working time, break time and wait time. The Duty Time “counter” is reset after the Rest Time is scheduled.

If you specify Max Duty Time Before Rest Time, a break of at least Rest Time will be taken at the end of the duty time. If you do not enter a value for Rest Time, the break will have no duration.

Max Drive Time Before Rest Time

Technology: TO

Table: TransportationAssets

Internal Name: MaxDriveTimePerShift

Type: Short Text (50)

Specifies the maximum amount of drive time that can be incurred before taking rest time. The drive time “counter” is reset after Rest Time is scheduled. Enter a value, then optionally select a time unit of measure. If you do not select a unit of measure, the default Time Unit Of Measure from Model Settings is used.

When specifying hours of service constraints, do not set any of the “Maximum” field values, such as Max Drive Time Before Rest Time, to 0. This can cause unexpected routing results, including violation of other hours of service constraints.

Rest Time

Technology: TO

Table: TransportationAssets

Internal Name: MinBreakTimeBetweenShifts

Type: Short Text (50)

Specifies the minimum amount of off duty time before being on duty again. This break must be long enough to sleep. Enter a value, then optionally select a time unit of measure. If you do not select a unit of measure, the default Time Unit Of Measure from Model Settings is used.

Default: 0

Max Duty Time Before Break

Technology: TO

Table: TransportationAssets

Internal Name: MaxDutyTimeBeforeBreak

Type: Short Text (50)

Specifies the maximum allowed duty time before a break must be taken. The break will be the length of time set in Break Time. Duty time includes drive time, non-drive working time, break time and wait time. The Duty Time “counter” is reset after the Break Time is scheduled. Breaks are calculated if this field and Break Time are both populated. Enter a value, then optionally select a time unit of measure. If you do not select a unit of measure, the default Time Unit Of Measure from Model Settings is used.

When specifying hours of service constraints, do not set any of the “Maximum” field values, such as Max Duty Time Before Break, to 0. This can cause unexpected routing results, including violation of other hours of service constraints.

Max Drive Time Before Break

Technology: TO

Table: TransportationAssets

Internal Name: MaxDriveTimeWithinShift

Type: Short Text (50)

Specifies the maximum amount of drive time that can be incurred before a break must be taken. The break will be the length of time set in Break Time. Breaks are calculated if this field and Break Time are both populated. Enter a value, then optionally select a time unit of measure. If you do not select a unit of measure, the default Time Unit Of Measure from Model Settings is used.

When specifying hours of service constraints, do not set any of the “Maximum” field values, such as Max Drive Time Before Break, to 0. This can cause unexpected routing results, including violation of other hours of service constraints.

Break Time

Technology: TO

Table: TransportationAssets

Internal Name: MinBreakTimeWithinShift

Type: Short Text (50)

Specifies the minimum amount of break time required before continuing to drive. This break is incurred after the amount of drive time defined by Max Drive Time Before Break is incurred. Breaks are calculated if this field and Max Drive Time Before Break are both populated. Enter a value, then optionally select time unit of measure. If you do not select a unit of measure, the default Time Unit Of Measure from Model Settings is used.

Default: 0

Fill Level (Quantity)

Technology: NO S

Table: TransportationAssets

Internal Name: QuantityFillLevel

Type: Short Text (50)

Enter a value, then optionally select a quantity unit of measure. If you do not select a unit of measure, the default Quantity Unit Of Measure from Model Settings is used.

Simulation: Enter the number of products that this asset must transport in order to be dispatched for shipment.

Network Optimization: The fill levels are used as the average asset load size (rather than the capacities) in determining the number of trips the asset makes. If you have specified more than one Fill Level for an asset (such as Fill Level (Weight) and Fill Level (Quantity)), the more constraining level is used.

Fill Level (Weight)

Technology: NO S

Table: TransportationAssets

Internal Name: WeightFillLevel

Type: Short Text (50)

Enter a value, then optionally select a weight unit of measure. If you do not select a unit of measure, the default Weight Unit Of Measure from Model Settings is used.

Simulation: Enter the weight at which your asset is considered full enough to be dispatched. The Fill Level (Weight) acts as a trigger for certain Transportation Policies when the policy has a Mode with an Asset defined.

Network Optimization: The fill levels are used as the average asset load size (rather than the capacities) in determining the number of trips the asset makes. If you have specified more than one Fill Level for an asset (such as Fill Level (Weight) and Fill Level (Quantity)), the more constraining level is used.

Fill Level (Volume)

Technology: NO S

Table: TransportationAssets

Internal Name: CubicFillLevel

Type: Short Text (50)

Enter a value, then optionally select a volume unit of measure. If you do not select a unit of measure, the default Volume Unit Of Measure from Model Settings is used.

Simulation: Enter the volume at which your asset is considered full enough to be dispatched. The Fill Level (Volume) acts as a trigger for certain Transportation policies when the policy has a Mode defined with an Asset.

Network Optimization: The fill levels are used as the average asset load size (rather than the capacities) in determining the number of trips the asset makes. If you have specified more than one Fill Level for an asset (such as Fill Level (Weight) and Fill Level (Quantity)), the more constraining level is used.

Max In-Transit Stops Per Route

Technology: TO

Table: TransportationAssets

Internal Name: MaxStopPerRoute

Type: Number (Long Integer)

This field specifies the maximum number of shipment pickup and delivery stops, and the charging stops on a route. Vehicle domiciles are not included in this number. For example, in an outbound Standard Optimization problem, if the site where vehicles are located is not the pool site, then the “Equipment Start” and “Equipment Return” stops are not counted in this constraint.

Max Loading Stops

Technology: TO

Table: TransportationAssets

Internal Name: MaxLoadingStops

Type: Number (Long Integer)

This field specifies the maximum number of shipment pickup stops on a route; that is, the stops where the activity is "Load". In addition to defining the Max In-Transit Stops Per Route, you can now restrict the number of stops specific to the loading activity. While this is most useful for interleaved routes, the values are respected for other problem types.

Max Unloading Stops

Technology: TO

Table: TransportationAssets

Internal Name: MaxUnloadingStops

Type: Number (Long Integer)

This field specifies the maximum number of shipment delivery stops on a route; that is, the stops where the activity is "Unload". In addition to defining the Max In-Transit Stops Per Route, you can now restrict the number of stops specific to the unloading activity. While this is most useful for interleaved routes, the values are respected for other problem types.

Max Distance Per Route

Technology: TO

Table: TransportationAssets

Internal Name: MaxTotalDistancePerRoute

Type: Short Text (100)

This field specifies the maximum total distance of a complete route. This is from the asset location to the pool site, all in-transit legs, and the return to the asset home location if the route is round trip. Enter a value, then optionally select a distance unit of measure. If you do not select a unit of measure, the default Distance Unit Of Measure from Model Settings is used.

Max Time Per Route

Technology: TO

Table: TransportationAssets

Internal Name: MaxTravelTimePerRoute

Type: Short Text (50)

This field specifies the maximum travel time for a complete route. This is from the asset home location to the pool site, all in-transit legs, and the return to the asset home location if the route is round trip. Enter a value, then optionally select a time unit of measure. If you do not select a unit of measure, the default Time Unit Of Measure from Model Settings is used.

Max Time Per Asset

Technology: TO

Table: TransportationAssets

Internal Name: MaxTimePerAsset

Type: Short Text (50)

Use this field to define the maximum time for routes assigned to an asset when using Optimize Fleet Size. This time is from the Arrive Date Time at the first stop on the first route to the Leave Date Time at the last stop on the last route assigned to the asset. If Max Time Per Asset is null, the length of the Transportation Optimization horizon is used as the maximum time per asset. Enter a value, then optionally select a time unit of measure. If you do not select a unit of measure, the default Time Unit Of Measure from Model Settings is used.

Min Time Between Routes

Technology: TO

Table: TransportationAssets

Internal Name: MinTimeBetweenRoutes

Type: Short Text (50)

Use this field to define the minimum time that must occur between the routes assigned to an asset. This is the time from the end of one route (the End Date Time of one route to the Start Date Time of the next route on the asset). Enter a value, then optionally select a time unit of measure. If you do not select a unit of measure, the default Time Unit Of Measure from Model Settings is used.

Max Distance Between In-Transit Stops

Technology: TO

Table: TransportationAssets

Internal Name: MaxDistanceBetweenStops

Type: Short Text (50)

Enter a value, then optionally select a distance unit of measure. If you do not select a unit of measure, the default Distance Unit Of Measure from Model Settings is used. This field specifies the maximum distance between any consecutive pair of pickup or delivery stops on the route for this transportation asset.

Override Min Distance Between Stops

Technology: TO

Table: TransportationAssets

Internal Name: MinDistanceBetweenStops

Type: Short Text (50)

Specifies the minimum distance between two consecutive stops on a route. If the actual distance is lower than this value, the distance is set to this value. This override is useful when delivery or pickup locations are physically close or co-located, such as when locations are created to represent postal codes instead of actual addresses. This value can serve as an override to the distance between two locations in the Transit Matrix table. Enter a value, then optionally select a distance unit of measure. If you do not select a unit of measure, the default Distance Unit Of Measure from Model Settings is used.

Override Min Time Between Stops

Technology: TO

Table: TransportationAssets

Internal Name: MinTimeBetweenStops

Type: Short Text (50)

Specifies the minimum travel time between two consecutive stops on a route, excluding segments that have a pool site as an end node. If the actual time is lower than this value, the travel time is set to this value. Enter a value, then optionally select a time unit of measure. If you do not select a unit of measure, the default Time Unit Of Measure from Model Settings is used.

Default: 0

Max Distance from Asset Site

Technology: TO

Table: TransportationAssets

Internal Name: MaxDistanceFromWarehouse

Type: Short Text (100)

Specifies the maximum distance from the pool site that the asset can be in service. Enter a value, then optionally select a distance unit of measure. If you do not select a unit of measure, the default Distance Unit Of Measure from Model Settings is used.

Max Waiting Time At Location

Technology: TO

Table: TransportationAssets

Internal Name: MaxWaitingTimeAtLocation

Type: Short Text (50)

Specifies the maximum waiting time at each in transit location. Enter a value, then optionally select a time unit of measure. If you do not select a unit of measure, the default Time Unit Of Measure from Model Settings is used.

Fixed Service Time

Technology: TO

Table: TransportationAssets

Internal Name: FixedServiceTime

Type: Short Text (100)

Specifies the fixed amount of service time when the asset stops at a location. If the purpose of the stop is to charge an electric vehicle battery (based on the Battery value), Fixed Service Time is not incurred for that stop. Enter a value, then optionally select a time unit of measure. If you do not select a unit of measure, the default Time Unit Of Measure from Model Settings is used.

Default: 0

Fixed Service Time Load

Technology: TO

Table: TransportationAssets

Internal Name: FixedServiceTimeLoad

Type: Short Text (50)

Specifies the fixed amount of service time when the asset stops at a pickup location. The total service time at a pickup stop =

Fixed Service Time + Fixed Service Time Load + (Variable Service Time Load x total Quantity/Weight/Volume value),

Quantity/Weight/Volume is defined by the Key Unit of Measure in Transportation Optimization Options (default is Quantity).

Enter a value, then optionally select a time unit of measure. If you do not select a unit of measure, the default Time Unit Of Measure from Model Settings is used.

Default: 0

Fixed Service Time Unload

Technology: TO

Table: TransportationAssets

Internal Name: _FixedServiceTimeUnload

Type: Short Text (100)

Specifies the fixed amount of service time when the asset stops at a delivery location. The total service time at a delivery stop =

Fixed Service Time + Fixed Service Time Unload + (Variable Service Time Unload x total Quantity/Weight/Volume value),

Quantity/Weight/Volume is defined by the Key Unit of Measure in Transportation Optimization Options (default is Quantity).

Enter a value, then optionally select a time unit of measure. If you do not select a unit of measure, the default Time Unit Of Measure from Model Settings is used.

Default: 0

Variable Service Time Load

Technology: TO

Table: TransportationAssets

Internal Name: VariableServiceTimeLoad

Type: Short Text (50)

Specifies the variable amount of service time when the asset stops at a pickup location. The total service time at a pickup stop =

Fixed Service Time + Fixed Service Time Load + (Variable Service Time Load x total Quantity/Weight/Volume value),

Quantity/Weight/Volume is defined by the Key Unit of Measure in Transportation Optimization Options (default is quantity).

Enter a value, then optionally select a time unit of measure. If you do not select a unit of measure, the default Time Unit Of Measure from Model Settings is used.

Default: 0

Variable Service Time Unload

Technology: TO

Table: TransportationAssets

Internal Name: VariableServiceTimeUnload

Type: Short Text (100)

Specifies the variable amount of service time when the asset stops at a delivery location. The total service time at a delivery stop =

Fixed Service Time + Fixed Service Time Unload + (Variable Service Time Unload x total Quantity/Weight/Volume value),

Quantity/Weight/Volume is defined by the Key Unit of Measure in Transportation Optimization Options (default is quantity).

Enter a value, then optionally select a time unit of measure. If you do not select a unit of measure, the default Time Unit Of Measure from Model Settings is used.

Default: 0

Variable Service Time Basis

Technology: TO

Table: TransportationAssets

Internal Name: VariableServiceTimeBasis

Type: Short Text (50)

Select the Unit of Measure by which variable service time is assessed. Select one of Quantity, Weight or Volume, then select the specific unit of measure. If you do not select a unit of measure, the default Quantity unit of measure is used.

Speed

Technology: NO TO S

Table: TransportationAssets

Internal Name: Speed

Type: Short Text (50)

Enter the speed at which your asset can travel in miles or kilometers per hour. Enter a value, then optionally select a speed unit of measure. If you do not select a unit of measure, the default Speed Unit Of Measure from Model Settings is used. If a speed is not entered, the default speed set in Model Settings will be used for calculations.

Default: 55

Asset Weight

Technology: NO TO S

Table: TransportationAssets

Internal Name: TransportationAssetWeight

Type: Short Text (50)

Enter the weight of the transportation asset. This is the weight of an empty vehicle, also known as the “tare” weight. This weight enables Transportation Optimization to determine the CO2 emissions on segments of a route where the vehicle empty. Enter a value, then optionally select a weight unit of measure. If you do not select a unit of measure, the default Weight Unit Of Measure from Model Settings is used. When using containerization the weight of the shipment and the asset are taken into account.

If no value is populated in the Asset Weight column, no value is written when running the model. The default value is applied when creating new records.

Default: 35000

Asset Volume

Technology: NO S

Table: TransportationAssets

Internal Name: TransportationAssetCubic

Type: Short Text (50)

Enter the volume of the transportation asset. This is the volume of the actual asset, which is distinctly different from the volume capacity of the asset. Enter a value, then optionally select a volume unit of measure. If you do not select a unit of measure, the default Volume Unit Of Measure from Model Settings is used.

CO2

Technology: TO

Table: TransportationAssets

Internal Name: CO2

Type: Short Text (255)

In this field, set the CO2 emissions for this transportation asset based on the CO2 Basis. This is the emission amount per weight unit for the field.

For example, assume that you enter .04 and select LB as the Unit Of Measure for CO2. Also assume that you select Weight-Distance for CO2 Basis, then select T-MI (ton per mile) as the Units Of Measure for CO2 Basis. This defines .04 LB of CO2 per ton of product moved over one mile by this transportation asset.

The CO2 column also offers the Transportation Method field builder with predefined CO2 amounts for standard methods of transportation, such Diesel Train. The values provided are based on KG. For example, if you select UK Defra - Rail, you see 0.030653175168 with a default CO2 Basis of T-MI (ton per mile). If your default weight unit of measure is not KG, append the selected value with KG.

You cannot use a scenario item to change the value of CO2 for use with Transportation Optimization. The CO2 calculation is a post-process operation that is not affected by scenario changes.

CO2 Basis

Technology: TO

Table: TransportationAssets

Internal Name: CO2Basis

Type: Short Text (50)

Use this field to select the basis for determining CO2 emissions. The CO2 Basis is applied to the CO2 value. If you select a basis that is made up of two different measures (such as Weight-Distance), you can select the Unit Of Measure for each of these measures.

For example, assume that you enter .04 and select LB as the Unit Of Measure for CO2. Also assume that you select Weight-Distance for CO2 Basis, then select T-MI (ton per mile) as the Units Of Measure for CO2 Basis. This defines .04 LB of CO2 per ton of product moved over one mile by this transportation asset.

Default: Weight-Distance

Comp2 Capacity (Quantity)

Technology: TO

Table: TransportationAssets

Internal Name: Comp2QuantityCapacity

Type: Short Text (100)

Enter the maximum quantity that can be held in the second compartment of the asset. Enter a value, then optionally select a quantity unit of measure. If you do not select a unit of measure, the default Quantity Unit Of Measure from Model Settings is used. Shipments that have Comp2 Quantity values populated can be loaded into the second compartment of the asset during Transportation Optimization.

Comp2 Capacity (Weight)

Technology: TO

Table: TransportationAssets

Internal Name: Comp2WeightCapacity

Type: Short Text (100)

Enter the maximum weight that can be held in the second compartment of the asset. Enter a value, then optionally select a weight unit of measure. If you do not select a unit of measure, the default Weight Unit Of Measure from Model Settings is used. Shipments that have Comp2 Weight values populated can be loaded into the second compartment of the asset during Transportation Optimization.

Comp2 Capacity (Volume)

Technology: TO

Table: TransportationAssets

Internal Name: Comp2CubicCapacity

Type: Short Text (100)

Enter the maximum volume that can be held in the second compartment of the asset. Enter a value, then optionally select a volume unit of measure. If you do not select a unit of measure, the default Volume Unit Of Measure from Model Settings is used. Shipments that have Comp2 Cubic values populated can be loaded into the second compartment of the asset during Transportation Optimization.

Asset Max Available Time In Hours

Technology: NO

Table: TransportationAssets

Internal Name: AssetMaxAvailableTimeinHours

Type: Number (Float)

Enter the maximum number of hours that the asset is available. Use the Capacity/Fixed Cost Period column to control the period to which the Asset Max Available Time In Hours applies.

Capacity/Fixed Cost Period

Technology: NO

Table: TransportationAssets

Internal Name: FixedCostPeriod

Type: Short Text (50)

One of Period Length, Day, Week, Month (30 Day), Quarter (91 Day), Year, Horizon.

Select the period to which the Asset Max Available Time In Hours and Hourly Cost fields apply.

Integer Units

Technology: NO

Table: TransportationAssets

Internal Name: TransportationAssetUnitsIsInteger

Type: Bit

One of Yes, No. (Actual database values are 1,0.)

Enter Yes if the asset can only be an integer. This prevents values such as 1.5 assets.

Default: No

Shipping Route

Technology: S

Table: TransportationAssets

Internal Name: TransportationAssetShippingRouteName

Type: Short Text (100)

If there is a specific route this asset should take, select it in this field. The drop-down list is automatically populated from the Shipping Routes table.

Unit Selection Rule

Technology: S

Table: TransportationAssets

Internal Name: UnitSelectionRule

Type: Short Text (100)

One of First Available, Minimize Assets, Local Only, Closest Available. Also supports Custom Rule using the Scripts table.

This drop-down menu allows you to select a rule for determining which single asset in this asset group to use – First Available, Minimize Assets, Local Only, Closest Available, or create a Custom Rule in the Scripts table.

Shift Pattern

Technology: S

Table: TransportationAssets

Internal Name: ShiftPattern

Type: Short Text (100)

This causes the site to ship and receive orders only during its specified work times, just like work centers. Likewise, Transportation Assets are only available for transport when they are working.

Asset Home Base

Technology: S

Table: TransportationAssets

Internal Name: HomeBaseLocation

Type: Short Text (100)

Select the home location for this asset. This is the site which "owns" the asset. The site must be listed in the Sites table.

On Idle Behavior

Technology: S

Table: TransportationAssets

Internal Name: OnIdlePolicy

Type: Short Text (100)

One of Go to Home, Return to Start, Stay Put, Go to Location, Destroy Unit.

Select the policy to designate what the transportation asset should do once it has completed the delivery of a shipment or completed its shipping route. From the drop-down menu, select one of the following policies:

  • Go to Home – Return to the location listed in the Asset Home Base Field
  • Return to Start – Return to the starting location for that shipment
  • Stay Put – Remain at the site that it became idle
  • Go to Location – Travel to the site listed in the On Idle Location Field
  • Destroy Unit – Asset is no longer a part of the model. It is removed from further tracking and data collection

On Idle Location

Technology: S

Table: TransportationAssets

Internal Name: OnIdleLocation

Type: Short Text (100)

Select the site for this asset to travel to once it has completed its shipment or shipping route. This site must be listed in the Sites table.

Waiting Consumer Queue Basis

Technology: S

Table: TransportationAssets

Internal Name: WaitingConsumerQueueBasis

Type: Short Text (50)

One of None, Item, Quantity, Weight, Volume, Value.

Defines the basis from which asset loading queues are defined in the simulation output. Unit type, quantity, volume, weight, or value can be used for reporting.

Default: None

On Available Event Handler

Technology: S

Table: TransportationAssets

Internal Name: OnAvailableEventHandler

Type: Short Text (100)

This is the logic to tell an asset what to do once it becomes available. You define the logic in a custom script with a Type of “Asset OnAvailable Event”. Scripts of this type will be available in the drop-down list for this field. On Available behavior is different from the On Idle behavior because an asset only becomes Idle after a shipment. For example, if the On Idle behavior is to GO HOME, at the end of a shipment the asset would do that. The On Available event would fire upon arrival.

Vulnerability Factor

Technology: S

Table: TransportationAssets

Internal Name: VulnerabilityFactor

Type: Number (Double)

This allows you to weight the vulnerability of different assets. It only applies if an asset is part of a convoy with multiple asset types when an ambush occurs. For example, there are 5 assets in a convoy: 3 of type A and 2 of type B. Asset A has a Vulnerability Factor of 100 and Asset B has a Vulnerability Factor of 50. Asset A is therefore twice as likely to be destroyed if an ambush occurs.

Organization

Technology: NO S

Table: TransportationAssets

Internal Name: OrganizationName

Type: Short Text (255)

Select the organization to which the transportation asset belongs.

Battery

Technology: TO

Table: TransportationAssets

Internal Name: BatteryName

Type: Short Text (100)

If the transportation asset is an electric vehicle, select the name of the battery from the Electric Vehicle Battery Definitions table. You can associate only one battery to an asset.

Out Of Route Distance

Technology: TO

Table: TransportationAssets

Internal Name: AbsoluteOutOfRouteDistance

Type: Short Text (100)

Populate the out of route distance allowed per route. Enter a value, then optionally select a distance unit of measure. If you do not select a unit of measure, the default Distance Unit Of Measure from Model Settings is used. The out of route distance is calculated as follows:

  • Direct Distance - from route origin to furthest location on the route = DC -> B
  • Total Route Distance = DC -> A -> B -> C -> D
  • Out of Route Distance = Total Route Distance - Direct Distance = (DC -> A -> B -> C -> D) - (DC -> B)
  • Out of Route Percentage = (Total Route Distance - Direct Distance) / Total Route Distance = ((DC -> A -> B -> C -> D) - (DC -> B)) / (DC -> A -> B -> C -> D)

Out Of Route Distance Percentage (0-1)

Technology: TO

Table: TransportationAssets

Internal Name: PercentageOutOfRouteDistance

Type: Number (Float)

Enter the percentage (between 0 and 1) for the out of route distance allowed per route. See the description of the out of route calculation with Out Of Route Distance above.

Start Of Route Service Time

Technology: TO

Table: TransportationAssets

Internal Name: StartOfRouteServiceTime

Type: Short Text (100)

Specifies a fixed amount of service time occurring at the start of every route for this asset to model the duration of pre-route activities, such as the duration for vehicle refueling, updating documents, etc. A positive Start Of Route Service Time is reflected in the output as a positive time span for the "Equipment Start" Activity Type in the Route Details output table.

Enter a value, then optionally select a time unit of measure. If you do not select a unit of measure, the default Time Unit Of Measure from Model Settings is used.

Default: 0

End Of Route Service Time

Technology: TO

Table: TransportationAssets

Internal Name:EndOfRouteServiceTime

Type: Short Text (100)

Specifies a fixed amount of service time occurring at the end of every route for this asset to model the duration of post-route activities, such as the duration for vehicle refueling, updating documents, etc. A positive End Of Route Service Time is reflected in the output as a positive time span for the "Equipment End" Activity Type in the Route Details output table.

Enter a value, then optionally select a time unit of measure. If you do not select a unit of measure, the default Time Unit Of Measure from Model Settings is used.

Default: 0

Notes

Technology: NO TO S

Table: TransportationAssets

Internal Name: TransportationAssetNotes

Type: Memo

Enter optional descriptive notes about the asset.

Custom 1

Technology: NO TO S

Table: TransportationAssets

Internal Name: Custom1

Type: Short Text (255)

Enter optional descriptive notes about the asset.

Custom 2

Technology: NO TO S

Table: TransportationAssets

Internal Name: Custom2

Type: Short Text (255)

Enter optional descriptive notes about the asset.

Status

Technology: NO TO S

Table: TransportationAssets

Internal Name: Status

Type: Type: Short Text (50)

One of Include, Exclude

Choose the asset status:

  • Include - This Transportation Asset will be included in a solver run.
  • Exclude - This Transportation Asset will be excluded from a solver run.

Default: Include

Last modified: Wednesday May 15, 2024

Is this useful?