UK-registered +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. How Do We Plan Menu Cycles and Tariff Prices Across Contract Sites Without a Spreadsheet Per Site?
Problems We Solve

How Do We Plan Menu Cycles and Tariff Prices Across Contract Sites Without a Spreadsheet Per Site?

Contract caterers plan menu cycles and tariffs site by site in spreadsheets. We build one planner that costs each cycle and feeds tills and menu boards.

Updated 3 min readBy SpiderHunts Technologies

Free estimateNo obligation

Get a free estimate

Tell us what you need. A senior engineer reads every enquiry.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →

Quick answer: TL;DR

Contract catering sites usually run menu cycles, often several weeks long, with a tariff (selling price list) agreed with each client. Planning cycles, costing them, setting tariffs and updating tills and menu boards is done per site in spreadsheets. We build one menu cycle planner that shares dishes across sites, costs each cycle against its tariff, and pushes prices and descriptions to tills, menu screens and printed menus.

A new menu cycle for six sites

Your autumn menu cycle is due. The executive chef has written it as a four-week rotation, with a hot main, a vegetarian option, a grab-and-go range and a soup of the day. Each site takes the cycle but adapts it: the factory site wants bigger portions and an earlier breakfast, the college has a lower tariff agreed with the client, and one office site has a smaller kitchen that cannot do certain dishes.

So the cycle is copied into six spreadsheets and edited. Each site manager costs their version against their tariff. Tariffs are updated on the tills by hand. Menu boards are printed at each site. When the executive chef changes a dish in week two, the change reaches some sites and not others.

One menu, six copies

Menu cycles are designed centrally and delivered locally, which is the right model. The problem is that copying the cycle into site spreadsheets breaks the link between the central menu and what each site actually does.

  • Dishes are copied as text, so their recipes and costs do not travel with them.
  • Each site's tariff is agreed with its client and stored in a different document.
  • Costing against tariff is done differently at each site.
  • Till prices and menu boards are updated manually, site by site.
  • Central changes during a cycle depend on emails being read and acted on.

Head office cannot easily answer simple questions, like what the college is serving on Wednesday of week three, or which sites are selling a dish below cost.

What the copies cost

Dishes sold below their target margin at some sites go unnoticed because each site's costing is its own. Till prices drift out of line with agreed tariffs, which clients notice, especially if they subsidise the service. Menu boards and allergen information may not match the dish being served after a mid-cycle change.

The executive chef and site managers also spend hours on work that is repeated at every site: copying, costing, typing up menus and updating tills, instead of cooking and improving the food.

A central planner with site variations

  1. Dishes are held centrally with their recipes, costs and portion sizes, and each site can have an agreed variation such as a larger portion.
  2. A menu cycle is built once from central dishes, and each site selects which dishes it runs and in which weeks, based on its kitchen and client.
  3. Each site's tariff is stored with its effective dates. The planner shows each dish's cost against that site's tariff price and highlights anything below your target margin.
  4. When the cycle is approved, prices and descriptions are pushed to each site's till system where it has an API, and exported where it does not.
  5. Menu screens and printed menus are generated for each site from the same data, including the dish information your procedures require.
  6. Mid-cycle changes are made centrally, and each affected site is notified and its tills and menus updated.
OutputBuilt fromUpdated when
Site menu for the weekCycle and site selectionsA dish changes
Cost against tariffRecipe costs and site tariffA price or recipe changes
Till price listSite tariffTariff or cycle approved
Menu board and screensDish descriptionsAny dish change

Tariff changes remain a commercial matter between you and each client. The planner makes their effect on margin visible before you agree them.

A cycle launched once, not six times

The executive chef writes the cycle once and sees at a glance where it works and where it does not for each site's tariff. Site managers receive a finished menu for their site, costed, with tills and boards updated. When a dish changes mid-cycle, every site that runs it gets the change the same day.

Head office can see what every site is serving, at what price and margin, which makes client reviews and menu planning for the next cycle much more straightforward.

Menu development gets easier as well. When the chef wants to try a new dish, the planner shows immediately which sites could run it within their tariff and kitchen, rather than a round of emails to find out.

Could this be your menu planning?

  • Each site has its own copy of the menu cycle in a spreadsheet.
  • Till prices are updated by hand at each site.
  • Mid-cycle changes do not reach every site.
  • Head office cannot easily see margin by dish across sites.
  • Menu boards are typed up locally each week.

FAQ

Frequently asked questions

The questions readers ask us after this guide.

Still have a question?

Ask us directly. A senior engineer reads every question.

Ask about your project

Can it push prices to our tills?

Where your till system has an API, yes. Where it does not, it produces an import file in the till's format.

Can sites still add local specials?

Yes. Sites can add local dishes, which are costed against their tariff like any other.

Does it handle client subsidies?

It shows cost against tariff. Subsidy arrangements can be added so you see the effect, but commercial decisions stay with you.

Can it produce menu screens?

Yes. Menu content can feed digital screens or printed menus from the same data.

What do you need from us?

A current menu cycle, your site tariffs and a list of till systems at each site.

Keep reading

More on Problems We Solve

Start here

Tell us where the admin piles up between events and sites

Describe how your contracts, venues and menus are managed today and which documents or spreadsheets people rebuild each time. We will tell you what we would build and what we would leave alone, and if a smaller change would do it, we will say so.

  1. You tell us what you needTwo minutes on the form, or a message on WhatsApp.
  2. A senior engineer reviews itAnd comes back with questions, a realistic range and an honest view on fit.
  3. Free 30-minute scoping callWe talk through scope, options and a realistic estimate, with no obligation.
Free estimateNo obligation

Talk to someone who builds this

Send a short brief and we will come back with an honest view and a realistic range.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →