Most retailers measure inventory by what's sitting on the shelf. The harder question — what got pulled from the shelf because it wasn't there at all — almost never makes it to the dashboard. Stockouts feel ephemeral. A customer walks in, can't find what they want, and walks out without a digital footprint. But that lost sale is real, and over twelve months it adds up to a number worth knowing. Here's how to use the data you already collect to put a dollar figure on it.

Why Stockouts Are the Most Underestimated Cost in Retail

Inventory analytics tends to focus on what went wrong with the stock you bought: dead inventory, slow turns, markdown rates, carrying cost. Those metrics matter, but they're all about money already spent. Stockouts are the inverse — money you never had a chance to earn, and most retailers can't see it because their POS records what was sold, not what wasn't.

Industry research on retail stockouts has been remarkably consistent for two decades. Widely-cited grocery and retail studies have put average global out-of-stock rates near 8% at any given moment. More recent supply-chain studies during inventory volatility periods have seen that number climb past 10% for fast-moving categories. Translated into revenue: a small retailer running a 7% out-of-stock rate on its top-selling SKUs is typically leaving roughly 3-5% of total revenue on the table — even after accounting for customer substitution and willingness to wait.

For a $2 million retailer, that's $60,000-$100,000 a year. For a multi-location dispensary, the number can run higher because cannabis customers tend to brand-shop the menu next door rather than wait, and limited-license markets create allocation gaps that traditional retail never sees.

The fix isn't a heavier inventory cushion — that just creates dead stock. The fix is measuring what's actually happening so you can target the SKUs and time windows where stockouts are costing you the most.

The Three Components of Stockout Cost

Stockouts cost you in three ways, and most retailers only count the first.

1. The Direct Lost Sale

The customer wanted SKU A, didn't find it, and bought nothing. Direct revenue lost equals the product's average selling price times the number of times this happened during your stockout window.

The math is simple, but the data is hidden. Direct lost sales aren't in your POS — they're in the gap between expected demand and actual sales during the period when inventory was zero. To quantify them, you need a baseline: what does this SKU normally sell on a comparable day? Multiply that baseline by the hours or days the SKU was out of stock, and you have a defensible estimate.

2. The Substituted-Down Sale

The customer didn't leave, but they bought something else — usually cheaper or lower-margin. This is where retailers fool themselves into thinking stockouts don't matter. The receipt still rang. But if a $60 SKU was missing and the customer bought a $35 alternative, you traded margin for noise. Categorizing this requires basket-level analysis: when SKU A is out, what does the customer who came for it actually buy instead?

3. The Damaged-Trip Cost

The customer left without buying and is now slightly less likely to come back. Repeat-visit data across multiple retail studies shows that customers who experience two consecutive disappointing trips on items they wanted are noticeably less likely to return within 60 days than customers who got what they came for. That's a customer-acquisition cost you'll pay again to replace them — and most retailers never connect the dots.

How to Build a Stockout Cost Estimate From Existing Data

You don't need a new system. You need a structured pull from the data you already have.

Step 1: Identify your stockout windows. Your inventory system records when on-hand quantity hits zero for each SKU. Pull those zero-quantity intervals for the last 90 days. Filter to SKUs that account for the top 80% of revenue — your A and B items in classic ABC terms. Stockouts on tail SKUs matter less and add noise.

Step 2: Build the demand baseline. For each SKU in the stockout list, calculate the average daily units sold over the 30 days before the stockout, controlling for day-of-week. Tuesday demand is not Saturday demand, and a flat average will misread both. Most POS exports give you enough granularity to do this in a spreadsheet.

Step 3: Compute the lost-sale estimate. Multiply the daily baseline by the number of days (or fractional days) the SKU was out, then by the SKU's average selling price. That gives you a SKU-level lost-sale number. Sum across all stockouts in the period to get total estimated lost revenue.

Step 4: Apply a substitution discount. Not every lost sale walks out. Retail studies suggest 30-40% of would-be buyers substitute to another SKU in your store, depending on category. Cannabis flower has lower substitution (customers are often loyal to a specific strain or brand) — perhaps 20-30%. Apparel and convenience items have higher rates. Apply the right multiplier so you're not double-counting revenue you actually captured.

Step 5: Convert to margin impact. Multiply the net lost-sale figure by your gross margin percentage on that category. The headline revenue number gets attention, but margin is what the business actually keeps. That's the number that should drive how much you're willing to spend to fix the underlying issue.

Where Stockouts Concentrate — And Why It Matters

Once you've built the cost estimate, the next question is where stockouts cluster. They almost never spread evenly.

Three patterns show up over and over in retail data:

  • The 80/20 of stockouts. Roughly 20% of your SKUs generate 70-80% of stockout cost. These are usually fast movers with long lead times or unreliable vendors. Fixing reorder points on this short list captures most of the upside.
  • Day-of-week concentration. Stockouts cluster on the highest-demand days — typically Friday-Saturday for general retail, plus the day before any major holiday. If your reorder cadence is weekly and lands midweek, you're systematically running thin into your peak weekend.
  • End-of-month patterns. Vendor delivery delays, end-of-month cash management, and reorder hesitancy all push stockouts toward the back half of the month. If the second half of the month shows 30% more stockout cost than the first half, you have a purchasing-cadence problem, not a forecasting problem.

These patterns are visible in any POS export. Pivot stockout cost by SKU, by day-of-week, and by week-of-month, and the concentration will jump out — usually faster than the team expects.

Turning the Number Into a Plan

A stockout cost number is only useful if it changes a decision. Three places it almost always does:

Reorder points. A SKU that costs $4,000 a year in stockouts deserves a higher safety stock than one that costs $200 — even if their carrying cost looks identical. Stockout cost is the missing input that lets you price out the trade-off honestly. Without it, every reorder-point decision is gut-feel.

Vendor selection. When two vendors carry similar products, the one with shorter lead times and tighter fill rates is worth a small premium. Most retailers can't quantify that premium without a stockout cost estimate. Once you can, "their unit price is 4% higher but they cost us $0 in stockouts versus $6,000 last year" becomes a defensible comparison rather than a vibe.

Promotion timing. Running a promotion on a SKU that's chronically out of stock is paying to manufacture customer disappointment. A simple stockout overlay on your promo calendar prevents this — and most retailers discover at least one ongoing promotion they should pause when they look. The cost of that overlay is minimal; the upside is direct.

The Cannabis Wrinkle

Dispensaries face a sharper version of this problem for three reasons that don't apply to general retail:

  • Allocation-driven supply. In limited-license markets, vendor allocations cap what you can buy regardless of how much you'd like to order. That makes substitution analytics more important — knowing which brands customers will accept as alternates is a buying-strategy lever, not just a measurement exercise.
  • Strain and brand specificity. Cannabis customers often come in asking for a specific strain or brand by name. Substitution rates run lower than general retail, which means the direct-lost-sale component is a larger share of total stockout cost.
  • Menu-level transparency. Customers can see your live menu (and your competitor's) before they leave home. A stockout on a flagship SKU doesn't just lose that purchase — it can redirect the entire trip to a competitor that has it in stock today.

For dispensary operators, stockout cost analytics aren't a nice-to-have. They're a way to translate fuzzy "we ran out again" complaints into a number that justifies a buying-cadence change or a vendor renegotiation.

The Bottom Line

Stockouts are the most underestimated cost in retail because they don't show up on a P&L line. But the data to quantify them already exists in your POS and inventory system — you just have to ask different questions of it.

A few takeaways to act on:

  • Most retailers leak 3-5% of revenue to stockouts they can't see in their current reporting
  • About 20% of SKUs drive 70-80% of stockout cost — the fix is targeted, not blanket
  • Translate stockouts into margin dollars, not unit counts, so the number is comparable to other operational levers
  • Look for day-of-week and end-of-month concentration before assuming you have a forecasting problem

At Chapters Data, we help small and mid-sized retailers — including dispensaries — turn raw POS exports into the kind of operational analytics that surface lost-sale cost, vendor performance, and demand patterns the standard reports never show. If you've never seen a stockout cost estimate for your business, that gap is usually the first place we'd look.