Blog · Finance metrics and formulas · Supply chain
Inventory ratios connect stock balances with sales, cost of goods sold, and gross profit. Compare the measures on one category scorecard, reconcile the inputs, and choose the ratio that fits your decision.
Inventory ratios answer different questions about how much stock a business holds, how fast it moves, and what it earns. Turnover and days describe cost-based movement; inventory to sales relates stock to revenue; gross margin return relates inventory investment to gross profit. Choose the measure for the decision, then compare categories and sites on the same basis.
A purchasing manager deciding whether to reorder needs a different view from a finance manager deciding where cash is tied up. A single company ratio cannot settle both questions. The CFA Institute classifies turnover and inventory days as activity ratios and emphasizes examining several ratios together.
| Business question | Measure | Basis | What it does not prove |
|---|---|---|---|
| How much cost moved relative to stock held? | Inventory turnover | Period COGS / average inventory at cost | That every SKU was available |
| How much historical cost coverage did we hold? | Inventory days | Period days / period turnover | The exact age of physical units |
| How large is stock relative to revenue? | Inventory to sales | Closing inventory / period net sales | Future demand coverage at cost |
| What gross profit did stock investment support? | Gross margin return on inventory | Period gross profit / average inventory at cost | Net profit after operating expenses |
The detailed calculation belongs to the inventory turnover guide; its time-based counterpart is days inventory outstanding. The purpose here is to select and interpret the family without treating their outputs as interchangeable.
Use inventory snapshots with date, SKU, category, site, quantity, and carrying value. Use sales and cost exports with transaction date, SKU, site, net sales, and cost of goods sold. Keep returns, inventory adjustments, and stock status visible rather than letting them disappear into unexplained totals.
For this scorecard, average inventory is the opening and closing cost balance divided by two. Use more frequent dated balances when a seasonal build makes those endpoints unrepresentative. Closing inventory comes from the period-end snapshot; monthly sales come from the final month alone.
The IRS explanation of inventory valuation and cost of goods sold connects opening inventory, purchases, closing inventory, and the cost recognized on goods sold. It also explains that returns and allowances reduce gross sales. These relationships help identify which export columns belong together; your controller should confirm the company's reporting policies.
State the period beside every measure. A quarter's turnover is a quarterly figure. A ratio using one month's sales has a monthly denominator even when the rest of the scorecard covers a quarter.
Consider an illustrative US distributor for January 1 through March 31, 2026, a 90-day quarter. All inventory balances are at cost, and sales are net of returns. The first table supplies the inputs; the second calculates every scorecard result.
| Category | Opening inventory (USD) | Closing inventory (USD) | Quarter COGS (USD) | Quarter sales (USD) | March sales (USD) |
|---|---|---|---|---|---|
| Basics | 120,000 | 180,000 | 600,000 | 900,000 | 300,000 |
| Seasonal | 240,000 | 360,000 | 450,000 | 750,000 | 250,000 |
| Specialty | 90,000 | 210,000 | 150,000 | 300,000 | 100,000 |
| Total | 450,000 | 750,000 | 1,200,000 | 1,950,000 | 650,000 |
For each row, average inventory is (opening + closing) / 2; gross profit is quarter sales - quarter COGS. Turns use quarter COGS, days use 90 divided by unrounded turns, inventory to sales uses closing inventory divided by March sales, and gross margin return uses quarter gross profit divided by average inventory.
| Category | Average inventory (USD) | Gross profit (USD) | Quarter turns | Inventory days | Inventory / March sales | Quarter gross margin return |
|---|---|---|---|---|---|---|
| Basics | 150,000 | 300,000 | 4.00 | 22.5 | 0.60 | 2.00 |
| Seasonal | 300,000 | 300,000 | 1.50 | 60.0 | 1.44 | 1.00 |
| Specialty | 150,000 | 150,000 | 1.00 | 90.0 | 2.10 | 1.00 |
| Total | 600,000 | 750,000 | 2.00 | 45.0 | 1.15 | 1.25 |
Ratios are rounded to two decimals and days to one; calculations retain unrounded values. For example, the total sales-based ratio is 750,000 / 650,000 = 1.153846 before rounding.
Basics and Seasonal produce the same $300,000 of gross profit, but Seasonal holds twice the average inventory. Specialty has the slowest movement and the highest closing inventory relative to March sales. Those observations identify questions for buyers; they do not establish that Specialty is unnecessary or Seasonal is overstocked.
The company row must use summed inputs. Average inventory reconciles as (450,000 + 750,000) / 2 = 600,000. Gross profit reconciles as 1,950,000 - 1,200,000 = 750,000, matching the sum of category gross profit.
The total identities also run backward: 2.00 turns multiplied by $600,000 average inventory gives $1,200,000 COGS, and 1.25 gross margin return multiplied by the same balance gives $750,000 gross profit. Total inventory days are 90 / 2.00 = 45.0.
Never average category ratios to obtain company performance. The appropriate weighting changes with the denominator, as explained in count-weighted and value-weighted ratios.
For cash planning, investigate categories with substantial inventory value and slow turnover. For buying decisions, add open orders, supplier lead times, and evidence of unfilled demand. For profitability, ask whether sales required discounts that reduced gross profit.
The inventory-to-sales ratio page owns the sales-based calculation and its reciprocal. The return-on-inventory ratio page covers the return question in more detail. Neither measure should quietly replace a cost-based turnover measure in the same trend.
A public benchmark also needs its definition. The Federal Reserve's Census series notes describe inventory to sales as end-of-month inventory relative to monthly sales. That is a useful sales relationship, but margin differences prevent it from becoming a universal physical months-of-stock estimate.
Finance owns the definitions and ties the inputs to the ledger. Operations confirms stock status, and category managers explain replenishment and markdown choices. Each exception should end with an owner and a specific check, such as whether slow Specialty items remain essential service stock.
Bring inventory snapshots and sales and cost exports, including category and site columns, to Covirage. Covirage maps the columns, its tools compute and check the scorecard figures, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See Covirage for supply chain teams for the business context.
Start with the decision. Turnover helps compare movement against inventory investment; days make that relationship easier to discuss with buyers. Add inventory to sales for a revenue comparison and gross margin return when profitability matters. Keep availability measures beside the financial ratios.
Direction depends on the ratio. Higher turnover can indicate faster movement, while a higher inventory-to-sales ratio means more stock relative to sales. Neither proves better service or profit. Investigate stockouts, seasonal buying, and markdowns before assigning a favorable or unfavorable label.
Only with care. Product shelf life, purchasing lead times, gross margins, and accounting policies change the relationship between stock and sales. Compare similar categories and business formats first, using the same period and balance convention, before considering a broad industry reference.
Finance should own definitions and reconciliations, with operations confirming stock status and movements. Buyers or category managers explain purchasing and markdown decisions. Agree on who investigates each exception so the scorecard leads to a decision rather than another unexplained monthly number.