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

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. (Choose any 10 products that you want -different from each other sold in Migros and define them). You will manage the shipment of the products you define to 10 Migros stores in 10 different districts in Istanbul. (Select and define the 10 Migros stores you want using Google Map.). Migros has three large warehouses -Gebze warehouse -Bayrampaa warehouse and Esenyurt warehouse. 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 Esenyurt warehouse 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 (Determine the distance between the warehouses and these stores using Google Map.).You need to investigate how much the products you specify sell in which store. The exact information is the total daily sales of 10 products in all stores is 100 tons. 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 to the 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. Write the project report in your own handwriting. In the report, you should specify the locations of the stores you have chosen, the names of the products you have selected, the daily sales amounts for each store, and every cost item required to resolve the issue. 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.

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!