Total Revenue
₹4.10M
▲ 23.6% vs LY
Gross Profit
₹790K
▲ 25.1% vs LY
Gross Margin
19.3%
▲ 0.9% vs LY
Total Orders
5,000
▲ 20.2% vs LY
Units Sold
14,393
▲ 18.7% vs LY
Customers
1,000
▲ 15.3% vs LY
Revenue & Profit Trend (Monthly)
Revenue by Category
Top 10 Products by Revenue
Revenue by Region (State)
LowHigh
Sales vs Target (Monthly)
Actual
₹4.10M
Target
₹3.82M
Achievement
107.3%
Top 10 Products by Profit
Total Stores
10
Across 5 cities
Best Store Revenue
₹510.9K
▲ Whitefield
Avg Store Margin
19.3%
Stable across stores
Top City
Bengaluru
₹1.89M revenue
Revenue by Store
Profit Margin by Store (%)
Revenue & Profit by City
Store Performance Summary
| # | Store | Revenue | Profit | Orders | Margin |
|---|---|---|---|---|---|
| 1 | Whitefield | ₹510.9K | ₹98.8K | 617 | 19.3% |
| 2 | Indiranagar | ₹463.6K | ₹89.1K | 590 | 19.2% |
| 3 | Jayanagar | ₹460.1K | ₹88.1K | 548 | 19.1% |
| 4 | Electronic City | ₹453.7K | ₹86.2K | 527 | 19.0% |
| 5 | T Nagar | ₹445.4K | ₹87.7K | 520 | 19.7% |
| 6 | Anna Nagar | ₹389.4K | ₹76.4K | 486 | 19.6% |
| 7 | Banjara Hills | ₹384.1K | ₹76.3K | 487 | 19.9% |
| 8 | Gachibowli | ₹372.3K | ₹72.2K | 483 | 19.4% |
| 9 | Mysuru Central | ₹313.5K | ₹55.7K | 372 | 17.8% |
| 10 | RS Puram | ₹303.2K | ₹60.4K | 370 | 19.9% |
Total SKUs
5,000
Across 10 stores
Stock-Out Risk
530
▲ 10.6% of SKUs
Overstock Items
1,672
33.4% of SKUs
Total Stock Value
₹91.8M
At cost price
Inventory Stock Value by Category
Inventory Status Overview
5,000
SKUs
Healthy 2,798 (56%)
Stock-Out 530 (10.6%)
Overstock 1,672 (33.4%)
🚨 Stock-Out Risk — Reorder Alerts
| Product | Store | Stock | Reorder Lvl | Status |
|---|---|---|---|---|
| UrbanMart Soft Drink 2pk | Electronic City | 0 | 40 | OUT |
| ValueKart Freshener 1kg | Electronic City | 0 | 28 | OUT |
| HomePlus Chips 100g | Electronic City | 0 | 30 | OUT |
| ValueKart Namkeen 100g | Indiranagar | 0 | 30 | OUT |
| PrimeChoice Chips 500g | Electronic City | 0 | 30 | OUT |
| NatureWay Biscuits 250g | Electronic City | 0 | 30 | OUT |
| FreshNest Dal 2L | Electronic City | 0 | 45 | OUT |
| NatureWay Body Lotion 2L | Mysuru Central | 0 | 25 | OUT |
📦 Top Overstock Items
| Product | Store | Stock | Reorder Lvl | Stock Value |
|---|---|---|---|---|
| DailyPure Pasta 500g | Indiranagar | 274 | 45 | ₹56.8K |
| QuickBite Sugar 1L | Whitefield | 255 | 45 | ₹88.6K |
| HomePlus Coffee 2pk | T Nagar | 247 | 40 | ₹47.4K |
| FarmFresh Coffee 100g | Jayanagar | 242 | 40 | ₹104.0K |
| DailyPure Tea 1kg | Gachibowli | 239 | 40 | ₹45.7K |
| PrimeChoice Ghee 500g | Anna Nagar | 230 | 40 | ₹82.3K |
| UrbanMart Juice 1L | Banjara Hills | 225 | 38 | ₹38.6K |
| CareMore Shampoo 300ml | RS Puram | 218 | 35 | ₹55.1K |
Total Products
500+
Across 7 categories
Top Category Rev.
Snacks
₹773K revenue
Best Margin Cat.
Dairy
19.8% margin
Top Product
DailyPure Cheese
₹30.2K revenue
Revenue by Category
Profit Margin by Category
Top 10 Products by Revenue
| # | Product | Category | Revenue | Margin |
|---|---|---|---|---|
| 1 | DailyPure Cheese 2pk | Dairy | ₹30.2K | 23.6% |
| 2 | CareMore Yogurt 100g | Dairy | ₹30.2K | 22.6% |
| 3 | UrbanMart Frozen Corn | Frozen Foods | ₹26.4K | 22.6% |
| 4 | QuickBite Shampoo 200g | Personal Care | ₹25.5K | 27.8% |
| 5 | PrimeChoice Pasta 100g | Grocery | ₹25.2K | 21.6% |
| 6 | QuickBite Yogurt 200g | Dairy | ₹25.0K | 20.2% |
| 7 | CareMore Popcorn 200g | Snacks | ₹24.4K | 12.5% |
| 8 | CareMore Tissue 200g | Household | ₹24.1K | 27.9% |
| 9 | QuickBite Wheat Flour | Grocery | ₹24.1K | 21.4% |
| 10 | FreshNest Ice Cream | Frozen Foods | ₹23.9K | 9.3% |
Bottom 5 Products by Revenue
| # | Product | Category | Revenue | Margin |
|---|---|---|---|---|
| 1 | ValueKart Namkeen 500g | Snacks | ₹332 | 9.2% |
| 2 | PrimeChoice Popcorn 4pk | Snacks | ₹443 | 28.5% |
| 3 | UrbanMart Paneer 2L | Dairy | ₹469 | 24.8% |
| 4 | PrimeChoice Cleaner 250g | Household | ₹499 | 8.6% |
| 5 | QuickBite Cereal 100g | Grocery | ₹659 | 20.3% |
Category Revenue vs Margin
Total Customers
1,000
In sample dataset
Loyalty Members
586
▲ 58.6% of base
Repeat Customers
1,329
▲ 42% repeat rate
Loyalty Rev. Share
58.6%
vs 41.4% non-loyalty
Revenue by Age Group
Loyalty vs Non-Loyalty Revenue
58.6%
Loyalty
Loyalty ₹471.8K
Non-Loyalty ₹332.4K
Revenue by Gender
Top 10 Customers by Revenue
| Customer ID | Revenue | Status |
|---|---|---|
| C03304 | ₹11,191 | Loyalty |
| C03171 | ₹10,625 | Loyalty |
| C01784 | ₹10,005 | Loyalty |
| C03153 | ₹9,244 | Loyalty |
| C03730 | ₹8,046 | Non-Loyalty |
| C04011 | ₹8,046 | Loyalty |
| C02674 | ₹7,870 | Loyalty |
| C03532 | ₹7,747 | Non-Loyalty |
| C00931 | ₹7,675 | Loyalty |
| C01479 | ₹7,656 | Loyalty |
Purchase Frequency Distribution
One-time Buyers
1,837
Repeat Buyers
1,329