Network Asset Summary

Internal Table Name: OptimizationOutputTransportationAssetSummary

The Network Asset Summary table summarizes utilization and cost of transportation assets as well as suggesting an optimal number of assets.

Scenario

Table: OptimizationOutputTransportationAssetSummary

Internal Name: Not Applicable (Scenario column not in table)

The scenario for which the summary data was generated.

Name

Table: OptimizationOutputTransportationAssetSummary

Internal Name: TransportationAssetName

The name of the transportation asset.

Max Units

Table: OptimizationOutputTransportationAssetSummary

Internal Name: TransportationAssetMaxUnits

The number of units specified in the Transportation Assets data table.

Organization Name

Table: OptimizationOutputTransportationAssetSummary

Internal Name: OrganizationName

The Organization to which the transportation asset is allocated. When the transportation asset is associated with Sites that belong to the Organization, the transportation asset is attributed to the Organization as required.

Period Name

Table: OptimizationOutputTransportationAssetSummary

Internal Name: PeriodName

The name of the period to which these transportation asset statistics apply.

Optimized Units

Table: OptimizationOutputTransportationAssetSummary

Internal Name: TransportationAssetOptimizedUnits

The optimal number of transportation asset units for this period. It is the summation of the required assets on each lane in the network. The constraints that determine the number of assets required are:

• The first constraint puts a lower bound on the number of assets – The summation of all the trip hours for that asset on every lane on which it is used divided by the maximum available hours of that asset. By default, the maximum available hours is the number of hours in that period.
• The second constraint sets the bound on the trip hours – The flow times all the time required to make the trip (drive, load, unload, return) divided by the average shipment quantity (in this case, capacity) of the asset.

Flows typically happen within the same period and the number of units reflects the number of times the asset was used to transport. However when using cross period flows, the total number of units used is based on a prorated calculation. For example, assume a period length of 1 day and a transportation flow that takes 3 days. One asset cannot do one complete trip. The number of calculated trips is multiplied by the number of days (periods) to give the approximate number of units.

Utilization

Table: OptimizationOutputTransportationAssetSummary

Internal Name: TransportationAssetUtilization

Network Optimization calculates the Utilization as:

Optimized Units / Max Available Units

This is to approximate the proportion of time this asset is being used, when compared to the total time the asset is available during this period.

Fixed Cost

Table: OptimizationOutputTransportationAssetSummary

Internal Name: TransportationAssetFixedCost

The total fixed costs for using this asset during this period.

Fixed Cost = Optimized Units * Unit Fixed Cost from Transportation Assets

If the fixed cost is applied to the horizon, the number of optimized units is the maximum Optimized Units value across all periods.

Variable Cost

Table: OptimizationOutputTransportationAssetSummary

Internal Name: TransportationAssetVariableCost

The total variable costs for using this asset during this period. This amount is calculated from the Hourly Cap Cost function specified on the Transportation Assets data table and the total time this asset is used in this period. The cost includes the load cost, unload cost, and Return Trip Cost from the Transportation Policies table.

Num Trips

Table: OptimizationOutputTransportationAssetSummary

Internal Name: TransportationAssetNumTrips

The number of times this transportation asset is used during this period. This number is calculated by dividing the number of flow units by the limiting fill level, which refers to either the quantity, volume, or cubic fill level that reaches capacity first.

Remaining Units

Table: OptimizationOutputTransportationAssetSummary

Internal Name: TransportationAssetRemainingUnits

The number of Transportation Asset units not utilized during optimization.

Remaining Units = Max Units - Optimized Units

Period No

Table: OptimizationOutputTransportationAssetSummary

Internal Name: PeriodNo

The sequence number for the period. This value is useful in sorting periods sequentially rather than by name.

Scenario ID

Table: OptimizationOutputTransportationAssetSummary

Internal Name: ScenarioID

The identifier of the scenario for which the summary data was generated.

Sub-Scenario ID

Table: OptimizationOutputTransportationAssetSummary

Internal Name: StepNumber

The identifier of the sub-scenario, if applicable, for which the summary data was generated.