Periodic Optimization Summary

Internal Table Name: VRPOutputPeriodicOptimizationSummary

The Periodic Optimization Summary table provides information about the orders or shipments from source to destination sites, including cost, amount delivered and frequency and days of visits. In the case that inventory is held at the destination with Transportation Daily Orders, the inventory holding cost is reported.

Scenario

Table: VRPOutputPeriodicOptimizationSummary

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

The scenario for which the output data was generated.

Source Name

Table: VRPOutputPeriodicOptimizationSummary

Internal Name: SourceName

The source of the transportation order or shipment.

Destination Name

Table: VRPOutputPeriodicOptimizationSummary

Internal Name: DestinationName

The destination of the transportation order or shipment.

Frequency Of Visit

Table: VRPOutputPeriodicOptimizationSummary

Internal Name: FrequencyOfVisit

The number of distinct days that the destination is visited on during the periodic schedule. If the same location is visited multiple times on the same day, the Frequency Of Visit value will be 1.

Days Of Visit

Table: VRPOutputPeriodicOptimizationSummary

Internal Name: DaysOfVisit

The days in the periodic schedule on which a visit to the destination occurred. For example, if your periodic schedule goes from 5/23/2019 to 5/29/2019, and the Days Of Visit are reported as 1|3|5, this means that a visit to the destination took place on 5/23/2019, 5/25/2019 and 5/27/2019.

Total Inventory Holding Cost

Table: VRPOutputPeriodicOptimizationSummary

Internal Name: TotalInventoryHoldingCost

This column displays the cost incurred holding inventory with periodic optimization . The Inventory Holding Cost in the Periodic Schedule table is applied to the quantity, weight or volume of Transportation Daily Orders as determined by the Periodic Schedule Inventory Holding Cost Basis.

Total Allocated Transportation Cost

Table: VRPOutputPeriodicOptimizationSummary

Internal Name: TotalAllocatedTransportationCost

Displays an allocated cost to route the orders or shipments from the source to the destination. For example, assume you have three stops on a route. This is the cost to remove each one at a time, then allocate the fixed cost back to the order or shipment based its size.

Total Quantity Delivered

Table: VRPOutputPeriodicOptimizationSummary

Internal Name: TotalQuantityDelivered

The total quantity from Transportation Daily Orders or Shipments delivered from the source to the destination across the periodic horizon.

Total Weight Delivered

Table: VRPOutputPeriodicOptimizationSummary

Internal Name: TotalWeightDelivered

The total weight from Transportation Daily Orders or Shipments delivered from the source to the destination across the periodic horizon.

Total Volume Delivered

Table: VRPOutputPeriodicOptimizationSummary

Internal Name: TotalVolumeDelivered

The total volume from Transportation Daily Orders or Shipments delivered from the source to the destination across the periodic horizon.

Scenario ID

Table: VRPOutputPeriodicOptimizationSummary

Internal Name: ScenarioID

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

Sub-Scenario ID

Table: VRPOutputPeriodicOptimizationSummary

Internal Name: StepNumber

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