Author: Belén Llatas Beny
Tools: Excel + Solver
Course: Supply Chain Management – Hofstra University (New York, USA)
This portfolio includes real-world case studies and optimization models developed during my studies in Supply Chain Management at Hofstra University (New York, USA).
Each project replicates a decision-making scenario related to production, inventory, transportation, or facility location — solved using Excel and Solver.
Este repositorio reúne modelos y casos prácticos desarrollados durante mis estudios en Hofstra.
Todos los archivos están en inglés, pero puedo explicarlos en español si lo necesitas.
- Inventory optimization under uncertainty
- Risk pooling and safety stock analysis
- Transportation cost minimization
- Facility location and fixed-cost tradeoffs
- Binary and linear optimization with Solver
- Strategic thinking in supply chain planning
| Nº | Folder | Project (EN) | Proyecto (ES) |
|---|---|---|---|
| 01 | 01_fast-fashion-newsvendor/ |
Newsvendor Model – Fast Fashion | Modelo Newsvendor aplicado a moda |
| 02 | 02_risk-pooling/ |
Risk Pooling Strategy | Estrategias de agrupación de stock |
| 03 | 03_transportation-location-models/ |
Transportation Network Optimization | Optimización de red de transporte |
| 04 | 04_factory-location-dryice/ |
DryIce Factory Location Problem | Localización de fábricas: caso DryIce |
📁 Each project is organized in its own folder with prefix
01_,02_, etc.
Each folder contains:
- 📄
README.md– Summary of the problem and approach - 📊
.xlsx– Excel file with Solver model and results - 📑
.pdf– Original problem statement (if available)
Cada carpeta incluye:
- 📄 Un
README.mdcon resumen y planteamiento - 📊 Un Excel con fórmulas y Solver configurado
- 📑 Un PDF con el enunciado original (si aplica)
Belén Llatas Beny – Logistics & Analytics Enthusiast
🌍 Location: Valencia, Spain
✉️ Email: belenllatas1@gmail.com
🔗 LinkedIn: www.linkedin.com/in/belenllatasbeny
This portfolio is part of my goal to build a hybrid logistics-finance profile, combining technical knowledge with international experience.
- Excel Solver (Linear, Integer, Binary)
- Newsvendor and inventory models
- Risk pooling and centralization
- Transportation optimization
- Facility location with fixed costs
- NORM.INV and Z-score for uncertainty modeling
All projects were completed by me as part of my academic training.
Attributions to professors and institutions are included where needed.
This content is published for educational and professional demonstration purposes.
You can reach me at: belenllatas1@gmail.com Or visit my LinkedIn profile: www.linkedin.com/in/belenllatasbeny
Me puedes contactar en: belenllatas1@gmail.com
O visitar mi perfil de LinkedIn: www.linkedin.com/in/belenllatasbeny