4.4 Sheet: Solution Summary
4.4.1 Scenario Name
Type: Text.
Description: The name of the scenario from which the solution was generated. Matches the name field of the General
sheet.
4.4.2 Total Iterations
Type: Number.
Description: The actual number of iterations completed by the optimiser before termination.
4.4.3 Total Cost
Type: Number.
Description: The total cost for all routes in the solution.
4.4.4 Total Revenue
Type: Number.
Description: The total revenue earned for all routes in the solution.
4.4.5 Total Profit
Type: Number.
Description: The total profit or loss for all routes in the solution. Profit is the difference between revenue and
cost.
4.4.6 Total Distance
Type: Number.
Description: The total transit distance of all routes in the solution.
4.4.7 Loaded Distance
Type: Number.
Description: The total transit distance travelled in all routes while the vehicles are carrying at least one
order.
4.4.8 Empty Distance
Type: Number.
Description: The total transit distance travelled in all routes while the vehicles are empty.
4.4.9 Average Transit Speed (km/h)
Type: Number.
Description: The average speed of the vehicles in the solution. This is derived by dividing the total transit distance by
the total transit time. Only present if Use Miles in the General sheet is false.
4.4.10 Average Transit Speed (mph)
Type: Number.
Description: The average speed of the vehicles in the solution. This is derived by dividing the total transit distance by
the total transit time. Only present if Use Miles in the General sheet is true.
4.4.11 Loads
Type: Number.
Description: If Batched Loads is true, then the total number of loads in the solution.
4.4.12 Km Per Load
Type: Number.
Description: If Batched Loads is true and Use Miles is false, then this is the average kilometres per load in the
solution.
4.4.13 Miles Per Load
Type: Number.
Description: If Batched Loads and Use Miles are both true, then this is the average miles per load in the
solution.
4.4.14 Hours Per Load
Type: Excel time.
Description: If Batched Loads is true then the average time per load in the solution.
4.4.15 Drops Per Load
Type: Number.
Description: If Batched Loads is true then the total average number of drops per load in the solution.
4.4.16 Work Time
Type: Excel time.
Description: The total work time for all routes in the solution.
4.4.17 Transit Time
Type: Excel time.
Description: The total transit time for all routes in the solution.
4.4.18 Break Time
Type: Excel time.
Description: The total break time for all routes in the solution.
4.4.19 Idle Time
Type: Excel time.
Description: The total idle time for all routes in the solution.
4.4.20 Total Weight
Type: Number.
Description: The cumulative weight carried in all routes in the solution.
4.4.21 Total Volume
Type: Number.
Description: The cumulative volume carried in all routes in the solution.
4.4.22 Assigned Orders
Type: Number.
Description: The number of assigned orders represented as a fraction of the total number of orders.
4.4.23 Fleet Usage
Type: Number.
Description: The number of vehicles used in the solution represented as a fraction of the total number of
vehicles.
4.4.24 Column: Pickup Soft Time Window Early
Type: Excel time.
Description: The total time an order’s pickup occurred before the start of its closest soft time window.
4.4.25 Column: Pickup Soft Time Window Late
Type: Excel time.
Description: The total time an order’s pickup occurred after the end of its closest soft time window.
4.4.26 Column: Delivery Soft Time Window Early
Type: Excel time.
Description: The total time an order’s delivery occurred before the start of its closest soft time window.
4.4.27 Column: Delivery Soft Time Window Late
Type: Excel time.
Description: The total time an order’s delivery occurred after the end of its closest soft time window.

