I have data that I need to smooth to better calculate order points for ordering inventory.
I have the 12 months usage for a particular part in cells A1:L1.
The data fluctuates all over the place from 10 to 132, and anywhere in between. I need a better way to smooth this data to avoid ordering "excess" due to the spikes in usage.
Any formula's that can be provided to help is greatly appreciated.
Bookmarks