Retail Inventory Intelligence · India

From inventory data
to confident decisions

The intelligence hub for retail operators, category managers, and buying teams.

  • Benchmarks
  • Frameworks
  • Calculators
  • Retail Scenarios
  • Practical Inventory Thinking

Built for retail operators, category managers and business owners.

Try it now — GMROI Calculator
📊 GMROI Calculator Indian retail benchmarks
Fashion
CE
Durables
FMCG
Your GMROI
4
Free calculators live
4
Categories benchmarked
12+
Years retail experience
Ask ASP

What's your inventory challenge?

Select your situation — we'll route you to the right tool, benchmark, or resource.

My GMROI is low
Too much dead stock
Inventory ageing issue
Stock-outs happening
Buying decisions
Sell-through problem
Inventory turns too low

Free Toolkit

Retail Intelligence Calculators

Professional-grade formulas with Indian retail benchmarks. Select your category, enter your numbers, get an instant directional reading.

📊 GMROI Calculator
GMROI
Gross Margin ÷ Average Inventory Cost
🔄 Inventory Turns Calculator
Inventory Turns / Year
COGS ÷ Average Inventory
📉 Sell-Through Calculator
Sell-Through Rate
Units Sold ÷ Units Received × 100
⚠️ Dead Stock Exposure Calculator
Dead Stock Exposure
Dead Stock Value ÷ Total Inventory Value × 100

Coming to the toolkit

Stock CoverOTB EstimatorStore Health ScoreABC AnalysisSafety StockReorder PointMarkdown OptimiserAssortment ProductivityDemand PlanningCategory Health Scorecard

All calculator outputs are directional and for reference purposes only. Educational and informational content.

Want to discuss what your numbers mean? Discuss your inventory situation directly.

Start a Conversation →
Benchmark Library

Indian Retail Inventory Benchmarks

Reference ranges calibrated for Indian retail. Use these alongside your calculator results to understand where you stand.

MetricHealthy ✓Watch ⚠Risk ✗Notes

Numbers in the Watch or Risk range? Start a conversation — no agenda required.

Start a Conversation →
Retail Scenario Library

Inventory Problems — Structured and Analysed

Illustrative Retail Scenarios · Educational Use · Not based on real clients or engagements
Apparel Retailer

The Tail Stock Trap — Apparel Chain

Situation

GMROI at 1.2×. Tail SKU concentration at 42% of range. Three consecutive seasons of residual build-up.

Metrics revealed

Inventory turns at 2.1×. 38% of SKUs generating 4% of revenue. Working capital effectively frozen.

Considerations

Size-run depth review, tail clearance cadence, intake pause triggers by store.

Key lesson: GMROI below 1.5× in fashion is rarely a sales problem — it's almost always a buying depth problem compounding over seasons.
Consumer Electronics Retailer

The Obsolescence Trap — Electronics Retailer

Situation

₹14L exposure in handsets aged beyond warranty cycle. New-gen launches arrived while old-gen stock remained.

Metrics revealed

Days-on-hand 180+ for 22% of SKUs. GMROI 0.9× on aged segment. No tech-generation tracking in place.

Considerations

Tech-generation mapping, age-based reorder gates, vendor return clause activation.

Key lesson: In CE, the clock starts at product launch — not at purchase. Ageing thresholds must be tech-cycle relative, not calendar-fixed.
Consumer Durables Retailer

Network Concentration Risk — Durables Chain

Situation

60% of network profit from 2 stores. Remaining 10 stores showing negative GMROI while receiving uniform buying.

Metrics revealed

Network GMROI masked store-level distress. Two profitable stores were subsidising ten underperformers.

Considerations

Store-level OTB segmentation, format-appropriate range width, buying model by store tier.

Key lesson: Network averages hide the problem. Store-level GMROI should be the primary buying input — not the blended network figure.
Multi-Store Retail Network

The Allocation Paradox — Multi-Store Network

Situation

Overstock and stock-outs coexisting across the same network simultaneously. Centralised buying, no store-cluster differentiation.

Metrics revealed

Sell-through variance of 60 percentage points between top and bottom store quartile. Allocation model not adjusted for velocity differences.

Considerations

Cluster-based allocation, inter-store transfer triggers, velocity-adjusted OTB by store tier.

Key lesson: When sell-through variance is high across a network, the allocation model is almost always the root cause — not the product itself.
FMCG Retailer

Days-of-Cover Misread — Grocery Chain

Situation

Near-expiry exposure at 18% of ambient category value. National benchmark applied without adjusting for local market velocity.

Metrics revealed

Category turn rate 40% below benchmark. Cover at 22 weeks vs an 8-week category benchmark. Vendor replenishment not recalibrated.

Considerations

Localised cover targets, promo clearance calendar, vendor return clause review, category-level turn analysis.

Key lesson: Days-of-cover benchmarks must be localised. A national benchmark applied without local calibration is structurally wrong from day one.

Recognise your situation in one of these scenarios? Start a conversation.

Start a Conversation →
Inventory Audit Checklist

8 Questions Every Retailer Should Ask Monthly

A practical executive-level inventory review. If you cannot answer these questions quickly, there is usually hidden working capital, margin leakage, or availability risk somewhere in the business.

Where is capital trapped?

Which SKUs consume the most inventory value but contribute the least sales and margin?

What is ageing beyond target?

Measure inventory in 0–90, 90–180 and 180+ day buckets and identify action owners.

Who are the true winners?

Identify the top 20% of SKUs driving the majority of sales, margin and inventory productivity.

Where are stock-outs recurring?

Separate forecasting issues from replenishment, allocation and buying issues.

Which stores are overstocked?

Compare weeks of cover, turns and sell-through by location instead of network averages.

Is GMROI improving?

Track whether inventory investment is generating stronger gross margin returns over time.

What would you not buy again?

Review poor-performing SKUs and challenge repeat purchases before the next intake cycle.

What action happens this week?

Every audit should end with clear actions: liquidate, transfer, promote, reduce or invest.

Use these questions as a monthly inventory review agenda with your buying, merchandising and operations teams.

Discuss Your Inventory →
About
Amit Agarwala
Retail Inventory Intelligence
09amitagarwala90@gmail.com

I created ASP as a practical resource for retail operators, category managers, merchandisers and business owners looking to make better inventory decisions through benchmarks, frameworks and structured analysis.

The benchmarks, frameworks, calculators, and scenarios on this site are built on 12+ years of experience across inventory management, retail analytics, buying and planning, and multi-store operations in large-scale retail environments.

12+ Years Experience Global Retail Category Management Merchandising Buying & Planning Inventory Intelligence Retail Analytics Multi-Store Operations Retail Strategy
  • Reliance Retail — category management across one of India's largest retail networks
  • iDestiny — ₹175Cr category portfolio, buying and planning responsibility
  • Infosys — retail strategy consulting practice
  • 12+ years across global retail, category management, merchandising, buying, planning and inventory operations
  • Experience across large-format and multi-store retail operations
  • Connect on LinkedIn
Start a Conversation

Start a Conversation

Discuss inventory, merchandising, category management, buying, retail analytics, operational challenges, or retail strategy.

09amitagarwala90@gmail.com Connect on LinkedIn
  • Responded to within 24 hours
  • Inventory · Merchandising · Category Management
  • Buying · Retail Analytics · Retail Strategy
  • All conversations are confidential

Your details are used only to respond to your message. Not stored, not shared.