- Background & Overview
- Executive Summary
- Data Structure Overview
- Insights & Deep Dive
- Recommendations
- Caveats
Precision Logistics is a UAE based logistics company founded in 2018, they move goods for their clients across key commercial hubs.
Despite a healthy top line, profitability kept tightening and management had no structured way to pinpoint where the losses were coming from.
This analysis was conducted to identify where exactly margin was being lost across jobs, clients, and routes. Which would let the business make informed decisions on pricing, contract management, and operations.
To make those findings actionable rather than arbitrary, performance thresholds were used as part of the analytical framework. Each job type carries a margin target, and any job falling below it is classified as off-target. At the client and route level a 40% threshold was applied, meaning a client or route is only flagged for reassessment when 40% or more of it's jobs are off target, not just occasionally. This distinction separates structural underperformance from normal variation and ensures the analysis points to where the business genuinely needs to act.
Precision Logistics generated AED 8.75M as revenue across 250 jobs in 2025 but earned only AED 1.40M in margin AED 621.80K below what was expected. This shortfall is directly linked to cost overruns, 83.6% of jobs exceeded their estimated cost and 57.2% failed to meet their margin target. The problem is not isolated, it is consistent across clients and routes throughout the year. This points to a systematic gap between how jobs are priced and what they actually cost to run. 5 out of 19 clients have an off-target rate of above 70%. Several routes show a 100% off-target rate. Until the current pricing model is changed and reflects actual operational costs, margin will continue to erode regardless of revenue performance.
The entire analysis is built on a single flat table, JobsMaster with one row per job. There are no secondary tables or relationships. Every field needed for the analysis either existed in the source data or was derived from it.
Precision Logistics generated AED 8.75M as revenue in 2025 but earned only AED 1.40M in actual margin against an expected AED 2.02M leaving AED 621.80K unrecovered. The margin erosion chart confirms this gap was present every single month, not a seasonal anomaly.
The numbers behind it:
- 83.6% of jobs (209/250) exceeded their estimated cost.
- 57.2% of jobs (143/250) failed to meet their margin target.
- 27 jobs were outright loss-making.
The business is not losing margin occasionally. It is losing margin as a default outcome.
The majority of the client base breaches the 40% off-target threshold. The most damaging combination in the portfolio is high volume and high off-target rate, Aramex MENA has both. As the largest client by revenue, its 14 off-target jobs carry more financial weight than any other account. Al Futtaim Logistics compounds this further with the lowest margin rate in the portfolio at 12.05% nearly 4 points below the 15.88% average while having a 75% off target rate. Across 19 clients, only Sharaf Shipping and Gulf Agency Company are operating below the 40% threshold, meaning just 2 out of 19 clients can currently be considered structurally healthy.
Of 63 active routes, 12 show a 100% off-target rate, not a single job on these corridors met its margin target. That is not bad luck. That is evidence that the cost assumptions built into the pricing for these routes bear no relationship to what they actually cost to run. At the opposite end, routes like Al Ain → Dubai Logistics City (23.05%) and Ras Al Khaimah → Sharjah (22.42%) are consistently delivering above the portfolio average of 15.88%. The gap between the best and worst routes is not marginal — it is the difference between a business that works and one that doesn't.
27 jobs didn't just underperform, they cost the company money to execute. Every delivery on these jobs generated a loss, meaning Precision Logistics was effectively paying to serve those clients. But the loss-making jobs are only part of the story. The more serious problem is many jobs were still over the estimate despite remaining profitable. They made money, just less than they should have. Individually each gap looks small. Collectively, they account for the majority of the AED 621.80K variance loss. This is the silent margin leak and it is the hardest to see until you look at every job individually.
-
Reprice structurally weak clients first -
Prioritise clients with high volume and high off‑target rates for immediate pricing review. Use the dashboard to show each client their historical cost variance and margin performance to support rate increases or revised terms -
Introduce minimum margin thresholds in contracts - Set clear clauses for fuel, tolls, or other volatile costs. For clients persistently breaching the 40% off‑target threshold even after repricing, consider reducing exposure or exiting unprofitable lanes.
-
Fix or exit 100% off‑target routes -
For the 12 routes where every job misses margin targets, trigger a route-level review. Check typical load factors, empty return legs, tolls, waiting times, and subcontractor rates. Decide per route whether to reprice aggressively, change the operating model (different vehicle, timing, or consolidation) or stop offering that lane unless specific conditions are met. -
Protect and replicate best‑performing routes -
Use high-margin lanes such as Al Ain → Dubai Logistics City and Ras Al Khaimah → Sharjah as benchmarks for target utilisation, pricing discipline, and planning. Where possible, route more volume through these profitable corridors or design new products around them. -
Update the costing model using actuals -
Replace old estimates with data‑driven cost curves by route, vehicle type, and job type, using the last 12 months of actual cost data. Explicitly include all recurring extras (waiting, handling, last‑mile complexity) so that estimates reflect reality. -
Enforce a pre‑booking margin check -
Build a simple check where sales can only confirm a job if the estimated margin meets or exceeds the target % for that client and route. Any job below target should require manager approval and a documented reason -
Use the dashboard as a monthly margin review pack -
Formalise a monthly “Margin Review” where management walks through the 4 dashboard pages. Track how total variance loss and off‑target rates move after pricing or operational changes. -
Set Clear KPI targets -
Short term targets like reducing jobs over estimate from 83.6% to below 60% and reducing off‑target jobs from 57.2% to below 40%. Medium term targets like recovering at least 50% of the current AED 621.80K variance loss through repricing and route optimisation.
The findings should be interpreted with the following limitations in mind -
-
The dataset is a single denormalised table, so there is no separate relational model for customers, routes, pricing contracts, or operational events.
-
The analysis covers 2025 only, so findings reflect one reporting period rather than a multi-year trend.
-
The 40% threshold is a business rule chosen by the company for decision-making, not a statistically optimised cutoff.
-
Low-volume clients and routes will be sensitive to the small number of jobs.
-
The analysis identifies where margin is being lost, but it does not by itself prove the exact operational cause, such as fuel, labour, delays, routing inefficiency, or contract pricing design.
Overall, the aim is to turn the dashboard into a decision tool that helps the business protect margin, not just measure it.