Free tool · P6 unit economics
Restaurant sales mix report India
Analyse revenue contribution, food cost %, and gross profit for every menu item. Sort by revenue, quantity sold, or food cost. Filter by category. Top and bottom performers highlighted. Category revenue breakdown with FC% by segment. Export CSV or print. No signup.
Total Revenue
₹54,800
Gross Profit
₹38,456
Blended FC%
29.8%
Total Covers/Orders
390
Top 5 by Revenue
1Chicken Biryani₹16,80030.7%
2Paneer Butter Masala₹10,08018.4%
3Veg Manchurian₹7,56013.8%
4Masala Chai₹4,8008.8%
5Dal Tadka₹4,8008.8%
Bottom 5 by Revenue
1Gulab Jamun₹2,5204.6%
2Garlic Naan₹3,8407.0%
3Veg Fried Rice₹4,4008.0%
4Dal Tadka₹4,8008.8%
5Masala Chai₹4,8008.8%
| Item | Category | Sell ₹ | Food Cost ₹ | FC% | GP% | Qty | Revenue | Rev% | GP ₹ | |
|---|---|---|---|---|---|---|---|---|---|---|
₹ | ₹ | 32.0% | 68.0% | ₹16,800 | 30.7% | ₹11,424 | ||||
₹ | ₹ | 30.0% | 70.0% | ₹10,080 | 18.4% | ₹7,056 | ||||
₹ | ₹ | 30.0% | 70.0% | ₹7,560 | 13.8% | ₹5,292 | ||||
₹ | ₹ | 25.0% | 75.0% | ₹4,800 | 8.8% | ₹3,600 | ||||
₹ | ₹ | 30.0% | 70.0% | ₹4,800 | 8.8% | ₹3,360 | ||||
₹ | ₹ | 30.0% | 70.0% | ₹4,400 | 8.0% | ₹3,080 | ||||
₹ | ₹ | 25.0% | 75.0% | ₹3,840 | 7.0% | ₹2,880 | ||||
₹ | ₹ | 30.0% | 70.0% | ₹2,520 | 4.6% | ₹1,764 | ||||
| Total (8 items) | 390 | ₹54,800 | 100% | ₹38,456 | ||||||
Revenue by Category
Rice & Biryani
70 items soldFC 31.6%₹21,20038.7%
Curries
36 items soldFC 30.0%₹10,08018.4%
Starters
42 items soldFC 30.0%₹7,56013.8%
Beverages
120 items soldFC 25.0%₹4,8008.8%
Dal & Sides
30 items soldFC 30.0%₹4,8008.8%
Breads
64 items soldFC 25.0%₹3,8407.0%
Desserts
28 items soldFC 30.0%₹2,5204.6%
Sales Mix Report —
| Item | Category | Sell ₹ | FC% | GP% | Qty | Revenue ₹ | Rev% | GP ₹ |
|---|---|---|---|---|---|---|---|---|
| Chicken Biryani | Rice & Biryani | 350 | 32.0% | 68.0% | 48 | 16,800 | 30.7% | 11,424 |
| Paneer Butter Masala | Curries | 280 | 30.0% | 70.0% | 36 | 10,080 | 18.4% | 7,056 |
| Veg Manchurian | Starters | 180 | 30.0% | 70.0% | 42 | 7,560 | 13.8% | 5,292 |
| Masala Chai | Beverages | 40 | 25.0% | 75.0% | 120 | 4,800 | 8.8% | 3,600 |
| Dal Tadka | Dal & Sides | 160 | 30.0% | 70.0% | 30 | 4,800 | 8.8% | 3,360 |
| Veg Fried Rice | Rice & Biryani | 200 | 30.0% | 70.0% | 22 | 4,400 | 8.0% | 3,080 |
| Garlic Naan | Breads | 60 | 25.0% | 75.0% | 64 | 3,840 | 7.0% | 2,880 |
| Gulab Jamun | Desserts | 90 | 30.0% | 70.0% | 28 | 2,520 | 4.6% | 1,764 |
| Total | 390 | 54,800 | 100% | 38,456 | ||||
Blended FC%: 29.8% · Generated by restaurantdaily.ai
Sales mix benchmarks for Indian restaurants
A healthy restaurant sales mix has a blended food cost % of 28–35% across all items, with no single category contributing more than 40% of revenue unless it has a food cost below 30%. Indian restaurants typically see beverages (including chai, lassi, and soft drinks) with food cost below 20%, while rich curries and protein-heavy dishes carry food cost of 35–45%.
- Blended food cost target. 28–33% for casual dining, 25–30% for QSR (lower because of high standardisation and bulk purchasing), 28–35% for fine dining (higher-cost ingredients offset by premium pricing). A blended FC above 38% indicates either menu pricing is too low or ingredient costs are not being controlled.
- Revenue concentration risk. If the top 3 items account for more than 50% of revenue, the restaurant is exposed to supply chain risk and demand volatility. A more distributed sales mix is more resilient. However, a highly concentrated menu can also indicate strong brand identity — Moti Mahal Biryani or Tunday Kebab derive value from narrowness. Context matters.
- Beverage attach rate. Beverages should contribute 15–25% of total revenue in casual dining. In a restaurant where beverages are below 10% of revenue, the team is almost certainly under-suggesting beverages. Each incremental beverage sale at 15–20% food cost significantly improves the blended FC%.
- Menu rationalisation trigger. Any item with less than 0.5% revenue share and more than 35% food cost should be reviewed quarterly. Items below 1% revenue share that also have above-average food cost have no redeeming financial characteristic — they are complexity without contribution.
Where this fits
- Menu engineering matrix — classify items as Stars, Plowhorses, Puzzles, or Dogs using sales mix data
- Food cost calculator — calculate total period food cost % to validate against blended FC in this report
- Recipe cost card — build accurate food cost per dish to feed into the sales mix food cost column
- P&L statement — revenue from this report cross-checks against the P&L revenue line
- Prime cost calculator — blended FC% from this report feeds into prime cost calculation
- P6 — Unit economics pillar — complete guide to P&L analysis, menu economics, and financial management for Indian restaurants