Value tree · Logistics & freight forwarding

The logistics & freight forwarding value tree

Freight is bought and sold as capacity on a lane. Margin is made per shipment, in a spread that is small, and lost in the accessorials, demurrage and empty legs that no single system totals up.

Drivers 24 across four branches See also Supply Chain 360 Metrics 12 linked

01 The same tree, this industry

Where the money is made and lost here

The structure does not change: value is profit plus how well that profit becomes cash, profit is revenue minus cost, and revenue is price times quantity. What changes is which drivers sit underneath each branch, and which system holds them. If you have not read the general version, start with the Enterprise Value Tree and come back.

What is different here

The defining problem is that one shipment touches a dozen parties — shipper, carrier, terminal, customs broker, agent, consignee — and each holds one fragment of its cost. The shipment is the unit of margin, and almost no forwarder can produce its true profit without a manual exercise.

Every driver below names the metric it lands on. Follow one and you get its formula, the system the number lives in, and the ways it is commonly misread.

06 Where the numbers live

The systems behind the branches

A value tree is only usable once each box maps to a system and a record. These are the six that matter most in logistics & freight forwarding: what each one is actually for, the records inside it the tree depends on, and which branch it feeds.

SystemWhat it holdsKey recordsFeeds
Freight forwarding / TMSThe shipment of record: booking, routing, documents, milestones and the charges attached to each leg.Shipment, Consol, Leg, Charge code, MilestonePrice, quantity, cost
Rate and contract managementBuy rates, sell tariffs, allocations and surcharge formulas, by lane and validity period.Rate, Lane, Contract, Surcharge, ValidityPrice, cost
Customs and complianceDeclarations, classifications and the screening that gates a shipment moving at all.Declaration, HS code, Party, Screening resultCost, quantity
Warehouse / CFSWhat is physically in the facility: consolidation, deconsolidation and the handling that gets billed.Stock item, Handling event, Location, ConsolCost, price
Finance / ERPInvoices, cost accruals and the shipment-level profitability the rest of the business argues about.Invoice line, Accrual, Cost centre, JobPrice, cost, cash
Track and trace / EDICarrier and terminal messages: the events that prove service and start the demurrage clock.EDI message, Event, Container, ETA/ATAQuantity, cost

Almost every hard question in logistics & freight forwarding needs two of these joined. That join — not the calculation — is the work.

07 Where it leaks

Value lost between two systems

These are the losses that no single system can see, because the evidence is split across two of them. Each one is a real number that stays invisible until the join exists — which is why the tree is an integration exercise before it is an analysis one.

Where value leaksWhy it happensThe join that finds it
Shipment profit at standard cost, not actualThe job is costed on accruals at booking and the real carrier and terminal invoices arrive weeks later. Lane decisions are made on the estimate.Join the actual cost document to the shipment job, and re-close it
Demurrage paid, never recoveredThe charge arrives from the carrier while the evidence of who caused the delay sits in milestone events nobody joined to it.Join EDI milestone events to the demurrage charge and the responsible party
Accessorials earned and not billedWaiting time and special handling happen in operations and are billed from a document that never records them.Join the handling event in the warehouse system to the charge code on the job
Lane profitability only in aggregateReporting rolls up to trade or region, so a loss-making lane hides inside a profitable trade for years.Cost and report at shipment level, then aggregate — not the other way round
The same customer under many codesA global shipper is a different account in every origin office, so tender pricing is set without knowing the total relationship.Resolve customer to a global parent across every office and system

08 Worked example

A record volume year at a thinner spread

In practice

Volume grew 14% and gross profit per shipment fell. The tree separates it: buy rates rose faster than the sell tariff was repriced, consolidation ratio slipped on two trades, and demurrage paid but not recovered absorbed most of what was left. All three are visible only once actual cost documents are joined to the job.

ComponentEffectWhat sits behind it
Volume+€4.1m14% more shipments at the prior spread
Buy rate inflation−€2.7mRepriced late on contracted lanes
Consolidation slip−€1.3mConsole fill down on two trades
Demurrage not recovered−€0.9mCharged by carriers, not passed on
Unbilled accessorials−€0.4mPerformed in operations, never invoiced
Net−€1.2mMore freight moved, less profit made

Illustrative figures, shown to demonstrate the split. The point is the shape of the walk, not the numbers — on your own data the same bridge is built from your ledger.

09 Diagnostics

Six questions to ask in logistics & freight forwarding

Ask them of your own team before anyone asks them of you. In most organisations at least two of these cannot be answered without a manual exercise, and those two are the plan.

  • Can you produce true profit for one shipment, including every actual cost document?
  • How much demurrage did you pay last quarter, and how much of it was recoverable?
  • Which lanes lost money last month — and would two of your offices agree on the answer?
  • Is the same global shipper one customer in your systems, or one per office?
  • What proportion of accessorial work performed was actually invoiced?
  • How long after delivery does a job close financially, and what is waiting for?

11 Questions

Frequently asked

Why is shipment-level profitability so hard?

Because the costs arrive after the job is done, from different parties, in different currencies, against a reference that is not always the shipment number. The arithmetic is trivial; matching the cost document to the job is the work.

What does entity resolution change for a forwarder?

It turns twelve local accounts into one global customer, which is the only way to price a tender knowing the total relationship and the total cost to serve it.

Is consolidation ratio really a margin metric?

In LCL it is the margin metric. The box costs what it costs; every additional cubic metre in it is close to pure contribution, which is why a point of fill outperforms a point of rate.

Where should a forwarder start?

One trade lane, with actual cost documents joined to the job. It produces a defensible shipment P&L in weeks and usually finds recoverable demurrage that pays for the work.

See this tree on your own data

Connect the systems above, define each box once, and the tree stops being a slide.

Book a live demo