Inventory Turnover Calculator
Calculate Inventory Turnover Ratio and Days in Inventory from Cost of Goods Sold, Average Inventory and Period days—the same three inputs used by the live ZenBoxInfinity tool. Prepare COGS and inventory on a matching cost basis before you run the numbers.
What you get
Two outputs for one period: how many times average stock turned through at cost, and how many days that implies inventory sat before being sold—not a cash-release forecast or industry ranking.
What inventory turnover represents
Inventory turnover measures how many times the business sold and replaced its average inventory, valued at cost, during a defined period. Faster turns often mean less capital parked in stock; slower turns can signal overstock, weak demand or aging product—but context always matters.
Owners, finance, purchasing and warehouse teams use the ratio and days-in-inventory view together: one number is a frequency, the other is a time translation of the same relationship. Neither number alone proves that cash will be freed or that service levels are healthy.
What the live calculator measures
The live tool computes only:
- Inventory Turnover Ratio — COGS divided by Average Inventory;
- Days in Inventory — Period days divided by that turnover ratio.
It does not calculate SKU segmentation, service level, stockout rate, obsolete inventory, carrying cost or cash conversion cycle. Reset restores Period days to 365.
Live tool inputs
Cost of Goods Sold (COGS)
Cost of goods sold for the period—not revenue or sales at selling price. Must be greater than zero. Use the same period window you will enter under Period days.
Average Inventory
Average inventory value on a cost basis compatible with COGS for that same period. Must be greater than zero. Selling-price valuation will distort the ratio.
Period (days)
Length of the COGS period in days. Defaults to 365 for a full year; use about 90 for a quarter or about 30 for a month when COGS is for that shorter window. Must be greater than zero.
How to calculate Average Inventory
A common simple average is (Opening Inventory + Closing Inventory) ÷ 2. When demand or purchases are seasonal, monthly or more frequent averages usually represent the period better than a single opening/closing pair. Whatever method you choose, keep valuation at cost and aligned with how COGS is measured.
Confirmed formulas
Inventory Turnover Ratio = COGS ÷ Average Inventory
Days in Inventory = Period Days ÷ Inventory Turnover Ratio
Live validation: COGS > 0, Average Inventory > 0, Period days > 0. Both results display to two decimal places.
What the calculator returns
Inventory Turnover Ratio
How many times average inventory turned at cost in the period (for example 4.00×).
Days in Inventory
Implied average days stock sat before being sold, given the period length you entered (for example 91.25 days).
Hypothetical worked examples
Both examples are hypothetical illustrations of the live formulas—not targets or industry norms.
Example 1
COGS = 120,000; Average Inventory = 30,000; Period = 365 days.
- Turnover = 120,000 ÷ 30,000 = 4.00×
- Days in Inventory = 365 ÷ 4 = 91.25 days
Example 2
Opening Inventory = 34,000; Closing Inventory = 46,000 → Average Inventory = (34,000 + 46,000) ÷ 2 = 40,000. COGS = 480,000; Period = 365 days.
- Turnover = 480,000 ÷ 40,000 = 12.00×
- Days in Inventory = 365 ÷ 12 = 30.42 days
How to interpret results
- Rising turnover / falling days: Stock is moving faster relative to COGS—confirm fill rates and service before calling it a win.
- Falling turnover / rising days: More capital tied in inventory relative to cost of goods sold—investigate demand, mix, buying and aging.
- Unusually high turnover: May signal lean operations or insufficient stock, stockout risk and thin safety buffers—not automatically “good.”
- Unusually low turnover: May signal overstock, slow demand, poor mix or obsolete inventory—not automatically “bad” without seasonality and category context.
There is no universal “good” turnover benchmark on this page. Compare against your own history, budget and relevant peer set.
Inventory turnover and working capital
Lower days in inventory can free cash when the business truly carries less stock without damaging sales. A single calculator result does not guarantee cash release: payables, receivables, purchase timing and markdowns still shape the cash outcome. Read turnover alongside operational and cash reports—not as a stand-alone treasury decision.
Turnover versus related concepts
Days in Inventory / DIO
Time view of the same COGS–inventory relationship. This tool’s second output.
Reorder Point & Safety Stock
When to replenish and how much buffer to hold—operational triggers, not period turnover ratios.
Cash Conversion Cycle
Combines inventory days with receivable and payable timing. Not computed by this calculator.
Operational drivers
Turnover and days respond to purchasing volume, demand shifts, product mix, seasonality, obsolete and slow-moving stock, and supplier or replenishment policy. A blended company ratio can hide fast and slow categories—review mix when the headline number looks healthy but warehouse space and cash do not.
Limitations
- Results are only as reliable as COGS, average inventory and period alignment.
- Company-level figures can mask SKU or category problems.
- High turns do not prove availability; low turns do not prove poor purchasing without context.
- The tool does not value inventory, age stock or forecast cash.
Common mistakes
- Entering revenue instead of COGS.
- Mismatched periods between COGS and inventory.
- Using only closing inventory when a representative average is needed.
- Mixing cost and selling-price valuation.
- Treating higher turnover as automatically better.
- Ignoring SKU or category mix inside a blended ratio.
- Comparing unrelated industries as if one “good” number exists.
- Entering annual COGS with quarterly period days (or the reverse).
Practical review workflow
- Lock the period (year, quarter or month) and matching Period days.
- Pull COGS for that period from the P&L.
- Build Average Inventory at cost for the same window.
- Run the live calculator and record both outputs.
- Compare to prior periods and budget—not to a generic benchmark.
- Split by category or channel if the blended result looks odd.
- Link findings to purchasing, demand and aging actions; revisit after policy changes.
FAQ
What does the calculator compute?
Inventory Turnover Ratio = COGS ÷ Average Inventory, and Days in Inventory = Period Days ÷ Turnover, both to two decimals.
Why COGS instead of sales?
Turnover at cost stays consistent with inventory valued at cost. Sales dollars embed markup and distort comparability.
Must Average Inventory match the COGS period?
Yes. Same period and a cost basis compatible with COGS.
Is higher turnover always better?
No. Very high turns can mean stockouts or thin buffers; very low turns can mean overstock or aging—interpret with service and demand context.
What Period days should I use?
Match the COGS window: 365 for a year, about 90 for a quarter, about 30 for a month. Reset restores 365.
Does this tool calculate cash conversion cycle?
No. It only returns turnover ratio and days in inventory.
Where should I go for deeper analysis?
Use the inventory turnover analysis guide for a longer discussion, then return to the calculator with clean inputs.
Next step
Open the live calculator with matched COGS, average inventory and period days, then use the guide or analysis page when you need more interpretation—or the inventory system page for broader stock control context.
Reviewed by ZBI editorial
Inventory turnover for working capital control
Turnover links inventory investment to sales velocity. Warehouse and finance teams track it when carrying cost rises but service levels feel unchanged. Use cost of goods sold and average inventory at cost — retail value mixes can distort comparisons across channels.