What Manual Planning Is Really Costing UK & Irish Food Manufacturers

If your planning, buying and reporting run on spreadsheets, the cost is real. It just never shows up as a line on the P&L. It shows up as hours spent rebuilding the same report, errors nobody catches, and decisions made on numbers that were out of date before the meeting started.

The cost nobody budgets for

Food and drink is the UK's largest manufacturing sector. There are 12,130 UK food and drink manufacturers employing 484,750 people, with turnover of £152bn (FDF). In Ireland, food, drink and horticulture exports reached a record €19bn in 2025 (Bord Bia).

Most of those businesses aren't multinationals. They're owner-led firms where planning, buying and reporting sit with a handful of people and a lot of Excel. The spreadsheet isn't the problem. What happens around it is:

• The same work, every week. Someone exports data, pastes it in, fixes the formulas and builds the report again.
• Errors that look like facts. A copied formula or a duplicated week changes the answer, and nobody can tell a real movement from a mistake.
• Answers that arrive late. By the time the numbers are ready, the decision has usually been made.
• Knowledge in one head. Only one person knows how the spreadsheet works. When they're off, it stops.

The errors hiding in your exports

Most planning spreadsheets start with an export from the ERP or finance system. Those exports have traps that a spreadsheet won't warn you about:

• Credit notes counted as spend. Some systems hold credits in a separate column. Miss it and your costs look higher than they are.
• The same week loaded twice. File names that don't match their contents are more common than you'd think.
• Units that change. Litres one week, kilos the next. Every cost-per-kilo and yield figure built on top is wrong.
• Currencies read as pounds. A supplier invoicing in euros can make an ingredient look 15–20% dearer than it is.

None of these are anyone's fault. They're the normal result of joining data by hand, and they get worse as the business grows.

How to put a number on it in your business

You don't need a consultant to get a first estimate. Take an hour and do this:

1. List every report, plan or reconciliation someone builds by hand at least once a month.
2. Next to each, write the hours it takes and who does it.
3. Multiply the hours by a fully loaded hourly cost for that role, then by 12 for a monthly task or 52 for a weekly one.
4. Add one line for the cost of a mistake: a missed contract renewal, a price nobody checked, a week of waste nobody spotted.
5. Circle the item that people argue about most in meetings. That's usually where to start.

For a sense of scale: when we automated weekly and monthly reporting for Courtney & Nelson, a Northern Ireland wholesaler, it saved about 35 hours a month. With reworked delivery routes on top, the estimated saving is about £33,000 a year.

What good looks like

• One source of truth. Purchases, production and sales data in one place, not five spreadsheets.
• Checked on arrival. Every new file reconciled against its own totals automatically. A file that doesn't add up is refused, not absorbed.
• Refreshed without anyone touching it. Reports ready every morning, not when someone has a free afternoon.
• Exceptions, not everything. The system flags what's changed or off-target, so people spend their time on decisions.

Where to start (it might not be AI)

Start with the one plan or report that takes the most hours and causes the most arguments. Often the first fix isn't AI at all. It's getting your data into one place, checked automatically, so the numbers are right every morning.

AI earns its place later, where it saves reading rather than replacing judgement: pulling terms out of supplier contracts, or sorting supply news by what matters to you. It should never be the thing that produces your numbers.

Sources

• Food and drink industry at a glance, Food and Drink Federation
• Export Performance and Prospects 2025–2026, Bord Bia