Worked examples
Healthy six-turn store
| Annual COGS | $240,000.00 |
| Average inventory value | $40,000.00 |
| Turns per year | 6 |
| Days per turn | 60.83 |
Six turns a year — inventory converts to cash roughly every two months.
Overstocked catalog
| Annual COGS | $240,000.00 |
| Average inventory value | $96,000.00 |
| Turns per year | 2.50 |
| Days per turn | 146 |
The same sales on 2.4× the stock: 2.5 turns, with cash asleep on shelves.
Frequently asked questions
What is a good inventory turnover for e-commerce?
Most healthy e-commerce stores land between 4 and 8 turns a year — selling through stock every 6 to 13 weeks. Fashion and consumables often run 8–12; furniture and slow durable goods may sit at 2–4. Compare against your own category and lead times: a store restocking from overseas simply cannot turn as fast as one with a domestic supplier.
Why use COGS instead of revenue in the formula?
Because inventory is valued at cost. Dividing revenue by inventory-at-cost mixes a marked-up number with an at-cost number and inflates the result by your margin — a store with 50% margins would look twice as fast as it really is. Using COGS keeps both sides of the ratio in the same units, which is why accountants and lenders insist on it.
How do I calculate average inventory value?
The simple version is (beginning inventory + ending inventory) ÷ 2 for the period, valued at cost. If your stock swings hard across the year — a Q4-heavy business, for instance — average the month-end values of all 12 months instead. A single end-of-year snapshot taken right after holiday sell-through will flatter your turnover badly.
Is a higher turnover always better?
Only up to the point where you start stocking out. Beyond roughly 12 turns on a long-lead-time product, you are ordering constantly and probably running out between shipments, losing sales and marketplace ranking. The sweet spot is the fastest turn rate you can sustain without stockouts — push it by shortening lead times, not just cutting stock.
Related calculators
- EOQ Calculator
- Reorder Point Calculator
- Safety Stock Calculator
- Break-even ROAS Calculator
- All calculators
Part of the Inventory collection.