Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. How Do We Put Picking Labour, Racking Space and Carrier Bills Against Each 3PL Client?
Problems We Solve

How Do We Put Picking Labour, Racking Space and Carrier Bills Against Each 3PL Client?

3PL revenue per client is easy to see, but labour, space and carrier cost per client are not. We build client margin reports from WMS, payroll and invoice data.

Updated 3 min readBy SpiderHunts Technologies

Free estimateNo obligation

Get a free estimate

Tell us what you need. A senior engineer reads every enquiry.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →

Quick answer — TL;DR

Most 3PLs know revenue per client to the penny and cost per client only as a feeling. The costs sit in different places: labour in rotas and agency invoices, space in the WMS, carriers in their invoices, packaging in purchase ledgers. We build a monthly cost-to-serve model that allocates those costs to clients using activity data from your WMS, so price reviews and renewal conversations start from numbers.

A good-looking client that is not

At the board meeting the biggest client by revenue is the one everybody points to. But the operations manager has a nagging feeling. Their orders are multi-line, their products are awkward, they send returns in bulk after every sale, and the account manager spends half a day a week on their emails. Meanwhile a smaller client with simple single-item orders never causes a problem.

Nobody can prove which one earns more, because nobody has put labour, space and carrier costs against each client in the same place.

Why cost per client stays hidden

Costs in a warehouse are shared. Pickers work for several clients in a shift, racking holds everybody's stock, the carrier bills one account for all of it. Allocating them needs activity data, and the activity data is in the WMS while the costs are in payroll, the agency invoices and the ledger.

CostWhere it livesHow it can be allocated
Picking and packing labourRotas, clocking, agency invoicesPick and pack activity per client from the WMS
Goods in and returns labourSame as aboveReceipt and return lines per client
SpaceRent, rates, racking depreciationLocation occupancy per client
Carrier costCarrier invoicesShipment matching by tracking number
Packaging and consumablesPurchase ledgerBox types and inserts per order
Account managementSalariesTime or contact volume, if recorded

Without this, pricing reviews rely on revenue alone, and clients with complicated work look as good as those with simple work.

What not knowing costs

Unprofitable clients get renewed on the same terms, sometimes with discounts. Profitable ones may be lost on price because you could not see the room you had. Operational decisions, such as who gets the prime pick locations or the best staff, are made without knowing which accounts can bear it.

It also affects which new clients you chase. If you cannot tell what kind of work pays, sales will keep bringing in more of whatever is easiest to sell.

The cost-to-serve model we build

  1. Activity data from your WMS each month: orders, lines, units, receipts, returns, value-added jobs and occupancy per client.
  2. Cost data from your accounts package, such as Xero, QuickBooks or Sage, plus payroll totals, agency invoices and carrier invoice lines.
  3. Allocation rules your finance team agrees: labour hours by activity counts weighted by standard times, space by occupancy, carriers by matched shipments.
  4. A monthly profit and loss per client with revenue from your billing, the allocated costs and the margin, with the method visible for each line.
  5. Trends per client over time, and a comparison of actual activity with what was assumed when the client was quoted.
  6. A simple scenario tool for price reviews: what happens to margin if a rate changes or the client's order shape shifts.

Allocation is always an approximation. The value is in using the same method every month, so changes are real, and in being able to explain the method to anyone who questions it.

What the management team gets

A shared, monthly view of which clients pay their way and why. Price reviews start with the client's own activity and cost. Account managers know where to spend their time. And sales can be pointed at the kind of client that suits your operation.

Signs you need a cost-to-serve view

  • Clients are ranked by revenue, not margin.
  • Price reviews use the original quote assumptions.
  • Labour and carrier costs are known in total but not per client.
  • Someone suspects a big client loses money, but nobody can show it.
  • You are not sure what kind of new client to look for.

FAQ

Frequently asked questions

The questions readers ask us after this guide.

Still have a question?

Ask us directly — a senior engineer will get back to you.

Ask about your project

How accurate is allocated cost?

It is an approximation using agreed rules. It is accurate enough to compare clients and spot trends, which is what pricing decisions need.

Do we need timesheets per client?

No. Activity counts from the WMS combined with standard times per activity give a workable split. If you do record time per client, we use it.

Who sees the numbers?

Access is set by you. Most keep client margins to the management team.

What drives the cost?

How many data sources are involved, the state of activity data in your WMS and how detailed your finance team wants the allocation to be.

What do you need from us?

Read access to the WMS activity data and your accounts, carrier invoices, and time with your finance lead to agree the allocation rules.

Keep reading

More on Problems We Solve

Start here

Tell us where your 3PL operation leaks time or money

Describe the problem, the WMS you run, and how many clients it touches. We will tell you what we would build around your warehouse system, and if a setting in your WMS or a smaller change would fix it, we will say so.

  1. You tell us what you needTwo minutes on the form, or a message on WhatsApp.
  2. A senior engineer reviews itAnd comes back with questions, a realistic range and an honest view on fit.
  3. Free 30-minute scoping callWe talk through scope, options and a realistic estimate — with no obligation.
Free estimateNo obligation

Talk to someone who builds this

Send a short brief and we will come back with an honest view and a realistic range.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →