Excel Solver - Alldifferent Logic

[jmcginnis336]

Hello All,

Background
I have what I think is a simple route schedule problem. I need to create a delivery schedule that enables my delivery truck to always start "Plant 1". The delivery truck needs to take the shortest route amongst the other plants, and finish back at 'Plant 1".

Issue
1)Within the solver constraints, I'm not sure who to create the constraint that makes sure the delivery truck always starts at Plant 1
2) Not sure if I need to adjust my Solver Parameters? Every time I run the model I get a different optimal route, but the miles are reduce the same amount

1 A B C D E F G H I J 2 Distance Between All Locations 3 4 Plant 1 Plant 2 Plant 3 Plant 4 Plant 5 5 Plant 1 0 7 5 18 20 6 Plant 2 7 0 2 11 13 7 Plant 3 5 2 0 13 15 8 Plant 4 18 11 13 0 2 9 Plant 5 20 13 15 2 0 10 11 12 13 Actual Trip Order Location Row In Chart Location in the Row (Use the Index function to look up that location) Distance from previous location 14 1st Location Visited 1 Plant 1 20 15 2nd Location Visited 2 Plant 2 7 16 3rd Location Visited 3 Plant 3 2 17 4th Location Visited 4 Plant 4 13 18 5th Location Visited 5 Plant 5 2 Total Miles (Baseline) Total Miles (Minimize) 44 44 <colgroup><col style="width: 23pt; mso-width-source: userset; mso-width-alt: 1133;" width="31"> <col style="width: 155pt; mso-width-source: userset; mso-width-alt: 7533;" width="206"> <col style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;" span="2" width="75"> <col style="width: 65pt; mso-width-source: userset; mso-width-alt: 3181;" width="87"> <col style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;" span="2" width="75"> <col style="width: 76pt; mso-width-source: userset; mso-width-alt: 3693;" width="101"> <col style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;" span="3" width="75"> <tbody> </tbody>

<tbody>
</tbody>

 

[jmcginnis336]

No help?