3 Replies Latest reply: Jun 10, 2013 3:42 PM by Michael Solomovich RSS

    Forecast Demand and Safety Stock Calculations

    Bradley Coyne

      Hi all!

       

      i am having the problem with forecast for Purchasing in QV.

       

      Dimensions

      • Delivered Qty
      • Month
      • Year

      Expressions

      • Safety Stock (Demand Qty * LeadTime)
      • Demand Qty (not yet established)

       

      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?

       

      Best,

      Brad