MasterPrompt VaultBY MASTERESTAURANT

AI assistant · N5 Complete system

◆ Included in the annual plan🎛️ Dashboards, KPIs and Scorecardsv1.2.0 · 2026-08-27🛠 Delivers a file · use in Cowork
This assistant builds files (dashboard, board, report). Use it in Claude with Cowork or Claude Code: paste the prompt there and receive the tool ready. In a plain chat you will get the design and the instructions, not the files. With a paid plan, also download the Universal Kit in My Library: the input these tools start your project with.
📁 Needs an AI that builds files — Claude with Cowork or Claude Code

Master KPI Sheet Builder for Restaurants

The «sábana» —Latin American kitchen slang for the wide sheet where everything fits at once— is the master measurement document: every indicator with its formula, its area, the role accountable for it, who reads it, when, and against which target. Every dashboard in the house then hangs off that sheet.

N5
Depth
9/23
Your data
1
Compatible AIs
5
Steps to use it
Depth of the resulttap a level to see what you get
◀ Put out today's fireRun the year ▶
🏛️

N5Complete system

Several chained pieces you install and operate over time, with their review cadence. It changes how the business runs, not one decision.

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

Is this for you?

What it does and what you get

  • A restaurant can own ten boards and still fly blind, because nobody wrote the mother document: what the WHOLE house measures, with which formula, who answers for each number and who reads it every week.
  • This assistant builds the complete master sheet — by area and by job — and delivers it in one file: the server sees two numbers, the kitchen chief four, the owner eight, and every indicator declares formula, source, frequency, owner and target.
  • Area boards show one slice; the master sheet is the map they all hang from.

What you end up with

The complete indicator sheet by area and by job — each with formula, source, frequency, owner and target —, the sabana.html file with its traffic light and reading order, and the weekly meeting routine written into the file, with the five-first rule.

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: «I run two locations, one financial board I do read and twenty loose numbers nobody reads. I want the mother document: what my house measures, who answers for each number and what each job reads.»

Census at Sazón de Origen: 23 loose numbers found across the POS, a kitchen notebook and two spreadsheets. 18 were consolidated with an owner; 5 stayed OUT for having no verifiable source and are listed with the job that must bring it and the date.

AreaIndicatorFormulaSourceFrequencyOwnerTarget
SalesAverage ticket by sales channelsales / checks, dining room and delivery splitPOSweeklyfloor chiefcomputed on the house's declared sales
SalesSales mix by familyfamily portions / total portionsPOSweeklymanagerthe highest-margin family must not fall
KitchenReal against theoretical food costtheoretical recipe usage / period purchasesrecipes + invoicesweeklykitchen chiefgap shrinking against its own baseline
KitchenWasteproduct written off / product receivedwrite-off sheetweeklykitchen chiefPENDING — no sheet exists yet
ServiceCovers and occupancy by slotshift covers / seats per shiftPOS + capacitydailyfloor chiefper the full hours the house declared
PeopleLabor cost over salesperiod payroll / same period salespayroll + POSweeklymanageron the declared figure, not on an average
DirectionPrime cost and contribution marginfood cost + labor cost; margin against the month's break-evenP&Lmonthlyowneragainst the year's goal

SUPUESTO: targets are computed on the figures the house declared —sales, food cost and labor cost—, not on industry benchmark percentages, which shift by country, by format and by year. If the declared sales turned out to be a high-season month, every target in the table gets re-read against the 12-month average and several come down.

This is 2 of 3 parts. Behind the wall are **the sabana.html file with the printable cut by job** and **the Monday routine**: the 40 min meeting with the five-first rule, each week's deep-dive indicator and the written boundary against the area boards.

See the full example — free account

Works with these AIs

Claude — the best for this assistant The only path to the file: use it in Claude with Cowork or Claude Code and receive sabana.html working. Have your real org chart at hand and whatever you measure today, even on paper.

How to use it

Fill in My Restaurant with your sales, costs and team: the sheet is built on YOUR operation.
Copy the full assistant and paste it into Claude with Cowork or Claude Code: this assistant builds a file.
Tell it which areas your house has, which jobs really exist and what you measure today even on paper, and answer one at a time.
Get the sheet by area and by job, approve it, and receive your sabana.html with Monday's reading order.
Walk the sheet weekly in your meeting: five numbers first, the rest only when one demands an explanation.

Which of your data it uses

9
of 23

This assistant works with 9 of the 23 fields in «My Restaurant», among them Restaurant name, Business type and Number of locations. 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.

Restaurant nameBusiness typeNumber of locationsTeam sizeStrong and slow daypartsAverage monthly salesApproximate food cost (%)Approximate labor 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.

More assistants in this category

Included in the always-growing library

Access to every published assistant, adapted to your AI and personalised with your restaurant's data, updates included.

Master KPI Sheet Builder for RestaurantsN5 · Complete system · Included in the annual plan See the plan

Exclusively for restaurant leaders

AI Executive · Artificial Intelligence for Restaurants

Make 1 person produce like 5. In 8 weeks you turn Artificial Intelligence into a new productivity department inside your restaurant: content, sales, finance, manuals, automations and specialized assistants.

I want to implement AI in my restaurant →
NEW AI Executive — executive Artificial Intelligence program for restaurant leaders