NL

Warehouses selector

Which N-out-of-M warehouses to select, given the supply costs from each warehouse to each customer, and the number of warehouses to be opened per warehouse group? This tool selects those warehouses that come with minimal supply costs.

This tool evaluates simply all permutations. Selecting 5 out of 50 warehouses (2.1 million permutations) is possible, but selecting 10 out of 40 warehouses (848 million permutations) will cause a run time issue. The number of permutations also depends on warehouse groupings. A case with multi-million permutations requires a more sophisticated algorithm.

INPUT: warehouse-customer supply costs & warehouse groups (semicolon or tab separated; you can copy data from MS Excel into the text area)


INPUT: number of warehouses to open


 Warehouse group  abcdefghij
 Number available  
 Number to open



Select warehouses