← All AI ROI products
Founder pricing
AI product · Profit and cash

Profit by Customer and Product

The AI works through your sales and cost exports to show which customers, products and services really make you money once all the costs are counted, and which ones to reprice, fix or stop.

About 6–10 hours of your time (estimate)Your sales, costs and time dataRun it yourself or with Geoff
What it answers

Four questions it answers

  1. 1

    What do we really make on each customer?After the costs that follow them.

  2. 2

    Which products carry the business?And which ones drag it down.

  3. 3

    What is losing money?Named, with the size of the loss.

  4. 4

    What do we do about it?Reprice, fix, or stop, for each one.

The Target Market Map finds your best types of customer to win more of; this product finds what each existing customer, product and service actually earns you.

Founder pricing. The method, the calculation spreadsheet with 16 built-in checks, and a complete worked example are built and tested. The first client for this product gets the founder price, in return for permission to measure the results and, if they are good, write them up as a case study. After that, the price goes up. Book a call to take the founder place.

What you get

What you get

Profit by customer, on one page

Gross profit and the cost to serve each customer, from your own data, with a one-page profit summary for you and your team.

Profit by product and service

Which lines earn their keep and which do not.

A reprice, fix or stop list

Each loss-maker with what stopping it would really do to profit, and your chosen action valued in £.

Reconciled to your accounts

Totals checked against your profit and loss account, so nothing is missing.

Honest about the estimates

Counts only the costs that would actually go, and says which figures are judgements.

A quarterly agent in your own accounts

With guided or done for you, the review is rerun every quarter in your own accounts against the target you set, and you are told if a customer or product line gets worse. Nothing leaves your business, and no decision changes, without one of your people approving it.

Worked example

A Staffordshire food wholesaler

A fictional 34-person wholesaler delivering to cafés, pubs, schools and care homes, with 28 customers and £3,330,000 of turnover. Its overheads were split by orders, deliveries, service calls, sales visits, picking and stock, and reconciled to the accounts.

Four small customers lose money after the cost of serving them, but stopping any of them would cut profit, because most of the delivery cost stays. The answer was to change the terms: price rises, a delivery charge, and fewer, larger orders.

Read the full example

Trentmere Foodservice LtdFictional · Worked example
Gross profiton £3,313,000 of sales
£839,590
Cost to serve customersorders, deliveries, calls and visits
£392,000
Profit from the top fifthof profit after cost to serve
59%
Customers losing money£6,387 a year between them
4
Profit change from the actionsa year, with owners and dates
£18,884
IllustrativeAll names and figures are invented. The shares of each cost that would go if an activity stopped are judgements, and price rises assume volumes hold.
How it works

Five stages

  1. Load

    Export sales by customer and product, and your cost lines.

  2. Allocate

    Share overheads fairly using drivers you agree, such as orders or hours.

  3. Rank

    See profit by customer and product, worst first.

  4. Decide

    Agree what to reprice, fix or stop, and the value of each.

  5. Keep

    Each quarter the agent reruns the review in your own accounts and flags any customer or product line that gets worse, so a new loss is caught early.

Three ways to buy

Do it yourself, with Geoff, or done for you

The same method and the same spreadsheet in every option. You choose how much of your own time goes in.

Self-implement kit

Run it yourself

For owners comfortable with a spreadsheet and an AI assistant.

  • The AI skill
  • The calculation spreadsheet
  • A worked example
  • The buyer's guide
Book a call
Guided implementation

Run it with Geoff

For owners who want a second pair of eyes on the data and the analysis.

  • Everything in the kit
  • Three working sessions
  • Geoff checks your cost allocations
  • Your profit summary, reviewed
  • The quarterly agent, set up with you in your own accounts; its test rerun on the latest quarter read together at the 30-day check-in
Book a call
Done for you

Geoff runs it

For owners who would rather hand over the data and get the answer.

  • Geoff builds the analysis in your own systems, from your exports
  • Reprice, fix or stop list with £ values
  • A two-hour session to agree decisions
  • Final files updated after the session
  • The quarterly agent set up in your account; its test rerun on the latest quarter reviewed with you at the 30-day check-in
Book a call
What you'll need

Data you already have

  • Sales by customer and product for the last 12 months
  • Your profit and loss account for the same period
  • A rough idea of where staff time goes
  • About 6–10 hours of your time over two weeks (estimate)
  • For the quarterly agent (guided and done for you): an AI assistant your business already uses or approves, that can run a scheduled task and connect read-only to your accounting system and your order, delivery and service records; we confirm this with your IT before you commit
Which AI?

Designed for Claude, in an open format

It is built on the open Agent Skills standard and designed for Claude (any plan, with code execution switched on). A paste-in version is included for ChatGPT, Gemini and Microsoft Copilot; it has not yet been tested on them.

The calculations live in the spreadsheet, not in the AI, so the numbers don't depend on which assistant reads them.

Know where your profit really comes from

Book a short call to talk through your customers and products.

Book a call
Geoff@fox.coach · 07770 683883 · fox.coach