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.
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.
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.
A 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.
See the number for your business.
The Profit Check estimates where your cost to serve is hiding in five minutes, with no data upload.
Take the Profit Check