Unified inventory and export platform for an air-cargo logistics provider

The client – a global provider of aviation cargo equipment – ran procurement and shipping on fragmented Excel spreadsheets. Procurement was reactive, triggered by shortages instead of forecasts, and 20-week supplier lead times made recovery from stockouts brutal. Demand spikes went undetected, $500K+ in safety stock sat idle, and 40+ staff hours per week were spent maintaining inventory in Excel.

Shipping operations were equally constrained. A single Excel master sheet served as the export consolidation backbone, with 2-3 hours of manual data entry per shipment and version conflicts whenever multiple users edited at once. Manual PDF generation produced inconsistent customer-facing documents, and the workflow capped out at roughly 300 shipments before throughput collapsed.

We delivered a unified cloud platform bridging procurement and logistics on a shared authentication, API, and database foundation. Phase 1 shipped as parallel delivery in 16 weeks, replacing both surfaces simultaneously rather than sequencing them across 24 weeks of overhead.

On the inventory side, the platform ships ABC classification (auto-categorising items by value and velocity), Z-score anomaly detection flagging irregular demand patterns, dynamic reorder-point monitoring with critical and warning alerts, and one-click PO generation with optimised MOQs and lead times. A human-in-the-loop review queue keeps SMEs in control of edge cases and special projects.

On the export side, intelligent ingestion pulls ERP data straight into shipment dashboards, automated field mapping fills shipping fields from master databases, and one-click documentation produces compliance-validated invoices and packing lists in under 15 minutes. Real-time tracking spans every shipment from draft to delivered, with integrated e-signature and e-stamp workflows.

Tech stack: cloud-native architecture with shared auth, API, and data layers underpinning both modules, plus statistical analysis and rules engines for the inventory intelligence layer.

The platform unlocks a $1.55M annual benefit and a 530–710% three-year ROI, with payback inside 4-6 months. 3,000+ staff hours per year are returned to higher-value work – a 90% reduction in shipment-prep time.

Procurement now operates at a 99%+ target service level with 70% fewer stockouts, and $300K–$500K in working capital is liquidated within 12 months as the safety-stock buffer compresses. Excel formula and document errors are eliminated outright, and the workflow now scales well past the prior 300-shipment ceiling.