We have a new customer with a few hundred vehicles. But they have 4 delivery vehicles whose miles need to be internally billed to each of their various job sites for accounting purposes. It takes one of their employees about 4 hours each month to get this data out of the current stop detail report we provide.
They asked us if we would build them a custom GPS tracking report to help.
Here’s a depiction of how they assign mileage to job sites:
Delivery workflow & mileage calculation
All mileage from the warehouse or another job site needs to be allocated to the NEXT job site reached, to include miles spent going to non-job sites (such as McDonald’s, above).
The mileage spent heading BACK to the warehouse needs to be assigned to the most recent job site serviced.
Rather than go through a stop/detail report, line by line, for hundreds or thousands of trips for a month, we created this consolidated GPS tracking report, called the “Delivery Vehicle Mileage” report:
New Custom Delivery Mileage GPS Tracking Report
Here is the output with client specific information blurred out:
Easy totals for mileage to job sites
Note the red arrows illustrate mileage TO the job site, and a couple blue arrows show mileage FROM the job site deadheading back to the yard.
Any group of vehicles as well as starting/reset landmarks such as a warehouse and job site landmarks may be chosen and it can be run for 31 days at a time (and we can always increase that restriction if the number of vehicles/landmarks are reasonable and you need quarterly reports instead).
And the best part: Instead of it taking this customer 4 hours a month to tabulate through a mind-numbing stop detail report, they can now run it in about 2 seconds with this report we built for them (and any customers who may require it in the future):
2 seconds to do 4 hours work
As always, we appreciate customer requests, and accommodate them better than any other GPS Tracking provider out there. Keep them coming — when we help our customers, we help the product as well!