Ügyfélelemzés
Analytics & Business Intelligence
ML churn detection · lane margin analysis · OTD · fuel cost · driver utilisation — Hungary market
High Churn Risk Customers
2
Revenue drop >20% in 3m
Loss-Making Lanes
1
2 more below 5% margin
Avg On-Time Delivery
91%
Target 95%
Peak Fuel Absorption
12.5%
Of revenue (strategic cap 11%)
AI Actions Recommended
- Kékkörláт Logisztika revenue dropped 50% in 3 months — highest churn risk. Immediate outreach recommended with loyalty pricing.
- Budapest→Győr LTL lane is loss-making at –4.7% margin. Review subcontractor tariff or renegotiate rate.
- Fuel absorption rose to 12.5% in March — above the 11% strategic cap. Consider a dynamic fuel surcharge clause on new contracts.
- OTD underperformed target every month. Root cause: Nagy Péter and scheduling gaps on Budapest→Miskolc reefer.
Customer Churn Analysis
Revenue trend last 4 months — customers with >10% drop flagged
Lane Margin Analysis
Revenue, cost and margin per freight lane — negative margins highlighted
| Lane | Type | Revenue | Cost | Margin | Margin % | Volume | Trend |
|---|---|---|---|---|---|---|---|
| Budapest → Bécs | FTL | 205k HUF | 198k HUF | 7k HUF | 3.3% | 48 | |
| Debrecen → Bécs | FTL Bulk | 289k HUF | 241k HUF | 48k HUF | 16.5% | 22 | |
| Budapest → Győr | LTL | 68k HUF | 71k HUF | -3k HUF | -4.7% | 87 | |
| Budapest → Miskolc | Reefer | 112k HUF | 104k HUF | 8k HUF | 7.1% | 34 | |
| Pécs → Budapest | Express | 89k HUF | 89k HUF | 500 HUF | 0.6% | 19 |
Margin % by lane
On-Time Delivery (OTD)
Monthly OTD % vs target
Fuel Cost Absorption
Fuel as % of monthly revenue — cap 11%
Driver Utilisation
Trip count, utilisation %, OTD rate and penalty fines YTD
| Driver | Trips YTD | Utilisation | OTD % | Penalty Fines YTD |
|---|---|---|---|---|
| Kovács László | 42 | 91% | 97% | — |
| Nagy Péter | 38 | 83% | 89% | 45k HUF |
| Horváth Béla | 29 | 63% | 93% | — |
| Szabó Gábor | 44 | 96% | 95% | 22k HUF |