Inventory Turnover, Explained: Ratio, COGS, and Days Sales of Inventory

Inventory is cash you can't spend yet. It sits on a shelf or in a warehouse, waiting to become a sale. Inventory turnover is the single number that tells you how fast that cash cycles back into your hands, and whether you're carrying too much of it. If you sell physical goods, it's one of the few operating metrics that links directly to how much working capital your business needs.

This guide walks through the formula, the days version of the same number, a worked example you can follow line by line, and how to read a high versus low ratio for retail and ecommerce. You can run any of the numbers below in the Inventory Turnover Calculator as you read.

The inventory turnover formula

Turnover measures how many times you sold through and replaced your stock during a period:

inventory turnover = cost of goods sold (COGS) / average inventory

Two details decide whether your number is trustworthy.

First, use cost of goods sold, not sales revenue. Average inventory is carried at cost on your balance sheet. If you divide revenue by inventory, you're mixing a retail-priced number on top with a cost-priced number on the bottom, and the ratio gets inflated by your gross margin. A line that genuinely turns 5 times can read like 8 if you slip revenue into the numerator. Some older textbooks use sales for a quick estimate, but for a figure you can compare year over year or against a competitor, COGS is the consistent choice.

Second, use average inventory, not whatever happened to be on hand on one random day. A single snapshot can land on a seasonal peak or a post-clearance trough. The standard method is to average the beginning and ending balances:

average inventory = (beginning inventory + ending inventory) / 2

A quarter that opens at 15,000 and closes at 25,000 has an average inventory of 20,000. Businesses with heavy seasonal swings sometimes average twelve month-end balances instead, which smooths out a December spike, but two-point averaging is the textbook default.

From turnover to days sales of inventory

The raw ratio is hard to feel. "We turn 5 times a year" is abstract. Days sales of inventory (DSI), also called days inventory outstanding, converts the same number into a calendar figure: how long the average unit sits before it sells.

days sales of inventory = days in period / inventory turnover

For an annual figure that's usually 365 divided by your turnover. A turnover of 5 gives 365 / 5 = 73 days, meaning a typical item spends about 73 days in stock. If your books run on a 360-day convention or a quarterly cycle, swap the day count accordingly. Lower DSI means stock moves faster and ties up less cash. The two metrics carry identical information; DSI is just the version that's easier to act on, because "73 days on the shelf" makes the cash-tied-up problem tangible.

A worked example

Take a retail line with a full-year COGS of 500,000 and an average inventory of 100,000.

turnover = 500,000 / 100,000 = 5
DSI      = 365 / 5 = 73 days

So this line cycles its entire stock five times a year, and the average unit sits roughly 73 days before it sells. Put differently, you have about two and a half months of cost parked on the shelf at any moment. Whether that's good depends entirely on what you sell — which is the next section — but the calculation itself is this simple.

I learned to trust this number the hard way. Years ago I was helping a small homeware shop decide whether to take a vendor's bulk discount on a slow-moving line. The discount looked great on a spreadsheet. Then we computed turnover: 2.4, a DSI of roughly 152 days. The "savings" would have locked up five months of cash in goods that already moved at a crawl, and the extra units would have pushed DSI higher still. We passed. That one ratio reframed the whole decision from "is the discount big enough?" to "can we even afford to hold this much of it?"

What a high or low turnover signals

There's no universal good number. Turnover tracks how perishable, fast-moving, or capital-heavy your goods are, so a number that's excellent in one category is alarming in another.

High turnover usually means lean, efficient inventory: less cash locked in unsold goods, fresher stock, lower storage and obsolescence cost. Pushed too far, though, it flips into a liability. Turnover that's too high relative to your category often signals thin stock and frequent stockouts, which means lost sales and rushed, expensive reorders. Running lean only works if your supply chain can refill before shelves go empty.

Low turnover signals slow-moving or overstocked product. The goods age, tie up working capital, and risk markdowns or write-offs. A category that used to turn 6 times and now turns 3 is an early warning — its DSI just doubled from about 60 days to 120 — and that's the moment to mark down or stop reordering, while the stock still has resale value, rather than discovering a warehouse full of dead stock at the year-end count.

Typical ranges by category:

• Fresh grocery: 10 to 15 times a year. Food spoils, so it has to move.
• Apparel: roughly 4 to 6, paced by seasonal collections.
• Consumer electronics / general retail: around 6 to 10.
• Furniture, jewelry, auto parts: 2 to 4, because units are expensive and demand is occasional.

Comparing a jeweler to a supermarket on raw turnover is meaningless. Always benchmark against your own past periods and peers in the same category.

Reading turnover for retail and ecommerce

For an ecommerce operator, turnover and DSI are working-capital metrics first. Every extra day of DSI is a day longer before inventory cash converts back to spendable cash, which lengthens your cash conversion cycle and forces you to finance more stock up front. Two product lines under the same roof can have wildly different turnover — one at 10, one at 3 — and that gap is a direct argument for shifting open-to-buy budget toward the faster mover, rather than guessing which line "sells better."

It also pairs naturally with other unit-economics checks. Once you know how fast a line turns, the Break-Even Calculator tells you how many units you have to clear before that inventory investment pays for itself, and the ROI Calculator puts the return on a purchase order in percentage terms you can compare across lines. Turnover answers "how fast?"; those answer "is it worth it?".

A few habits keep the number honest: always feed COGS rather than revenue, always average your inventory rather than snapshotting it, and always compare within your own category and history. Get those three right and turnover becomes one of the most reliable signals you have for whether your inventory is an asset or a slow leak.

---

Made by Toolora · Updated 2026-06-13