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.
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.
| Activity | Full cost | Would 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.
| Customer | Sales | Profit after cost to serve | If stopped, a year | Decision | Evidence |
|---|---|---|---|---|---|
| Kingfisher Sports Club Pubs | £74,000 | −£940 | −£9,378 | Reprice | Extra Sunday deliveries at no charge since 2023. |
| Wren Cottage Tea Room Cafés | £24,000 | −£1,065 | −£4,100 | Keep | On 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,894 | Reprice | Small drops twice a week across town; pays below list. |
| The Red Lion, Elmford Pubs | £29,000 | −£2,208 | −£3,262 | Reprice | Loses 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.
| Customer | Action | A year | Owner | By when |
|---|---|---|---|---|
| The Swan Inns | Fix the cost to serve | £3,903 | Sales manager | January 2027 |
| Kingfisher Sports Club | Reprice | £2,960 | Sales manager | November 2026 |
| The Plough at Hollinbrook | Reprice | £2,640 | Sales manager | November 2026 |
| Bramble & Bean Coffee House | Fix the cost to serve | £2,559 | Operations manager | January 2027 |
| Riverside Café Company | Fix the cost to serve | £2,552 | Operations manager | February 2027 |
| The Red Lion, Elmford | Reprice | £2,320 | Managing director | January 2027 |
| Mill Lane Bistro | Reprice | £1,950 | Sales manager | December 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.
Gross margin less picking and stock-holding costs, by product line.
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.
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.
| Date | What the agent found | Flag? | What people decided |
|---|---|---|---|
| 9 Nov 2026 | Test 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 only | Nothing needed. The managing director read the note. |
| 11 Jan 2027 | First 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 only | Nothing needed for this part of the note. |
| 11 Jan 2027 | Riverbank 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. | Flag | Offer deliveries three days a week with a minimum order; the sales manager agreed it with the canteen in February. |
| 12 Apr 2027 | Dovebrook 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%. | Flag | An 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 2027 | The 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. | Flag | The finance manager added the lease to the Delivery pool. Checks passed again the same morning. |
| 12 Jul 2027 | Hillside 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. | Flag | Have 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.