predict vehicle service, report if car is above or below lease schedule

Hi,

Attached is a visual spreadsheet for middle and upper management to see how the fleet is preforming.

I think the graphs work well but what I would like to do is summaries the vehicles by region(South, North, NorthWest)
Display the car rego, current km's, if the car is more than 3,000km above or below it schedule and possibly predict when the next service will be due.
Maybe even display it on the graph, if that is at all possible.


Kind of at a stand still, just wondering if you can have a look and offer some advise.

Thanks in advance.