Inventory turnover and inventory days: what does the ratio tell you?

A warehouse reports six inventory turns a year. Someone converts that to 61 days and concludes that every item spends about two months on the shelf.

The calculation can be right while the conclusion is wrong.

Inventory turnover compares the cost of goods sold during a period with the average inventory value held during that period. Inventory days expresses the same relationship in days. Neither number tells you how long a particular box has been sitting there.

The ratios help you judge how much stock the business carries relative to what it sells. You still need item records and service results to decide whether that stock is doing its job.

Calculate inventory turnover using cost, not selling price

Take a fictional distributor over a 365-day year. Its cost of goods sold, often shortened to COGS, is €1,200,000. That is the inventory cost associated with the goods sold, rather than the €1,800,000 customers paid for them.

Inventory starts the year at €160,000 and ends at €240,000. Both balances use the same cost basis and cover the same goods as the COGS figure.

For this first calculation, use the simple average of those two balances.

OpenStax's accounting text explains this cost-based formula. The numerator is a flow over the year; the denominator is an average balance held during it.

Using sales revenue instead gives €1,800,000 ÷ €200,000 = 9. That mixes selling prices with stock valued at cost. A price increase could then make the ratio rise without another unit leaving the warehouse.

Some reports deliberately use a sales-based ratio. Keep its name and basis explicit, and don't compare it directly with cost-based turnover.

Convert turns into inventory days

For the same year, days inventory outstanding, also called days' sales in inventory, is:

Both versions use average inventory and the same annual COGS. Round to about 61 days when discussing the result.

That means the average balance is equivalent to roughly 61 days of that year's cost of sales. It doesn't establish the age of any item, or promise that today's stock will cover the next 61 days of demand.

A warehouse can hold fast-moving products alongside old stock that barely moves. The overall ratio combines them. The ABC/XYZ inventory note helps separate products by their importance and demand pattern before changing their planning rules.

What changes the ratio?

The comparison below keeps the cost basis consistent. The alternatives are separate fictional annual cases, not forecasts of what a stock reduction would achieve.

Reducing average inventory from €200,000 to €150,000 while keeping COGS at €1,200,000 raises turnover from six to eight. Inventory days falls to 45.6.

But if COGS also falls, the apparent improvement can disappear. At €900,000 COGS and €150,000 average stock, turnover is back at six. The business carries less stock in euros, yet the balance has the same relationship to its lower activity.

The €50,000 difference between average balances isn't automatically cash released. Establishing that needs actual purchases, stock movements, payments and any write-downs. A ratio comparison isn't a cash-flow statement.

Choose an average that represents the period

Using only our distributor's closing inventory gives €1,200,000 ÷ €240,000 = 5 turns. That's different from the six turns calculated with the opening and closing average.

The two-point average is simple. It can miss a large stock build in the middle of the year. If the business buys heavily before a seasonal peak, inspect balances through the period and use an averaging method that represents that pattern. Record the dates and weighting.

Keep periods aligned too. For a 90-day quarter, divide 90 by that quarter's turnover to obtain inventory days. Dividing 365 by an unannualised quarterly turnover would overstate the result.

Before comparing sites or years, check that they include the same inventory categories and valuation rules. Raw material, work in progress and finished goods shouldn't quietly enter or leave the denominator between reviews.

Is higher inventory turnover always better?

There is no useful universal target for every warehouse. A short-life product, a seasonal range and a critical spare serve different needs.

A higher ratio can accompany less excess stock. It can also accompany shortages. Show turnover beside a service measure such as unit fill rate, which counts demand supplied immediately from stock. If recorded sales omit unmet demand, the turnover report won't recover that missing customer experience.

The stockout forecasting example explains that data gap. Cutting stock because the sales history looks small can reinforce it.

For the next inventory review, put the average balance and COGS beside the ratio. Then inspect ageing, shortages and the items responsible for the balance. Use that evidence to change a replenishment rule or clear a specific excess, and check service afterwards.

Six turns tells you where the discussion starts. The item records tell you what to change.

Sources and calculation notes

• OpenStax: Examine the Efficiency of Inventory Management Using Financial Ratios. Inventory turnover, the opening/closing average and inventory days calculated with daily COGS.

All business figures and comparisons are fictional. The baseline uses an opening/closing average, a 365-day year and consistent cost valuation. The interactive alternatives use assumed average balances directly. No demand forecast, stock-age estimate, service optimum or measured cash saving is claimed.