Skip to content
Tool N13Available

Customer operations cost-to-serve analysis

See which customers cost more to serve than they bring in, where that cost comes from, and what to change for each group.

Ready to use. Buy it in your account: a one-time licence fee and a monthly fee, plus the AI it uses.

01

What it does

Upload a customer sheet (orders, revenue and, if you have them, support contacts, returns and margin) and say what one order, one contact and one return cost you. We work out each customer's gross profit, cost to serve and what is left, and group customers as profitable, thin or unprofitable, with where the cost comes from. The AI suggests practical actions for each group and what to do first, using only those figures and your notes. It never names individual customers in its advice.

Who it is for

  • Wholesalers, trade suppliers and service businesses with many accounts
  • Owners who suspect small orders or heavy support eat their margin
  • Anyone setting minimum orders or delivery charges
02

Quick start

  1. 01Export your customersA row per customer for a period, such as the last 12 months, as a CSV.
  2. 02Add your costsWhat handling one order, one support contact and one return costs you.
  3. 03Run itIt takes a minute. You can leave the page: the result waits in your run history.
  4. 04Start with what to do firstThen look at the actions for each group.
03

What you give it

Your customer sheet (CSV)Required, up to 1 files
Your customer sheet as a CSV, with customer, orders and revenue, and optionally contacts, returns and margin.
Cost of handling one orderOptional, 0 to 10000
What handling one order costs you: picking, packing, delivery and admin.
Cost of one support contactOptional, 0 to 10000
What one support call, email or chat costs you.
Cost of one returnOptional, 0 to 10000
What one return costs you: collection, checking and restocking.
Your gross margin (%)Optional, 1 to 95
Your gross margin, used when the sheet has no margin column.
Anything elseOptional, up to 1,500 characters
Anything else, such as free delivery over a set amount. Optional.
04

What you get

At a glance
Customers, revenue, cost to serve and what is left, worked out by us.
Customers by profitability
Each group's figures, where its cost comes from and actions to take.
What to do first
Three to five steps, quoting our figures.
Every customer
Each customer's figures and group, as a spreadsheet download only.

You can edit the result, then copy it, print it or download it as Word, Markdown, plain text or data. Every run is kept in your run history until you delete it.

05

An example

Millbrook Wholesale is a made-up business. Below is what was entered, then the tool's real result, unedited, made on 14 November 2026. Subscribe to run it with your own details.

What was entered

From Millbrook Wholesale’s Business profile

What you sell
Food and drink wholesale to cafés and shops in Devon
Your customer sheet (CSV)
  • customers.csv
Cost of handling one order

18

Cost of one support contact

6

Cost of one return

25

Your gross margin (%)

28

What customers.csv says
Customer,Orders,Revenue,Contacts,Returns
Harbour Café,24,9800,4,0
Northgate Deli,20,8600,6,1
Riverside Hotel,18,12400,3,0
Oak Tree Bistro,22,7200,5,1
Corner Shop,30,1200,10,3
Green Grocer,36,1290,13,4
Village Store,42,1380,16,5
Park Kiosk,48,1470,19,3
Station Café,30,1560,22,4
Market Stall,36,1650,10,5
Bakehouse,42,1740,13,3
Tea Room,48,1830,16,4
Garden Centre,30,1920,19,5
Farm Shop,36,2010,22,3
Bike Café,42,2100,10,4
Book Nook,48,2190,13,5

1 optional detail was left empty.

In your account this is a form you fill in, and the tool runs once you subscribe.

What the tool returned

In short

Profit is lost among the 12 unprofitable customers, who bring in £20,340.00 in revenue but cost £10,722.00 to serve, leaving a net of -£5,026.80. Their average order is only £43.46, and 78.6% of their cost to serve comes from orders. The 4 profitable customers bring in £38,000.00 and net £8,970.00, with an average order of £452.38.

At a glance

Customers: 16

Revenue: £58,340.00

Cost to serve: £12,392.00

Net after cost to serve: £3,943.20

Unprofitable customers: 12

Customers by profitability

Band 1

Band: Unprofitable

Customers: 12

Revenue: £20,340.00

Cost to serve: £10,722.00

Net: -£5,026.80

Average order: £43.46

Cost comes from: Orders 78.6%, contacts 10.2%, returns 11.2%

Actions

  1. Set a minimum order value, as the average order of £43.46 sits against a cost of £18.00 per order and a gross margin of 28%.
  2. Add a delivery or handling charge on small orders, since orders make up 78.6% of their cost to serve.
  3. Encourage fewer, larger orders, for example by offering a regular weekly or fortnightly ordering slot.
  4. Look at returns, which are 11.2% of cost at £25.00 each, and set up self-service for routine queries, as contacts are 10.2% of cost at £6.00 each.

Band 2

Band: Profitable

Customers: 4

Revenue: £38,000.00

Cost to serve: £1,670.00

Net: £8,970.00

Average order: £452.38

Cost comes from: Orders 90.5%, contacts 6.5%, returns 3%

Actions

  1. Keep these 4 customers well served, as they net £8,970.00 on £38,000.00 of revenue.
  2. Protect their large orders, with an average of £452.38, by keeping ordering simple and reliable.
  3. Keep returns and contacts low, at 3% and 6.5% of cost, by fixing any problems early.
  4. Ask about their future needs and offer other products from your range to grow their orders further.

What to do first

  • Introduce a minimum order value for the 12 unprofitable customers, whose average order is £43.46.
  • Add a delivery or handling charge on small orders, because orders are 78.6% of their cost to serve.
  • Review prices for this group, as they net -£5,026.80 against a gross margin of 28%.
  • Reduce returns (£25.00 each) and routine contacts (£6.00 each) with clearer product information and self-service.
  • Protect the 4 profitable customers, who net £8,970.00.

How it was worked out

  • Gross profit is each customer's revenue at their margin (from the sheet, or your gross margin).
  • Cost to serve is their orders, support contacts and returns at the costs you gave.
  • Net is gross profit less cost to serve. Unprofitable means below zero; thin means under 10% of revenue.
  • Costs you did not give count as nothing, so the net is a best case.
06

What the AI does

It does

  • Suggests actions for each group of customers
  • Writes what to do first, quoting our figures
  • Uses your notes, such as your delivery terms
  • Never names individual customers or works out figures

It does not

  • Know your true costs if you leave them out
  • Explain why a customer orders the way they do
  • Contact customers for you
  • Change your prices

Please check itCheck your costs per order, contact and return before acting, because every figure depends on them.

07

Limits

  • Your customer sheet (CSV): up to 1 files.
  • Cost of handling one order: 0 to 10000.
  • Cost of one support contact: 0 to 10000.
  • Cost of one return: 0 to 10000.
  • Your gross margin (%): 1 to 95.
  • Anything else: up to 1,500 characters.
  • Costs you leave out count as nothing, and the result says so.
  • Your workspace's monthly cap: a run that would take you over it pauses, and carries on where it stopped when you raise the cap.
08

Your data

  • What you enter, the files you choose and the result are stored encrypted with your workspace's own key. Only people in your workspace can open them.
  • To produce the result, what you give the tool (and the parts of your Business profile it uses) is sent to our AI provider, Anthropic. It uses it only to answer, and its terms do not allow it to train its models on it. We do not train on it either.
  • Files you upload are deleted after 30 days unless you choose to keep them. You can delete a run at any time: what you entered, the result and the progress notes go; only the usage record stays, because it is part of your billing.
  • Our service is hosted in the United States.

The full details are in our privacy notice.

09

Questions

How are runs charged?

A one-time licence fee of $1,200 (£1,200 in the UK), then $300 a month (£250 in the UK), including any tax that applies. On top, you pay for the AI each run uses, billed each month with your invoice and never more than the monthly cap you set. From your fourth tool there is no licence fee.

Can I change the result?

Yes. Choose Edit this result to change any wording or figure, and Restore the original result to go back. Copy, print and downloads use your edited version.

Is it ready to use now?

Yes. Sign in, open Tools in your account and choose Get started for this tool.

Will it tell me to drop customers?

No. It suggests changes such as minimum orders, delivery charges or self-service, and leaves decisions about customers to you.

Where do I find my costs?

A rough figure is fine: divide a month's delivery, packing and admin costs by that month's orders, and do the same for support and returns.

10

If something goes wrong

The sheet could not be read.
Make sure it has columns named Customer, Orders and Revenue.
Every customer looks profitable.
Add your costs per order, contact and return; without them the cost to serve is nothing.

Still stuck? Use the enquiry form and say which tool and what you saw.