Skip to main content

Multi-Country Food Import Logistics & Supply Chain Platform

Business management and logistic platform for company which import and distribute food products like eggs, flour, sunflower oil etc. AI demand forecasting, optimized routing for full-size and last-mile trucks, multi-warehouse FEFO inventory, spoilage tracking and full P&L management.


Company operating warehouses in 3 countries and serving regional customers with a mixed fleet of full-size articulated trucks (for inter-warehouse and large customer deliveries) and smaller vans (for last-mile local distribution). Demand fluctuated significantly by season and customer, supply chains stretched across multiple countries and product shelf life created hard constraints on stock rotation.



Back to Case Studies
The challenge

Multi-country agricultural logistics
Control and Management

The operation was managed largely manually: route planning by phone, inventory tracked in country-specific spreadsheets, demand forecasting based on gut feel from sales managers. The results were predictable — sub-optimal route loading, spoilage from poor stock rotation, and cash tied up in excess warehouse inventory . Finance had no real-time picture of landed costs, margin by product or P &L by country.
The brief

Build an end-to-end logistics and supply chain platform: AI demand forecasting, optimised routing for both full-size trucks and last-mile vans (including multi-stop truck loads across 2–3 locations), warehouse inventory with spoilage tracking, and a full financial management layer covering all costs and revenue.

The solution

End-to-end platform from
demand forecast to delivered invoice

The platform covers the full supply chain cycle — from forecasting what customers will order next week to generating the invoice and recording the margin. Every module shares the same data model.
🤖
AI Demand Forecasting
ML model forecasts demand per customer per SKU (eggs by size/grade, flour by type, oil by pack size) using order history, seasonality, customer growth trends and external signals (local market events, holidays). 14-day rolling forecast updated daily — drives procurement and warehouse replenishment planning.
Per-SKU · Per-customer · 14-day rolling
🗺️
Full-Size Truck Route Optimisation
Optimises loads for articulated trucks delivering between central warehouses and to large customers. Solves the multi-stop problem: one truck can serve 2–3 drop locations if the combined load fills the vehicle and the route is efficient. Accounts for time windows, driver hours regulations (EU tachograph rules) and product compatibility constraints (no flour with unpackaged eggs).
VRP · Multi-stop · EU tachograph · Load optimisation
🚐
Last-Mile Van Routing
Daily route optimisation for local delivery vans from regional warehouses to smaller customers. Customer time window constraints, vehicle capacity and driver familiarity scoring. Dynamic re-routing when orders change or a delivery fails. Integration with Google Maps for live traffic-adjusted ETAs.
Daily VRP · Time windows · Dynamic re-routing · ETA
🏪
Multi-Warehouse Inventory
Real-time stock levels across all warehouses by product, lot, arrival date and expiry date. FEFO (First Expired First Out) picking rules enforced by the WMS layer — prevents avoidable spoilage. Inter-warehouse transfer recommendations when one location has surplus and another is at risk of stockout.
FEFO · Lot tracking · Inter-warehouse transfer
🥚
Spoilage &Loss Tracking
Every loss event recorded: breakage (eggs), moisture damage (flour), oxidation (oil), returns. Loss categorised by cause, location and responsible party. Supplier claims automatically generated for transit damage. Loss cost allocated to P &L and flagged for operational investigation above configurable thresholds.
Loss categories · Supplier claims · P &L allocation
💰
Financial Management &P &L
Full landed cost calculation per shipment: product cost, customs, freight, warehouse handling, last-mile delivery. Real-time gross margin per SKU, per customer and per country. Accounts payable (suppliers, carriers, warehouse operators) and accounts receivable (customers). Management P &L on demand — no month-end assembly from spreadsheets.
Landed cost · Margin by SKU/customer · AP/AR · P &L

Additional features we added based on operational insight

Customer order pattern analysis: flags customers whose ordering behaviour is deviating significantly from their historical pattern — early warning for churn or opportunity to upsell. Carrier performance tracking: on-time delivery rates, damage rates and cost per km per carrier — gives the procurement team objective data for carrier negotiations. Customs and compliance documentation: automated generation of import documentation templates per country and product type — reduces the administrative burden of multi-country EU import compliance.

Outcomes

Lower costs,
less waste, full financial visibility

Results measured 12 months post full deployment.
–18%
total transport cost through route optimisation and load consolidation
–31%
product spoilage and waste losses through FEFO and better forecasting
–24%
warehouse inventory value through AI-driven replenishment planning
Real-time
P&L per SKU, per customer and per country
Technology

Stack &architecture

Multi-tenant, multi-currency, multi-language. Built for the complexity of EU-wide agricultural trade.
Frontend
React + TypeScript
Operations dashboard, route planner, warehouse UI, finance
Backend
Python / FastAPI
Business logic, routing engine, forecasting model serving
AI / ML
Prophet + OR-Tools
Demand forecasting + Google OR-Tools for VRP optimisation
Maps
Google Maps Platform
Geocoding, distance matrix, live traffic ETAs
Infrastructure
AWS EU multi-region
Multi-country data residency, GDPR-compliant
Back to Case Studies

Managing logistic and distribution?

We develop solutions for logistic with any scale of complexity to reduce any manual operations as much as possible. Implementing AI and Computer Vision solutions in logistic and warehousing.