Who is this assistant for?

Your bar sells well and you measure it with a single global percentage. You suspect the bottle yields fewer glasses than it should and you have no way to prove it. You push whatever "leaves more" by percentage and the month does not improve.

The bar is often the most profitable corner of the house and the worst measured: one blended percentage hides families that give margin away. This assistant splits beverages by family, finds where the money sits and where it leaks, and leaves three concrete actions for the week.

AI assistant · N3 Analysis with a verdict

◆ Included in the annual plan🧮 Costs, Pricing and Profitabilityv1.2.0 · 2026-08-20

Beverage Cost Analyzer for Restaurants

Measures your bar cost split by family, bottled drinks, beer, wine, cocktails and coffee, shows which family leaves the most money and builds a three-move physical control plan.

Depth

10/23

Your data

Compatible AIs

Steps to use it

Depth of the resulttap a level to see what you get

◀ Put out today's fireRun the year ▶

📊

N3Analysis with a verdict

Crosses YOUR numbers and takes a stand, with a table, units and currency. Not options: a recommendation you can defend.

◆ This assistant 24 of the 164 published assistants are at this level

Is this for you?

What it does and what you get

The bar is often the most profitable corner of the house and the worst measured: one blended percentage hides families that give margin away.
This assistant splits beverages by family, finds where the money sits and where it leaks, and leaves three concrete actions for the week.

What you end up with

A cost and cash-margin table per beverage family, the winning and the leaking family named, and a three-action bar plan with measurable success signals.

EXAMPLE This is what you getAn example built with Sazón de Origen, the house's fictional restaurant.Not your data: your result is built with YOUR restaurant's.See the full example →

Sample result

Sazón de OrigenFictional contemporary Colombian restaurant in Medellín, 2 locations, 6 years in business. Every sample result in the library comes from this same case. Fictional restaurant

The owner asked this: «The bar sells me around 36 million a month and all I know is that it runs at 29 %. What do I push and what do I fix?»

Family	Sales excluding tax	Consumption	Cost %	Cash margin
Beer	11,200,000	3,810,000	34.0 %	7,390,000
Bottled (soda, water, juices)	7,900,000	2,450,000	31.0 %	5,450,000
Cocktails and spirits	6,800,000	1,700,000	25.0 %	5,100,000
Coffee and hot drinks	5,800,000	820,000	14.1 %	4,980,000
Wine	4,300,000	1,720,000	40.0 %	2,580,000
Whole bar	36,000,000	10,500,000	29.2 %	25,500,000

Ranked by money, the family that leaves the most is beer: 7,390,000 a month. Ranked by percentage, the first would be coffee at 14.1 % — and coffee is fourth in cash. Pushing coffee instead of beer because it "costs less" would have cost the house 2.4 million of margin a month. It is the mistake bars always pay for, and it is why this table is sorted by the last column and not the fourth.

The leaking family has a name: wine, 40.0 %. It costs more than the kitchen, which runs at an actual 35.0 %. It is the only one of the five that gets re-costed before being pushed, and the global 29.2 % had it perfectly hidden.

Ten glasses of the house wine were weighed during service, unannounced. The recipe says 150 ml and the average glass came out at 190 ml: 27 % over-pour.

	As it is today	As it should be
Glasses per 750 ml bottle	3.9	5.0
Consumption for the month	1,720,000	1,358,000
Cost of the family	40.0 %	31.6 %

That is 362,000 COP a month going over the rim of the glass. It needs no new software and no professional bartender: it needs marked glasses and a Sunday count.

The same weighing on the best-selling cocktail gave 58 ml where the recipe calls for 45: 229,000 COP a month. It is real and it is small, and saying so is part of the job — whoever chases the 229,000 and leaves the 362,000 picked the wrong leak.

And one that is not the bar's fault: 4,100,000 of the month's beverages go out through the delivery platform. There the leak is not the pour, it is the commission.

SUPUESTO: the platform commission is taken at 24 % because the contract was not brought to the session; the figure came from the owner's memory. That is 984,000 COP a month the bar invoices and does not collect. If the real settlement said 18 %, it would be 738,000 and beer through the platform would stop being the worst business in the house. Before moving a single platform price, pull the statement: here the difference between an assumption and a fact is 246,000 COP a month.

Illustrative example generated with a fictional restaurant. Not a promise of results, not a client case.

This is 2 of 3 parts. Behind the wall is **the bar plan**: which family gets pushed, which gets re-costed and which gets controlled, each with owner, date and success signal, plus the Sunday physical count sheet that proves within 4 weeks whether the rim of the glass got closed.

See the full example — free account

Works with these AIs

Claude para Excel — the best for this assistant The only one that enters YOUR spreadsheet instead of working on a copy: it reads your tabs, calculates and leaves the result in a new dated tab without overwriting anything. Ask it for the sheet map before it calculates.

How to use it

Separate beverage sales from food sales, even by hand, and gather the month's beverage purchases.

Paste the assistant into your everyday AI and confirm the sales share per family when asked.

Apply the three-move bar plan and schedule the first physical bottle count.

Which of your data it uses

of 23

This assistant works with 10 of the 23 fields in «My Restaurant», among them Business type, Cuisine or concept and City and country. It does not ask out of curiosity: these are what make the answer speak about YOUR scale instead of an industry average — the same calculation on a business of another size returns a number you cannot decide with. You fill them once and they apply across the library, so the second assistant you open already starts with them in place. Whatever you leave blank, the assistant asks for one thing at a time instead of inventing it, and says so before answering, so you know what it is working from.

Business typeCuisine or conceptCity and countryActive sales channelsMenu price rangeAverage check (with currency)Average monthly salesStrong and slow daypartsApproximate food cost (%)Main goal this year

Always up to date

Every assistant carries a visible version and date. When an AI changes how it works, the assistant's version goes up and you see what changed.

Same method, another variant

Inside the app this is a single control: you press it and the assistant reframes itself, including the variants that don't appear here because they don't have their own page yet.

What gets audited

food costbeverage costlabour cost prime cost cost and margin per dish AI Costing Spreadsheet Analyzer for Restaurants