Spreadsheet: 776061d1649481790-solver-solving-non-linear-equation-by-linearizing-the-equation-question-2
Sheet: 300-P14

 |  | Distance matrix between the nodes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Unit Rates between Two Cities @ $2.3 / km
 |  |  | Istanbul | Ankara | [NAME] | Bursa | Adana | Gaziantep | Konya | Antalya | Kayseri | Mersin | [NAME] | Diyarbakır | Samsun | [NAME] | Şanlıurfa | Adapazarı | Malatya | Kahramanmaraş | Erzurum | Van | Batman | Elâzığ | İzmit | Manisa |  |  |  |  |  | Istanbul | Ankara | [NAME] | Bursa | Adana | Gaziantep | Konya | Antalya | Kayseri | Mersin | [NAME] | Diyarbakır | Samsun | [NAME] | Şanlıurfa | Adapazarı | Malatya | Kahramanmaraş | Erzurum | Van | Batman | Elâzığ | İzmit | Manisa
 |  | Istanbul | 1 | 1151 | 582 | 1203 | 879 | 872 | 246 | 676 | 1056 | 825 | 695 | 1350 | 885 | 974 | 1331 | 1134 | 855 | 876 | 913 | 1500 | 1264 | 1319 | 552 | 763 |  |  |  |  | Istanbul
 |  | Ankara | 1435 | 1 | 255 | 1449 | 1259 | 1068 | 294 | 1469 | 952 | 320 | 820 | 1430 | 1269 | 1211 | 836 | 275 | 605 | 1275 | 1318 | 282 | 1227 | 489 | 1053 | 232 |  |  |  |  | Ankara
 |  | [NAME] | 258 | 553 | 1 | 1145 | 592 | 337 | 819 | 329 | 753 | 724 | 844 | 870 | 1192 | 1120 | 885 | 1102 | 750 | 870 | 985 | 395 | 204 | 1331 | 898 | 894 |  |  |  |  | [NAME]
 |  | Bursa | 421 | 1150 | 307 | 1 | 1393 | 871 | 560 | 1104 | 273 | 843 | 295 | 857 | 328 | 443 | 219 | 536 | 232 | 1449 | 1446 | 1452 | 1239 | 1303 | 653 | 1049 |  |  |  |  | Bursa
 |  | Adana | 583 | 652 | 355 | 1332 | 1 | 1232 | 1098 | 1074 | 206 | 1292 | 774 | 752 | 1430 | 457 | 1147 | 722 | 1032 | 331 | 966 | 1345 | 372 | 920 | 269 | 1093 |  |  |  |  | Adana
 |  | Gaziantep | 1059 | 1422 | 1479 | 999 | 1133 | 1 | 578 | 802 | 1401 | 427 | 560 | 1245 | 567 | 1063 | 740 | 1177 | 1142 | 953 | 1220 | 648 | 423 | 1185 | 322 | 242 |  |  |  |  | Gaziantep
 |  | Konya | 1034 | 612 | 284 | 492 | 576 | 435 | 1 | 1407 | 407 | 1258 | 1042 | 473 | 1108 | 636 | 858 | 710 | 550 | 534 | 937 | 1144 | 801 | 997 | 1278 | 897 |  |  |  |  | Konya
 |  | Antalya | 441 | 912 | 1417 | 808 | 552 | 915 | 989 | 1 | 965 | 342 | 604 | 662 | 804 | 633 | 701 | 754 | 455 | 203 | 533 | 325 | 452 | 432 | 1184 | 1191 |  |  |  |  | Antalya
 |  | Kayseri | 1004 | 531 | 1274 | 408 | 999 | 454 | 801 | 1026 | 1 | 1199 | 1401 | 793 | 451 | 331 | 957 | 956 | 1333 | 1373 | 909 | 1066 | 1225 | 214 | 1477 | 1422 |  |  |  |  | Kayseri
 |  | Mersin | 990 | 376 | 326 | 1200 | 280 | 843 | 864 | 542 | 731 | 1 | 234 | 1357 | 689 | 1160 | 1321 | 423 | 436 | 1185 | 1039 | 898 | 812 | 447 | 530 | 1135 |  |  |  |  | Mersin
 |  | [NAME] | 856 | 315 | 726 | 420 | 552 | 864 | 1195 | 837 | 1493 | 860 | 1 | 543 | 1332 | 482 | 1278 | 1389 | 305 | 824 | 1239 | 1054 | 633 | 989 | 533 | 977 |  |  |  |  | [NAME]
 |  | Diyarbakır | 1049 | 413 | 467 | 724 | 874 | 1197 | 673 | 1192 | 1342 | 444 | 398 | 1 | 201 | 1125 | 316 | 935 | 1087 | 1429 | 1190 | 1123 | 308 | 991 | 1243 | 626 |  |  |  |  | Diyarbakır
 |  | Samsun | 617 | 925 | 1041 | 828 | 633 | 447 | 784 | 1049 | 212 | 1180 | 1149 | 1250 | 1 | 852 | 699 | 1134 | 708 | 1259 | 372 | 742 | 1294 | 1127 | 1394 | 1105 |  |  |  |  | Samsun
 |  | [NAME] | 1279 | 1076 | 1087 | 1439 | 764 | 270 | 547 | 1097 | 217 | 1143 | 1494 | 973 | 304 | 1 | 287 | 403 | 1347 | 883 | 852 | 586 | 1075 | 467 | 740 | 501 |  |  |  |  | [NAME]
 |  | Şanlıurfa | 742 | 555 | 1367 | 320 | 307 | 1331 | 1484 | 222 | 1086 | 672 | 1269 | 630 | 665 | 448 | 1 | 854 | 1237 | 289 | 945 | 263 | 355 | 1344 | 1321 | 886 |  |  |  |  | Şanlıurfa
 |  | Adapazarı | 1441 | 1146 | 1170 | 414 | 331 | 1361 | 890 | 1283 | 428 | 1006 | 810 | 1211 | 1258 | 1203 | 988 | 1 | 886 | 370 | 726 | 274 | 358 | 353 | 224 | 702 |  |  |  |  | Adapazarı
 |  | Malatya | 275 | 756 | 374 | 334 | 1390 | 1171 | 994 | 1226 | 749 | 697 | 1143 | 1054 | 814 | 1458 | 1265 | 961 | 1 | 1101 | 1416 | 391 | 812 | 847 | 1447 | 908 |  |  |  |  | Malatya
 |  | Kahramanmaraş | 683 | 856 | 1388 | 1299 | 1357 | 1052 | 1064 | 431 | 627 | 227 | 458 | 337 | 1312 | 240 | 542 | 402 | 681 | 1 | 812 | 1471 | 976 | 846 | 1435 | 1191 |  |  |  |  | Kahramanmaraş
 |  | Erzurum | 395 | 1252 | 236 | 1004 | 830 | 1277 | 830 | 1103 | 620 | 1026 | 741 | 515 | 244 | 361 | 759 | 790 | 1488 | 1266 | 1 | 664 | 400 | 1491 | 530 | 772 |  |  |  |  | Erzurum
 |  | Van | 325 | 763 | 1105 | 305 | 911 | 1030 | 1097 | 1460 | 389 | 952 | 527 | 247 | 279 | 773 | 214 | 343 | 1074 | 1059 | 393 | 1 | 207 | 1066 | 801 | 951 |  |  |  |  | Van
 |  | Batman | 1395 | 1071 | 298 | 508 | 908 | 1335 | 617 | 1031 | 1368 | 530 | 1302 | 1113 | 1416 | 311 | 883 | 889 | 236 | 309 | 1075 | 501 | 1 | 1069 | 958 | 753 |  |  |  |  | Batman
 |  | Elâzığ | 913 | 1119 | 991 | 965 | 567 | 607 | 1372 | 1268 | 991 | 1013 | 514 | 1247 | 824 | 593 | 695 | 459 | 849 | 1298 | 1159 | 1465 | 435 | 1 | 576 | 525 |  |  |  |  | Elâzığ
 |  | İzmit | 1319 | 893 | 1425 | 807 | 1330 | 572 | 336 | 1225 | 1429 | 402 | 229 | 643 | 316 | 1421 | 1484 | 1306 | 933 | 882 | 1270 | 594 | 461 | 478 | 1 | 956 |  |  |  |  | İzmit
 |  | Manisa | 1464 | 516 | 1199 | 655 | 562 | 1136 | 505 | 557 | 552 | 1248 | 1116 | 385 | 1060 | 1383 | 1308 | 795 | 709 | 1212 | 352 | 1500 | 697 | 1354 | 353 | 1 |  |  |  |  | Manisa
 |  | Model parameters - Constraint - Coverage Distance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Average Cost of building a cross dock in Turkey @ $500,000
300 |  |  | Istanbul | Ankara | [NAME] | Bursa | Adana | Gaziantep | Konya | Antalya | Kayseri | Mersin | [NAME] | Diyarbakır | Samsun | [NAME] | Şanlıurfa | Adapazarı | Malatya | Kahramanmaraş | Erzurum | Van | Batman | Elâzığ | İzmit | Manisa |  |  |  |  |  | Istanbul | Ankara | [NAME] | Bursa | Adana | Gaziantep | Konya | Antalya | Kayseri | Mersin | [NAME] | Diyarbakır | Samsun | [NAME] | Şanlıurfa | Adapazarı | Malatya | Kahramanmaraş | Erzurum | Van | Batman | Elâzığ | İzmit | Manisa
 |  | Istanbul |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | >= | 1 |  | Cost of Establishment | 492825 | 532557 | 372545 | 377660 | 562588 | 433688 | 450283 | 377781 | 364889 | 381977 | 512323 | 459425 | 573534 | 353324 | 414345 | 461628 | 502932 | 373515 | 531748 | 436812 | 357567 | 531783 | 576551 | 401612
 |  | Ankara |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | >= | 1
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | >= | 1 |  | Capacity Constraint at cross dock
 |  | Bursa |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | >= | 1 |  |  | Istanbul | Ankara | [NAME] | Bursa | Adana | Gaziantep | Konya | Antalya | Kayseri | Mersin | [NAME] | Diyarbakır | Samsun | [NAME] | Şanlıurfa | Adapazarı | Malatya | Kahramanmaraş | Erzurum | Van | Batman | Elâzığ | İzmit | Manisa
 |  | Adana |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | >= | 1 |  | Capacity
 |  | Gaziantep |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | >= | 1
 |  | Konya |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | >= | 1
 |  | Antalya |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | >= | 1
 |  | Kayseri |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | >= | 1
 |  | Mersin |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | >= | 1
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | >= | 1
 |  | Diyarbakır |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | >= | 1
 |  | Samsun |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | >= | 1
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | >= | 1
 |  | Şanlıurfa |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | >= | 1
 |  | Adapazarı |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | >= | 1
 |  | Malatya |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | >= | 1
 |  | Kahramanmaraş |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | >= | 1
 |  | Erzurum |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | >= | 1
 |  | Van |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | >= | 1
 |  | Batman |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | >= | 1
 |  | Elâzığ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | >= | 1
 |  | İzmit |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | >= | 1
 |  | Manisa |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | >= | 1
 |  | Decision Variable - Which Site to Select
 |  |  | Istanbul | Ankara | [NAME] | Bursa | Adana | Gaziantep | Konya | Antalya | Kayseri | Mersin | [NAME] | Diyarbakır | Samsun | [NAME] | Şanlıurfa | Adapazarı | Malatya | Kahramanmaraş | Erzurum | Van | Batman | Elâzığ | İzmit | Manisa
 |  |  | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 1 | 0 | 1 | 1 | 0 | 1 | 1 | 0 | 1 |  | = | 14
 |  | Decision Variable - How much Demand is to the shipped from [NAME] Node
 |  |  | Istanbul | Ankara | [NAME] | Bursa | Adana | Gaziantep | Konya | Antalya | Kayseri | Mersin | [NAME] | Diyarbakır | Samsun | [NAME] | Şanlıurfa | Adapazarı | Malatya | Kahramanmaraş | Erzurum | Van | Batman | Elâzığ | İzmit | Manisa
 |  | Istanbul | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | <= | 14025646
 |  | Ankara | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | <= | 4587558
 |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | <= | 2847691
 |  | Bursa | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | <= | 1854285
 |  | Adana | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | <= | 1563545
 |  | Gaziantep | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | <= | 1495050
 |  | Konya | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | <= | 1003373
 |  | Antalya | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | <= | 955573
 |  | Kayseri | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | <= | 911984
 |  | Mersin | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | <= | 842230
 |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | <= | 617215
 |  | Diyarbakır | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | <= | 614310
 |  | Samsun | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | <= | 511601
 |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | <= | 492815
 |  | Şanlıurfa | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | <= | 465748
 |  | Adapazarı | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | <= | 399022
 |  | Malatya | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | <= | 388590
 |  | Kahramanmaraş | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | <= | 384953
 |  | Erzurum | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | <= | 358344
 |  | Van | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | <= | 352292
 |  | Batman | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | <= | 313355
 |  | Elâzığ | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | <= | 305787
 |  | İzmit | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | <= | 293339
 |  | Manisa | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | <= | 291374
 |  |  | <= | <= | <= | <= | <= | <= | <= | <= | <= | <= | <= | <= | <= | <= | <= | <= | <= | <= | <= | <= | <= | <= | <= | <=
 | Capacity Constraint |  | 1467407 | 1566115 | 1463112 | 1553784 | 1523636 | 1538021 | 1561048 | 1584903 | 1474667 | 1624657 | 1506141 | 1572304 | 1546359 | 1588040 | 1619310 | 1560177 | 1507015 | 1580030 | 1439847 | 1545076 | 1514586 | 1531153 | 1530768 | 1583456
 |  | Cost of Transportation from Node to Node
 |  |  | Istanbul | Ankara | [NAME] | Bursa | Adana | Gaziantep | Konya | Antalya | Kayseri | Mersin | [NAME] | Diyarbakır | Samsun | [NAME] | Şanlıurfa | Adapazarı | Malatya | Kahramanmaraş | Erzurum | Van | Batman | Elâzığ | İzmit | Manisa
 |  | Istanbul
 |  | Ankara
 |  | [NAME]
 |  | Bursa
 |  | Adana
 |  | Gaziantep
 |  | Konya
 |  | Antalya
 |  | Kayseri
 |  | Mersin
 |  | [NAME]
 |  | Diyarbakır
 |  | Samsun
 |  | [NAME]
 |  | Şanlıurfa
 |  | Adapazarı
 |  | Malatya
 |  | Kahramanmaraş
 |  | Erzurum
 |  | Van
 |  | Batman
 |  | Elâzığ
 |  | İzmit
 |  | Manisa
 |  |  | Istanbul | Ankara | [NAME] | Bursa | Adana | Gaziantep | Konya | Antalya | Kayseri | Mersin | [NAME] | Diyarbakır | Samsun | [NAME] | Şanlıurfa | Adapazarı | Malatya | Kahramanmaraş | Erzurum | Van | Batman | Elâzığ | İzmit | Manisa
 |  | Total Demand
 |  | Total Transportation Cost
 |  | Total Facility Cost
 |  | Total Cost