BFLUBS operates a network of strategically located distribution branches across Brazil. Due to a planning issue, the Sorocaba branch did not have enough material available to fulfill its scheduled deliveries for the following week. As an emergency solution, deliveries originally assigned to Sorocaba were executed by the Campinas branch instead — a branch farther from the customer base, creating a significant increase in total route distance and reduced transportation efficiency.
- Calculate weekly delivery routes under normal operations starting from Sorocaba
- Calculate the same routes under the emergency scenario starting from Campinas
- Measure the additional distance generated by the branch change
- Evaluate the operational impact and generate actionable recommendations
| Metric | Value |
|---|---|
| Sorocaba (normal) | 5,522 km |
| Campinas (emergency) | 10,250 km |
| Additional distance | +4,728 km |
| Route distance increase | +85.6% |
- Python · Pandas · Jupyter Notebook
- OpenRouteService API · Folium
- python-dotenv (API key management)
RouteAnalysis/
│
├── dados/ # Input data files
├── Route Analysis.ipynb # Main notebook
├── Route Analysis.pdf # Final report
├── requirements.txt
└── .gitignore
The emergency rerouting preserved service continuity — but at an 85.6% increase in total route distance. The issue was not customer demand, but the operational cost of serving that demand from the wrong branch. This highlights the importance of inventory planning, branch readiness, and contingency route preparation.
- API key loaded from environment variable — not included in repository
- Impact measured by distance, not direct freight cost
- Some routes may return missing values depending on API response