0 Replies Latest reply on Mar 11, 2014 2:59 PM by Drew Riley

    Complex calculation, or maybe just an easier way to do it.

    Drew Riley

      Im trying to create a calculation to be used as an error factor.  This is all for inventory purposes.  I have kown compsumtion, and assumed consumption.  The actual consumption lies somewhere therein.  I think by taking the prior weeks consumption and multiplying that by the moving average of the % difference of each weeks known/assumed delta it would give me an acceptable "error factor" that would allow for better judgement in ordering quantities.

       

      Any and all help is apprecieated.

       

      PS:  I know better use tracking would be way easier, I just don't have any control over that.