Is inventory turnover calculated with sales or COGS?

Use cost of goods sold, not sales revenue. Revenue includes your profit margin, so it inflates the ratio and makes comparisons between products, plants, or time periods misleading. COGS and inventory are both stated at cost, so the ratio compares like with like.

What is a good inventory turnover ratio for manufacturing?

It depends on industry, production strategy, and margins, so benchmark against peers and your own trend rather than a universal number. Perishable food and CPG plants turn far faster than aerospace or custom machine shops. For scale, the U.S. Census Bureau's M3 survey shows U.S. manufacturers overall holding about a month and a half of shipments as inventory.

How do you convert inventory turnover to days?

Divide 365 by the turnover ratio. Six turns per year is 365 ÷ 6, roughly 61 days of inventory on hand. Days of inventory is often easier to act on than the ratio, because it reads directly as how long stock sits before it ships.

Is a higher inventory turnover always better?

No. Turns raised by cutting stock without shortening lead times or reducing variability show up later as stockouts, expedited freight, and missed ship dates. A very high ratio can also signal chronic shortages rather than efficiency. Judge turnover together with service level, never alone.

Why does my inventory turnover not match what I see on the floor?

Usually record accuracy. If the system carries phantom inventory, average inventory is overstated and turnover reads low, while the floor still hits stockouts the metric cannot explain. Fix cycle counting first; the ratio is only as honest as the records under it.

Inventory Turnover: The Formula and What 'Good' Looks Like

Q: What is average inventory in the turnover formula?

The inventory balance held over the same period as the COGS figure. The simple version is beginning inventory plus ending inventory, divided by two. If stock swings a lot during the year, average the twelve month-end balances so one flattering snapshot does not distort the ratio.

How to read the number finance loves, and how to improve it without starving the line.

Inventory turnover is how many times a plant sells through its stock in a year: cost of goods sold divided by average inventory. Divide 365 by your turns to get days of inventory on hand. Higher turns mean less cash sitting on shelves; what counts as good depends on the industry.

Turnover is one of the few numbers finance and operations both watch, and one of the easiest to misread, or to improve in ways that quietly damage the business. This post covers the formula, a worked example, what a defensible target looks like, and how to raise turns without wrecking your service level.

How do you calculate inventory turnover?

Inventory turnover equals cost of goods sold divided by average inventory, both measured over the same period. Use COGS, not revenue. Revenue includes your margin, so it inflates the ratio and makes comparisons across products, plants, or years meaningless. Both inputs come from books you already keep: COGS from the income statement, inventory from the balance sheet.

Average inventory matters because the balance moves. The simple version is beginning inventory plus ending inventory, divided by two. If stock swings hard within the year, average the twelve month-end balances instead. A single year-end snapshot taken right after a big shipment flatters the ratio, and everyone who has closed a fiscal year knows it.

Here is a fully hypothetical example. Say a plant runs $12 million in annual COGS and carries $2 million in average inventory. Turnover is $12M divided by $2M, or 6 turns per year. Days of inventory is 365 divided by 6, roughly 61 days. In plain terms, about two months of production is sitting in the building as raw material, WIP, or finished goods at any given moment.

The turnover formula with a hypothetical worked example: $12M COGS over $2M average inventory gives 6 turns per year, about 61 days of inventory on hand.

What is a good inventory turnover ratio?

There is no universal good number; benchmark against your own industry and your own trend. Perishable food and CPG plants turn far faster than aerospace suppliers or custom machine shops, because the product spoils or the retail order cycle forces the pace. A defense supplier holding certified alloys on six-month lead times can run 2 turns and be well managed. A dairy running 2 turns is out of business.

For national scale: the U.S. Census Bureau's M3 survey of manufacturers' shipments, inventories, and orders put the total inventories-to-shipments ratio for U.S. manufacturing at 1.47 in May 2026, roughly a month and a half of shipments held as inventory across the whole sector (U.S. Census Bureau, M3 survey). That is an average across wildly different businesses, not a target, but it is a useful sanity check on where you sit.

Three things set where your number should land. Industry, as above. Production strategy: a make-to-stock plant deliberately carries finished goods so it can ship same-day, while a make-to-order shop carries almost none, and its higher turns say nothing about discipline. And margin structure: a high-margin custom equipment builder can afford slow inventory that a thin-margin consumer goods plant cannot.

One scope note: turnover is normally measured on production inventory only. The MRO storeroom of spares, consumables, and tooling is stocked against failure risk rather than demand, and judging it by turns leads to bad decisions.

Why is inventory turnover really a cash question?

Because inventory is cash you cannot spend. Every dollar of stock left the bank as a material purchase or a labor cost and has not come back yet. It returns when the product ships and the customer pays. Turnover measures how fast that loop spins: at 6 turns, each dollar in the loop makes the round trip about every 61 days.

Inventory is cash caught mid-loop between the bank and the customer. Turnover measures how fast the loop spins.

This is why turns get attention whenever cash tightens. Slower turns mean more working capital financed by someone: a credit line, stretched payables, or capital that could have bought a machine.

What goes wrong when you chase turns blindly?

Cutting inventory without changing the system that requires it trades a visible cost for hidden ones. If lead times and demand variability stay the same and you cut stock anyway, the gap shows up as stockouts, missed ship dates, and expedite fees. Emergency freight and weekend overtime usually cost more than the carrying cost they replaced, and a lost customer costs more than both.

The pattern is predictable. A working-capital push triggers an across-the-board cut. Turnover looks great for a quarter. Then service slips, expedites climb, and planners quietly rebuild buffers, often bigger than before, because nobody trusts the system anymore. Safety stock exists for a reason; the goal is to size it deliberately, not delete it.

How do bad inventory records corrupt the metric?

Turnover is a ratio of two accounting numbers, so it is only as honest as the records underneath it. If the system says 400 units and the shelf holds 250, average inventory is overstated and turnover reads lower than reality, until the write-off lands, COGS spikes, and the ratio lurches the other way. Phantom inventory also causes real stockouts the metric never explains, because on paper the material was there. Before managing to turnover, fix record accuracy with disciplined cycle counting. Plants that skip this step are managing to fiction.

How do you improve inventory turnover without hurting service?

Work these steps in order. Each one either improves the data or removes a reason the inventory had to exist in the first place.

Clean up record accuracy first. Cycle count until location and quantity records are trustworthy. Every later step depends on believing the numbers.
Segment SKUs with ABC analysis. A small share of items carries most of the value. Give A items tight review and frequent orders; stop micromanaging C items that cost more to fuss over than to hold.
Right-size safety stock item by item. Set it from measured demand variability and actual lead time, not habit or fear. Most plants find some items carrying far too much and a few critical ones carrying too little.
Attack dead and slow stock. Anything with no movement in 12 to 24 months gets returned, reworked, sold, or scrapped. It pads average inventory and pays no rent.
Shorten replenishment and production lead times. Smaller, more frequent supplier deliveries and faster changeovers reduce the inventory the system genuinely needs, which is the honest way to raise turns. This is production planning work, not a storeroom project.
Put turnover on a cadence. Review turns, days of inventory, and service level together, monthly, by segment. Any turnover conversation that ignores service level is half a conversation.

Most of this depends on seeing inventory, WIP, and demand in one place, which is exactly what plants with data spread across an ERP, spreadsheets, and paper logs struggle to do. Harmony connects those existing systems into one operational layer, with no rip-and-replace, and its inventory and shortage intelligence watches inventory, WIP, and supply against live demand, flagging shortages before they hit the line. CLS used the same platform to replace paper-based production logging with real-time operational intelligence (case study).