Free PDCA kit for restaurant owners: plan, check and act on your numbers

A one-page plan, a list of result and performance indicators and example data to steer a restaurant month by month.

In this topic: Planning and control 12

A full dining room and a thin bank balance often go together. The reason is rarely one big mistake. It is usually a handful of small shifts that nobody follows month by month: food cost creeping up, more delivery orders with a commission attached, a quiet Monday with a full crew on the floor.

In short

This free kit helps you steer a restaurant on more than last month's results. It holds a one-page plan built on Plan, Do, Check, Act, a list of result and performance indicators with an owner for each, an agenda for the monthly review, and the example data of Bistro Marlo, a fictional restaurant, to practise with in Power BI or Excel.

What is in the kit

One-page PDCA plan

The four steps of the cycle translated to a restaurant, with room for your own targets. Print it, fill it in with your chef and floor manager, and bring it to every monthly review.

Indicators with an owner

Result indicators from your bookkeeping and performance indicators from your daily operations, each with an owner, a source and a rhythm. Plus the three rules that keep the review short.

Bistro Marlo example data

A fictional restaurant in CSV files: general ledger, chart of accounts, till sales per service, delivery orders, reservations, the staff roster, the budget, guest reviews and an action list. A Power BI theme is included.

Free download

PDCA kit for restaurant owners

No account needed. The restaurant and all its data are fictional and were made for the Firmfocus video about AI and Power BI.

Video: Claude builds the Bistro Marlo dashboard in Power BI from one sentence, and a BI specialist / controller reviews it.

Why a dashboard alone does not steer a restaurant

Most restaurant dashboards show what already happened: revenue, margins, labour cost, cash. That is useful, but by the time a number turns red, the month is over. To change next month, you also need numbers that move before the result does, such as covers booked for the next two weeks or planned staff hours against expected covers.

That is the logic of the PDCA cycle (Plan, Do, Check, Act), the improvement loop that goes back to Walter Shewhart and that W. Edwards Deming made widely known. A dashboard covers the Check. The plan, the owners and the decisions are up to you and your team. The guide to the PDCA cycle explains the model and its history in more depth.

Result indicators and performance indicators

David Parmenter, author of one of the standard works on KPIs, distinguishes key result indicators from key performance indicators. Key result indicators (KRIs) tell you how you did over a period. Key performance indicators (KPIs) tell you what to act on now and are measured often, daily or weekly. The kit uses that split.

IndicatorTypeOwnerRhythm
Revenue against planResult (KRI)OwnerMonthly
Food cost as a share of food revenueResult (KRI)ChefMonthly
Prime cost: food, drinks and labour as a share of revenueResult (KRI)OwnerMonthly
Covers booked for the next two weeks, against last yearPerformance (KPI)Floor managerWeekly
Expected covers against planned staff hours, per dayPerformance (KPI)Floor managerWeekly
Delivery share and margin after commissionPerformance (KPI)OwnerWeekly

A selection from the kit. The full list also covers cash, average spend per guest and dishes below their target margin.

One round of PDCA in a restaurant

  1. 01

    Plan

    Choose a few targets for the next quarter and the indicators you will steer on. Write down one definition for each number, and compare your targets with the sector figures for your industry.

  2. 02

    Do

    Give every indicator one owner and one action. The chef owns food cost, the floor manager owns the roster and the spend per guest.

  3. 03

    Check

    Each month, compare results with the plan. Each week, look ahead at bookings, staffing and delivery. This is where a dashboard earns its place.

  4. 04

    Act

    Decide what changes: menu prices, the roster, the delivery mix. Keep it to a few actions, each with one owner and a date, and start the next review with last month's actions.

Agree on definitions before you build anything

In the video, AI built a neat dashboard for Bistro Marlo from the bookkeeping export alone. Revenue was up and the result had turned negative, both correctly shown. Prime cost, however, came out far higher than the owner expected, because the owner's own management fee was counted as labour. Once the fee moved out of labour, prime cost dropped by about six points. Nothing was miscalculated: a definition had been chosen that nobody had agreed on.

Fictional example. Bistro Marlo and its figures were made for the video.

That is why the kit asks you to agree on one definition per indicator first. Does revenue include delivery? Does labour include the owner's fee? Write it down once, and every report uses it. If revenue rises while profit falls, the guide revenue up, profit down shows how to trace the cause, and management reporting covers how to present the numbers each month.

Try the example data in Power BI or Excel

The ZIP file holds the same data that Claude received in the video, split into two parts: the bookkeeping export for a first dashboard, and the operational files (till, reservations, roster, budget, reviews and actions) for a dashboard that also looks ahead. The CSV files open in Excel and in Power BI Desktop, and the theme file gives Power BI reports the Firmfocus colours.

Want a dashboard like this on your own numbers? The guide Power BI dashboard development explains what to ask a specialist and what to agree, and Power BI setup and governance covers the data model, access and agreements behind it.

Is the PDCA kit free?
Yes. You can download the one-page plan and the example data without an account.
Do I need Power BI to use the kit?
No. The plan works on paper or in a spreadsheet. The example data are CSV files that open in Excel; the Power BI theme is only needed if you build a report in Power BI Desktop.
Is Bistro Marlo a real restaurant?
No. Bistro Marlo and all of its data are fictional. The data were generated for the video, with a realistic pattern of costs, bookings and reviews to practise on.
How often should a restaurant run a PDCA review?
The kit suggests a short monthly review of results against the plan, and a weekly look ahead at bookings, staffing and delivery. Same day, same time: the rhythm matters more than the tool.
Profit and cost benchmark

Compare your margins and costs with your sector