I need help with a linear optimization model for a logistics problem

Jubyhuff
Supply-Chain-Analytics-Case-Study-Data.xlsx

Locations

Location X-Coordinate Y-Coordinate Pallets per Day
Cambridge, OH 0 0 N/A
Bellaire, OH 5.8 -0.3 5
Cadiz, OH 4 2.1 5
Calcutta, OH 7.1 5.6 9
Coshocton, OH -1.9 2.3 4
Dover, OH 0.7 4.5 6
East Palestine, OH 7.4 7.3 10
Lisbon, OH 5.7 6.6 8
Mt. Gilead, OH -8.5 4.9 9
New Martinsville, WV 4.7 -3.6 3
Newark, OH -5.8 0.4 6
Pataskala, OH -7.7 -0.2 10
Toronto, OH 6.8 3.9 9
Uhrichsville, OH 1.6 3.3 5
Weirton, WV 6.9 3.4 7
Zanesville, OH -3.1 -0.8 6
5.8 4 7.1 -1.9 0.7 7.4 5.7 -8.5 4.7 -5.8 -7.7 6.8 1.6 6.9 -3.1 -0.3 2.1 5.6 2.2999999999999998 4.5 7.3 6.6 4.9000000000000004 -3.6 0.4 -0.2 3.9 3.3 3.4 -0.8 0 0

Travel Times

Travel Times (in Min) Cambridge, OH Bellaire, OH Cadiz, OH Calcutta, OH Coshocton, OH Dover, OH East Palestine, OH Lisbon, OH Mt. Gilead, OH New Martinsville, WV Newark, OH Pataskala, OH Toronto, OH Uhrichsville, OH Weirton, WV Zanesville, OH
Cambridge, OH 0
Bellaire, OH 56 0
Cadiz, OH 56 46 0
Calcutta, OH 108 70 56 0
Coshocton, OH 47 94 70 119 0
Dover, OH 45 88 47 86 46 0
East Palestine, OH 129 93 79 23 130 90 0
Lisbon, OH 106 85 71 18 107 68 24 0
Mt. Gilead, OH 119 161 163 153 83 109 152 137 0
New Martinsville, WV 94 45 82 106 128 125 127 117 198 0
Newark, OH 62 105 105 154 44 81 165 142 72 142 0
Pataskala, OH 67 110 115 164 65 101 185 163 63 147 27 0
Toronto, OH 90 52 38 27 104 81 48 38 173 90 140 150 0
Uhrichsville, OH 43 77 33 82 43 20 100 78 119 114 80 99 65 0
Weirton, WV 84 46 32 33 98 75 55 44 174 83 134 144 21 60 0
Zanesville, OH 33 75 80 130 48 67 151 129 93 112 37 45 112 65 106 0