129 stores are under-ranged and 95 are over-ranged compared to top performers in their archetype.
Top performers achieve Rs 806,546 per SKU vs Rs 441,782 for others - a 83% gap.
277 category-archetype combinations show high brand concentration risk, while 7 are fragmented.
5962 category-store combinations identified for range expansion based on top performer benchmarks.
Shows how stores are grouped. Larger segments = more stores of that type. Each archetype gets its own benchmark.
EXPAND = add more SKUs | MAINTAIN = on track | OPTIMIZE = reduce excess SKUs.
Stores grouped by archetype to reveal patterns within each store type. ● Top Performers | ● Other Stores | Larger bubbles = higher sales.
Stores classified by SKU range and productivity. High Range + High Productivity = ideal. High Range + Low Productivity = over-ranged, needs optimization.
View detailed insights including category gaps, benchmarks, and specific recommendations
View performance classification, sales attribution, quick wins, and strategic recommendations
Stores are segmented across 4 dimensions: Affluence Level, Store Size, Competition Intensity, and Category Focus - creating actionable archetypes.
Unlike fixed rules, thresholds are derived from actual data distribution using quantile-based segmentation.
Each archetype has its own benchmarks from top 25% performers within that segment.
Sales/SKU measures productivity - how much revenue each product generates. Higher is better. Compare bars to identify which archetypes are most efficient at converting range into sales.
Summary metrics for each archetype. Top Performers = stores in top 25% of sales within their archetype - these set the benchmark. Use Avg Sales/SKU to compare productivity across archetypes.
| Archetype | Stores | Avg Sales | Avg Sales/SKU | Avg Range | Top Performers |
|---|---|---|---|---|---|
| Flagship Premium (Competitive) | 40 | Rs 416,097,314 | Rs 574,797 | 672 | 10 |
| Flagship Premium (Competitive) (Atypical) | 10 | Rs 677,713,198 | Rs 762,312 | 814 | 3 |
| Large Format (Competitive) | 262 | Rs 374,907,226 | Rs 520,719 | 649 | 66 |
| Large Format (Competitive) (Atypical) | 5 | Rs 437,759,106 | Rs 509,474 | 660 | 2 |
Histogram showing how gaps are distributed. Green bars (right of 15%) = expansion opportunities. Red bars (left of -15%) = over-ranged stores. Center = well-aligned stores.
Compares average current range vs benchmark for each archetype. Large gaps between bars indicate systemic under/over-ranging.
These stores have the largest positive gaps - they carry significantly fewer SKUs than top performers in their archetype. Action: Prioritize adding SKUs in high-performing categories to capture missed sales potential.
| Store ID | City | Archetype | Current Range | Benchmark | Gap | Action |
|---|---|---|---|---|---|---|
| A506 | Surat | Large Format (Competitive) | 0 | 605 | +605 (+100%) | |
| A609 | Ludhiana | Flagship Premium (Competitive) | 251 | 630 | +379 (+63%) | |
| A059 | New Delhi | Large Format (Competitive) (Atypical) | 334 | 662 | +328 (+49%) | |
| A064 | New Delhi | Flagship Premium (Competitive) (Atypical) | 462 | 769 | +307 (+43%) | |
| A698 | Ambernath | Large Format (Competitive) (Atypical) | 356 | 662 | +306 (+46%) | |
| A406 | Ahmedabad | Flagship Premium (Competitive) (Atypical) | 464 | 769 | +305 (+43%) | |
| A612 | Agra | Large Format (Competitive) | 313 | 605 | +292 (+52%) | |
| A703 | Bangalore | Large Format (Competitive) | 321 | 605 | +284 (+51%) | |
| A513 | Indore | Large Format (Competitive) | 325 | 605 | +280 (+50%) | |
| A307 | Ahmedabad | Flagship Premium (Competitive) (Atypical) | 497 | 769 | +272 (+39%) |
These stores carry more SKUs than top performers in their archetype, which may dilute productivity. Action: Review slow-moving SKUs and consider delisting underperformers to improve sales per SKU.
| Store ID | City | Archetype | Current Range | Benchmark | Excess | Action |
|---|---|---|---|---|---|---|
| A207 | Bangalore | Large Format (Competitive) | 865 | 605 | -259 (-33%) | OPTIMIZE & REDUCE |
| A134 | Hyderabad | Large Format (Competitive) | 814 | 605 | -208 (-25%) | OPTIMIZE & REDUCE |
| A169 | Hyderabad | Flagship Premium (Competitive) | 803 | 630 | -173 (-20%) | OPTIMIZE & REDUCE |
| A029 | Hyderabad | Large Format (Competitive) | 767 | 605 | -161 (-18%) | OPTIMIZE & REDUCE |
| A028 | Hyderabad | Flagship Premium (Competitive) | 786 | 630 | -156 (-17%) | OPTIMIZE & REDUCE |
| A385 | Kolkata | Large Format (Competitive) | 702 | 605 | -96 (-8%) | OPTIMIZE & REDUCE |
| A660 | Mumbai | Large Format (Competitive) | 691 | 605 | -85 (-6%) | OPTIMIZE & REDUCE |
| A225 | Hosur | Large Format (Competitive) | 685 | 605 | -79 (-6%) | OPTIMIZE & REDUCE |
Top 10 categories by total sales across all stores. Longer bars = higher revenue contribution. Focus expansion efforts on high-revenue categories.
Categories with the highest % gap vs benchmark across stores. Higher % = more under-represented relative to potential.
Categories with the highest % excess SKUs vs benchmarks. Higher % = more over-ranged relative to current assortment.
Shows what % of sales each category contributes within each archetype. Darker cells = higher contribution. Use this to understand category importance by store type - Premium stores may skew toward different categories than Mass stores.
Distribution of portfolio health across all category-archetype combinations. Aim for more "Balanced" and fewer "High Concentration" segments.
| Category | Archetype | Brands | Top Brand | Top Brand Share | Top 3 Share | Status |
|---|---|---|---|---|---|---|
| Air Conditioners | Flagship Premium (Competitive) | 23 | Croma | 15.9% | 38.6% | FRAGMENTED |
| Air Purifier | Flagship Premium (Competitive) | 16 | Dyson | 73.7% | 94.9% | HIGH_CONCENTRATION |
| Apple Audio | Flagship Premium (Competitive) | 1 | Apple | 100.0% | 100.0% | HIGH_CONCENTRATION |
| BT Speakers | Flagship Premium (Competitive) | 27 | Marshall | 49.9% | 72.8% | |
| Batteries | Flagship Premium (Competitive) | 1 | Croma | 100.0% | 100.0% | HIGH_CONCENTRATION |
| Cleaning & Hygiene | Flagship Premium (Competitive) | 17 | Dyson | 57.5% | 92.0% | HIGH_CONCENTRATION |
| Computer Bags OEM | Flagship Premium (Competitive) | 5 | Lenovo | 41.1% | 88.6% | HIGH_CONCENTRATION |
| Computer Consignments | Flagship Premium (Competitive) | 1 | Canon | 100.0% | 100.0% | HIGH_CONCENTRATION |
| Connected Homes & Devices | Flagship Premium (Competitive) | 5 | Yale | 88.8% | 99.5% | HIGH_CONCENTRATION |
| Cookware | Flagship Premium (Competitive) | 20 | Faber | 47.4% | 91.6% | HIGH_CONCENTRATION |
| Cooling & Heating Appliances | Flagship Premium (Competitive) | 26 | Croma | 23.8% | 54.2% | |
| Croma Bags Plastic & Paper | Flagship Premium (Competitive) | 1 | Croma | 100.0% | 100.0% | HIGH_CONCENTRATION |
| DSLR Cameras | Flagship Premium (Competitive) | 4 | Nikon | 41.5% | 99.0% | HIGH_CONCENTRATION |
| Desktops | Flagship Premium (Competitive) | 5 | HP | 71.5% | 98.2% | HIGH_CONCENTRATION |
| Digital Cameras | Flagship Premium (Competitive) | 10 | Go Pro | 87.8% | 98.5% | HIGH_CONCENTRATION |
| Dishwashers | Flagship Premium (Competitive) | 10 | Bosch | 40.6% | 89.0% | HIGH_CONCENTRATION |
| Dryers | Flagship Premium (Competitive) | 7 | Bosch | 27.1% | 62.8% | |
| Dummies KA | Flagship Premium (Competitive) | 1 | Godrej | 100.0% | 100.0% | HIGH_CONCENTRATION |
| Dummy Laptop / Netbook / Tabs | Flagship Premium (Competitive) | 1 | Microsoft | 100.0% | 100.0% | HIGH_CONCENTRATION |
| Electric Sewing Machine | Flagship Premium (Competitive) | 1 | Usha | 100.0% | 100.0% | HIGH_CONCENTRATION |
Top 30 stores sorted by priority and gap size. Current = store's SKU count. Benchmark = top performer avg in same archetype. Gap = how many SKUs to add (+) or remove (-). Sales/SKU = current productivity.
| Store ID | City | Archetype | Current | Benchmark | Gap | Sales/SKU | Action | Priority | Rationale |
|---|---|---|---|---|---|---|---|---|---|
| A506 | Surat | Large Format (Competitive) | 0 | 605 | +605 | Rs 0 | DATA QUALITY REVIEW | Critical | Store has zero SKUs - verify data accuracy before planning |
| A059 | New Delhi | Large Format (Competitive) (Atypical) | 334 | 662 | +328 | Rs 0 | DATA QUALITY REVIEW | Critical | Store has SKUs but zero sales per SKU - investigate data quality |
| A009 | Navi Mumbai | Large Format (Competitive) | 1,163 | 605 | -557 | Rs 0 | DATA QUALITY REVIEW | Critical | Store has SKUs but zero sales per SKU - investigate data quality |
| A670 | New Delhi | Large Format (Competitive) | 413 | 605 | +192 | Rs 523,418 | High | Significantly under-ranged, productivity is strong | |
| A311 | New Delhi | Large Format (Competitive) | 431 | 605 | +174 | Rs 598,048 | High | Significantly under-ranged, productivity is strong | |
| A417 | New Delhi | Large Format (Competitive) | 443 | 605 | +162 | Rs 521,280 | High | Significantly under-ranged, productivity is strong | |
| A313 | New Delhi | Large Format (Competitive) | 459 | 605 | +146 | Rs 510,810 | High | Significantly under-ranged, productivity is strong | |
| A552 | Kanpur | Large Format (Competitive) | 464 | 605 | +141 | Rs 507,661 | High | Significantly under-ranged, productivity is strong | |
| A503 | New Delhi | Large Format (Competitive) | 469 | 605 | +136 | Rs 556,559 | High | Significantly under-ranged, productivity is strong | |
| A545 | New Delhi | Flagship Premium (Competitive) | 516 | 630 | +114 | Rs 599,545 | High | Significantly under-ranged (p=0.000), productivity is strong | |
| A532 | New Delhi | Large Format (Competitive) | 496 | 605 | +109 | Rs 529,271 | High | Significantly under-ranged, productivity is strong | |
| A555 | Noida | Flagship Premium (Competitive) | 523 | 630 | +107 | Rs 560,540 | High | Significantly under-ranged (p=0.000), productivity is strong | |
| A393 | Faridabad | Large Format (Competitive) | 500 | 605 | +105 | Rs 544,104 | High | Significantly under-ranged, productivity is strong | |
| A453 | Bhopal | Large Format (Competitive) | 517 | 605 | +88 | Rs 501,117 | High | Significantly under-ranged, productivity is strong | |
| A559 | Nagpur | Large Format (Competitive) | 521 | 605 | +84 | Rs 534,486 | High | Significantly under-ranged, productivity is strong | |
| A626 | Vadodara | Large Format (Competitive) | 530 | 605 | +75 | Rs 541,587 | High | Significantly under-ranged (p=0.000), productivity is strong | |
| A529 | Jabalpur | Large Format (Competitive) | 548 | 605 | +57 | Rs 529,455 | High | Significantly under-ranged (p=0.000), productivity is strong | |
| A162 | Mohali | Large Format (Competitive) | 550 | 605 | +55 | Rs 522,532 | High | Significantly under-ranged (p=0.000), productivity is strong | |
| A478 | Mumbai | Large Format (Competitive) | 552 | 605 | +53 | Rs 527,012 | High | Significantly under-ranged (p=0.000), productivity is strong | |
| A445 | Kalyan | Large Format (Competitive) | 556 | 605 | +49 | Rs 515,703 | High | Significantly under-ranged (p=0.000), productivity is strong | |
| A230 | Ahmedabad | Flagship Premium (Competitive) | 591 | 630 | +39 | Rs 590,890 | High | Significantly under-ranged (p=0.022), productivity is strong | |
| A194 | Pune | Large Format (Competitive) | 568 | 605 | +37 | Rs 506,825 | High | Significantly under-ranged (p=0.000), productivity is strong | |
| A567 | Indore | Large Format (Competitive) | 570 | 605 | +35 | Rs 628,975 | High | Significantly under-ranged (p=0.000), productivity is strong | |
| A022 | Ghaziabad | Large Format (Competitive) | 576 | 605 | +29 | Rs 559,141 | High | Significantly under-ranged (p=0.000), productivity is strong | |
| A382 | Chandigarh | Large Format (Competitive) | 586 | 605 | +19 | Rs 637,048 | High | Significantly under-ranged (p=0.000), productivity is strong | |
| A138 | Chennai | Large Format (Competitive) | 593 | 605 | +12 | Rs 513,403 | High | Significantly under-ranged (p=0.000), productivity is strong | |
| A240 | Gurugram | Large Format (Competitive) | 596 | 605 | +9 | Rs 679,292 | High | Significantly under-ranged (p=0.000), productivity is strong | |
| A318 | Kolkata | Large Format (Competitive) | 612 | 605 | -6 | Rs 523,148 | High | Significantly under-ranged (p=0.006), productivity is strong | |
| A328 | Ahmedabad | Large Format (Competitive) | 612 | 605 | -6 | Rs 537,494 | High | Significantly under-ranged (p=0.006), productivity is strong | |
| A359 | Kanpur | Large Format (Competitive) | 613 | 605 | -7 | Rs 626,394 | High | Significantly under-ranged (p=0.008), productivity is strong |
Specific category-store combinations requiring action. This tells you exactly which categories to expand or optimize in each store. Use this for tactical execution - share with merchandising teams for category-specific planning.
| Store ID | Category | Archetype | Current SKUs | Recommended | Gap | Action |
|---|---|---|---|---|---|---|
| A506 | Hearables | Large Format (Competitive) | 0 | 145 | +145 | |
| A260 | Hearables | Flagship Premium (Competitive) | 49 | 155 | +106 | |
| A609 | Hearables | Flagship Premium (Competitive) | 55 | 155 | +100 | |
| A490 | Hearables | Flagship Premium (Competitive) | 71 | 155 | +84 | |
| A698 | Smart Phones (OS Based) | Large Format (Competitive) (Atypical) | 15 | 121 | +106 | |
| A059 | Smart Phones (OS Based) | Large Format (Competitive) (Atypical) | 16 | 121 | +105 | |
| A697 | Hearables | Large Format (Competitive) | 63 | 145 | +82 | |
| A319 | Hearables | Large Format (Competitive) | 63 | 145 | +82 | |
| A572 | Hearables | Large Format (Competitive) | 64 | 145 | +81 | |
| A365 | Hearables | Large Format (Competitive) | 65 | 145 | +80 | |
| A431 | Hearables | Large Format (Competitive) | 66 | 145 | +79 | |
| A506 | Smart Phones (OS Based) | Large Format (Competitive) | 0 | 107 | +107 | |
| A595 | Hearables | Large Format (Competitive) | 67 | 145 | +78 | |
| A698 | Hearables | Large Format (Competitive) (Atypical) | 79 | 155 | +76 | |
| A703 | Hearables | Large Format (Competitive) | 68 | 145 | +77 | |
| A350 | Hearables | Large Format (Competitive) | 68 | 145 | +77 | |
| A685 | Hearables | Large Format (Competitive) | 68 | 145 | +77 | |
| A547 | Hearables | Large Format (Competitive) | 69 | 145 | +76 | |
| A585 | Hearables | Large Format (Competitive) | 70 | 145 | +75 | |
| A651 | Hearables | Large Format (Competitive) | 70 | 145 | +75 |
Gaps are tested for statistical significance using t-tests and bootstrap resampling. Only statistically significant gaps drive recommendations.
282 stores have statistically significant gaps (p < 0.05)
317 stores evaluated with confidence intervals
Recommendations are stress-tested through 200 Monte Carlo simulations to measure robustness and confidence.
71.2% average recommendation confidence across all stores
69 stores have ≥70% recommendation confidence
Stores ranked using TOPSIS (Technique for Order Preference by Similarity to Ideal Solution) considering financial impact, implementation ease, strategic importance, and risk.
| Rank | Store ID | City | TOPSIS Score | Action |
|---|---|---|---|---|
| #1 | A041 | Mumbai | 0.834 | REVIEW RANGE |
| #2 | A001 | Mumbai | 0.780 | REVIEW RANGE |
| #3 | A151 | Noida | 0.780 | REVIEW RANGE |
| #4 | A039 | Mumbai | 0.775 | REVIEW RANGE |
| #5 | A035 | Mumbai | 0.772 | REVIEW RANGE |
| #6 | A147 | Mumbai | 0.737 | REVIEW RANGE |
| #7 | A027 | Mumbai | 0.669 | REVIEW RANGE |
| #8 | A153 | Mumbai | 0.659 | REVIEW RANGE |
| #9 | A119 | Mumbai | 0.639 | REVIEW RANGE |
| #10 | A175 | Thane | 0.624 | REVIEW RANGE |
HHI measures market concentration. High concentration (>2500) suggests dominant brands, low (<1500) indicates healthy competition.
84 category-store combinations dominated by few brands
15 combinations with moderate brand diversity
5 combinations with healthy brand competition
Stress testing validates how stable recommendations are when benchmarks vary by ±10%. Stable recommendations remain consistent across parameter variations.
Based on multi-criteria analysis, these stores should be prioritized for implementation given limited resources. Ranked by urgency score combining gap size, sales potential, and strategic fit.
| Priority | Store ID | City | Urgency Score | Action |
|---|---|---|---|---|
| #1 | A041 | Mumbai | 1.67 | |
| #2 | A001 | Mumbai | 1.56 | |
| #3 | A151 | Noida | 1.56 | |
| #4 | A039 | Mumbai | 1.55 | |
| #5 | A035 | Mumbai | 1.54 | |
| #6 | A147 | Mumbai | 1.47 | |
| #7 | A027 | Mumbai | 1.34 | |
| #8 | A153 | Mumbai | 1.32 | |
| #9 | A119 | Mumbai | 1.28 | |
| #10 | A175 | Thane | 1.25 |