CCalclabhub

Operations

How To Calculate Inventory Turnover

Inventory turnover is cost of goods sold divided by average inventory, and it answers one question: how many times did the shelf empty during the period? Everything contentious about it comes from which inventory figure sits in the denominator.

Quick Answer

Inventory turnover = COGS / average inventory

COGS
Cost of goods sold over the period — the cost of the stock that was actually sold
AVG
Average inventory, equal to (opening + closing) / 2
T
Turnover, the number of times the shelf emptied in the period
D
Days of inventory, equal to days in the period divided by turnover

Divide cost of goods sold by the average inventory carried over the period, where the average is opening plus closing divided by two. On cost of goods sold of 480000 against an average inventory of 60000.0 the ratio is 8.0, meaning the shelf emptied eight times. Dividing the days in the year by that figure converts turns into time: 365 / 8 = 45.625 days of inventory. Cost of goods sold per day is 480000 / 365 = 1315.0684931506848, the rate at which stock is consumed.

What Is Inventory Turnover?

Inventory turnover measures how many times a business emptied and refilled its shelf over a period, and it is computed as cost of goods sold divided by average inventory. On cost of goods sold of 480000 and an average inventory of 60000.0 the ratio is 8.0, meaning the stock turned over eight times. The average matters because a single closing figure of 65000 would give 480000 / 65000 = 7.384615384615385 turns, while the opening figure of 55000 would give 480000 / 55000 = 8.727272727272727 — a spread wide enough to change the story. Taking (55000 + 65000) / 2 = 60000.0 sits between those extremes and describes the stock the business actually carried through the year. Without that averaging the ratio silently rewards or punishes a firm for whatever happened on the last day of the accounting period.

The worked case is deliberately simple so the arithmetic stays visible: cost of goods sold of 480000 against an average inventory of 60000.0 gives 8.0 turns. Dividing the number of days in the year by that figure converts the ratio into time, so 365 / 8 = 45.625 days of inventory. That second number is often the more useful of the two, because it says the business holds roughly forty-six days of stock at its current rate of sale. Cost of goods sold per day works out to 480000 / 365 = 1315.0684931506848, the daily rate at which inventory is consumed. Reading 8.0 and 45.625 together makes it clear they are the same fact expressed on two different clocks.

The numerator is cost of goods sold rather than revenue, and the choice is not cosmetic. Revenue carries the gross margin inside it, so dividing revenue by inventory would measure how much customers paid rather than what the stock actually cost. Had revenue been 600000 in the same period, 600000 / 60000.0 would report 10.0 turns against the true 8.0 — an overstatement of a quarter. Inventory sits on the balance sheet at cost, so only a cost-based numerator is measured in the same units as the denominator. Matching the two is what keeps the ratio dimensionless and comparable across periods.

A turnover of 8.0 is neither good nor bad on its own, and treating any single number as a target is a reliable way to draw the wrong conclusion. A supermarket may turn stock twenty times a year while a bespoke furniture maker turns it twice, and both can be run well. The meaningful comparisons are the same business in earlier periods and close competitors in the same sector, where the operating model is similar enough for the gap to mean something. A jeweller holding 45.625 days of inventory is carrying little for its trade, whereas a grocery holding the same forty-six days is sitting on a warehouse full of perishables. The absolute figure tells you almost nothing until it is placed beside a relevant reference point.

High turnover is usually read as efficiency, but it can equally be a symptom of running too lean. If a business turns stock 20 times a year it holds roughly 18.25 days of inventory, and any unexpected surge in demand becomes a stock-out. Lost sales are invisible in the accounts — they never appear as a cost — so a firm can congratulate itself on 20 turns while quietly handing revenue to competitors. The ratio rises whenever stock is thin, whether that thinness is deliberate or accidental. The question to ask of any high figure is not whether it is impressive but whether customers were ever turned away.

Inventory is cash that has been converted into goods and parked on a shelf, so the turnover ratio is really a measure of how long money stays parked. With 60000.0 of average inventory and cost of goods sold of 480000, the business funds 45.625 days of stock before it sells. Every day of inventory that can be removed releases roughly 1315.0684931506848 of cash, so shaving ten days off the holding period frees about 13150.68. That released cash reduces the need for borrowing or can be redeployed into growth. Turnover and days of inventory therefore sit at the centre of working capital management, alongside receivables and payables.

Seasonality distorts the average because a simple two-point mean can be badly unrepresentative of a business whose stock swings through the year. A retailer that builds to 90000 for a December peak and runs at 30000 in summer may average (30000 + 90000) / 2 = 60000.0 across the year, yet hold only 15 days of stock in one month and 45 days in another. Using monthly averages instead of two year-end snapshots gives a far truer picture of the capital tied up. When the opening and closing figures fall at the same point in the seasonal cycle the two-point average is reasonable, but when they straddle a peak it can mislead in either direction. The fix is to average more frequently, not to abandon the ratio.

Definitions matter as much as arithmetic, because turnover can be quoted on a 360-day or a 365-day convention and the two do not agree. On the worked case the 365-day figure is 45.625 days, while a 360-day year gives 45.0 — a difference of more than half a day that is pure convention. The period itself must also be stated, because a ratio computed from annual cost of goods sold is not comparable with one computed from a quarter. Consistency is the discipline: the same period length, the same cost definition and the same averaging method across every comparison. A ratio whose basis is unstated is a number, not a measurement.

Read on its own, 8.0 turns and 45.625 days are simply descriptions of how one business moved its stock over one year. Their value appears only when they are set against the same firm's prior periods, against direct competitors, and against the cash they release. A rising turnover alongside stable sales usually means better stock control; a rising turnover alongside falling sales usually means the shelves are emptying because nobody is restocking them. Because lost sales leave no trace in the ledger, the ratio should always be checked against service levels and stock-out records before it is praised. Treated that way, inventory turnover becomes a working instrument for freeing cash rather than a score to be maximised.

Formula

T = COGS / AVG

The standard form. Divide the cost of the stock sold by the average value of the stock held to get the number of turns.

SymbolMeaning
COGSCost of goods sold over the period
AVGAverage inventory
TInventory turnover

AVG = (opening + closing) / 2

The two-point mean used when only the start and end of the period are known. Averaging removes the timing artefact of a single snapshot.

SymbolMeaning
openingInventory at the start of the period
closingInventory at the end of the period
AVGAverage inventory

D = days / T

Converts the ratio into time. It is the same fact as turnover, expressed as how many days of stock are on hand.

SymbolMeaning
daysLength of the period in days
TInventory turnover
DDays of inventory

How To Calculate Inventory Turnover

  1. 1

    Fix the period and pull the matching cost of goods sold

    Decide whether you are measuring a year, a quarter or a month, then take cost of goods sold for exactly that span. The worked case uses 480000 for a full year, and the same figure on a quarter would describe a completely different business. Never pair an annual cost of goods sold with a quarterly inventory figure, because the two sides of the fraction then measure different things.

  2. 2

    Establish opening and closing inventory on the same basis

    Take the stock value at cost at the start and end of the period. On the worked case those are 55000 and 65000. Both must be valued the same way: mixing a cost-based opening figure with a retail-priced closing figure corrupts the average before any ratio is computed.

  3. 3

    Average the two inventory figures

    Add the opening and closing balances and halve them: (55000 + 65000) / 2 = 60000.0. Using the closing 65000 alone would give 7.384615384615385 turns and the opening 55000 alone would give 8.727272727272727, so the average of 60000.0 is the fairer denominator.

  4. 4

    Divide cost of goods sold by average inventory

    480000 / 60000.0 = 8.0, so the shelf emptied eight times in the year. This ratio is dimensionless: the currency cancels, which is exactly why turnover is comparable across firms of very different size, provided the underlying definitions match.

  5. 5

    Convert to days and compare against history and sector

    365 / 8 = 45.625 days of inventory, or roughly forty-six days of stock on hand. Cost of goods sold per day is 480000 / 365 = 1315.0684931506848. Read 45.625 next to the same firm's prior years and to close competitors, never against an absolute benchmark, and check it beside stock-out records before calling a high figure good.

Examples

Example 1: Averaging opening and closing inventory

Opening inventory
55000
Closing inventory
65000
StepCalculationResult
Opening plus closing55000 + 65000120000
Divide by two to average(55000 + 65000) / 260000.0

Result: An average inventory of 60000.0. Using the closing 65000 alone would give 7.384615384615385 turns and the opening 55000 alone 8.727272727272727, so the two-point mean sits between them.

Example 2: Turnover from cost of goods sold and average inventory

Cost of goods sold
480000
Average inventory
60000.0
StepCalculationResult
Average inventory(55000 + 65000) / 260000.0
COGS divided by average inventory480000 / 600008.0

Result: An inventory turnover of 8.0, meaning the shelf emptied eight times during the year. The currency cancels, leaving a dimensionless ratio of 8.0.

Example 3: Turning the ratio into days of inventory

Days in the period
365
Inventory turnover
8.0
StepCalculationResult
Turns over the period480000 / 600008.0
Days divided by turnover365 / 845.625

Result: 45.625 days of inventory, the same fact as 8.0 turns expressed as time. Under a 360-day convention the identical ratio would read 45.0 days.

Calculator

Inventory turnover

8

Average inventory
60,000
Days of inventory
45.625
Cost of goods sold per day
1,315.0685

Values update as you type. This calculator covers the single scenario its formula assumes — see Common Mistakes for what it leaves out.

Prefer a full-width tool? Open the Inventory Turnover calculator page.

Common Mistakes

  • Dividing revenue by inventory instead of cost of goods sold

    Revenue contains the gross margin, so using it as the numerator inflates the ratio by exactly the margin factor. On revenue of 600000 against an average inventory of 60000.0 the result reads 10.0 turns, a quarter higher than the true 8.0 derived from cost of goods sold of 480000. Inventory is carried at cost on the balance sheet, so only a cost-based numerator keeps the two sides of the fraction in the same units.

  • Using the closing inventory figure on its own

    A single year-end snapshot reflects whatever stock happened to be on hand on one arbitrary day. Closing inventory of 65000 gives 480000 / 65000 = 7.384615384615385 turns, while the opening 55000 gives 8.727272727272727 — a range of more than a full turn driven purely by timing. Averaging to 60000.0 removes that artefact and describes the stock actually carried through the period.

  • Assuming a high turnover is always good

    The ratio rises whenever stock is thin, and thin stock causes stock-outs. A business turning stock 20 times a year holds only 18.25 days of inventory, so a demand spike becomes lost sales that never appear in the accounts. High turnover paired with flat or falling revenue usually points to understocking rather than efficiency, so read it next to service levels and stock-out records.

  • Comparing turnover across unrelated industries

    A supermarket turning stock twenty times and a furniture maker turning it twice can both be run well, because their operating models differ. An absolute benchmark ignores that a grocery holding 45.625 days of perishables faces a different problem from a jeweller holding the same forty-six days of slow-moving metal. Compare against your own history and close competitors, where the model is similar enough for the gap to be informative.

  • Mixing period lengths or averaging across a seasonal peak

    A ratio built from annual cost of goods sold is not comparable with one built from a quarter, and a two-point average can straddle a seasonal peak. A retailer running at 30000 in summer and 90000 in December may average 60000.0 across the year while holding 15 days in one month and 45 in another. State the period, average more frequently where demand swings, and never compare figures computed on different bases.

FAQ

What is a good inventory turnover ratio?

There is no universal figure. A supermarket may turn stock twenty times a year while a bespoke furniture maker turns it twice, and both can be healthy. The useful comparison is your own trend over time and the turnover of close competitors in the same sector. A ratio of 8.0 means the shelf emptied eight times in the period, or roughly every 45.625 days, but whether that is fast or slow depends entirely on the trade.

Should I use cost of goods sold or revenue in the numerator?

Use cost of goods sold. Revenue includes the gross margin, so dividing it by inventory measures customer payments rather than the cost of the stock. On revenue of 600000 against an average inventory of 60000.0 the ratio would read 10.0, a quarter above the true 8.0 obtained from cost of goods sold of 480000. Inventory sits at cost on the balance sheet, so a cost numerator keeps the two sides of the fraction in the same units.

How do I convert turnover into days of inventory?

Divide the number of days in the period by the turnover ratio. With 8.0 turns over a 365-day year, 365 / 8 = 45.625 days of inventory, meaning the business holds about forty-six days of stock at its current rate of sale. Some firms use a 360-day convention, which gives 45.0 days for the same ratio; the difference is convention, so pick one and apply it consistently.

Why use average inventory rather than the closing figure?

Because a single closing snapshot reflects one arbitrary day. Closing inventory of 65000 gives 7.384615384615385 turns and opening inventory of 55000 gives 8.727272727272727, a swing of more than a full turn from timing alone. Averaging the two to 60000.0 describes the stock the business actually carried through the period and removes that distortion from the denominator.

Can a high turnover be a warning sign?

Yes. Turnover rises whenever stock is thin, and thin stock causes stock-outs and lost sales that never show up as a cost in the accounts. A firm turning stock 20 times a year holds only 18.25 days of inventory, leaving little buffer against a demand spike. Read the ratio next to service levels and stock-out records before treating a high figure as a success.

References

  1. [1]Wikipedia, Inventory turnover — https://en.wikipedia.org/wiki/Inventory_turnover
  2. [2]Wikipedia, Cost of goods sold — https://en.wikipedia.org/wiki/Cost_of_goods_sold
  3. [3]Wikipedia, Economic order quantity — https://en.wikipedia.org/wiki/Economic_order_quantity