This content has been marked as final. Show 3 replies
i am having the problem with forecast for Purchasing in QV.
What i would like to do is calculate the Demand qty based on the historical data i.e 2010,2011,2012,2013, and divide it through the allocated mths i.e 36
if there is no history i would like to build a similar function to look up on other articles history.
However, the problem is that the articles are season based, so irregular sales throughout they year.
is weighted averages more applicable in the calculation? has anyone experience of this from previous projects?