1 Reply Latest reply: Sep 27, 2016 3:40 PM by m w RSS

    Run Rate Algorithm

    Katherine Evans

      I am looking for assistance in coding the following tables run rate based on sporadic weekly sales data. The data is available as daily sales volume by customer and by product

       

      I'm not sure this is possible as the run rate would be required for each product customer combination by day but any alternative ideas on run rates for data sets of this size and complexity would be welcome.

       

      Essentially

       

      Calc 1: starting point no prior data therefore no run rate

      Calc 2: no promo sales so run rate is total of that week for std sales only

      Calc 3 :both promo and std sales so total of both for that week = run rate

      Calc 4: no Std sales so run rate is total of that week for promo sales only

      Calc 5: no sales so last week containing sales would calculate as the run rate (so if no sales for two months then the sales from the last point of sale would be used)


      My table below would therefore not contain columns for std and promo merely a run rate for each week for each product and customer.

       

       

           

      ProductWeekStd SalesPromo SalesRun Rate
      1wk32001000
      1wk43000300
      1wk5100200300
      1wk62000200
      1wk7100100200
      1Wk83000300
      1Wk900300
      2wk44500450
      2wk5150300450
      2wk63000300
      2wk7150150300
      2Wk84500450
      2Wk900450
      3wk36003000
      3wk49000900
      3wk5300600900
      3wk66000600
      3wk7300300600
      3Wk89000900
      3Wk900900