Optimize complex international logistics to reduce costs and lead times
*This project was produced in French, so the visual elements may contain French content.
The context
An industrial company operating on an international scale was facing high logistics costs and unstable delivery times between its factories in Africa and its end customers.
The objective: to rethink the organization of logistics flows while maintaining a high level of customer service and preserving sales.
What I’ve done
- Analysis of current logistics flows: plant → port → customer assignments
- Assessment of carrier performance: compliance with contractual lead times (max. 72 hours)
- Complete mapping of logistics roads and friction points
- Calculation of total daily costs (production + transport)
- Optimize distribution flows with Power Query to reduce lead times and streamline flows
- Elaboration of alternative scenarios and concrete recommendations for Supply Chain management
The results
- Clear view of logistics organization and areas for improvement
- Cost savings estimated at 13% on optimized flows
- Scenario to deliver all orders in 11 days
- Realistic recommendations on factory upgrades and carrier contract negotiations
What about the technical side ?
- Exploratory and bivariate analysis in Python
- Data processing and transformation with Excel + Power Query
- Optimization methodology inspired by graph theory
- Logistics mapping and performance visualization in a clear presentation (PowerPoint)
Let’s talk about it !
Do you manage an international or multi-site supply chain?
I can help you with :
- Map your logistics flows
- Evaluate your suppliers
- Optimize your supply chain
- Visualize your performance using simple decision-making tools
📩 Contact me to discuss your requirements !