Below is a description of how the allocation chart mileage traffic light system is calculated currently in Prohire.
The traffic light system is based off a vehicles optimum mile to date figure (OMTD)
First, we need to work out what the OMTD is, this is done by:
Entry Miles = 100
Entry Date = 01/01/2023
Exit Miles = 10,000
Exit Date = 31/12/2023
- Proposed Miles = Exit Miles - Entry Miles 10,000 – 100 = 9,900
- Proposed Days = Exit Date - Entry Date 31/12/2023 – 01/01/2023 = 365
So, the optimum miles to date (OMTD) for this vehicle would be:
- OMTD = Proposed Miles / Proposed Days 9,900 / 365 = 27
Now work out how many miles are left for the vehicle to cover
- Future Booking Predicted Miles = 0 (no booking(s) taken on the vehicle)
- Miles to book before vehicle exit date = Proposed Miles - Future Booking Predicted Miles è 9,900
Now work out how many on fleet days are left for the vehicle
- Days left on fleet = 16/02/2023 - Exit Date (31/12/2023) = 319 days
The green highlight on the allocation chart is now worked out by:
- Miles to book before vehicle exit date / Days left on fleet = 31.03448 which is within 10% of OMTD
First, we need to work out what the OMTD is, this is done by:
Entry Miles = 100
Entry Date = 01/01/2023
Exit Miles = 10,000
Exit Date = 01/04/2023
- Proposed Miles = Exit Miles - Entry Miles 10,000 – 100 = 9,900
- Proposed Days = Exit Date - Entry Date 01/04/2023 – 01/01/2023 = 91
So, the optimum miles to date (OMTD) for this vehicle would be:
- OMTD = Proposed Miles - Proposed Days 9,900 / 91 = 108
Now work out how many miles are left for the vehicle to cover
- Future Booking Predicted Miles = 5000
- Miles to book before vehicle exit date = Proposed Miles - Future Booking Predicted Miles 4,900
Now work out how many on fleet days are left for the vehicle
- Days left on fleet = 16/02/2023 - Exit Date (01/04/2023) = 45 days
The green highlight on the allocation chart is now worked out by:
Miles to book before vehicle exit date / Days left on fleet = 108.8888 which is greater than +10% of OMTD
First, we need to work out what the OMTD is, this is done by:
Entry Miles = 100
Entry Date = 01/01/2012
Exit Miles = 10,000
Exit Date = 01/05/2013
- Proposed Miles = Exit Miles - Entry Miles è 10,000 – 100 = 9,900
- Proposed Days = Exit Date - Entry Date è 01/05/2013 – 01/01/2012 = 486
So, the optimum miles to date (OMTD) for this vehicle would be:
- OMTD = Proposed Miles / Proposed Days è 9,900 / 486 = 20
Now work out how many miles are left for the vehicle to cover
- Future Booking Predicted Miles = 9,000
- Miles to book before vehicle exit date = Proposed Miles - Future Booking Predicted Miles è 9,900 – 9,000 = 900
Now work out how many on fleet days are left for the vehicle
- Days left on fleet = 16/02/2012 - Exit Date (01/05/2013) = 440 days