After graduating from BAU, you started working in Migros. The first project given to you in...

 

Transcribed Image Text:

After graduating from BAU, you started working in Migros. The first project given to you in the company is to minimize transportation cost. You have been given the shipment management of 10 different products. You will manage the shipment of the products you define to 10 Migros stores in 10 different districts in Istanbul. Migros has three large warehouses -Gebze warehouse -Bayrampaşa warehouse and Esenyurtwarehouse. For these 10products, the capacity of the Gebze warehouse is 40 tons per day, the capacity of the Bayrampaşa warehouse is 25 tons, and the capacity of the Esenyurtwarehouse is 35 tons. You have to load the products from these three warehouses to trucks every day and send them to 10 stores under your management. Trucks leave the warehouses every morning (except Sunday) at 6.00 and must leave all of their cargo to the last store at 10.00 in the morning-same day. Each Migros truck can carry 5 tons of products. These trucks are specially designed. There are 3 different compartments in each truck. The capacity of these three compartments is 1 ton, 2 ton and 2 ton respectively. Due tothe quality and cleaning rules of Migros, only one type of products can be transported in each compartment in each transport. You have to buy the trucks you need. The purchase price of a truck is 700,000 TL / piece. Fuel cost of the trucks per km, how many drivers are required, the cost of the driver, the annual maintenance cost, etc. you need to find out by exploring the expenses. The aim of this study is to find out how many trucks this operation can be done with minimum cost. You should also write the LP and/or ILP models you designed and the results of the models. Also, specify the number of trucks by analyzing in excel solver, which creates the minimum cost based on the data you set in your report. MMM Migros Ataşehir Migros Acıbadem MMM Migros caddebostan Migros Çengelköy Migros Göztepe 43,1 KM 54 KM 53 KM 54,2 KM 70,6 KM MMM Migros Anadolu Hisani 60,9 KM MMM Ortaköy 69,7 KM 70,5 KM 60,8 KM MMM Migros Bahçelievler Migros Istinye Migros Atakent MMM Migros Ataşehir Migros Acibadem MMM Migros caddebostan Migros Çengelköy Migros Göztepe MMM Migros Anadolu Hisan MMM Ortaköy MMM Migros Bahçelievler Migros Istinye Coca cola 500 kg 1000 kg 650 kg 1831 kg 500 kg 900 kg 650 kg 1500 kg 820 kg 1520 kg 26,8 KM 21,6 KM 25 KM 19,3 KM 9,5 KM 24,4 KM 14,2 KM 6,8 KM 21,3 KM Doritos Chips 436 kg 545 kg 196,2 kg 654 kg 550 kg 459 kg 218 kg 545 kg 490 kg 545 kg 50,6 KM 49 KM 49,7 KM 43 KM 24,6 KM 47,2 KM 37 KM 19,6 KM 44 KM Tadim Seed 72 kg 45 kg 180 kg 270 kg 171 kg 270 kg 153 kg 176 kg 82 kg 180 kg Ülker Chocolate Migros Rice 1250 kg 3750 kg 1875 kg 1250 kg 2500 kg 1250 kg 1475 kg 1250 kg 24 kg 48 kg 40 kg 48 kg 30 kg 37,5 kg 35,4 kg 51 kg 39 kg 60 kg 3125 kg 3125 kg Migros Flour Erikli Water Whiskas Dry Food Set Milk 2500 kg 3 kg 1200 kg 250 kg 3000 kg 300 kg 13 kg 1300 kg 200 kg 14 kg 1300 kg 500 kg 19,5 kg 1000 kg 178 kg 7,5 kg 1100 kg 14,7 kg 850 kg 1250 kg 6,3 kg 10,5 kg 6 kg 1450 kg 1440 kg 12,6 kg 1450 kg 3300 kg 2500 kg 3000 kg 1600 kg 2250 kg 2800 kg 2875 kg 6500 kg 450 kg 375 kg 1000 kg 500 kg 1000 kg Içim Yoghurt 1500 kg 1200 kg 1200 kg 1400 kg 2500 kg 1000 kg 1800 kg 2500 kg 1500 kg 1682 kg After graduating from BAU, you started working in Migros. The first project given to you in the company is to minimize transportation cost. You have been given the shipment management of 10 different products. You will manage the shipment of the products you define to 10 Migros stores in 10 different districts in Istanbul. Migros has three large warehouses -Gebze warehouse -Bayrampaşa warehouse and Esenyurtwarehouse. For these 10products, the capacity of the Gebze warehouse is 40 tons per day, the capacity of the Bayrampaşa warehouse is 25 tons, and the capacity of the Esenyurtwarehouse is 35 tons. You have to load the products from these three warehouses to trucks every day and send them to 10 stores under your management. Trucks leave the warehouses every morning (except Sunday) at 6.00 and must leave all of their cargo to the last store at 10.00 in the morning-same day. Each Migros truck can carry 5 tons of products. These trucks are specially designed. There are 3 different compartments in each truck. The capacity of these three compartments is 1 ton, 2 ton and 2 ton respectively. Due tothe quality and cleaning rules of Migros, only one type of products can be transported in each compartment in each transport. You have to buy the trucks you need. The purchase price of a truck is 700,000 TL / piece. Fuel cost of the trucks per km, how many drivers are required, the cost of the driver, the annual maintenance cost, etc. you need to find out by exploring the expenses. The aim of this study is to find out how many trucks this operation can be done with minimum cost. You should also write the LP and/or ILP models you designed and the results of the models. Also, specify the number of trucks by analyzing in excel solver, which creates the minimum cost based on the data you set in your report. MMM Migros Ataşehir Migros Acıbadem MMM Migros caddebostan Migros Çengelköy Migros Göztepe 43,1 KM 54 KM 53 KM 54,2 KM 70,6 KM MMM Migros Anadolu Hisani 60,9 KM MMM Ortaköy 69,7 KM 70,5 KM 60,8 KM MMM Migros Bahçelievler Migros Istinye Migros Atakent MMM Migros Ataşehir Migros Acibadem MMM Migros caddebostan Migros Çengelköy Migros Göztepe MMM Migros Anadolu Hisan MMM Ortaköy MMM Migros Bahçelievler Migros Istinye Coca cola 500 kg 1000 kg 650 kg 1831 kg 500 kg 900 kg 650 kg 1500 kg 820 kg 1520 kg 26,8 KM 21,6 KM 25 KM 19,3 KM 9,5 KM 24,4 KM 14,2 KM 6,8 KM 21,3 KM Doritos Chips 436 kg 545 kg 196,2 kg 654 kg 550 kg 459 kg 218 kg 545 kg 490 kg 545 kg 50,6 KM 49 KM 49,7 KM 43 KM 24,6 KM 47,2 KM 37 KM 19,6 KM 44 KM Tadim Seed 72 kg 45 kg 180 kg 270 kg 171 kg 270 kg 153 kg 176 kg 82 kg 180 kg Ülker Chocolate Migros Rice 1250 kg 3750 kg 1875 kg 1250 kg 2500 kg 1250 kg 1475 kg 1250 kg 24 kg 48 kg 40 kg 48 kg 30 kg 37,5 kg 35,4 kg 51 kg 39 kg 60 kg 3125 kg 3125 kg Migros Flour Erikli Water Whiskas Dry Food Set Milk 2500 kg 3 kg 1200 kg 250 kg 3000 kg 300 kg 13 kg 1300 kg 200 kg 14 kg 1300 kg 500 kg 19,5 kg 1000 kg 178 kg 7,5 kg 1100 kg 14,7 kg 850 kg 1250 kg 6,3 kg 10,5 kg 6 kg 1450 kg 1440 kg 12,6 kg 1450 kg 3300 kg 2500 kg 3000 kg 1600 kg 2250 kg 2800 kg 2875 kg 6500 kg 450 kg 375 kg 1000 kg 500 kg 1000 kg Içim Yoghurt 1500 kg 1200 kg 1200 kg 1400 kg 2500 kg 1000 kg 1800 kg 2500 kg 1500 kg 1682 kg

Answer rating: 100% (QA)

Given 10 1 Milk 2 Eggs shipment of to Products Produts choose... View the full answer