+150 XP

Building a defensible ROI case for AI investment

A regional grocery chain in the US Midwest deployed an AI planogram compliance tool across 200 stores in 2023. Eighteen months later, finance asked a simple question: "show me the money." The vendor's pitch deck cited "40% better shelf insights." The CFO's response: "insights aren't dollars. Show me dollars."

That gap, between what AI vendors promise and what a controller will actually approve, is where most FMCG (fast-moving consumer goods) AI projects die after the pilot. This lesson builds the ROI model that survives that meeting.

What planogram compliance AI actually does

A planogram is the diagram specifying exactly where each product should sit on a shelf, how many facings it gets, and at what height. Compliance means the physical shelf matches that diagram.

AI tools here typically use computer vision: a store associate or robot (like those from Simbe Robotics) captures shelf images, and a model detects gaps, misplaced products, and incorrect facings by comparing the image against the planogram.

Legacy method: manual audits, a store manager walking aisles with a clipboard, maybe once a week, covering a fraction of SKUs (stock-keeping units, the unique identifier for each distinct product variant).

AI method: near-daily or even hourly image capture, covering most or all SKUs, with automated alerts routed to shelf-stocking staff.

Separating hard savings from soft claims

This is the core skill. Every AI business case contains both, and only one survives an audit.

Hard savings are traceable to a specific, measurable financial outcome with a clear before/after comparison and an owner accountable for the number.

Soft claims describe improved knowledge, visibility, or capability, without a direct line to cash.

ClaimTypeWhy
"Reduces out-of-stock rate from 8% to 5%"HardMeasurable, tied to lost sales recovery
"Better shelf insights for category managers"SoftNo defined metric or dollar path
"Cuts manual audit labor hours by 60%"HardDirect labor cost offset
"Improves brand-retailer collaboration"SoftReal, but not quantifiable without further assumptions
"Reduces planogram compliance violations by 15 points"Hard, *if* linked to a sales-per-violation estimateNeeds a second calculation to become dollars

The test: can you draw a straight line from the AI output to a line item in a P&L (profit and loss statement)? If yes, it's hard. If the line requires three more assumptions nobody's validated, it's soft, useful for strategy conversations, not for capital approval.

The hard-savings ROI model, worked example

Let's build the case for a 200-store chain, using conservative, clearly-labeled estimates.

Assumptions (flagged as illustrative estimates, not published benchmarks):

  • Average store revenue: $12 million/year (estimate, mid-size grocery format)
  • Out-of-stock (OOS) rate before AI: 8% (industry studies, e.g. from Gartner and academic retail research, commonly cite OOS rates in the 5-10% range across grocery, as of recent years, estimate)
  • Estimated lost sales from OOS: roughly 4% of revenue is a commonly cited industry rule-of-thumb impact (estimate, varies significantly by category)
  • AI tool reduces OOS rate by 30% relative (i.e., from 8% to ~5.6%)
  • Manual audit labor cost: 2 hours/store/week at $18/hour fully loaded

Step 1: Lost sales recovery

Store revenue: $12,000,000
Estimated OOS-driven sales loss: 4% = $480,000
Relative OOS reduction from AI: 30%
Recovered sales per store: $480,000 x 0.30 = $144,000

Recovered sales are not pure profit. Apply gross margin (grocery gross margins commonly cited around 25-28%, estimate):

$144,000 x 0.26 margin = $37,440 incremental profit per store/year

Across 200 stores: $7.49 million/year in hard savings from OOS reduction alone.

Step 2: Labor savings

2 hours/week x 52 weeks x $18/hour = $1,872/store/year

If AI cuts manual audit time by 60%: $1,123/store/year, or $225,000 across 200 stores.

Total hard savings estimate: roughly $7.7 million/year.

Step 3: Cost of the tool

Vision-based shelf monitoring platforms are typically priced per store per month; figures vary widely by vendor and scope (hardware, robotics, or camera-only). For illustration, assume $400/store/month.

$400 x 12 months x 200 stores = $960,000/year

Net hard-dollar ROI: ($7.7M - $0.96M) / $0.96M ≈ 700%

This looks extraordinary, which is exactly why an auditor will push back on every assumption. That's the point of the next section.

Where auditors and finance will attack the model

  1. The OOS-to-sales-loss link. Is 4% real for *this* chain, in *this* category mix? Fresh produce and center-store dry goods behave very differently. Ask for chain-specific baseline data, not industry averages.
  1. Attribution. Did sales improve because of the AI tool, or because of a concurrent promotion, seasonality, or a new store format? Insist on a control group: stores without the tool, matched for size and demographics, tracked over the same period.
  1. The relative reduction assumption (30%). This is usually the weakest input, often taken from a vendor case study, not your own pilot. Demand a controlled pilot before scaling.
  1. Margin leakage. Recovered sales rarely convert to profit at full gross margin. Some are cannibalized from other SKUs or capture rates are lower in practice.
  1. Hidden costs. Integration with existing POS (point of sale) and inventory systems, staff time to act on alerts, and change management are often excluded from vendor pricing.

A defensible model shows a range, not a single number: e.g., "$3.5M to $7.7M annual hard savings, pending pilot validation of the OOS reduction assumption." Ranges survive scrutiny; single confident numbers invite it.

Knowledge check

1. A CFO tells a vendor 'insights aren't dollars.' What underlying problem is the CFO pointing to in most AI pilot business cases?

2. Why is a claim like 'reduces out-of-stock rate from 8% to 5%' classified as a hard saving rather than a soft claim?

3. A regional grocery chain compares manual planogram audits (weekly, partial SKU coverage) to an AI-based system (near-daily, near-full SKU coverage). What is the most important business implication of this shift for building an ROI case?

MULTIPLE CHOICE

4. Select ALL correct answers about the distinction between hard savings and soft claims in an AI ROI case.

Select all the correct answers.

MULTIPLE CHOICE

5. Select ALL correct answers about why AI pilots for planogram compliance often fail to get funded beyond the pilot stage.

Select all the correct answers.

Building the pilot that de-risks the business case

Before committing to 200 stores, run a matched-pair pilot:

  • 20 "treatment" stores with the AI tool, 20 "control" stores without, matched on size, format, and region.
  • Minimum 12-week window to smooth out weekly noise and capture at least one promotional cycle.
  • Track: OOS rate (measured independently of the AI tool's own reporting, ideally via manual spot-checks or POS-derived stockout signals), labor hours spent on shelf audits, and sales lift in treatment vs. control.

This pilot converts the vendor's claimed 30% OOS reduction into your own validated number, which is the single most important input in the whole model.

A simple way to frame the pilot's core comparison:

python
# Simplified pilot comparison
treatment_oos_before = 0.08
treatment_oos_after = 0.055   # measured, not assumed
control_oos_before = 0.08
control_oos_after = 0.078     # natural drift, no AI

ai_attributable_reduction = (treatment_oos_before - treatment_oos_after) - \
                             (control_oos_before - control_oos_after)
print(f"AI-attributable OOS reduction: {ai_attributable_reduction:.3f}")

This isolates the AI's true effect from seasonal or operational noise, exactly what an auditor wants to see.

For a deeper primer on retail execution measurement, Category Management Association publishes practitioner-oriented resources on shelf compliance metrics.

🎬 [VIDEO: "How AI is Changing Retail Shelf Monitoring" - youtube.com/results?search_query=ai+retail+shelf+monitoring+planogram+compliance - search for recent vendor and analyst walkthroughs of computer vision shelf auditing in action, useful for seeing the technology before evaluating claims]

Key Takeaways

  • Separate every AI benefit claim into hard (traceable to a P&L line, measurable, owned) or soft (directional, useful for strategy, not for capital approval). Auditors only fund hard savings.
  • Build the ROI model with explicit, labeled assumptions (OOS rate, margin, relative improvement), and present a range, not a single confident figure.
  • Run a matched-pair pilot with a control group before scaling. It converts vendor-claimed performance into your own validated number, the single highest-leverage step in the whole business case.
  • Watch for the three classic model weaknesses: attribution (was it really the AI?), margin leakage (recovered sales aren't pure profit), and hidden integration and labor-response costs.
  • A credible AI business case in FMCG is not the most optimistic one, it's the one that survives a skeptical CFO asking "how do you know?" for every number on the slide.