Question: 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

2. Turkish Cargo will decide on the locations for

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. Weekly capacity Weekly fixed Warehouse (units) cost stanbul 50 200 Ankara 52 160 Trabzon 56 240 Diyarbakr 54 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. 140 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 solution

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!