Browse categories
Explore
Fiverr Pro
English
$
USD
I will optimize vrp vrptw and mip in python ortools cplex gams
Sihao W
_nqgq8i.jpg)
About this gig
I build practical VRP, VRPTW and MIP solutions in Python with OR-Tools or CPLEX. You get clean code, simple configs, and a KPI snapshot (distance, vehicles, runtime). I focus on reproducibility and clear handover.
What I handle: capacity, time windows, shifts/breaks, multi-depot, priorities, soft penalties, skills/compatibility, max route time. Optional FastAPI service and SQL/Oracle link.
Packages: Basic prototype up to 50 stops, 1 dataset, script + KPI. Standard VRPTW up to 150 stops, 2 datasets, JSON config + tests, optional API. Premium advanced rules up to 300 stops, 3 datasets, FastAPI + Docker + DB integration.
Notes: Pages = input files. Sources = data sources (file/DB/API). One revision = one consolidated list within 48h; no scope change. Complex VRP (PnD, multi-depot, hetero fleet, large size, multi-objective, full API+DB) custom offer 5001500 USD. Default solver OR-Tools (free). CPLEX/Gurobi/COPT require client license; fees not included. Please contact before ordering.
Get to know Sihao W
Sihao W
Operations Research engineer
- FromGermany
- Member sinceSep 2025
- Avg. response time1 hour
- Last delivery4 months
Languages
English, Chinese, German
Operations Research engineer building optimization for routing & scheduling (VRP/VRPTW, MIP, network flow) in logistics, ports & manufacturing. Write clean, reproducible Python and integrate with SQL/Oracle. Select & tune solvers to balance quality vs runtime: Gams, OR-Tools, DOcplex/CPLEX, Gurobi, COPT. Deliverables: model + code, data prep, KPIs report, optional API. Strengths: clear comms, fast iterations, NDA ready. Skills: Python, SQL, Oracle; also C/MATLAB/FlexSim; docs in LaTeX/Markdown/MS Office.
My Portfolio
FAQ
What data do you need to start?
A small sample in CSV or Excel or SQL with fields like stop_id, lat, lon, demand, service_time, time_window, vehicle_capacity, plus your objective and constraints.
Which solver will you use?
OR Tools by default. I can use CPLEX or Gurobi or COPT if you provide a valid commercial license or a licensed runtime. License fees are not included.
Do you use academic licenses for paid work?
No(in principle). For commercial projects I use only client provided commercial licenses. For academic work we can discuss scope and proof.
What counts as a revision?
One revision equals one consolidated list within 48 hours after delivery. It covers formatting, thresholds, small parameter changes. New constraints, new datasets or sources, or size increases require an extra or a custom offer.
What do Pages and Sources mean in pricing?
Pages equals number of input files. Sources equals data sources such as file, database, or API.
Can you deliver an API and connect a database?
Yes. I can provide a FastAPI endpoint and Docker file. SQL or Oracle integration is available in Premium or as an extra.
Do you support complex VRP such as pickup and delivery or multi depot or heterogeneous fleet?
Yes. These are quoted as a custom offer. Typical range is 500 to 1500 USD depending on scope.
Who owns the IP and do you sign NDAs?
You own the project specific code and artifacts after full payment, third party licenses excluded. I can sign a standard NDA.
