News for hackers. Stuff that matters.
Re:The software routing 260,000 grocery deliveries a week by Zizizizz on Tuesday August 15, 2017 @11:58AM (#15019375)
For someone quite interested in these kind of problems, what's the current best practice for solving these kind of problems? Not on this scale but still large enough that Google's built-in api for solving it (only 25 points allowed) can't do it.
Re:The software routing 260,000 grocery deliveries a week by paulsutter on Tuesday August 15, 2017 @12:18PM (#15019585)
99% of their code will be ordinary CRUD plumbing, dealing with orders and integrating with other systems. The algorithmic code is the fun part, and they've had years to tune it.

This is just self-congratulatory PR, trying to persuade potential investors that's they're a hard tech company.

Re:The software routing 260,000 grocery deliveries a week by joshvm on Tuesday August 15, 2017 @01:01PM (#15020022)
Ocado is an interesting case. Their public line is that they're a technology company that happened to end up delivering groceries. They invest a lot in automation and robotics - definitely a hard tech company:

http://www.gizmodo.co.uk/2017/02/inside-ocado-discover-the-h...

This is not a vapourware start-up, they've been leading the grocery delivery business in the UK for years. That said, they have the same problem as Amazon in that they invest so much into RnD that they're not terribly profitable (about £10M on a $1Bn turnover).

That said, in this particular example I don't know how much their solution differs from Royal Mail (which uses fixed routes) or people like DHL, Fedex, et al. Routing isn't exactly a new problem and courier companies presumably have always had a lot of people working in operations research.

Re:The software routing 260,000 grocery deliveries a week by noir_lord on Tuesday August 15, 2017 @02:31PM (#15020976)
The missus uses Ocado, they really have their shit together in the UK on the logistics side (a field I work in but not groceries), the deliveries are on time, the process is slick and professional and the drivers are polite and helpful.

She swears by them, I mostly swear at the bill.

Re:The software routing 260,000 grocery deliveries a week by alexvoica on Tuesday August 15, 2017 @01:31PM (#15020363)
This gives a comparison between various developers of routing software, including Ocado https://www.technologyreview.com/s/608640/inside-the-increas...
Re:The software routing 260,000 grocery deliveries a week by caoilte on Tuesday August 15, 2017 @01:17PM (#15020208)
Or to try and persuade techies to come and work for them on more CRUD plumbing.
Re:The software routing 260,000 grocery deliveries a week by michaelt on Tuesday August 15, 2017 @02:07PM (#15020736)
There are a few commercial options available, with different levels of complexity, performance and price. Depends on whether you need to support multiple vehicles with several deliveries on each, specific delivery time windows, and things like that.

For example, Oracle sell a product called 'Real Time Scheduler' [1]. Google finds me a bunch of other products too, but I haven't looked at them in depth.

The off-the-shelf software can deal with tens to low hundreds of orders per solution, - which can scale reasonably well if you're willing to divide your service area with boundaries you can't optimise across.

Ocado built a custom system which can support more orders with fewer boundaries; this offers better routing efficiency, which is important as delivery efficiency is a key cost driver. If your business does something like, say, washing machine repair your time-per-customer might be dominated by repair time rather than travel time; in that case you might be able to operate a nationwide business on off-the-shelf software.

The underlying algorithm in Ocado's system is based on simulated annealing [2] - although those precise words don't seem to have made it into the article!

[1] http://www.oracle.com/us/solutions/scm/service-optimization-... [2] https://en.wikipedia.org/wiki/Simulated_annealing

Re:The software routing 260,000 grocery deliveries a week by owaislone on Tuesday August 15, 2017 @12:19PM (#15019599)
We have an in house system built from ground up in Python and use ortools (https://github.com/google/or-tools) to power the core of the algorithms.
Re:The software routing 260,000 grocery deliveries a week by Zizizizz on Thursday August 24, 2017 @01:29PM (#15092134)
Is there any chance I could send you an email or chat with you further about this? I've been using the ortools python package and while it works, I've found support hard to find and would just like to chat with someone about it. I'm an academic and would love to talk if you have the time.
Re:The software routing 260,000 grocery deliveries a week by alfla on Tuesday August 15, 2017 @12:39PM (#15019783)
The article is quite vague on the problem formulation, other than being somewhat equivalent to the TSP, so I'm just going to speculate a bit onto how they solve it. The TSP can be formulated as an Integer Linear Program (http://examples.gurobi.com/traveling-salesman-problem/). This type of problem is very well studied, and several free and commercial problem formulation tools and solvers are available, some that scale to thousands of variables.

They also probably decouple their problem into disjoint regions before solving it, to reduce the dimensionality of the problem(s).

Re:The software routing 260,000 grocery deliveries a week by n4r9 on Wednesday August 16, 2017 @04:25AM (#15025824)
The article says that their solution is in house, and they don't seem to be using integer linear programming. My guess is that they start with a random feasible solution using a fast greedy heuristic, then iteratively improve it using a simulated annealing process.
Re:The software routing 260,000 grocery deliveries a week by strongai on Tuesday August 15, 2017 @12:20PM (#15019606)
I think it depends if you're interested in knowing how to solve these problems, or simply in solving them. If the latter, there's a bunch of commercial solvers out there. I won't name any for fear of an adverse reaction :0) but a trawl through the first page of Google results for 'optimization solvers' would probably work.
Re:The software routing 260,000 grocery deliveries a week by Zizizizz on Tuesday August 15, 2017 @02:12PM (#15020798)
more about the how is what interests me. I just find it fascinating. I've tried nearest neighbour, ant colony and simmulated annealing thus far (Or read about them and tweaked some code)
Re:The software routing 260,000 grocery deliveries a week by sbrother on Tuesday August 15, 2017 @12:14PM (#15019536)
I did something similar for a client about 4 years ago and used simulated annealing to reasonable success. I would be interested to know if there are better options now!