Is there a function that could be easily added to allow for a column to display weeks in stock of a product within a warehouse based on either static or dynamic values (looking back over a 10 week period or variable period)?
Example: I have 37 products from one supplier, each one with their own floating inventory and demand. Currently I don’t place an order for restock until I’ve reached a threshold below “X” weeks in stock, but it is very rarely ever the same product that triggers. The demand is dynamic enough that setting a “reorder threshold” number isn’t granular enough.
Can a column be added or another page be created to the inventory page that will reflect the calculation for weeks in stock based on a lookback period?