Warehouses Selector

This tool selects those warehouses that come with minimal supply costs given the supply costs from each warehouse to each customer, and the number of warehouses to be opened per warehouse group. This tool simply evaluates 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 (would require a different 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