Sample result
Menu Engineering Tool Creator for Restaurants
The owner asked this:«Here is the POS export from May to September, the menu and the chef's costing spreadsheet, which is half done. I want to know which dishes hold me up, which ones eat the cost and what I do this month.»
① The dashboard that opens the report
Deliverable A · REPORTE_tizon-norte-2026-10-01.html, built with the folder's motor/armar_reporte.py: the case meets the schema and the five guardians come out green. This is how it opens:
Tizón Norte, a northern Mexican grill in Mexico City (fictional case). Sales from May to September since the menu change: 31 dishes, 585 POS rows, incomplete costing.
Your menu leaves $1,483,620 in contribution margin a month, and the grill is both what holds it up and what eats the cost.
| Figure | Value |
|---|---|
| What the menu leaves a month (before payroll and rent) | $1,483,620 |
| How much cost eats (theoretical food cost) | 33.4 % · house ceiling 32 % |
| Sales in star dishes | 21 % |
| Data confidence | 87 out of 100 |
The month's three decisions, in order of money:
- Lower the cost of the 300 g Skirt Steak to $126.40 — its food cost is 36.2 %: portion and supplier before price · $11,975 a month (assumption: same units).
- Lower the cost of the 400 g Rib Eye to $220.80 before pushing it — 37.5 %: the dish you promote does not go over 32 % · $11,379 a month (same units).
- Push the Charcoal Picanha from the menu and the server — it meets the ceiling (30.2 %) and sells little · $9,932 a month (assumption: +15 % units).
Figures in Mexican pesos, illustrative. The report interface is in Spanish today; the figures, dish names and your texts stay in your language.
② The matrix, dish by dish
The eight dishes that leave the most a month. The engine decides the quadrant with the averages of the food menu.
| Dish | Units/mo | Price | Cost | Leaves each | Leaves a month | Food cost | Quadrant | Data |
|---|---|---|---|---|---|---|---|---|
| 300 g Skirt Steak | 722 | $395.00 | $143.00 | $252.00 | $181,846 | 36.2 % | Star | B · June costing |
| 400 g Rib Eye | 302 | $690.00 | $258.43 | $431.57 | $130,507 | 37.5 % | Leaves and sells little | A |
| Half Charcoal Chicken | 446 | $265.00 | $91.20 | $173.80 | $77,549 | 34.4 % | Star · anchor | A |
| Skirt Steak Taco | 1,365 | $89.00 | $37.90 | $51.10 | $69,753 | 42.6 % | Sells and leaves little | A |
| Tomahawk for Two | 72 | $1,590.00 | $625.50 | $964.50 | $69,444 | 39.3 % | Leaves and sells little | A |
| Charcoal Picanha | 209 | $455.00 | $137.60 | $317.40 | $66,211 | 30.2 % | Leaves and sells little | A |
| Northern Cecina | 260 | $345.00 | $110.80 | $234.20 | $60,845 | 32.1 % | Leaves and sells little | B · no date |
| Molcajete Guacamole | 601 | $145.00 | $44.25 | $100.75 | $60,508 | 30.5 % | Sells and leaves little | A |
Reading: the skirt steak taco is the best seller and the one cost eats most; the lever is its portion and the supplier, not raising the price of the dish that brings people in. The rib eye and the tomahawk leave a lot per unit, but neither is pushed while it is over the ceiling.
③ What is missing from your data, and what it is for
The report does not fill in what is missing: it says so, with what it changes and how to ask for it.
| Missing | Dishes | What it changes | What to ask for |
|---|---|---|---|
| Costing | Beef Rib Crackling, Pastor-style Kid Goat, Grilled Corn | Their margin is an ESTIMATE and they are not recommended for pushing | The standard recipe with the latest invoice price |
| Current costing | 5 dishes older than 60 days, among them the grill's skirt steak | The cost used may be below the real one | Re-cost with today's purchase price |
| Costing date | 3 dishes | Nobody knows whether the cost is current | The price date of each ingredient |
| Complexity | 8 dishes | It does not break ties in the matrix | Six answers from the head chef per dish |
④ The board's minutes
Eight seats of the expert board read the case and vote. They are AI agents, and the report says so.
| Seat | Vote | Decision |
|---|---|---|
| Supply chain and food cost | Conditional | Re-cost the grill this month |
| Financial | Conditional | Execute in order of money |
| Consumer behaviour | Yes | Do not remove the chicken or the enchiladas |
| Market and competition | Conditional | Tell the northern seal on the menu |
| Operations | Conditional | Protect the grill at peak hour |
| Marketing and launch | Conditional | Push only what already meets the ceiling |
| Brand and IP | Yes | Shield the house cecina |
| Technology | Conditional | Monthly POS export |
The full example has 1 more part(s): you see them inside the library, with your account.