How to calculate cost to serve, step by step.
Cost to serve is the full operational cost of fulfilling a customer's orders, once picking, packing, shipping, support, returns and account admin are counted, not just the cost of the goods. You calculate it by timing each activity, costing that time, and attributing it to the orders and customers that triggered it. Here is the exact method we use, and the point where a spreadsheet stops working.
Net contribution = revenue − cost of goods − cost to serve.
List the activities that actually serve the order
Start with the journey of an order, not the chart of accounts. A typical path is receive, pick, pack, ship, handle support and returns, and run account admin. Five to eight activities is usually enough. The goal is to name the work that consumes cost, in the language the operation already uses.
Time each activity
Estimate the minutes each activity takes for a normal order, then adjust for what makes orders different: size, number of lines, channel, fragility, special requests. This is the heart of Time-Driven Activity-Based Costing. A short time equation, such as 2 minutes per order plus 0.4 minutes per line, captures real variety without surveying everyone. The cost driver library lists which driver to use for each activity, from picking to invoicing.
Cost the time
For each resource pool, warehouse, transport, customer service, take its total cost and divide by its practical capacity in minutes (not theoretical, around 80 to 85 percent of paid time). That gives a defensible cost per minute. The capacity you do not use becomes visible here, instead of hiding inside an inflated rate.
Attribute cost to order, then to customer
For every order, multiply the minutes each activity consumed by that activity's cost per minute, and sum. Roll the orders up to the customer. Now each customer carries the real cost of the way they buy: many small urgent orders cost far more than one planned bulk order of the same value.
Compare to revenue and rank
Set cost to serve against the revenue and gross margin each customer brings. Rank them best to worst and the pattern appears: a profitable core, a flat middle, and a tail that quietly gives margin back. That ranked picture is the whale curve, and it is where the decisions start.
A worked example
Take one wholesale customer billing 240,000 euro a year, on goods that cost 168,000, so the gross margin is 72,000 euro, a healthy 30 percent. Now cost the way they actually buy. Their 320 orders, deliveries, support calls and returns consume, across warehouse, transport and service, about 30,000 minutes of capacity in the year. At a fully loaded 0.80 euro per minute, that is roughly 24,000 euro of cost to serve.
Illustrative. Cost to serve quietly eats a third of this customer's gross margin. Give the same revenue to an account that splits it into many small urgent orders with frequent returns, and those 30,000 minutes can double, turning a 20 percent net margin into a loss without a single price changing.
The calculation template, ready to fill in.
The five steps above, laid out as a working file: activities, time equations, cost per minute, attribution and the final ranking, with the worked example already in place. Open it in Excel or Google Sheets and replace the example with your own numbers.
Download the template (CSV)WHERE A EURO OF REVENUE GOES
Illustrative. Cost of goods is only the first step down. The four costs of serving, usually invisible in a standard P&L, are what separate a profitable customer from a loss-making one of the same size.
What does cost to serve typically run?
Honestly: nobody can tell you yet. We have looked for a public benchmark of cost to serve as a share of revenue, by sector, and it does not exist. Consultancies quote it in private decks, ERP vendors imply it in case studies, and no one publishes the distribution. So we are building it.
The Cost-to-Serve Index is collecting, in defined ranges rather than exact figures, how much of revenue goes to serving customers, which activities drive it, and how confident finance teams are in their own number. Every response sharpens the picture. Once the sample per sector is large enough to be meaningful, the bands will be published here, on this page, with the method open for inspection.
Eight minutes of questions, no data upload. Contributors receive the full report when it is published, with their position against their sector.
Take the Cost-to-Serve IndexA spreadsheet can show you the number once. It cannot show it to you every month, for ten thousand customers, in a way a board will trust.
The method above is honest work, and a capable finance team can build a first version in Excel. The limit is not the maths, it is the maintenance. The moment the model has to be rerun monthly, survive a data refresh, and be explained line by line to people who will act on it, manual spreadsheets break. That is the point where we build a model that updates itself and that your team owns afterwards.
Common questions
- What data do I need to calculate cost to serve?
- Less than people expect. You need order and line counts per customer, a view of the activities that fulfil an order, the total cost of each resource pool (warehouse, transport, customer service) and a sensible estimate of how long each activity takes. Most of this already exists in your ERP exports and operational records.
- Can I calculate cost to serve in Excel?
- For a single snapshot, yes, and it is a good way to learn. A spreadsheet stops working when the model has to be rerun every month, cope with thousands of customers, or be trusted by a board. At that point the manual links break and no one can explain a number. That is when a maintainable operating model earns its keep.
- How long does it take to build a cost-to-serve model?
- A focused diagnostic runs in a few weeks. A full operating model typically lands in three to six weeks, built alongside your finance team so they own it and can update it afterwards.
- What is the cost-to-serve formula?
- For each customer, cost to serve is the sum across all activities of the minutes that customer's orders consumed multiplied by the cost per minute of each activity. Net contribution is then revenue minus cost of goods minus that cost to serve.
Build the time equation yourself.
Adjust the parameters of one order and watch the cost to serve recalculate, term by term. Figures are illustrative.
Sources
Canonical works behind this method. Each opens in a new tab.
- BookTime-Driven Activity-Based Costing: A Simpler and More Powerful Path to Higher ProfitsKaplan, R. S. & Anderson, S. R. (2007). Harvard Business School Press.Book-length treatment of TDABC with implementation cases.
- PaperTime-Driven Activity-Based CostingKaplan, R. S. & Anderson, S. R. (2004). Harvard Business Review 82(11).The founding article defining TDABC and its two-parameter model.
- PaperThe Cost-to-Serve MethodBraithwaite, A. & Samakh, E. (1998). International Journal of Logistics Management 9(1).Seminal paper that formalized the cost-to-serve method.
- PaperCost-to-serve measurement and customer profitability analysisGuerreiro, R., Bio, S. R. & Merschmann, E. V. V. (2008). International Journal of Logistics Management 19(3).Peer-reviewed case linking cost-to-serve measurement to customer profitability.
- PaperMeasure Costs Right: Make the Right DecisionsCooper, R. & Kaplan, R. S. (1988). Harvard Business Review 66(5).Seminal argument that averaged overhead distorts true product and customer cost.
See the number for your business.
The Profit Check estimates where your cost to serve is hiding in 12 to 15 minutes, with no data upload.
- Duration
- 12 to 15 minutes
- You receive
- Score, 7 dimensions, sector benchmark
- Price
- Free, no email needed
Proof
A distributor in New Zealand. €1.335M of cost-to-serve made visible, then halved, and 830 loss-making customers brought down to 295.
Read the case study →Who you would be talking to
Miguel Guimarães, Founding Partner
Cost and profitability practitioner for 25+ years. Lectured alongside Professor Robert S. Kaplan at the CFO conference in Amsterdam (2009).
Call +351 910 313 731
