After graduating from BAU, you started working in Migros. The first project given to you in...
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
Answer rating: 100% (QA)
Given 10 1 Milk 2 Eggs shipment of to Products Produts choose... View the full answer
Related Book For
Vector Mechanics for Engineers Statics and Dynamics
ISBN: 978-0073212227
8th Edition
Authors: Ferdinand Beer, E. Russell Johnston, Jr., Elliot Eisenberg, William Clausen, David Mazurek, Phillip Cornwell
Posted Date:
Students also viewed these finance questions
-
At Stevens Manufacturing, workers are organized in teams that combine their efforts to produce complex units of a final product. Stevens is using a facility layout known as a(n): consolidated process...
-
I have 2 kg of liquid water at 20oC, 100 kPa. I now add 20 kJ of energy at a constant pressure. How hot does it get if it is heated? How fast does it move if it is pushed by a constant horizontal...
-
I have 4 lbm of liquid water at 70 F, 15 psia. I now add 20 Btu of energy at a constant pressure. How hot does it get if it is heated? How fast does it move if it is pushed by a constant horizontal...
-
7 8 0 The following data is provided for the Piedmont Corporation. All costs are actual costs. Complete the cost flows diagram attached to this problem and calculate CGM and CGS. Prepare journal...
-
For each of the following errors identify an audit procedure the auditor could have used to detect it. a. The allowance for doubtful accounts estimated by management is too small. b. Cash in payment...
-
Refer to the information given below. a. The October 31 cash balance in the general ledger is $817. b. The October 31 balance shown on the bank statement is $371. c. Checks issued but not returned...
-
Ann Osborne recently graduated from college with a degree in landscape architecture. Her father runs a tree, shrub, and perennial-flower uursery, and her brother has a business delivering lopsoil,...
-
Cybernetics Inc. issued $60 million of 5% three-year bonds, with coupon paid at the end of every year. The effective interest rate at the beginning of Years 1, 2, and 3 was 8%, 5%, and 2%. Required:...
-
Consider a stock with an initial price of $64.88 per share at the beginning of year 1. Its subsequent year-end stock prices and dividends paid are provided below: Year Price ($) Dividend (5) 1 71.75...
-
In recent years, Kannada Company purchased three machines. Because of heavy turnover in the accounting department, a different accountant was in charge of selecting the depreciation method for each...
-
Alaskan Seafood Enterprises Inc., a wholesaler of fresh fish, agrees with Red Lobster Inc. to sell 1,200 boxes of fresh-caught lobsters at 'market value.' The contract is unenforceable because the...
-
Which of the following tests of computer programs involve processing of the clients actual data by the clients and the auditors computer programs? a. Parallel simulation. b. Generalized audit...
-
Mr. Traditional had a modest accounting practice consisting, for the most part, of local clients. None of the firms he serviced had a computer system, although several of them had talked of obtaining...
-
Which of the following activities would most likely be performed in the computer department? a. Conversion of information to machine-readable form. b. Initiation of changes to master records. c....
-
For control purposes, which of the following should be organizationally segregated from the computer operations functions? a. Surveillance of CRT messages. b. Data conversion. c. Systems development....
-
In its computer processing system a company might use check digits to detect which of the following errors? a. Recording an invalid customers identification charge account number. b. Assigning a...
-
Dana Company manufactures and sells a single product. The following costs were incurred during the company's first year of operations: Variable costs per unit: Manufacturing Direct materials $ 20...
-
If someone's Z-score for a variable was 0.67. Their score is a significant extreme score. Their score is not significant. O Their score is slightly above average. O Their score is an outlier.
-
Solve Prob. 15.204 assuming that the arm of the crosspiece attached to shaft AC is horizontal. Problem 15.204: Two shafts AC and EG, which lie in the vertical yz plane, are connected by a universal...
-
Refer to Probs. 18.141 and 18.142. (a) Show that the curve (called polhode) described by the tip of the vector with respect to a frame of reference coinciding with the principal axes of inertia of...
-
Determine the kinetic energy of the assembly of Prob. 18.145. 3 in. 3 in.
-
The income statement of Barbra Streisand Company is shown below. Additional information: 1. Accounts receivable decreased \($280,000\) during the year. 2. Prepaid expenses increased \($150,000\)...
-
George Clooney Company's income statement for the year ended December 31 2002, contained the following condensed information. Clooney s balance sheet contained the following comparative data at...
-
The financial statements of Frank B. Robinson Company appear below. Additional information: 1. Dividends declared and paid were \($3,000\). 2. During the year equipment was sold for \($8,500\) cash....
Study smarter with the SolutionInn App