To be done with Excel Solver. Please focus on part "b" and submit the actual Excel file if possible

DAM is an automobile manufacturer and is considering building distribution centers in the eastern part of the country to serve its 10 dealerships. The companys Supply Chain Management Department identified 12 potential locations. The company wants each dealership to be within 140 miles of at least one distribution center.

a. What is the minimum number of distribution centers to be built and at which locations should they be built?

b. Due to differences in the cost of land, construction, and the incentives provided by local governments, building costs vary from one location to the next as given in the following Table.

Potential Location	Building cost (in millions of $)
1	190
2	210
3	220
4	90
5	110
6	120
7	95
8	88
9	100
10	135
11	150
12	98

Given that the within 140 miles criterion is still valid, how many and at which locations should the company build the distribution centers to minimize the total cost of building? What is the total cost associated with your solution?

Potential Distribution Center locations 1 2 3 4 5 6 7 8 9 10 11 12 V Dealerships 1 65 91 63 2 375 121 392 192 288 3 160 176 382 64 361 237 339 56 93 120 56 59 341 96 363 165 206 255 353 55 91 4 250 236 223 120 238 183 377 354 223 125 228 141 138 233 282 187 204 283 289 96 227 257 368 224 400 335 259 5 372 370 52 146 347 176 272 359 287 327 176 122 163 232 208 310 204 245 394 261 332 128 6 362 188 352 262 111 101 65 137 239 87 84 393 132 282 298 247 269 205 233 7 199 169 8 86 285 62 165 63 284 355 233 9 10 146 298 91 179 83 208 244 256 289 383 53 373 150