Inventory Turnover Calculator

The inventory turnover formula and its two companions

Inventory turnover ratio = annual cost of goods sold ÷ average inventory value, with both measured at cost. A ratio of 4 means you sold through the equivalent of your average stock four times during the year. Days of inventory on hand = 365 ÷ the ratio, translating the same fact into a duration: at a ratio of 4, the average unit waits 91.25 days between arriving and selling. The months figure divides days on hand by 30.4 — the average month length — for a rougher but more conversational unit.

Both the numerator and denominator use cost deliberately. COGS is already a cost figure, and valuing inventory at retail while measuring outflow at cost would mix two different yardsticks — margin would inflate the denominator and make turnover look slower than it is. Value the shelf at what you paid, not what you hope to sell it for.

Assembling the two inputs without formal accounting

Neither input requires a bookkeeper, but each has a detail worth respecting.

• Annual COGS: units sold over the last 12 months × cost per unit, summed across SKUs. If you track landed cost (supplier price plus freight and duty), use it consistently in both inputs.
• Average inventory value: (inventory value at the start of the period + value at the end) ÷ 2, both at cost. A single end-of-year snapshot can badly misrepresent a seasonal business.
• Better averaging: if you record a stock valuation monthly, average the 12 monthly figures instead of two endpoints — the ratio becomes much harder to distort with one unusual month.
• Shorter windows: with only six months of history, divide the period’s COGS by average inventory and multiply by 2 to annualize — then re-run the inventory turnover calculator once a full year of data exists.

Worked example: $48,000 of COGS on a $12,000 shelf

The defaults describe a small brand that sold $48,000 of goods at cost over twelve months while carrying $12,000 of average inventory. Turnover ratio = 48,000 ÷ 12,000 = 4.0. Days on hand = 365 ÷ 4.0 = 91.25, and months on hand = 91.25 ÷ 30.4 ≈ 3.0. In plain terms: a dollar invested in this inventory takes about three months to come home.

Compare a roaster with the same shelf value but faster movement: $60,000 of annual COGS against a beginning inventory of $14,000 and an ending inventory of $10,000, so average inventory = (14,000 + 10,000) ÷ 2 = $12,000. Turnover = 60,000 ÷ 12,000 = 5.0, days on hand = 365 ÷ 5 = 73. Identical cash tied up, yet each dollar cycles back 18 days sooner — which compounds into more buying power across a year without a single extra dollar of working capital.

Reading your number: higher is not automatically better

Published benchmark tables are mostly noise for a small brand — turnover varies with category, price point, supplier distance and how you buy. The productive comparisons are internal: this quarter against last quarter, this SKU against your catalog average, your ratio before and after a change in order quantities. Direction and spread carry more signal than any absolute target.

A falling ratio means stock is accumulating faster than it sells — cash quietly converting into shelf weight, often concentrated in a few SKUs a per-product breakdown will expose. A very high ratio is not free either: it usually means lean buffers, and lean buffers convert supplier hiccups into stockouts. The number you want is the highest turnover you can sustain without missing sales, which is a balance point, not a maximum.

Also remember turnover is a trailing average. A SKU can post a healthy annual ratio and still be three weeks from a stockout today. Turnover tells you how efficiently capital moved; it does not tell you when to place the next order.

Turning a slow ratio into a faster one

The mechanical fixes follow from the formula. Shrink average inventory: order smaller quantities more often where price breaks allow, and stop automatically reordering the slowest movers at their historical volumes. Grow COGS relative to stock: concentrate purchasing on SKUs that actually sell, and clear dead stock through bundles or markdowns — the cash recovered matters more than the accounting loss on units that were never going to move.

Smaller, more frequent orders only work if the timing is right every time, which is where the rest of ShelfOwl comes in. The reorder point calculator tells you the stock level that should trigger a purchase order, the safety stock calculator sizes the buffer, and the latest order date calculator names the day. For a whole catalog, the paid ShelfOwl forecaster takes one CSV of sales and stock and returns per-SKU latest order dates with email reminders — $29/mo, and the 14-day trial asks for no card.