hi,

I am working on a research which its purpose to forecast future sales demand. I have annual data of about 27 years which my data set is obviously small. I am trying to train the model which I can forecast 6 years later's sales demand.

At first, I trained my model with annual data of each year. To clarify, Year 2000's inputs data are set with year 2000's actual sale in one row. As i trained with this technique, Everything was good and i got Rsquare of about 99%. The problem is, if I want to forecast next 6 years I have to have the input data for next 6 years. for instance currency rate for next 6 years which it will decrease my model's forecast accuracy.

I came to an idea which I could train each year with input data of the previous years. For example in training, i set currency rate of year 94 with actual sales of year 2000. 

With this technique I can use year 2016's input data in order to forecast year 2022's sales. 

Is this technique logical?

Similar questions and discussions