Inventory Turnover Ratio Calculator

What is average inventory?

Average inventory is the midpoint of what you were holding across the period, and it is the denominator of the turnover ratio:

Average inventory = (beginning inventory + ending inventory) ÷ 2

Using only the ending figure is where turnover usually goes wrong. A delivery that lands in the final week inflates it and pushes turnover down. A clearance event in the last few days deflates it and pushes turnover up. Neither reflects the stock you actually carried and paid for across the period, which is what the ratio is supposed to measure against.

Both figures need to be at cost, taken from the same inventory report, on the first and last day of the window your COGS covers. If you measure by month or by season, take a snapshot at each period boundary and the calculation stays consistent from one period to the next.

Why turnover has to be calculated at cost

The most common way this metric gets broken is dividing retail sales by inventory at cost. It is an easy mistake, because sales is the number sitting on your dashboard and cost is the number in your inventory report. The result is not turnover, it is turnover multiplied by your markup. A boutique with a keystone markup will see roughly double the real figure, conclude stock is moving beautifully, and keep buying into categories that are actually sitting.

Keep both sides of the division at cost and the ratio means what it claims to: the number of times you replaced your average stock investment during the period. If you are not sure your COGS figure is clean, the COGS calculator builds it properly and hands the result straight back here.

Inventory turnover example

Here is a complete calculation using hypothetical figures. The numbers are an illustration of the method, not a target.

Read literally, this store sold and replaced the equivalent of its average stock investment three times during the year, and the average item sat for about four months before it sold. That is what the arithmetic says, and nothing more. Whether 3.0 is the right speed for this store depends on what it sells, how long its suppliers take to deliver, how deep it buys and how much margin each category carries.

What the owner now has is a baseline. Run the same calculation for the prior year, for each category, for each vendor, or before and after a change in buying strategy, and the movement between those numbers is the finding. A single figure in isolation rarely is.

Why turnover cannot be judged on its own

Two hypothetical categories, both carrying $10,000 in average inventory at cost for the year:

• Jewelry: $20,000 COGS, so turnover is 2.0. Gross margin dollars for the year: $18,000.
• Graphic tees: $50,000 COGS, so turnover is 5.0. Gross margin dollars for the year: $15,000.

The tees turn two and a half times faster. The jewelry produced more margin dollars from the same money tied up. Turnover ranked one way and the earnings ranked the other, which is why the ratio answers how fast rather than how productive. The metric that combines both is GMROI, and you can run it on these same inventory figures in the GMROI calculator before you move budget between categories.

What causes low inventory turnover?

Slow turnover is a symptom, and the cause decides the fix. The usual suspects in a small store, not all of which will apply to yours:

• Buying too deep on a style before demand was proven.
• Demand that came in softer than the buy assumed.
• An assortment that does not quite match who actually shops with you.
• Overestimating a season and carrying the remainder past its window.
• Waiting too long to mark down merchandise that stopped selling.
• Receiving goods weeks before customers are ready to buy them.
• Carrying several similar styles that split the same demand between them.
• Vendor minimums that force more units than the store can sell in a sensible window.

To find out which styles are responsible rather than guessing, run the sell-through calculator on the individual items. A small share of the assortment usually accounts for most of the drag.

Can inventory turnover be too high?

Yes. Turnover rewards being out of stock, so a store that runs thin posts a strong number while leaving sales on the table. Things to check when the figure climbs:

• Best sellers going out of stock before customers can buy them.
• Broken size runs and missing colors on styles that were working.
• Buying too shallow on merchandise with proven demand.
• No safety stock on items that carry the floor.
• Replenishment arriving later than the shelf empties.
• Discounting hard to keep units moving, which clears stock and takes the margin with it.

None of that shows up in the turnover ratio itself, which is why the number is a prompt to look rather than a verdict.

How to improve inventory turnover

• Buy narrower when demand is unproven, then go deeper on what sells. The inventory buy planner scores how much risk a planned order carries before you place it.
• Reorder proven winners instead of making another large speculative buy into an untested style.
• Review aging stock on a fixed schedule rather than whenever it catches your eye.
• Mark down or exit merchandise that has stopped earning its space, and work out what the discount does to profit first in the markdown calculator.
• Compare categories against each other instead of judging the store as a single number. The store average hides both your best and your worst.
• Align reorder timing with supplier lead time, so replenishment lands while a style is still selling. The reorder point calculator turns that timing into a unit level for a replenishable product.
• Move future buying dollars toward the merchandise producing stronger results, using your open-to-buy budget as the limit.

Retail price is part of this too. A margin that looks healthy on paper earns nothing while the item is still on the rack, so pricing and velocity get decided together. The pricing side is covered in how to price boutique clothing.

What to do once you know your inventory turnover

The ratio is only worth calculating if it changes a decision. Run it by category and by vendor, then use it to:

• Identify categories you bought more of than the store can sell.
• Spot merchandise holding cash you need for the next buy.
• Decide where to reduce future buying rather than cutting across the board.
• Find where proven demand justifies replenishing instead of testing something new.
• Compare vendors on how quickly their goods actually move for you.
• Build a markdown list from the slowest stock rather than the most visible.
• Inform your open-to-buy for the coming period.
• Judge whether the assortment is too broad, too deep, or aimed at the wrong customer.
• Check GMROI wherever turnover alone does not settle the argument, because speed and earnings can point in different directions.

For the full rhythm these numbers sit inside, from receiving and counting through reorder and markdown decisions, read boutique inventory management.

Turnover is one of about a dozen formulas a store runs regularly. The rest are collected in the retail math formulas hub.