Buying moWhat should you buy, how much should you order, and when should you replenish? These are three critical purchasing decisions for a retail business. Ordering too much can tie up cash in slow-moving products; ordering too little can leave your bestsellers unavailable when customers want them.
Inventory KPIs turn stock and sales data into practical purchasing decisions for small retailers, ecommerce businesses, and distributors. Learn to calculate five core metrics—sell-through rate, ABC inventory analysis, unmet demand from stockouts, days of inventory coverage, and GMROI—and use them to prioritize products, time orders, and protect gross margin.
We use Harbor Home Supply, a fictional U.S. home-goods retailer, and consistent figures from our free Inventory KPI Excel template. The focus is not corporate sourcing performance: it is better buying decisions for a business that holds physical inventory. Explore our Metrics & KPIs hub for related guides.
On This Page
- What Are Inventory KPIs?
- Data You Need Before Calculating
- 1. Sell-Through Rate
- 2. ABC Inventory Analysis
- 3. Stockouts and Unmet Demand
- 4. Days of Inventory Coverage
- 5. GMROI
- Turn KPIs Into Purchasing Decisions
- Complementary Supplier and Purchasing KPIs
- Purchasing KPI Checklist by Role
- Common Calculation Mistakes
- Free Inventory KPI Excel Template
- Frequently Asked Questions
What Are Inventory KPIs?
Inventory key performance indicators (KPIs) show how effectively a business converts inventory into sales and gross margin while maintaining product availability. They are most useful when tied to a purchasing decision: which SKUs deserve priority, what quantity is justified, and when an order needs to arrive. They connect purchasing activity to actual demand, customer service, and cash tied up in stock.
| KPI | Question it answers | Main purchasing decision |
|---|---|---|
| Sell-through rate | What share of available units sold? | Reduce or increase future order quantities. |
| ABC inventory analysis | Which products generate the most sales revenue? | Prioritize attention and replenishment resources. |
| Unmet demand from stockouts | How much customer demand could we not fulfill? | Investigate shortages and service failures. |
| Days of inventory coverage | How long might the current stock last? | Time replenishment against supplier lead times. |
| GMROI | How much gross margin does average inventory generate? | Review assortment, pricing, and inventory investment. |
This is a retail and inventory management scorecard, not a complete set of corporate procurement KPIs. Supplier contract compliance, purchase-order processing, and sourcing savings are different measures. APQC similarly recommends balancing inventory, service, cost, and working-capital measures rather than relying on one number.
Data You Need Before Calculating Inventory KPIs
Start with one reporting period—such as a 30-day month—and record data for each SKU: beginning inventory, units received, units sold, ending inventory, selling price, unit cost, days out of stock, and unfilled customer-requested units when known. Use consistent product identifiers; see how to create SKU numbers if your business still relies on ambiguous product names.
First reconcile the quantity movement:
Expected ending inventory = Beginning inventory + Receipts − Units sold.
In our fictional example, Harbor Home Supply sells a compact coffee maker (SKU HOG-001). During a 30-day period, it begins with 80 units, receives 40, and sells 95. Expected ending stock is 80 + 40 − 95 = 25 units, which matches the counted closing stock.
This simple reconciliation assumes no returns, damaged stock, transfers, theft, or other inventory adjustments. Record those movements separately in your real inventory system; investigate any unexplained difference rather than trusting the calculated KPIs. The Excel template uses this simplified stock movement model.
1. Sell-Through Rate: How Much of Your Available Stock Sold?
Sell-through rate expresses the share of units available for sale that customers purchased in a defined period. For an inventory file that tracks beginning stock and receipts, use:
Sell-through (%) = Units sold ÷ (Beginning inventory + Units received) × 100.
For the compact coffee maker: 95 ÷ (80 + 40) × 100 = 79.17%. In other words, approximately four out of every five units made available during this period were sold.
You may encounter other sell-through definitions in retail platforms. Shopify’s reporting formula, for example, is units sold ÷ (units sold + ending inventory). When inventory movement reconciles without other adjustments, that is equivalent here: 95 ÷ (95 + 25) = 79.17%. The important requirement is to define the denominator and use the same method when comparing periods.
Dividing by opening inventory alone produces 95 ÷ 80 = 118.75%. That can happen when replenishments arrive during the month, so it should not be presented as the percentage of all available inventory sold. The companion workbook shows both calculations, with sell-through on available units as the more useful measure for this example.
What to do: a persistently low sell-through may justify smaller orders, better merchandising, or an assortment review. A high rate may support timely replenishment—but first check stockout days and gross margin. There is no universal cutoff that is appropriate for every category.
2. ABC Inventory Analysis: Prioritize Products by Revenue
ABC inventory analysis ranks products by their contribution to sales revenue. In a common approach, A items account for roughly the first 80% of cumulative revenue, B items for the next 15%, and C items for the remainder. These are adjustable management thresholds, not fixed economic laws.
Revenue per SKU = Units sold × Unit selling price. Then calculate SKU revenue share = SKU revenue ÷ Total revenue × 100, rank from highest to lowest revenue, and accumulate the shares.
Harbor Home Supply’s eight illustrative products generate $17,979.00 in total sales. The following ranking follows the original spreadsheet, which places the SKU crossing the 80% threshold in A and the SKU approaching the next 95% threshold in B:
| Product | Sales (USD) | Cumulative share | ABC |
|---|---|---|---|
| Compact coffee maker | $5,690.50 | 31.65% | A |
| 10-piece storage container set | $3,735.00 | 52.43% | A |
| Insulated stainless-steel bottle | $2,541.50 | 66.56% | A |
| Blender | $2,020.50 | 77.80% | A |
| Coffee filters (100-count) | $1,869.00 | 88.19% | A |
| Nonstick skillet | $1,221.50 | 94.99% | B |
| Drawer organizer | $566.20 | 98.14% | C |
| Digital kitchen scale | $334.80 | 100.00% | C |
How to use it: monitor A items more frequently because stockouts may affect a large share of sales; review B items for changes in demand; investigate whether low-revenue C items still serve a useful role. With only eight products, class sizes will be uneven. Another ABC convention can place products differently at a threshold—document your rule and apply it consistently.
Important: this workbook assigns ABC grades using sales revenue, not gross margin. A product can sell a lot and still earn little. Combine the classification with GMROI before reallocating purchasing dollars. Shopify’s ABC inventory guidance also describes revenue-based grading.
3. Stockouts and Unmet Demand: What Could You Not Sell?
A stockout occurs when a product is unavailable while customers still want it. The workbook focuses on the percentage of demand not fulfilled; this is not the same thing as the percentage of SKU-days that experienced a stockout.
Direct Method: When You Record Unfilled Units
If you log units requested but not fulfilled, calculate:
Unmet demand (%) = Unfilled units ÷ (Units sold + Unfilled units) × 100.
For the coffee maker, 95 units were sold and customers requested another 8 units that could not be supplied. 8 ÷ (95 + 8) × 100 = 7.77% of recorded demand was not fulfilled. The 8 units are recorded requests—not a claim that every disappointed customer would have completed a purchase.
Estimated Method: When Unfilled Units Are Unknown
When you have stockout-day records but no log of unfilled requests, estimate demand during days that stock was available:
In-stock days = Period days − Out-of-stock days.
Estimated daily demand = Units sold ÷ In-stock days.
Estimated unfilled units = Estimated daily demand × Out-of-stock days.
Estimated unmet demand (%) = Estimated unfilled units ÷ (Units sold + Estimated unfilled units) × 100.
Take coffee filters, another SKU from the same example: 210 units sold over a 30-day month, with 2 full days out of stock and no recorded unfilled units. Estimated daily demand is 210 ÷ 28 = 7.5 units; estimated unfilled units are 7.5 × 2 = 15; and estimated unmet demand is 15 ÷ (210 + 15) = 6.67%.
This is a scenario-based estimate, not an observed lost-sales count. It assumes demand on out-of-stock days resembles demand on in-stock days. Promotions, weekends, seasonal changes, substitutions, and partial-day outages can all make it inaccurate. If all days were out of stock, or the denominator is zero, report insufficient data rather than a valid percentage. In the workbook, enter 0 when you know no requests were unfilled; leave the input blank when the count was not collected, so the estimated method is used.
When shortages repeat, investigate supplier lead time, late or incomplete deliveries, reorder points, and inventory accuracy. Our Supplier Evaluation guide and OTIF delivery KPI guide provide complementary ways to assess supplier reliability.
4. Days of Inventory Coverage: When Might You Run Out?
Days of inventory coverage estimates how many more days current ending stock might satisfy demand at the recent sales pace. It is a forward-looking operating estimate, useful when deciding when to place a replenishment order.
Daily demand estimate = Units sold ÷ In-stock days.
Days of coverage = Ending inventory ÷ Daily demand estimate.
The coffee maker sold 95 units in 28 in-stock days, so estimated daily demand is 95 ÷ 28 = 3.39 units. With 25 ending units, coverage is 25 ÷ (95 ÷ 28) = 7.37 days.
Interpretation: if the supplier needs 10 days to deliver, the stock may not last until replenishment arrives. That lead time is an illustrative decision scenario, not a supplier commitment recorded in the workbook. Compare coverage with actual lead time, order-review frequency, and safety stock before ordering. A reorder point and a full purchase plan require more information than this coverage measure alone.
Do not confuse coverage using ending stock and units per day with the financial metric days sales of inventory (DSI), which often uses average inventory at cost divided by cost of goods sold over a longer period. They answer related but different questions. If daily sales are zero, there is no reliable pace for a finite coverage estimate; do not turn the division into a reassuring number.
5. GMROI: How Much Gross Margin Does Inventory Generate?
Gross margin return on inventory investment (GMROI) relates the gross margin earned during a period to the inventory investment held on average, measured at cost. Unlike sell-through, it reflects both selling performance and product economics.
Gross margin (USD) = Net sales − Cost of goods sold.
Average inventory at cost = (Beginning inventory units + Ending inventory units) ÷ 2 × Unit cost.
GMROI = Gross margin ÷ Average inventory at cost.
For the same coffee maker, the original worksheet contains these illustrative figures:
- Units sold: 95; selling price: $59.90; unit cost: $36.00.
- Sales: 95 × $59.90 = $5,690.50.
- Cost of goods sold: 95 × $36.00 = $3,420.00.
- Gross margin: $5,690.50 − $3,420.00 = $2,270.50.
- Average inventory: (80 + 25) ÷ 2 = 52.5 units, worth $1,890.00 at cost.
- GMROI: $2,270.50 ÷ $1,890.00 = 1.20.
A GMROI of 1.20 means the business generated approximately $1.20 in gross margin for every $1 of average inventory at cost during this reporting period. It does not mean a 120% net profit margin or guarantee overall profitability: rent, payroll, financing, shrinkage, and other expenses are not fully represented by this simplified calculation.
For real reporting, use net sales after relevant returns and discounts and an appropriate inventory cost basis. The workbook assumes a constant unit cost and approximates average inventory with opening and closing balances; additional stock snapshots can improve the average when inventory fluctuates. Compare GMROI over equal-length periods and similar categories. The Oracle retail inventory guide and Shopify’s GMROI guide describe the underlying financial relationship.
How to Turn Inventory KPIs Into Better Purchasing Decisions
Use the five indicators together to address what to buy, how much to order, and when to replenish. A high sell-through rate alone does not justify a bigger order: check stock availability, supplier lead time, gross margin, and the cash required for that order.
| Combination | Possible issue | Useful next action |
|---|---|---|
| High sell-through + low coverage | Replenishment may arrive after stock runs out. | When: compare coverage with supplier lead time and place orders before the likely stockout. |
| Low sell-through + high coverage | Potential overstock or slow-moving inventory. | How much: reduce or postpone planned quantities after checking demand and open orders. |
| ABC A item + significant unmet demand | A major sales contributor is frequently unavailable. | What and when: prioritize that SKU and investigate supplier delivery reliability. |
| High sell-through + weak GMROI | Strong movement may not generate enough gross margin. | What: review prices, costs, and assortment before committing more purchasing cash. |
| Low GMROI + high inventory value | Cash may be tied up without adequate gross return. | How much: reassess future orders and free cash where commercially reasonable. |
For Harbor Home Supply, the coffee maker’s 79.17% sell-through suggests strong movement, but its estimated 7.37 days of coverage would be insufficient against an illustrative 10-day supplier lead time. A buyer should review the next delivery date and reorder point, then check whether its 1.20 GMROI justifies the additional inventory investment. Coverage alone does not determine the correct order quantity. For the planning method, see How to Plan Inventory Purchases.
Purchasing decisions also affect liquidity. Our Working Capital guide explains why a business can report sales while still facing cash pressure from excess inventory.
Complementary Purchasing KPIs: When to Track Supplier Performance
Inventory KPIs reveal what is happening to your stock; supplier and purchasing KPIs help explain why replenishment may be late, incomplete, or more expensive. Once the five core inventory measures are reliable, consider the following indicators. They are not calculated in the companion Excel workbook.
- Supplier lead time: the elapsed time from a consistently defined purchase-order start point to goods receipt. Compare typical and variable lead times with days of inventory coverage to decide when to order.
- Supplier OTIF (on time, in full): the share of supplier orders that arrive both by the agreed date and in the ordered quantities. Define whether performance is measured by purchase order or order line. Repeated misses may explain shortages even when order quantities are reasonable.
- Supplier fill rate: the percentage of requested units that a supplier actually delivers within the defined measurement window. For a basic unit-based measure, compare units delivered with units ordered. Do not confuse this supplier-side measure with the customer-demand measure in the stockout section.
- Purchase price variance (PPV): the difference between the actual and standard purchase price, multiplied by units purchased. Under an (actual price − standard price) × quantity convention, a positive result means an unfavorable price increase. PPV does not capture freight, carrying cost, or supplier quality.
Do not add these metrics simply to create a longer dashboard. Measure supplier performance when stockouts or price changes persist, using the data your business can collect reliably. Review those results alongside the unmet-demand indicator to separate supplier problems from changes in customer demand.
Purchasing KPI Checklist: Who Should Review What?
A small business may have one person handling all three roles. The point is to connect each metric with an owner and an action, not to create unnecessary reporting.
- Owner or general manager: review ABC revenue concentration, gross margin, GMROI, and cash tied up in inventory; approve changes to assortment and purchasing budgets.
- Buyer or purchasing lead: review sell-through and stock coverage by SKU, compare coverage with lead times, investigate unmet demand, and adjust future orders when justified.
- Inventory or operations lead: verify receiving and stock counts, record out-of-stock days and unfilled requests, and resolve discrepancies before the team relies on the KPIs.
At the end of each reporting period, document a small set of decisions: SKU, finding, action, owner, and review date. This makes the numbers useful without adding another worksheet to a basic-intermediate template.
Common Inventory KPI Mistakes to Avoid
- Ignoring inventory receipts: opening-stock sell-through can exceed 100% when inventory is replenished midperiod. Use a consistently defined available-stock denominator.
- Skipping inventory reconciliation: missing adjustments, wrong SKUs, or incorrect physical counts can distort every downstream KPI.
- Calling all stockout measures the same thing: the percentage of unfulfilled demand is not the same as stockout days or stockout incidents.
- Mixing measured and estimated demand: record which method was used, especially when no one logs lost requests.
- Using revenue-based ABC as a profit ranking: revenue share and gross margin measure different outcomes.
- Comparing GMROI across unlike periods: a 30-day result and a full-year result are not directly comparable without adjustment.
- Using universal performance thresholds: product category, seasonality, margin structure, and replenishment frequency affect what is reasonable.
Free Inventory KPI Excel Template
The free Inventory KPI Excel template (US English) supports up to 20 SKUs per reporting period. Its seven worksheets cover instructions, a glossary, a shared data-entry sheet, and calculations for sell-through, ABC analysis, unmet demand, inventory coverage, and GMROI. It uses the same Harbor Home Supply examples and USD figures explained in this guide.
Enter product and inventory data in the designated blue input cells, check that stock movements reconcile, and review the KPI alerts before making purchasing decisions. The workbook contains the five core inventory metrics described here; supplementary supplier KPIs are not part of its calculations.
Frequently Asked Questions
Which inventory KPI should a small retailer track first?
Start with sell-through and days of coverage if your main problem is overstocking some products while running out of others. Add unmet demand when shortages affect customers, ABC to prioritize products, and GMROI to understand the gross return on inventory investment.
How often should inventory KPIs be updated?
Monitor coverage and stockouts frequently for fast-moving items; review sell-through, ABC, and GMROI at consistent weekly or monthly intervals as appropriate. Always compare similar timeframes and document the chosen calculation method.
What is the difference between sell-through and inventory turnover?
Sell-through compares units sold with units available for sale. Inventory turnover commonly divides cost of goods sold by average inventory at cost to estimate how frequently inventory is sold and replaced. Their inputs and interpretation are different.
Can I use these KPIs for a service business?
They are most directly applicable to physical products and supplies. A service company that holds parts or consumables can track those items, but pure labor-based services require different operational and financial measures.
Sources and Further Reading
Institute for Supply Management — Purchase Price Variance. PPV applications and limitations.
Shopify Help Center — Product Analytics Overview. Sell-through and remaining-inventory definitions.
Shopify Help Center — ABC Inventory Analysis. Revenue-based classification and purchasing implications.
APQC (September 2026) — How Can Inventory and Demand Planning Be Measured and Improved? Balanced inventory, service, and planning KPIs.
ASCM — The XYZs of Inventory Management. Inventory classification and management context.
Oracle — Retail Inventory Management. GMROI and inventory-management measures.
Shopify (July 2026) — GMROI Formula. Gross margin compared with average inventory at cost.
inFlow Inventory (June 2026) — Days Sales of Inventory. Difference between financial inventory-days measures and operational coverage.
APQC — How Do You Benchmark Procurement? Supplier lead time and on-time delivery as procurement performance measures.
ASCM SCOR — Reliability Metrics. Definitions for fill rate and delivery reliability.
Discover more from
Subscribe to get the latest posts sent to your email.
