The formula in R6 and copied down should be
=Q6 * INDEX($K$6:$K$17, MONTH(P6))
Your sales values are more noise than anything else. There is no year-to-year seasonality, just random large values.But my actuals do not in any way come close to what the worksheet is forecasting for those months.
Entia non sunt multiplicanda sine necessitate
Thank you shg!
Next, I'm now going to do some research and try to find a way to make noisy data usable. Any suggestion on a methodology I should be looking into? Maybe a different forecasting method?
The assistance in much appreciated. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks