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.