excel - Best way to forecast optimum allocation between locations

Question

This may seem a rudimentary question but I have been searching with no luck.

I have a timeseries of 4 prices and 4 locations and the historical allocation between the locations

What is the best way to forecast this split using predicted future prices in Excel, it seems most of the functions are useful for predicting one dependent variable.

any ideas

thanks

question from:https://stackoverflow.com/questions/65881678/best-way-to-forecast-optimum-allocation-between-locations

Answer 1

Waitting for answers