I need help trying to forecast items we sell. Our business is mostly seasonal, we peak in early spring summer and fall off during the winter months. Item K is newer and starting to sell better each month but items N-Q are old items that follow the seasonal trend. Its these newer items that is giving me trouble because I can't base the forecast off of LY sales.
I was hoping the forecast or trend formulas would work but I could not get it to work for me.
Any suggestions would be greatly appreciated.
Bookmarks