Job 12 of 16 · Outline

Find menu items to cut using sales and margin

The problem

A long menu means more stock, more waste and slower service. Comparing what sells with what makes money shows what can go.

What AI does

AI sorts your menu by how well each item sells and how much it makes, using your till data and costings, and shows which items to look at first. What stays or goes is your call.

Time

Time: About 20 minutesTools: Google Sheets, ChatGPT

The steps, in short

  1. Download sales by item for a normal trading period.
  2. Bring in the margin on each item from your costings.
  3. Have AI group the items and list the ones to review.
  4. Decide what to change, keeping regulars' favourites in mind, and update allergen information if recipes change.

A short sample prompt

Here are sales by item at my café for [period], with the margin on each. Group the items by sales and margin, and list the ones worth reviewing first, with a short reason. Use only my data. Data: [paste]

In the full playbook

  • 4 steps in full
  • The exact prompt to copy
  • A check-before-you-send list (3 points)
  • UK notes with official sources
The full playbook

Unlock all 16 cafés and coffee shops jobs

Every job has the full steps, the exact prompt, a check-before-you-send list and optional UK notes. We keep adding new jobs and new niches, and re-checking existing jobs, while you subscribe. Monthly, cancel anytime, instant access, no password.

Just cafés and coffee shops

£5 a month

Every job in cafés and coffee shops, including its agent playbooks, plus the updates we make to it.

Subscribe · £5/mo

3 niches

£12.99 a month

Starts with cafés and coffee shops; you pick the other two (or swap later) on your account page.

Subscribe · £12.99/mo

All niches

£19.99 a month

All 81 niches, and every new one we add. Or £149 a year: save £90.88.

Subscribe · £19.99/mo or £149 a year (save £90.88)

Cancel anytime. One click in Stripe's billing page, no emails or phone calls: how to cancel.

Pay securely with Stripe. Prices include any VAT. Digital content: at checkout you ask for instant access and agree you lose the 14-day right to cancel once it starts. Terms · Privacy · Pricing · Already subscribed? Sign in

More jobs for cafés and coffee shops

See all 16 jobs in the cafés and coffee shops playbook →