How many times stock turns over in the period.
Your figures
Keep units consistent: kg with kg, minutes with minutes. Results update as you type.
Inventory turnover
—
Days of stock held
—
Formula
Cost of goods sold ÷ average inventory value
=IFERROR(B2/C2,0)Excel: B2 cost of goods sold (period); C2 average inventory value; D2 days in the period
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.