How many days the stock will last at current usage.
Your figures
Keep units consistent: kg with kg, minutes with minutes. Results update as you type.
Days of inventory
—
Formula
Average inventory ÷ average daily usage
=IFERROR(B2/C2,0)Excel: B2 average or current inventory; C2 average daily usage
Save this calculation
Enter your figures (or try the worked example) to save them.
General calculation. Confirm your site's own definitions, validated limits and specifications before using a result for process control or product release.