Inventory
Turnover
Inventory earns its place when it supports profitable demand without trapping unnecessary cash.
Learn how to calculate inventory turnover, translate it into inventory days, distinguish healthy velocity from stockout-driven efficiency, and turn SKU-level evidence into purchasing decisions. The framework applies to DTC stores, marketplace sellers and multichannel ecommerce businesses.
Understand the ratio. Improve the decisions.
Inventory turnover is the cost of goods sold during a period divided by the average inventory investment supporting those sales. Operators often describe it as the number of times average stock is sold and replaced. It is an aggregate flow-to-stock ratio, not a count of replenishment orders or the actual age of each unit.
Turnover measures flow, not profitability
Turnover shows how much cost flows through inventory relative to the amount held. It does not measure cash receipts, customer demand that went unfulfilled, or the profit earned on those sales.
Use COGS and average inventory on the same basis
Use COGS and inventory at a compatible cost basis for the same period and business scope. A revenue-based ratio also reflects markup, making it unsuitable for direct comparison with the standard cost-based measure.
High and low turnover both need context
Low turnover may reflect overbuying or a deliberate seasonal build. High turnover may reflect strong demand or chronic understocking. Check availability, lead times, product lifecycle and comparable periods before judging either result.
Turnover should be measured by SKU and category
Calculate category and SKU ratios where data is reliable. A bestseller can mask hundreds of slow variants; channel totals can double-count shared stock unless inventory ownership and allocation are consistent.
Pair turnover with margin, availability and cash
Read turnover beside gross margin, contribution margin, aging, sell-through and stockouts. Prefer economically efficient inventory availability to a maximum-turnover target.
Inventory decisions are cash decisions. Buying less can release working capital, but buying too little can sacrifice profitable sales. The decision must balance the cost of holding stock with the cost of failing to serve demand.
COGS ÷ average inventory.
Match a flow over time with the stock that supported it: COGS for the selected period divided by average inventory at cost over that same period. Keep currency, ownership, locations, categories and valuation methods aligned. The example assumes merchandise COGS and owned merchandise inventory, with no material write-downs.
How much inventory supported $600,000 of COGS?
5.0x means $5 of annual COGS for each $1 of average inventory.
It does not mean each SKU sold out five times, that each purchase lasted 73 days, or that the business collected its cash five times. Using ending stock alone would give $600,000 ÷ $100,000 = 6.0x and overstate velocity in this example. Visual bars are decorative; the figures and formulas define the calculation.
Choose an average that represents the whole period.
Beginning plus ending inventory divided by two is a useful approximation when balances are reasonably stable. For volatile or seasonal stock, average daily balances, or use consistently sampled weekly or monthly balances; weight observations by elapsed time if intervals differ. Two quiet year-end dates can miss a large peak-season build. Use the same sampling method for comparisons. Revenue includes selling margin: $1,000,000 revenue ÷ $120,000 stock would be 8.33x despite unchanged physical inventory flow. Purchases are not COGS: buying stock increases an asset before the units are sold. Reconcile returns, transfers, landed costs and owned goods in transit to your accounting policy. Exclude consigned goods you do not own and avoid counting shared stock twice. Document the scope and cost method before comparing ratios . If reported COGS includes material write-downs or costs outside the inventory valuation base, reconcile the reported ratio to a clearly labeled operational measure. Do not silently remove aging stock to improve the number. With zero average inventory the ratio is undefined; with positive stock and zero COGS, turnover is zero and finite DIO cannot be calculated.
Five annual turns translate into 73 inventory days.
Inventory days, often called Days Inventory Outstanding (DIO), expresses the same relationship in time units. Use the actual number of days in the measurement period: DIO = average inventory ÷ period COGS × period days. For an annual 365-day period, this is 365 ÷ annual turnover.
From annual cost flow to inventory days
Follow the calculation, then separate this historical average from forward-looking stock cover. Rounded figures below are educational examples.
Choose the period
Use a complete 365-day reporting year for this example. A leap year or quarter requires its own day count.
Measure the cost flow
Use COGS recognized over that year, not purchase orders placed or retail sales value.
Average inventory
Average the inventory cost balances supporting the same year's COGS.
Calculate turnover
Divide $600,000 of COGS by $120,000 of average inventory.
Find daily COGS
Divide annual COGS by 365 to estimate average daily inventory consumption at cost.
Translate into days
Divide average inventory by daily COGS, or divide 365 by the annual turnover ratio.
Interpret with care
The ratio is a historical average holding-time proxy. It is not a promise about when any particular unit will sell.
Useful for comparing the inventory investment supporting a given cost flow.
Useful for discussing working capital in days with purchasing and finance.
$150,000 quarterly COGS ÷ $120,000 average inventory over a 90-day quarter.
90 ÷ 1.25 = 72. Using 365 with an unannualized quarterly ratio would be wrong.
Historical inventory days are not forward days of cover.
Forward cover uses current usable units and forecast demand; DIO uses historical COGS and average inventory value. A 73-day DIO can coexist with a bestseller stockout tomorrow. Neither is the cash conversion cycle: collection timing and supplier payment terms also matter. Cash conversion cycle is commonly DIO + receivable days − payable days. Do not treat a reduction in DIO as an immediate bank balance increase.
High and low turnover are signals, not verdicts.
Start with your own comparable history, then investigate demand, stock availability and purchasing. There is no universal good ratio across categories or business models. Perishability, margin, supplier lead times, minimum orders and the required service level change what is economically sensible.
Find why stock is not moving
Excess purchases, weakening demand, a poor assortment, obsolete products, optimistic forecasts, excessive safety stock and SKU proliferation can all reduce turnover. Separate a justified seasonal build or supply buffer from inventory that has no credible sales path.
The same $600,000 COGS requires more capital when average stock rises from $120,000 to $200,000. The extra $80,000 is an inventory investment, not automatically a loss. Investigate whether it protects enough profitable sales to justify financing, storage, handling and obsolescence risk.
Separate causes before cutting orders
Check whether demand is being served
Strong demand and dependable small replenishments can support high turnover. Under-ordering can also shrink average stock so sharply that the ratio rises while sales are lost. Observed sales understate demand when a product is unavailable; a forecast trained only on those sales can repeat the shortage.
Ten turns is neither a target nor proof of excellence. If key variants repeatedly stock out, compare in-stock days, order fill rate, cancellations and backorders. Estimate lost demand cautiously using comparable in-stock periods and record uncertainty rather than treating the estimate as booked revenue.
Protect economically valuable availability
A year-end snapshot can hide a seasonal peak
A seasonal merchant may build stock months before sales arrive, so turnover falls during the build and rises during the sell-down. Compare the same seasonal stage year over year and a rolling full year. Monthly or daily averages expose capital held between two unusually low year-end balances.
If daily records show $180,000 average stock, annual turnover is 3.33x and DIO is 109.5 days. The endpoint shortcut understated the inventory investment. Bulk-buy discounts, long lead times and minimum orders can create the same distortion. Evaluate total landed and holding costs, not only the supplier's unit-price saving.
Make purchasing assumptions explicit
Fast stock is not always the most profitable stock
Gross margin measures sales less COGS; contribution margin also deducts the defined sale-linked variable costs. Faster turns achieved through deep discounts can reduce total contribution. Dead stock consumes space and capital while creating markdown, disposal or write-down exposure.
With $100,000 average inventory each, A has $600,000 COGS and a 20% gross margin on sales: revenue is $750,000 and gross profit $150,000. B has $300,000 COGS and a 40% margin: revenue is $500,000 and gross profit $200,000. Gross margin return on inventory investment (GMROI = gross profit ÷ average inventory at cost) is 1.5x for A and 2.0x for B. B turns slower but earns more gross profit per inventory dollar; fulfillment and other variable costs may change the contribution ranking.
Evaluate liquidation against realistic alternatives
Four signals. One decision framework.
Combine demand, purchasing, availability and product economics. The next section converts those signals into a diagnosis with named decisions. The colored bars are illustrative design elements, not benchmark scores or calculated risk probabilities.
Find the inventory problem behind the ratio.
Build an exception report from inventory balances, item movement, receipts, stockout records and margin data. Rank issues by capital exposed and profitable demand at risk, then assign an owner. The figures below illustrate an operator's review, not a MarginLab inventory feature or a universal scoring model.
Illustrative review of 48 SKUs over a comparable annual period. No live store data or automated diagnosis is shown.
Twelve flagged SKUs represent 25% of the assortment but hold $84,000, or 35% of $240,000 ending stock. Use the concentration to prioritize investigation. Graphic fills are decorative and do not encode a score.
Owned merchandise across the included ecommerce channels and locations.
$720,000 annual COGS ÷ $240,000 average inventory; DIO is 121.7 days.
No sales for 180 days in this example; validate lifecycle and season before calling them dead stock.
Excess purchasing, hidden shortages and aging margin exposure.
Inventory Outgrows the Business
Revenue increased from $1.0m to $1.2m and COGS from $600,000 to $720,000, both +20%. Average inventory increased from $120,000 to $240,000, +100%. Turnover fell from 5.0x to 3.0x. Revenue growth did not justify the full increase in stock.
At the previous 5.0x, current COGS would require $144,000 average inventory. The $96,000 difference is a scenario for investigation, not guaranteed releasable cash. Purchasing should review open orders, supplier minimums and demand assumptions SKU by SKU before reducing commitments.
Fast Sellers Still Stock Out
One bestseller has $120,000 annual COGS and only $10,000 average stock: 12.0x turnover. It was unavailable for 30 of 365 days. Low stock inflates the efficiency impression while the business may lose profitable orders and incur rush freight.
Reconstruct demand from in-stock periods, assess abandoned or canceled orders and review lead-time variability. Reallocate stock from slow variants where appropriate and test the reorder point. Calendar availability is not a demand-weighted fill rate; track both when possible.
Cash Sits in Weak, Aging SKUs
The 12 flagged SKUs hold $84,000 of the $240,000 ending inventory, including $36,000 with no movement for 180 days. This is an aging policy trigger, not a universal definition of obsolete stock. Falling category margins increase the risk that recovery will require discounting.
Merchandising should check demand, product condition, listing quality, season and lifecycle. Finance should compare realistic recovery proceeds, incremental selling costs and holding exposure. Separate obsolete goods from healthy stock operationally while keeping the accounting reconciliation complete.
A useful diagnosis ends with a decision and an owner.
Purchasing owns excess commitments; operations owns availability and lead-time exceptions; merchandising owns weak assortment; finance reconciles valuation and cash effects. Record the affected SKUs, evidence, proposed action, expected tradeoffs and next review date.
Use physical counts and inventory records to validate the figures. Under IFRS, IAS 2 measures inventory at the lower of cost and net realisable value; other reporting frameworks may differ. Write-downs can change reported ratios without physical movement or cash recovery. See IAS 2 Inventories for that accounting basis.
Turn inventory evidence into eight operating decisions.
Use a recurring cross-functional review rather than a blanket instruction to buy less. Each step should produce a usable output: a reconciled baseline, a prioritized exception list, a purchasing change or a verified financial result.
An eight-step inventory improvement plan
Work from reliable measurement to targeted actions. The ownership and review timings below are operating examples; adapt them to your replenishment cycle and business scale.
Establish the baseline
Select a complete reporting period, reconcile COGS and owned inventory, and calculate turnover and DIO. Record the averaging frequency and valuation method. Keep a comparable prior period and rolling-year view so a seasonal purchase does not masquerade as deterioration.
Segment inventory by SKU and category
Calculate ratios for categories and material SKUs using the same cost basis. Group products by value, demand variability, lifecycle, lead time and service requirements. An ABC grouping can prioritize economic importance; demand variability adds context that sales value alone misses.
Identify slow-moving and dead stock
Create aging buckets suited to the category, plus last-sale dates, units sold and forecast depletion. A 90- or 180-day threshold is a policy trigger, not proof of obsolescence. Inspect condition, season, product lifecycle and return-to-supplier options before deciding recovery actions.
Identify stockout-driven false efficiency
Pair high turnover with availability, order fill rate, backorders, cancellations and urgent freight. Rebuild demand estimates where stockouts censored sales. A small increase in stock may be the right decision if it restores enough contribution to outweigh the added holding cost.
Review purchasing and reorder assumptions
Set reorder points from expected demand during replenishment lead time plus justified safety stock. Review the inventory position, not just on-hand units. Test supplier delays and demand variability; a single average lead time can hide frequent service failures.
Compare turnover with margin
Assess gross margin, contribution dollars and GMROI beside turnover. Separate a margin effect from a velocity effect: a clearance can make turnover rise while reducing profit. Define the contribution cost boundary consistently across channels, including relevant fulfillment, marketplace and payment costs.
Free trapped working capital
Select a disposition route for confirmed excess: supplier return, transfer, targeted bundle, markdown or disposal. Compare realistic net recovery with continued holding, and cancel avoidable future purchases before they arrive. Lower inventory is not automatically higher profit.
Monitor trends continuously
Review exceptions weekly and reconcile the full report at month-end. Compare the same season and a rolling year, and keep a decision log. Turnover improvements must persist without a hidden deterioration in availability, margin or supplier reliability.
Build a repeatable inventory review.
A useful plan changes purchase commitments, availability or stock recovery outcomes. Keep the calculation method stable, record decisions and compare realized results with the original assumptions.
Revenue grew. Inventory grew much faster.
A hypothetical multichannel homewares merchant has growing revenue but declining inventory efficiency. Compare three complete 365-day periods. The before-and-after cards show Year 2 and Year 3; Year 1 provides the earlier baseline. All averages use the same daily sampling and cost basis.
Invented but internally consistent figures for learning. This is not a real MarginLab customer, product demonstration or promised outcome.
Revenue increases by $80,000 while COGS increases by $48,000, also 6.7%.
Average inventory falls from $240,000 to $160,000. This is lower average capital employed, not an $80,000 cash-flow receipt.
Unrounded DIO falls from 121.6667 to 76.0417; the difference is 45.625 days.
The year-end slow-stock subset falls from $84,000 to $32,000. It overlaps the total stock reduction and must not be added to it.
What changed, and how the result was checked
The annual turnover result is supported by SKU actions and a purchase-to-inventory reconciliation. The example assumes no write-downs, shrinkage, acquisitions or other inventory adjustments.
Recover the earlier baseline
Year 1 revenue was $1,000,000, COGS $600,000 and average inventory $120,000: 5.0x turnover and 73 days. In Year 2, revenue and COGS rose 20%, while average stock doubled. Investigate the excess rather than celebrating sales growth alone.
Stock +100%; COGS +20%Change buying and assortment
Pause duplicate slow variants, renegotiate minimum orders and use smaller receipts for uncertain demand. Keep safety buffers for profitable core products. Review the $36,000 no-movement subset before choosing supplier returns, bundles or targeted clearance.
SKU-level decisionsProtect service and margins
Year 3 gross profit is $1,280,000 − $768,000 = $512,000, versus $480,000 in Year 2: both 40% gross margin. An illustrative order fill rate improves from 94% to 96%. Check contribution after all relevant variable costs as well; gross margin alone cannot establish the final profit improvement.
Margin and service guardrailsReconcile the stock movement
Year 3 beginning inventory is $240,000 and ending inventory $120,000. With $768,000 COGS and no other adjustments, purchases at inventory cost are $648,000: $240,000 + $648,000 − $768,000 = $120,000. Daily average stock is $160,000; it need not equal the $180,000 endpoint average.
Purchases $648,000Separate working capital from cash
The $120,000 ending-balance reduction means purchases were $120,000 below COGS. It reduces inventory working capital in this simplified reconciliation. Actual supplier cash payments also depend on payables and deposits, while customer collections, selling costs and timing affect the bank balance.
Verify the cash-flow bridgeImprovement is more than a better turnover number.
The business supports higher revenue with less average stock and fewer slow-moving goods, while monitoring availability and gross margin. It does not need to exceed the old 5.0x ratio to show progress. The operating lesson is to change the inventory that lacks a credible demand path while protecting the products customers actually want. Decorative comparison bars do not represent a scored assessment.
Can you trust the inventory decision?
Use these 18 checks as an audit, not a performance score. For every missing answer, record an owner, supporting evidence and a review date. A high turnover ratio cannot compensate for unreliable stock records or recurring service failures.
Calculation integrity
COGS is the numerator
We use period COGS, not revenue or purchases, and document material adjustments.
Periods and scope match
COGS and average inventory cover the same dates, currency, ownership and locations.
The average is representative
We use a stated sampling method and check whether endpoints miss seasonal peaks.
Useful segmentation
Category turnover is reviewed
We calculate category COGS divided by category average inventory rather than averaging ratios.
Material SKUs are reviewed
We identify weak variants hidden by bestsellers and avoid double-counting shared channel stock.
Seasonal and new products are separate
Comparisons reflect lifecycle, selling windows, lead times and comparable seasonal stages.
Aging and physical stock
Slow-moving products are identified
Aging, last-sale dates and demand forecasts identify inventory needing an action plan.
Obsolete stock is separated
Unsaleable units are tracked distinctly without disappearing from the financial reconciliation.
Records match reality
Counts, returns, damaged goods, transfers and owned stock in transit reconcile to inventory records.
Availability and replenishment
Stockouts are monitored
SKU availability, fill rate and cancellations are reviewed alongside high turnover.
Demand estimates reflect shortages
We flag periods where unavailability suppressed observed sales instead of treating them as normal demand.
Purchase quantities are challenged
Minimum orders, open commitments, reorder points and safety-stock assumptions have named owners.
Economics and cash
Margin is considered before clearance
Discounts, fees, fulfillment and expected recovery proceeds inform disposition decisions.
Turnover is paired with profitability
Gross margin, contribution dollars and GMROI are checked before favoring faster-moving products.
Working capital is not confused with profit
Average inventory, ending inventory movement and supplier cash payments are reconciled separately.
Controls and follow-through
Cost assumptions are current
Inventory and COGS use compatible methods; write-downs and cost changes are explained.
Actions have owners and dates
Aging stock, service failures and purchase exceptions have evidence-backed next steps.
Outcomes are monitored
We track comparable turnover, DIO, availability and margin after changes and reverse harmful cuts.
Four answers should support every inventory action.
What is the demand evidence? What stock is economically necessary? What cash and margin effects are expected? Who will verify the result? Missing evidence should trigger investigation before a blanket inventory reduction.
Reconcile the data
Confirm scope, valuation and the averaging method before trusting the ratio.
Check demand and economics
Test service, recovery value and contribution impact before reducing purchases or prices.
Verify the outcome
Compare actual inventory, margin and availability with the assumptions behind each decision.
Six questions that improve inventory decisions.
These answers clarify the calculation, the limits of benchmarks and the practical choices behind inventory efficiency. Use the detailed sections above when setting reporting and purchasing rules.
01 Metric fundamentals What is inventory turnover? +
Inventory turnover measures period COGS relative to average inventory at cost. It is commonly described as how often average inventory is sold and replaced during the period. A ratio of 5.0x means annual COGS equals five times the average stock investment.
It is not a count of supplier orders, the physical age of every unit or a profit measure. Fast sellers and dead stock can coexist behind one aggregate ratio, so examine categories and material SKUs.
Use it across DTC, marketplaces and multichannel operations with a consistent ownership and location boundary. Avoid double-counting the same shared stock across channels.
Calculate inventory days →02 Calculation What is the inventory turnover formula? +
Use the standard cost-based relationship:
With annual COGS of $600,000 and average stock of $120,000, turnover is 5.0x. A simple beginning-and-ending estimate is:
Average Inventory = (Beginning Inventory + Ending Inventory) ÷ 2 . Here, ($140,000 + $100,000) ÷ 2 = $120,000. Daily or consistently sampled periodic balances are more representative when stock is volatile. Revenue mixes selling price with inventory cost and can change the ratio simply because markup changes.
Review the worked formula →03 Benchmarks and context What is a good inventory turnover ratio for ecommerce? +
There is no universal good number. Category, business model, product life, gross margin, supplier lead time, seasonality and availability requirements determine the stock investment that makes economic sense.
Compare your own like-for-like trend first. External comparisons are useful only when the period, cost basis, inventory scope and business model are genuinely comparable. A deliberate buffer for a long-lead core product may be more profitable than a higher ratio with lost sales.
Set a category-specific operating range and check it against availability and margin. A rising ratio is useful when it reflects less unnecessary capital without unacceptable shortages, emergency freight or loss of contribution.
Review turnover signals and risks →Three questions answered. Three to apply.
Continue with high turnover, inventory days and a practical improvement approach.
04 Availability Is higher inventory turnover always better? +
No. Higher turnover can result from stronger demand and efficient replenishment, but also from under-ordering and persistent stockouts. If average inventory shrinks faster than COGS falls, the ratio can improve while profitable sales are lost.
Review turnover + availability + margin together
A SKU with $120,000 annual COGS and $10,000 average inventory turns 12 times. That looks fast, but 30 unavailable days would require a separate service investigation. The ratio does not reveal unfulfilled demand.
Increasing safety stock for a profitable, unreliable-supply SKU may reduce turnover while improving the business. Judge the added inventory cost against the expected contribution protected, not a maximum-turnover target.
Review safety-stock assumptions →05 Time interpretation What is the difference between inventory turnover and inventory days? +
Turnover expresses period cost flow as a multiple of average stock. DIO expresses the same relationship in days when the scope and averaging method match:
Inventory Days = Period Days ÷ Period Turnover
At 5.0 annual turns, a 365-day year produces 73 days. A 90-day quarter with 1.25 turns produces 72 days; do not divide 365 by a quarterly ratio unless you first annualize consistently.
DIO is a historical holding-time proxy, not actual SKU age, forward stock cover or the full cash conversion cycle. For purchasing, compare usable units with forecast demand and lead time. Formula reference: Intuit's DIO explanation.
Use the DIO Calculator →06 Performance monitoring How can an ecommerce business improve inventory turnover? +
First verify the calculation and identify which SKUs account for unnecessary inventory. Then reduce unjustified purchase commitments, improve forecasts, rationalize duplicate variants and create recovery plans for aging stock. Protect core availability while testing changes.
Use targeted clearance only after comparing recovery proceeds and incremental selling costs with realistic future demand and holding costs. A write-down alone does not free cash or move units. Smaller receipts may help but can raise freight and ordering costs.
Monitor comparable turnover, DIO, aging, sell-through, stockout frequency, forecast bias and supplier lead-time reliability. Give each change an owner and review date; judge success by the combined capital, service and profit outcome.
Follow the eight-step action plan →All six inventory turnover questions answered.
You can now calculate turnover, interpret inventory days, challenge misleading efficiency and connect purchasing with availability, working capital and profitability.
Connect stock efficiency with product economics.
Inventory turnover explains the capital supporting sales. Continue with Lesson 17 — Dead Stock to see what happens when inventory stops converting into demand, then use the published lessons below to connect cost measurement, product profitability and the wider business result.
Product Profitability Analysis
Evaluate which products create economic value after their relevant costs. Pair the product result with inventory investment before deciding which SKUs deserve more capital.
Cost of Goods Sold
Review how product costs support profitability measurement. This published lesson uses Shopify examples; apply its cost concepts within your own accounting and inventory setup.
Contribution Margin
Connect product revenue with sale-linked variable costs. Use contribution dollars alongside turnover when evaluating discounts, channels and inventory recovery choices.
Keep capital, availability and profit in view. Make each inventory decision measurable.
Use inventory and accounting records to monitor turnover, aging, purchasing and service. Then connect the findings with product profitability. Explore MarginLab's published features to understand its current scope before deciding how it fits your review process.