Stock Turnover Formula: How to Find Your Inventory Turnover Ratio

The inventory turnover ratio is cost of goods sold divided by average inventory for the same period. It tells you how many times, on average, a business sold through and replaced the stock it was holding, and dividing the days in the period by the ratio converts it into days inventory outstanding: roughly how long stock sits before it sells.

The practical problem is not the formula. It is that the inputs are often mismatched, the average is taken from two convenient dates, and a single blended figure is read without asking what kind of stock produced it. A ratio of 6 can describe a healthy range, or a mix of best sellers that keep running out and slow lines that have not moved in months. This guide shows how to calculate it properly, how to read it by category and where it stops being useful.

Every shelf location holds stock that has been paid for and is waiting to sell. Illustrative photograph, not an OpsMavix project.

Image credit: Lance Chang, Unsplash License. No edits.

Key Takeaways

• Inventory turnover ratio equals cost of goods sold divided by average inventory, with both figures at cost and for the same period.
• Days inventory outstanding equals the days in the period divided by turnover, and is easier to compare with lead times and payment terms.
• A two-point average can overstate turnover for seasonal businesses; monthly or more frequent stock values give a fairer figure.
• There is no universal good ratio, so compare against your own trend and against businesses that hold similar stock.
• A blended ratio hides fast and slow lines, so calculate it by category, ABC class or supplier before acting.
• Turnover measures speed, not profit or service, so read it alongside GMROI, ageing and stockout data.

In this guide:

• 1. Understand What Inventory Turnover Measures
• 2. Use the Inventory Turnover Formula Correctly
• 3. Convert Turnover Into Days Inventory Outstanding
• 4. Work Through a Hypothetical Turnover Example
• 5. Interpret Turnover by Category
• 6. Calculate Turnover by Segment Before Acting
• 7. Know the Limits of the Inventory Turnover Ratio
• 8. Build a Repeatable Turnover Report
• Frequently Asked Questions
• How OpsMavix Can Help

1. Understand What Inventory Turnover Measures

A measure of speed through the stock investment

Stock is cash that has been spent but not yet recovered through a sale. Turnover counts how many times that average investment was consumed by sales during a period. A higher figure means the same amount of stock supported more cost of sales; a lower figure means more stock was held for each pound of goods sold.

That makes turnover a working capital measure as much as a warehouse one. Two businesses with the same sales and the same margin can need very different amounts of cash, simply because one holds two months of stock and the other holds five.

What it is useful for

What it does not tell you

Turnover does not show margin, holding cost or lost sales. A fast-moving line can earn very little gross margin, and a very high ratio can mean shelves are empty too often. Those gaps are covered in section 7.

2. Use the Inventory Turnover Formula Correctly

The core formula

Inventory turnover ratio = Cost of goods sold ÷ Average inventory

Both figures must cover the same products and the same period. If cost of goods sold is for twelve months, average inventory should represent those twelve months, not a single year-end balance.

Keep both sides at cost

Cost of goods sold is a cost figure, and stock on the balance sheet is also carried at cost, subject to write-downs. Under IAS 2 Inventories, inventories are measured at the lower of cost and net realisable value. Dividing sales revenue by stock at cost mixes selling prices with cost prices, so the result is inflated by your margin and cannot be compared with a properly calculated ratio.

Some published ratios do use sales. If you compare against an external figure, check which numerator it uses before drawing conclusions.

Choose an average that reflects the year

The opening and closing method is common because those two numbers are easy to find. It can be misleading where stock is deliberately run down before a year-end count, or where a seasonal peak falls between the two dates.

Input checklist

1. Cost of goods sold and stock values cover the same period, products and locations.
2. Stock is valued at cost using the business’s normal valuation method.
3. Returns, credits and stock write-downs are treated consistently.
4. Goods in transit and consignment stock are either included or excluded on both sides.
5. New and discontinued lines are flagged so part-year results are not compared with full-year ones.

3. Convert Turnover Into Days Inventory Outstanding

The formula

Days inventory outstanding = Days in the period ÷ Inventory turnover ratio

An equivalent version is (Average inventory ÷ Cost of goods sold) × days in the period. Both give the same answer when the inputs match. Some businesses use 360 days for convenience; whichever you choose, use it consistently.

Why days are easier to act on

Turns are useful for comparison, but days connect directly to operational decisions. If stock sits for about 61 days on average, you can compare that with a supplier lead time of 30 days, or with supplier terms of 30 days. In that situation, stock is typically paid for before it is sold, and the gap has to be funded from working capital.

Use the right period length

For a quarter, use the quarter’s cost of goods sold, the quarter’s average inventory and roughly 91 days. Do not divide a quarterly turnover figure into 365 days, or the result will be four times too long.

4. Work Through a Hypothetical Turnover Example

Hypothetical wholesaler, simple average

The figures below are hypothetical and chosen only to show the method. A homeware wholesaler has £1,200,000 of cost of goods sold for the year. Stock at cost was £180,000 at the start of the year and £220,000 at the end.

The same business with monthly values

Now suppose the wholesaler builds stock for an autumn peak. Its month-start stock values, in thousands of pounds, are 180, 190, 200, 210, 230, 260, 290, 320, 330, 300, 250 and 210, with a closing value of 220.

• Sum of the 13 values: £3,190,000.
• Monthly average inventory: £3,190,000 ÷ 13 = £245,385 (rounded).
• Inventory turnover ratio: £1,200,000 ÷ £245,385 = 4.89.
• Days inventory outstanding: 365 ÷ 4.89 = 74.6 days.

The business did not change. The simple average missed the stock carried through the summer and autumn, so it overstated turnover by more than one turn and understated the time stock sits by about 14 days.

The cash reading

At the simple average, the wholesaler holds £200,000 of stock to support £1,200,000 of cost of sales. If it could reach 8 turns on the same cost of sales without hurting availability, average inventory would be £1,200,000 ÷ 8 = £150,000, releasing about £50,000 of working capital. That is a hypothetical target, not a promise; section 6 shows why the improvement usually has to come from specific lines rather than an across-the-board cut.

5. Interpret Turnover by Category

Everyday consumables are usually expected to move faster than big-ticket or specialist stock. Illustrative photograph, not an OpsMavix project.

Image credit: Eduardo Soares, Unsplash License. No edits.

Why one benchmark cannot fit every business

What counts as healthy depends on what the stock is, how quickly it perishes or dates, how predictable demand is and what service customers expect. A business holding spare parts for breakdowns may deliberately keep slow stock because the cost of not having the part is high.

Official statistics show how wide the differences between sectors can be. In its manufacturing and trade inventories and sales release published in October 2026, the US Census Bureau reported seasonally adjusted inventories to sales ratios for August 2026 of 0.82 for food and beverage stores, 1.39 for general merchandise stores, 1.80 for furniture, home furnishings, electronics and appliance stores, 2.02 for clothing and clothing accessories stores and 2.53 for building materials, garden equipment and supplies dealers.

Those ratios compare end-of-month stock with a month’s sales, so they are not turnover ratios and they describe the US market. They are useful only to show the spread: food retailers held well under one month of sales in stock, while building materials dealers held about two and a half.

How to read the direction by stock type

Compare with your own history first

The most reliable comparison is usually the same business over time, measured the same way. A ratio that falls quarter after quarter means stock is growing faster than cost of sales, whatever the absolute level. Investigate that trend before reacting to a figure from another sector.

6. Calculate Turnover by Segment Before Acting

Why a blended figure misleads

The overall ratio is weighted towards the lines that sell most. Fast movers generate most of the cost of goods sold, while slow lines sit in average inventory contributing little to sales. The total can therefore look acceptable while some lines run out and others age on the shelf.

Hypothetical example by ABC class

Using the same hypothetical wholesaler and the simple average, suppose the range is split with ABC analysis.

Class C carries 35% of the average stock (£70,000 of £200,000) but only 7.5% of cost of goods sold (£90,000 of £1,200,000). The blended 6.0 hides that completely.

Test the improvement where it belongs

If the business halves average C-class stock to £35,000 with the same C-class cost of sales, C turnover rises to £90,000 ÷ £35,000 = 2.57, or about 142 days. Total average inventory becomes £165,000 and overall turnover rises to £1,200,000 ÷ £165,000 = 7.27, or about 50.2 days, without touching the A-class lines that drive most sales.

That assumes the reduction comes from not repeating over-buying or clearing lines that genuinely will not sell, rather than starving lines that customers still need.

Practical segment checklist

1. Calculate turnover and days by category, ABC class, supplier and location.
2. Flag lines with no sale in a set period and review them with inventory ageing.
3. Separate genuinely slow-moving inventory from stock that has stopped, and handle the latter with dead stock management.
4. Check order quantities and reorder point settings on slow lines that still sell.
5. Check the safety stock calculation on fast lines before reducing their cover.
6. Review the forecast for lines bought ahead of demand; see demand forecasting for a small business.

7. Know the Limits of the Inventory Turnover Ratio

What the ratio leaves out

High is not automatically good

A very high ratio can mean stock is lean and well managed. It can also mean the business is running out of popular lines and losing sales that turnover never records. Read a high figure alongside service level before treating it as a success.

Turnover and GMROI answer different questions

Turnover asks how fast stock moves. GMROI asks how much gross margin each pound of stock earns. Our GMROI guide shows how the two connect: GMROI equals markup on cost multiplied by turnover at cost, so a weak GMROI can come from slow movement, thin margin or both.

8. Build a Repeatable Turnover Report

Set the report up once

1. Fix the period, usually a rolling 12 months reviewed monthly.
2. Pull cost of goods sold per product from sales and cost records.
3. Pull stock at cost per product from month-start valuations or more frequent snapshots.
4. Calculate turnover and days inventory outstanding for each product, then roll up by category and class.
5. Add ageing, stockout flags and GMROI beside each line.
6. Sort by days inventory outstanding and assign owners to the slowest lines.
7. Record the action taken and check the result at the next review.

Choose the right tooling approach

Before buying anything new, check whether current tools can already produce monthly stock values at cost per product, or can be configured to. Many reporting gaps are a data or configuration problem rather than a missing system.

Frequently Asked Questions

What is the inventory turnover ratio?

It is cost of goods sold for a period divided by average inventory for the same period. It shows how many times the average stock investment was sold through and replaced.

How do you calculate inventory turnover ratio?

Add up cost of goods sold for the period, calculate average inventory at cost for the same period and divide the first by the second. For example, £1,200,000 of cost of goods sold on £200,000 of average stock gives a ratio of 6.0.

How do you calculate days inventory outstanding?

Divide the number of days in the period by the turnover ratio. A ratio of 6.0 over a 365-day year gives about 60.8 days.

What is a good inventory turnover ratio?

There is no single figure that suits every business. Fresh goods and consumables usually move faster than furniture, building materials or spares. Compare against your own trend and against businesses that hold similar stock, measured the same way.

Should I use sales or cost of goods sold?

Use cost of goods sold. Stock is held at cost, so dividing sales by stock includes your margin and overstates the ratio. If an external benchmark uses sales, compare it only with a figure calculated the same way.

Why does my turnover look fine when I have slow stock?

Because the overall ratio is dominated by fast movers. Calculate turnover by category or ABC class and review ageing to find the lines the average hides.

How often should turnover be reviewed?

Monthly on a rolling 12-month basis suits many businesses. Seasonal and fast-moving ranges may justify more frequent stock snapshots.

Can OpsMavix build an inventory turnover report or system?

Yes. OpsMavix can build focused applications or a full custom ERP, and can configure or integrate suitable existing tools where those approaches fit the requirements.

How OpsMavix Can Help

OpsMavix can bring costs, sales and stock values together so turnover, days inventory outstanding, ageing and GMROI are calculated per product and category without rebuilding a spreadsheet each month.

That may mean configuring or connecting the tools you already use, adding an inventory automation system, setting up ecommerce inventory automation across sales channels, linking stock to customer orders with wholesale order management or building a full custom ERP where the wider operation needs it.

Contact OpsMavix with one recent stock valuation, the records behind it and the handoff that creates the most rework. We can use that evidence to define requirements and a practical pilot.