How long does your current stock go? A week or several years?
WHAT:
This formula calculates the number of days that your stock will last. The calculation is based on data from 12 months.
WHY CALCULATE THE ADEQUACY?
When you have calculated your stock’s adequacy, you can estimate whether it is correctly compound. Do you for example have a lot of items number with more than 365 days’ consumption? Or have you bought items to several days’ consumption even though the supplier is stabile and able to deliver at short notice?
COLUMNS NEEDED IN THE CALCULATIONS:
- Sold pcs 12 months (NUMBER)
- Number in stock (NUMBER)
- Date created (DATE)
FORMULA:
if([Number in stock]=0, 0, (if(and([Consumption per day]0), 99999 [Number in stock]/[Consumption per day])))
RELATED RECIPE
- Stock surplus 12 months: Have you bought more than 12 months’ consumption? Use this recipe to calculate the value of your stock surplus.