Profit by Customer and Product · October 2026

Trentmere Foodservice Ltd

Wholesale food, drink and catering supplies delivered to cafés, pubs, schools and care homes across Staffordshire and Derbyshire. 34 staff. 28 customers and 7 product lines over 12 months, reconciled to the accounts.

Worked example. Trentmere Foodservice is a fictional business; every name and figure is invented. All figures come from the worked-example spreadsheet: ALL CHECKS PASSED (with 1 note), the note being the customers losing money.
The headline

Where the profit really comes from

Gross profit
£839,590
on £3,313,000 of sales
Cost to serve
£392,000
orders, deliveries, service calls and sales visits
Top fifth of customers
59%
of profit after cost to serve
Losing money
4 customers
£6,387 a year between them
The profit curve

Running total of profit

Running total of profit after cost to serve, customers ranked from most to least profitable. It peaks at 101% of the total and then falls. The figures are in the tables below.0%25%50%75%100%Trentside Academy Trust: £63,961Dovebrook Care Group: £57,397Spireview Schools Catering: £39,407Kestrel House Hotel: £37,693The Swan Inns: £35,870Meadowbank Care: £29,485Weaver Hills Events Catering: £29,339The Bridge Restaurant: £22,193Castle Mill Tea Rooms: £19,061Derwentvale Nursing Homes: £17,433Canalside Kitchens: £16,044Riverside Café Company: £14,622Ashcombe Hall Hotel: £11,033Willowmere Lodge Care: £10,025Oakvale Grange School: £9,638Hollybank Prep School: £8,381The Plough at Hollinbrook: £7,996Riverbank Works Canteen: £6,049The Crown, Ashwell Green: £5,114Hillside Village Café: £5,095Stretbrook Day Nursery: £3,582Bramble & Bean Coffee House: £3,064Fernlea Golf Club: £1,321Northfield Community Café: £174Kingfisher Sports Club: −£940Wren Cottage Tea Room: −£1,065Mill Lane Bistro: −£2,174The Red Lion, Elmford: −£2,2080%25%50%75%100%Peak 101%Share of customers, most profitable firstShare of profit

Customers ranked from most to least profitable after cost to serve. The line peaks at 101% of the final total: the customers after the peak (red dots for those losing money) take back profit the others make.

What an activity costs

Cost to serve, per unit

ActivityFull costWould go if stopped
Orders£9.18£3.67
Deliveries£35.31£17.66
Service calls£56.63£16.99
Sales visits£282.26£56.45

Full cost shares all of a pool's cost; "would go" is the assumed share that would actually disappear if the activity stopped. Most of a van route stays even if one drop goes.

The loss-makers

Why stopping isn't the answer

CustomerSalesProfit after cost to serveIf stopped, a yearDecisionEvidence
Kingfisher Sports Club
Pubs
£74,000−£940−£9,378RepriceExtra Sunday deliveries at no charge since 2023.
Wren Cottage Tea Room
Cafés
£24,000−£1,065−£4,100KeepOn the Kestrel House route, so little extra delivery cost; review the service calls in six months.
Mill Lane Bistro
Restaurants
£39,000−£2,174−£5,894RepriceSmall drops twice a week across town; pays below list.
The Red Lion, Elmford
Pubs
£29,000−£2,208−£3,262RepriceLoses money after cost to serve, but stopping would cut profit: most delivery cost stays. Offer a delivery charge worth about 8% instead.

Every customer losing money would cut profit if stopped, because most of the cost of serving them stays. The answer is to change the terms: a price rise, a delivery charge or fewer, larger orders.

The actions

Profit change a year

CustomerActionA yearOwnerBy when
The Swan InnsFix the cost to serve£3,903Sales managerJanuary 2027
Kingfisher Sports ClubReprice£2,960Sales managerNovember 2026
The Plough at HollinbrookReprice£2,640Sales managerNovember 2026
Bramble & Bean Coffee HouseFix the cost to serve£2,559Operations managerJanuary 2027
Riverside Café CompanyFix the cost to serve£2,552Operations managerFebruary 2027
The Red Lion, ElmfordReprice£2,320Managing directorJanuary 2027
Mill Lane BistroReprice£1,950Sales managerDecember 2026

£18,884 a year in all. Price rises assume volumes hold; cost-to-serve savings count only the share of cost that would actually go.

Products

Margin after handling

Cleaning and disposables27.0% · £39,689
Frozen21.9% · £121,560
Drinks20.7% · £72,227
Ambient groceries20.6% · £144,648
Chilled20.2% · £165,845
Bakery19.0% · £54,033
Fresh produce16.4% · £75,978

Gross margin less picking and stock-holding costs, by product line.

How confident are we?

What this rests on

Customer sales are 99% of turnover in the accounts, and the cost pools add up to the overheads. Cost to serve shares 54% of overheads by counts of orders, deliveries, service calls and sales visits; 22% is left unallocated. 81% of the pool costs are sourced from documents; the rest are estimated or assumed. The profit change from the actions uses judgements of the share of each pool that would actually go, and assumes volumes hold after a price rise.

Operating profit from these figures is £111,590, against £122,000 in the accounts; the gap is the small difference between customer sales and turnover. The shares of each pool that would go if an activity stopped are the softest figures: they decide the "if stopped" column.

The months after

What the agent flagged, and what was decided

At handover the managing director agreed the six top actions and their owners. The agent was then set up in Trentmere's own AI assistant account, with read-only access to the accounting system, the order and delivery logs and the service log. On the second Monday after each quarter end it loads the last 12 months' figures into a new dated copy of the review, runs the checks and sends the managing director a short note. It uses the rules on Inputs: the 6% target margin after cost to serve, and a flag when a customer's profit after cost to serve falls by more than £5,000 a year. Nothing left Trentmere, and no decision changed, without one of its own people approving it. These events continue the fictional example.

Quarterly reruns
3
January, April and July 2027, after a test run at set-up
Flags raised
4
one a data problem, stopped before any figures were used
Customers newly worse
3
each named within the quarter it happened
Rules changed
0
the 6% target and the £5,000 fall stayed as set
DateWhat the agent foundFlag?What people decided
9 Nov 2026Test run at set-up, on the latest quarter's figures. The agent rebuilt the review from the same October exports, to 30 September; every figure matched and all checks passed.Note onlyNothing needed. The managing director read the note.
11 Jan 2027First quarterly rerun, to 31 December. No customer or product line newly worse but one. Kingfisher Sports Club's loss was down from £940 to £450 after two months at its 4% rise.Note onlyNothing needed for this part of the note.
11 Jan 2027Riverbank Works Canteen had moved to daily deliveries in September. Orders and deliveries were up from 240 to 310 a year, and it was newly below the 6% target, at 3.6% after cost to serve.FlagOffer deliveries three days a week with a minimum order; the sales manager agreed it with the canteen in February.
12 Apr 2027Dovebrook Care Group's new menus had moved its spend towards fresh produce, which earns less. Its profit after cost to serve was down £7,700 a year, more than the £5,000 set, though still above target at 13.6%.FlagAn account review with Dovebrook's catering manager in May, with a fixed-price fresh produce list. No change to the action plan meanwhile.
12 Jul 2027The cost pools no longer added up to the overheads: a second refrigerated van lease was in the accounts but not on Pools. Checks showed CHECK, so the note gave no figures.FlagThe finance manager added the lease to the Delivery pool. Checks passed again the same morning.
12 Jul 2027Hillside Village Café had needed 125 service calls in a year, most about its leased chiller, and newly lost money after cost to serve: −£850 a year.FlagHave the chiller replaced under the supplier's warranty and log service calls by cause; review at the October rerun before any price change.

At the 30-day check-in on 16 November, Geoff and the managing director read the set-up test run together and confirmed the two rules on Inputs. No rule needed changing. Geoff's upkeep ended there: the first real quarterly rerun, in January, and the agent and its log were Trentmere's.

What the agent added. The method is unchanged: the same pools, drivers, target and actions. The agent made sure the review was rerun every quarter, so a customer sliding towards a loss was named within the quarter it happened instead of at the next annual review. The benefit here is the result holding and problems caught earlier; no £ figure is claimed for it.

Fictional and labelled: these events continue the worked example. The same 6 events are the sample rows in the Agent log of the worked-example spreadsheet. The workbook's other sheets stay as at October 2026; each rerun was saved as its own dated copy. The agent is part of the guided and done-for-you routes; the self-implement kit does not include it.