Hi All,

Thank you in advance for taking the time to read this and for any solutions and ideas you can provide me with.

I am looking to establish the best combination of routes to deliver 80 stores from one warehouse. Stores can be delivered in single (Warehouse ==> Store 1 ==> Warehouse), doubles (Warehouse ==> Store 1 ==> Store 2 ==> Warehouse), triple (warehouse ==> Store 1 ==> Store 2 ==> Store 3 ==> warehouse). I have established all the possible scenarios (82160 triple, 3160 doubles, 80 singles) and the cost associated to each of these scenerios (affected by the distance and time). My excel sheet is organised as follows. Column A is Warehouse, Column B is the distance between warehouse and first store that is in column C, Column D is the distance between first store (Column C) and second store which is in column E, Column F is the distance between second and third store (coulmn G) and column h is the distance between the third store and the warehouse (column A). Column I contains the total distance, J the time (total distance devided by 60) and the final column is K, which contains the cost associated to each route. Each store as a unique ID (number 1 to 80).

I would love a macro or a system that would go through all the data and establish what is the best combination of routes to use (with the lowest final cost) knowing that I have 33 trucks to deliver and that some trucks can do two routes if they are both under 3 hours (column J). All 80 store must be delivered.

Once again, thank you in advance for your help, let me know if I wasn't clear, I would be delighted to try and be more explicit,

Kind regards,

Tfuhr