“Which customers lose us money?”
Two customers on a flat national rate lose money on every pallet to Scotland, the Highlands and central London.
Industries · Logistics
Know what every pallet really earns.
Prism joins up your consignments, network charges, fuel, fleet and finance into one live view of profit by customer, lane and vehicle. See where the money leaks out, and ask about it in plain English.
Profit by customer and laneFuel surcharge recoveryExtras asked for vs charged
Depot overviewIllustrative data
14.8k+3.1%
£38+1.6%
71%−9 pts
Revenue by month£k
Ask Prism
Why did we lose money last quarter?
Fuel surcharge stayed at 4.5% while diesel rose 17%, and three customers on all-in rates pay none. That alone under-recovered £34k.
Ask about your numbers…
Ask Prism
The questions transport directors ask.
Ask Prism answers from your own consignment, network, fleet and finance data, all joined up.
“Are we charging for tail-lifts?”
Not often. Tail-lift was asked for on 6,409 consignments last quarter and charged on 1,729. Across all extras, £24k went unbilled.
“What is our oldest truck really costing us?”
T03: gearbox and turbo repairs, spot hire while it was off the road and late-hub penalties came to £18k this year.
“How do we compare with other depots?”
Above the median on price and pallets per driver, below it on fuel recovery, failed deliveries and cost per pallet.
Illustrative examples
Rounds on a map
Where every round earns and loses.
Every delivery round costed from telematics, fuel cards and payroll, and drawn over your own delivery area. In the portal you can colour it by round, cost per stop or failed deliveries, and click a round to trace it.
Rounds, £ a day
- Spalding & Holbeach17 drops · 71 mi+£307
- Peterborough north15 drops · 98 mi+£189
- Peterborough south14 drops · 103 mi+£151
- Boston14 drops · 111 mi+£128
- Wisbech & March13 drops · 130 mi+£44
- Lincoln14 drops · 172 mi+£30
- Bourne & Stamford11 drops · 113 mi+£10
- Grantham & Sleaford12 drops · 153 mi−£25
- Lincolnshire Wolds8 drops · 187 mi−£160
- Skegness coast8 drops · 181 mi−£179
Skegness coast drives 181 miles a day for 8 drops and loses £179 a day. Running it three days a week, with Boston covering the other two, would save about £9.1k a quarter.
Illustrative data
Dashboards included
Built around how logistics runs.
A starting set of dashboards modelled on a pallet network depot, then shaped to your depots, customers, fleet and network.
Depot overview
Pallets in and out, revenue, profit and service on one page.
- Profit
- vs last year
- Break-even
- pallets a day
Monthly P&L
Your P&L by month, line by line, from network income to vehicle costs.
- Net profit
- by month
- Cost lines
- vs budget
Customers and lanes
Profit by customer after network charges, collection and trunking.
- Profit
- per pallet
- Lanes
- region × size
Fuel and surcharge
Diesel price against the surcharge you charge, by customer.
- Fuel recovery
- %
- Under-recovered
- £
Surcharges and extras
Tail-lift, pre-warn and timed bookings asked for against charged.
- Extras
- asked vs charged
- Unbilled
- £
Fleet and drivers
Cost per vehicle, repairs, utilisation and pallets per driver.
- Cost
- per vehicle
- Pallets
- per driver
Service quality
On-time delivery, failed deliveries, PODs and hub penalties.
- On time
- %
- Penalties
- £
Network benchmarks
How your depot compares with the network on price, cost and service.
- Rank
- by measure
- Gap
- to median
Connects to the systems you already run
Pallet network and consignment systemsTransport management (TMS)Telematics and tachographFuel cardsWorkshop and maintenanceCustomer tariffs and rate cardsAccounting softwareSpreadsheets
Automations
Your data already knows the answers. Prism tells you before you think to ask.
Sent from the same reconciled data as the dashboards. Each person only receives the figures they are allowed to see.
Daily depot flash
Yesterday's pallets in and out, failed deliveries and hub penalties, against the same day last year.
Extras not charged
Consignments where a tail-lift, pre-warn or timed booking was asked for but not billed, sent to the office in time to add them.
Fuel surcharge alert
When the diesel price passes your trigger, the new surcharge and the customer letter are ready to send.
Monthly P&L pack
Your management accounts filled from the network statement, fuel cards and ledger, ready for the finance team.
How it works
From scattered systems to one view.
Connect
Read-only links to your network exports, transport system, fuel cards, telematics and accounts. Nothing to replace.
Model
Every consignment priced against your tariff and the network charge, joined to customers, lanes and vehicles, and checked against your own figures.
Launch
Your portal, in your branding. The traffic office sees today, directors see everything.
Ask
Directors question the numbers in plain English, and the daily flash, alerts and monthly pack send themselves.
Book a demo
See a logistics portal in 30 minutes.
We will walk you through a full demo for a pallet network depot, then talk about your customers, fleet and systems.