we are trying to cut our transportation costs for loads between our 5 consolidation buildings I have attached a file with the total miles between each Con. building as well the number of pallets being sent between the buildings what I am trying to do is maximize the trailers to 27 pallets by using the least amount of miles, can someone help in pointing me in the right direction using Solver......or is Solver the right tool?

Attached Files

Book1.xlsx (9.5 KB, 11 views)