minimizing transportation problem/ management science homework

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 - Bayrampaa warehouse and Esenyurtwarehouse. For these 10products, the capacity of the Gebze warehouse is 40 tons per day, the capacity of the Bayrampaa 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 Ataehir 43,1 KM Migros Acibadem 54 KM MMM Migros caddebostan 53 KM Migros engelky 54,2 KM Migros Gztepe 70,6 KM MMM Migros Anadolu Hisani 60,9 KM MMM Ortakoy 69,7 KM MMM Migros Bahelievler 20,5 KM Migros Istinye 60,8 KM 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 50,6 KM 49 KM 49,7 KM 43 KM 24,6 KM 47,2 KM 37 KM 19,6 KM 44 KM 138 146 48 Coca cola Migros Atakent 500 kg MMM Migros Ataehir 1000 kg Migros Acibadem 650 kg MMM Migros caddebostan 1831 kg Migros engelky 500 kg Migros Goztepe 900 kg MMM Migros Anadolu Hisan 650 kg MMM Ortakoy 1500 kg MMM Migros Bahelievler 820 kg Migros Istinye 1520 kg Doritos Chips 436 kg 545 kg 196,2 kg 654 kg 550 kg 459 kg 218 kg 545 kg 490 kg 545 kg Tadim Seed 72 kg 45 kg 180 kg 270 kg 171 kg 270 kg 153 kg 176 kg 82 kg 180 kg Olker Chocolate Migros Rice 24 kg 1250 kg 48 kg 3750 kg 40 kg 1875 kg 1250 kg 30 kg 2500 kg 37,5 kg 1250 kg 35,4 kg 1475 kg 51 kg 1250 kg 39 kg 3125 kg 60 kg 3125 kg Migros Flour Erikli Water Whiskas Dry Food Set Milk iim Yoghurt 2500 kg 250 kg 3R 1200 kg 1500 kg 3000 kg 300 kg 1300 kg 1200 kg 3300 kg 200 kg 1300 kg 1200 kg 2500 kg 500 kg 19,5 kg 1000 KR 1400 kg 3000 kg 178 kg 7,5 kg 1100 kg 2500 kg 1600 kg 450 kg 14,7 kg 350 kg 1000 kg 2250 kg 375 kg 6,3 kg 1250 kg 1800 kg 2800 kg 1000 kg 10,5 kg 1450 kg 2500 kg 2875 kg Soo kg 6 kg 1440 kg 1500 kg 6500 kg 1000 kg 12,6 kg 1450 kg 1682 kg