Forecasting vehicle service dates

Occasional Visitor

Good Evening

 

I am trying to forecast (using Formulae's) service dates for the Year 2022 going to the end of 2023.

This for proper planning, budgeting & procurement purposes.

Does anyone knw how to do this?

 

I have the current Mileage, Average Kms/month, Service intervals,last service date,last service mileage.

 

Any help is highly appreciated.

 

Regards and thanks

1 Reply

@omarbakerssalimited01 

Detailed sales forecast

More templates like this you will find in the upper link.

or...

Create your own forecast in Excel for Windows

If you have historical time-based data, you can use it to create a forecast. When you create a forecast, Excel creates a new worksheet that contains both a table of the historical and predicted values and a chart that expresses this data. A forecast can help you predict things like future sales, inventory requirements, or consumer trends.

Information about how the forecast is calculated and options you can change can be found at the bottom of this article.

 

Two example files from the internet are attached.

 

Hope I was able to help you with this info.

 

NikolinoDE

I know I don't know anything (Socrates)

Was the answer useful? Mark them as helpful!

This will help all forum participants.