Question: THERE IS NO MORE DATA GIVEN 2. Turkish Cargo will decide on the locations for two new warehouses. The potential candidate sites are stanbul, Ankara,

THERE IS NO MORE DATA GIVEN
2. Turkish Cargo will decide on the locations for two new warehouses. The potential candidate sites are stanbul, Ankara, Trabzon and Diyarbakr. The following table provides the weekly capacities and the weekly fixed costs for operating warehouses at each site. Warehouse stanbul Ankara Trabzon Diyarbakr Weekly capacity (units) 50 52 56 54 Weekly fixed cost 200 160 240 140 The warehouses will ship the cargos to three countries: Russia, Greece and Netherland. Weekly requirements are 40 units for Russia, 36 units for Greece and 24 units for Netherlands. The following table provides the cost to ship one unit between each location and country. Warehouse Russia Greece Netherlands stanbul $4 $7 $9 Ankara $6 $3 $11 Trabzon $5 $6 $5 Diyarbakr $8 $10 $2 In addition, the following conditions must be satisfied by the final decision: (1) A warehouse must be opened in at least one of stanbul and Diyarbakr, (2) if a warehouse is opened in stanbul, then one must be opened in Trabzon. Which two sites should be selected for the new warehouses to minimize total fixed and shipping costs? Formulate this problem as an IP model and then provide an excel solutionStep by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
