I have been searching for a way to forecast out 12 months for my business that has various seasonality spikes. I have found a few very helpful methods that de-seasonalize the data and show a nice trend that accounts for seasonality going forward.
The one Issue I have run into is that most of these methods show how to accomplish this on a single set of data. I have 350 item codes that I manage and would like to find a method that is scalable to multiple trends.
One of the easier methods I ran across was Bill Jelen's example on CFO.com The issue I run into is again that it is one for one set of sales data. it is not practical for me to set up this method 350 times so I need to find a work around. (I'd need to set up 1500+ columns to do so)
Has anyone run across something like this and could share how they did it?
The one Issue I have run into is that most of these methods show how to accomplish this on a single set of data. I have 350 item codes that I manage and would like to find a method that is scalable to multiple trends.
One of the easier methods I ran across was Bill Jelen's example on CFO.com The issue I run into is again that it is one for one set of sales data. it is not practical for me to set up this method 350 times so I need to find a work around. (I'd need to set up 1500+ columns to do so)
Has anyone run across something like this and could share how they did it?
