B

Menu Intelligence

📊

The cashier knows something the menu doesn't.

Every week, roughly 17,000 transactions move through this business. Each one is a vote. A Lager ordered without looking at the menu. A Margarita that arrives first because the server knows it's quick. A Steak and Frites that barely moves — quietly costing more than it earns.

Menu engineering is the practice of reading those votes. Not to reduce the menu to a spreadsheet. But to protect the things worth protecting: the kitchen, the craft, the people on both sides of the pass.

The data doesn't judge the food. It protects the people who make it.

📐

Two numbers. That's all this takes.

Popularity — Units/Month

How many times did someone order this last month? High volume means the room has spoken. Low volume raises a question worth asking.

📌 BSB threshold: 150 units/month

Profitability — GP per Unit

What's left after the ingredients are paid for? That's gross profit per unit — the difference between a dish that funds the business and one that quietly drains it.

📌 BSB: food target 30–35% COGS · drinks 22–28% COGS · GP floor Rp 75k/unit
🗺️

Four categories. Every item on the menu fits one.

⭐ Star

High Volume · High Profit

These are earning their place. Protect what makes them work. Keep them visible. If the price hasn't moved in two years, it probably should.

🐂 Plowhorse

High Volume · Low Profit

The room loves them. The margin doesn't. A careful price adjustment rarely loses the guest — and can recover tens of millions a month.

🎯 Puzzle

Low Volume · High Profit

There's something here. The dish can do more, but the room hasn't found it yet. Better placement. A word from the right server. Sometimes that's all it takes.

🐕 Dog

Low Volume · Low Profit

Not every dish earns its space. Some stay out of habit. The honest question: if it weren't on the menu, would anyone ask for it?

🧠

One question.

Which BSB item is a Star right now?

Steak & Frites
Classic Margarita
Beef Tartare
Brisket Burger
📋

Four items. Four different stories.

⭐ Star

Classic Margarita

150 units a month. 25% COGS. That's Rp 15.75M in monthly gross profit from a single cocktail. The price hasn't moved in over a year. A Rp 10k increase on a drink people order without thinking twice is probably overdue.

🐕 Dog

Beef & Truffle Slider

35 units a month. Rp 53k GP per unit. Below the line on both axes. The question isn't whether the dish is good. The question is whether the business can afford to keep it.

🎯 Puzzle

Steak and Frites

15 covers a month — but Rp 261k gross profit per unit. The maths on this one is striking. If servers were talking it up the way they talk up the Lager, the GP contribution could be three or four times what it is now.

🐂 Plowhorse

BSB Lager

1,700 units a month. The room's order of choice. GP sits at Rp 65.5k — just below the threshold. A Rp 10k move flips it to Star and adds roughly Rp 17M a month in gross profit. That's not a small number.

🚀

That's the framework. Now it's yours.

Command Centre gives you the daily read — revenue, alerts, top items, and a briefing on what's worth paying attention to right now.

Menu Engineering is where the work happens. Every item, plotted. The full scatter, the full table, pricing recommendations built from your actual April data.

Upload a CSV from Quinos anytime to refresh the numbers. The dashboard updates everything immediately.

The menu is already telling you something. This is just the translation.

Historical · April 2026
Gross Revenue
Rp 4.71B
April 2026
Net Sales
Rp 4.64B
After discounts
Gross Profit
Rp 3.88B
Before overheads
Total Covers
30,925
Guest count
Total Invoices
17,473
Transactions
📊
Menu Engineering
Open analysis →
✦ AI Briefing

April closed at Rp 4.71B across 30,925 covers. Rp 175k a head, on average.

The Brewhouse carried the room — Rp 1.99B in revenue, more than any other department. BSB Lager alone: 1,700 pints a month. The bar knows what it's doing.

Classic Margarita holds the cocktail line. 150 units. 25% COGS. Rp 15.75M in monthly gross profit from a single drink.

Steak and Frites is the quiet problem. 15 covers a month — but Rp 261k gross profit per unit. A word from the right server could change that completely.

Open AI Insights for the full read.

What to prioritise this week ↗
Items to consider removing ↗
Promote the Steak and Frites ↗
Underperforming cocktails ↗
🔔 Alerts
🔴
Steak and Frites42% COGS · ABOVE target · 15/mo · Puzzle item
🔴
Bacon Wrapped Tenderloin38% COGS · ABOVE target · 15/mo
🟡
Caprice Provence Rosé49% COGS · ABOVE drink target
🟡
Brisket Burger38% COGS · ABOVE target · 85/mo
🟢
BSB Lager at scale1,700/mo · Rp 10k price rise = +Rp 17M/mo GP
🏆 Top Items by Volume
Lager
1,700/moPlowhorse
Blonde
1,050/moPlowhorse
IPA
1,000/moPlowhorse
Pilsner
900/moPlowhorse
Soft Drinks (Coke / Sprite)
700/moPlowhorse
Something Fruity
195/moStar
Classic Margarita
150/moStar
📅 Monthly Programme
Tuesday
2-4-1 Pizza Tuesday · 5–10:30pm
Wednesday
Jukebox Wednesday + 2-4-1 Pints & Cocktails 5–7pm + Wings 100k
Thursday
Pasta Thursdays 60k + 50% off wines
Friday
Friday Beers 50k Pints 3–6pm + Guest DJ
Sunday
Texas Sunday's BBQ from 5pm
💰 Revenue Breakdown
Net Revenue
Rp 4.71B
Grand Total
Rp 5.43B
Gross Profit
Rp 3.88B
53.6% margin
🍺 Brewery
42.3%
🍹 Drinks
35.2%
🍔 Food
21.5%
💳 Card
90.4%
⚡ Data Connections 2 of 4 active
POS System CSV Upload
Quinos POS Live API Not connected Planned
Wix Reservations Connected · Live
Google Reviews Not connected Planned
tmrwlabs.io Hardcoded data Planned
📆 Today's Reservations
Covers Today
Parties
Loading…
🔆 Next Friday
Covers
Parties
Loading Canggu weather…
Loading…
📈 This Week (Reservations)
covers Mon–Sun
💬 Brand Sentiment
All Channels
🍺 Brewery
🎵 Studio
Google Reviews
4.6 ★
76% positive
IG Brewery
24K followers
84% positive sentiment
IG Studio
Growing
88% positive sentiment
YouTube Brewery
Active
71% positive sentiment
YouTube Studio
Active
90% positive sentiment
82%
Overall Positive Sentiment
Across all platforms · April 2026
Google
4.6 ★
76% positive
Wix Site
12k/mo
Top pages: Menu, Book
Instagram
24K
@blacksandbrewery · 84% pos
YouTube
Active
@BlackSandBrewery · 71% pos
Instagram
Growing
@studioblacksand · 88% pos
YouTube
Active
@StudioBlackSand · 90% pos
Website
Active
studio.blacksandbrewery.com
👥 Top Customers
107
Regulars
13.5
Avg Visits
Rp 375k
Avg/Bill
1.6%
Revenue Share
Rank Name Visits Total Spend Avg/Bill Discount
📂 No sales data uploaded yet.  The figures below are placeholders — upload a CSV to see your real numbers.
🎯 Pricing Challenge
0
Prices accepted
+Rp 0
Monthly GP gain
0
Problems fixed
0 of 0 recommendations actioned
✦ AI Overview
Click "Generate insights" for a structured AI health check across pricing, risk, trends and category performance.
Star
Plowhorse
Puzzle
Dog
Bubble size = monthly revenue · Hover for details
Category Item Units/moThese are proportional estimates — category totals come from your April 2026 Quinos POS report; the per-item split is weighted by relative popularity. Upload an item-level CSV to replace with real counts. GP/unit Monthly GP COGS% Price On Menu Quadrant Flag Action Your New Price
Pricing Methodology
May 2026 update
🧺
Basket-average method
One number per category. One increase, applied across every dish in that group. Not ingredient by ingredient — that would take weeks and invite arguments. Compare total supplier spend before and after the May 2026 invoices, calculate the weighted average, apply it. Clean. Auditable. Done.
🔴
Rp 5,000 rounding
Every recommended price rounds to the nearest Rp 5,000. Rp 142,500 on a menu is a distraction. If the rounding pulls a price below its current level, we hold. Prices in this pass move in one direction only.
📅
April 2026 sales data
30,925 guests. 17,473 invoices. A full month from Quinos POS, not a two-week sample. For items with seasonal swing, that matters. This is the most reliable baseline we've had.
+8%
Beer & Brewing
Brewery
+10%
Kitchen (Food)
Burgers · Pizza · Pasta · Mains · Sides · Shares · Veggie
+10%
Wine
Wine
+15.1%
Cocktails & Spirits
BSB Cocktails · House Pouring
+22.9%
Non-alcoholic
Non-Alcoholic · Coffee & Tea
Rp 0/wk
Fixed overheads
Rent · Utilities
📈 Supplier Cost Changes — May 2026

Weighted basket increase vs April 2026 invoices, pre-loaded from your May 2026 supplier analysis. Edit any value if costs have changed — the price recommendations update automatically.

🍺
Beer & Brewing
Grain, hops, kegs
%
🍽️
Kitchen (Food)
Meat, veg, dry goods
%
🍷
Wine
By glass and by bottle
%
🍸
Cocktails & Spirits
Aperol, Tequila, Gin, etc.
%
🥤
Non-alcoholic
Soft drinks, coffee beans
%
🏭
Fixed overheads
Rent & utilities increase
Rp/wk
🔌 Integrations
Quinos POS
Manual CSV sync mode
Manual
Claude AI (Anthropic)
Menu intelligence & insights
Connected
Google Sheets
Auto-export menu data weekly
Not set up
Zapier Webhook
Push alerts to Slack / email
Not set up
🎯 Classification Thresholds

These values define the Star/Plowhorse/Puzzle/Dog quadrants. Changes re-classify all 122 items instantly.

GP per unit threshold
Items above this are High Profit
Rp / unit
Volume threshold
Items above this are High Volume
/mo
Food COGS target
Above = ABOVE flag (urgent >50%)
%
Drinks COGS target
Above = ABOVE flag (urgent >50%)
%
📋 Data & Units/Month
Are the units/month in the Full Table accurate?
The category totals are pulled from your April 2026 Quinos POS report (e.g. Brewery: 5,618 pints/mo total). Within each category, the per-item split is a proportional estimate — the real item-level counts will only be available once you connect a live Quinos API or upload a POS item-detail CSV.

To get exact per-item data: upload a CSV from Quinos with at least the columns item_name, qty_sold, date. The dashboard will automatically replace these estimates with your real figures.
👤 Account
Logged in as
Venue
Black Sand Brewery · Canggu, Bali
Menu items loaded
122 items · 18 categories
Data period
April 2026 (POS report)
Platform
BSB Menu Intelligence v1.0
🔒
P&L data is restricted
Enter the access password to continue.