With Avrios you can easily monitor your fleet's leased vehicles and make sure they remain on track relative to the contracted maximum mileage. The mileage monitoring report offers you a complete overview of the excess or under-mileage of your leased vehicles. For each vehicle, a savings potential is calculated, to show the amount you could save with a contract closer to the vehicle's real usage over time.
How it works
The mileage monitoring report offers two important details: an estimated mileage at the end of the contract and a savings potential that is based on it and its cost.
1. Estimating mileage at end of contract
Avrios estimates the mileage of a vehicle at the end of the leasing contract in a simple way:
the difference between the last known mileage and the first mileage in the last year divided by the total number of days between the same two mileage entries is the average miles per day
the number of days between the last known mileage and the end of the contract multiplied by the average miles per day is the estimated mileage that will still be used until the end of the contract
the last known mileage plus the mileage that will still be used until the end of the contract is the projected mileage at the end of the contract
the difference between the projected mileage at the end of the contract and the maximum mileage is the excess mileage (projected)
All of these numbers are available in the excel export of the report if you want to check the calculation independently. An improved detail view of the report (coming soon) will also help you easily review them inside the app.
2. Calculating a savings potential
The savings potential is calculated using the vehicle's excess mileage cost or the undriven mileage credit:
For excess mileage, the savings potential is simply cost multiplied by excess mileage. If the vehicle is within the free mileage allowance, we show it on target (green) with no savings potential.
For under mileage, we first calculate the total credit that you should receive (excess mileage x credit amount). We then subtract the real credit, which is limited to the max. reimbursed mileages. The difference between these - in other words, the amount of credit which exceeds the max. reimbursed mileages - is the savings potential. A vehicle counts as on target as long as its excess mileage is below the max. reimbursed mileage limit.
Report glossary, fields & filters
The mileage monitoring report can be filtered using some of the typical vehicle attributes, as well as specific mileage monitoring attributes described below. It can also be exported to excel, in which case all of these fields will be present in the file:
Excess mileage (projected): the difference between the projected mileage at the end of the contract, and the maximum mileage
Projected mileage at end of contract: the estimate of the total mileage that Avrios predicts the vehicle will have at the end of its leasing contract, based on its usage in the last year.
Projected leasing utilization: the description of the state of the vehicle at the end of the contract, between over-mileage, under-mileage, on target, or impossible to calculate (data missing error).
Projection error (reason): the reason (missing data) why Avrios was unable to estimate the mileage at the end of the contract or calculate a savings potential.
Latest mileage date: the date when the last mileage was collected. Used to calculate the average KM the vehicle is driven, and how many days (months/years) are left until the end of the contract.
Usage duration (months): the number of months since the beginning of the leasing contract. Useful for filtering out new contracts for which it is too early to review excess mileage.
Savings potential: the amount that could be saved with a more precise contract maximum mileage.
Other Avrios mileage monitoring resources
Mileage monitoring is now an integral part of Avrios. You will find the same numbers in multiple places, allowing you to keep an eye on the current status in several ways:
the vehicle KPIs: the "distance" vehicle KPI will soon show the projected utilization as well. It is also a direct link to the new report where you can review the vehicle's excess mileage details.
the fleet dashboard: the "leasing utilization" numbers are based on the new report and provide direct links for you to review all the respective vehicles
the replacements report: the mileage calculation is based on the new report and provides a direct link for an easy review of the full report
flexible reporting: vehicle base reports now have an entire section dedicated to mileage management, allowing you to use those fields as filters or columns in custom reports
