mew3782
mew3782
  • Threads: 8
  • Posts: 15
Joined: Jan 18, 2010
December 4th, 2012 at 3:49:32 PM permalink
I have a national chain of 100 stores with 10 regional managers covering 10 stores each. Each manager travels 45 times a year (store 1 to 2...9 to 10). How do I group my managers so as to minimize total distance travelled? Bonus for p&oviding general solution ...
CrystalMath
CrystalMath
  • Threads: 8
  • Posts: 1911
Joined: May 10, 2011
December 4th, 2012 at 4:42:42 PM permalink
Operations Research homework?
I heart Crystal Math.
Ayecarumba
Ayecarumba
  • Threads: 236
  • Posts: 6763
Joined: Nov 17, 2009
December 4th, 2012 at 5:18:28 PM permalink
Quote: mew3782

I have a national chain of 100 stores with 10 regional managers covering 10 stores each. Each manager travels 45 times a year (store 1 to 2...9 to 10). How do I group my managers so as to minimize total distance travelled? Bonus for p&oviding general solution ...



This is known as a "Traveling Salesman Problem". See a resource here.
Simplicity is the ultimate sophistication - Leonardo da Vinci
dwheatley
dwheatley
  • Threads: 25
  • Posts: 1246
Joined: Nov 16, 2009
December 5th, 2012 at 7:19:27 AM permalink
Well, if the managers are assigned to 10 set stores and the managers' home locations are also set, then it is 10 independent TSPs. However, the phrase "how do I group my managers" makes me think that we can relocate the managers and reassign the stores. In that case, it's more like a multi-depot vehicle routing problem (VRP).
Wisdom is the quality that keeps you out of situations where you would otherwise need it
kubikulann
kubikulann
  • Threads: 27
  • Posts: 905
Joined: Jun 28, 2011
December 5th, 2012 at 8:13:28 AM permalink
I don't see why a manager has to travel 45 times a year.
In the TSP, you have one circuit to find, passing through each town once.
Why should you want to do each town-to-town pair?
Reperiet qui quaesiverit
mew3782
mew3782
  • Threads: 8
  • Posts: 15
Joined: Jan 18, 2010
December 6th, 2012 at 1:00:00 PM permalink
This is actually more like what I need, yes.

I don't actually own any stores. The real origin of my question, you can replace "me" with "the NCAA", my managers with "The Big Ten, the Pac-12", etc, and my stores with individual schools, who need to travel between each other. Basically, if the NCAA had to bucket all of its universities in such a way to minimize total travel, how would it do it...
  • Jump to: