Create account Price list Support

Fleet Mileage Calculator

What is the impact on transport mileage if a warehouse is relocated? Or how much mileage is saved if the transport operation is merged with that of another company? Fleet Mileage Calculator helps to answer these questions.

It calculates yearly customer transport mileage.
  • It simulates a full year of transports by creating vehicle routes, per warehouse, per day, solving an underlying Capacitated Vehicle Routing Problem.
  • It acts as a tactical analysis tool, not an operational transport planning tool.
  • First, you may want to optimize warehouse locations with Centers of Gravity Calculator.

The live demo starts if you scroll further.

🡇

Shipment size factor 
Route width 
Carto map
ESRI map
OpenStreetMap map
    
    
    
    
    

Expanding "Input tables" takes a few seconds. Please, be patient.
To import data, click button 'Import | Export' above each input table, paste your data (tab or semicolon separated) in textarea, click button again.
You have not logged in. Changes to warehouse demo data are ignored. Create an account to be able to log in and run with your own customers data.

You can adjust other input tables and parameters, and run the software, to see how it works.

Warehouses

WarehouseID is a free format alphanumeric field. Latitude and longitude are the result of geocoding your warehouse address(es).
You can change data directly in the input tables (except for table Warehouses if not logged in). Navigate with tab, shif+tab, arrow up, arrow down.


Option 1: Shipments per year (non-preferred option, option 2 is preferred)

CustomerID is a free format alphanumeric field. You can define demand and shipment size both in volume (for example, pallets) and in weight (for example, kilograms), as sometimes volume, sometimes weight may be the limiting factor of what fits into a truck (truck capacity is specified for volume and for weight - under Parameters). Express demand and shipment size in the same unit of measurement as you express truck capacity, and make sure that shipment size does not exceed truck capacity. After entry, press below "Convert" button.

Yearly input  versus  Daily output
Shipments
Demand volume
Demand weight

Option 2: Shipments per day (preferred)

If you know what shipments were delivered on what day (1,2,3,...), then use this option, as it will bring more realistic outcomes.
Kilometers
Miles
Truck capacity (volume)
Truck capacity (weight)
Working days per year
i
Distribution hours per workday(s)
i
Unloading minutes per delivery
Average speed (km/hour)
Average speed (miles/hour)
Distance circuity factor
i
Truck fill rate
i
From day
To day
i
Map will display routes of all warehouses on this last day.
CVRP runs
i
Progress
Current CVRP
Data entry errors

High level approximation

Approximation based on avg warehouse-customer distances, avg inter drop distances derived from auto-measuring delivery area sizes, shipment amounts and sizes, and transport parameter settings. Mileage is determined per warehouse per day, then accumulated.

Capacitated Vehicle Routing Problem solutions - Summary

Outcomes of vehicle routes constructed.

Capacitated Vehicle Routing Problem solutions - Route details






Your message / question / suggestion for improvement

"Your suggestions for improvement are always welcomed!"

Alrik Stelling - Owner