1 Reply Latest reply on Feb 12, 2016 8:18 AM by Dan Sanchez

    Sales Forecast based on inventory levels

    Ryan Thornton

      i run a e commerce business that deals with a lot of one time inventory buys as well as replenishable items. I'm trying to forecast my sales based on inventory on hand. For example

       

      SKU ABC

      Sales in the last 30 days. $10,000

      Qty Sold 100

      inventory On Hand 500

       

      im looking to design a report that would have the months at the top and the SKUS on the side and it should look like this

       

      SKU  .Jan.    Feb.  . March. . Apr.    May  Jun

      ABC  $10000 $10000.$10000.  $10000 $10000. $0

       

      so June would show $0 since my inventory would of ran out by then