Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Temel olarak, 3 kamyon iin bir aktarma plan modellemeniz bekleniyor. Baz veriler dahil deildir ve bu verileri toplamak ve/veya tahmin etmek ekibinizin grevidir. Kaynaklarnz iin
Temel olarak, 3 kamyon iin bir aktarma plan modellemeniz bekleniyor. Baz veriler dahil deildir ve bu verileri toplamak ve/veya tahmin etmek ekibinizin grevidir. Kaynaklarnz iin balant eklemelisiniz. Varsaymlarnz, veri balantlarnz, modelinizin snrlamalarn ve sonular aklamak iin Excel dosyasnn ilk 'Rapor' alma sayfasn kullanabilirsiniz.
Your Company Name Model Assumptions 17 What is the optimum 18 loading plan MASSA HASS15 10 11 12 13 14 16 82272225 19 20 21 23 24 26 27 28 29 30 31 32 33 34 Any thought or solution for BONUS What are the limitations of your model. B D E F G H I B C D E F GH I J Problem BauLog Trucking Co. has 3 identical trucks. Ecach truck has a capacity of 20 m3, and could carry at the maximum weight of 15 tor reguest for 20 load orders, where the volume, weight and the corresponding revenue expected from each are given in the table operations manager choose the best loads (orders) such that you will not exceed the limits of each truck and obtain the highest Assume that the shapes of packages are uniform, so that volume is the constraint not individual dimensions of 1 2 3 4 Package 1 2 3 4 5 6 7 8 9 10 11 12 13 5 Volume 4 4 3 3 4 1 2 3 4 2 4 6 4 6 Weight 2 1 3 4 5 4 3 3 4 5 6 3 4 7 Revenue ($) 40 23 13 25 17 12 13 11 16 15 18 15 14 8 Origin stanbul Istanbul stanbul istanbul istanbul istanbul istanbul Istanbul istanbul Istanbul istanbul istanbul istanbul is 9 Destination Frankfurt Trieste Trieste Trieste Frankfurt Frankfurt Frankfurt Frankfurt Vienna Frankfurt Frankfurt Vienna Frankfurt 10 Istanbul Vienna Trieste Frankfurt 11 Distance 12 istanbul 13 Vienna Trieste Frankfurt istanbul Vienna Trieste Frankfurt stanbul Vienna Trieste Frankfurt 23 24 Note: A decision variable could be zero one such that do you assign a load into the container of truck number-i or not? 26 First calculate the time and distance between these nodes on the map (i.e., cities listed in the above tables). While estimating time, include th 27 Use a constant cost of 1,5 Euro/km for land transportation and 1200 Euro for Ro-Ro transshipment between Istanbul and Trieste. 28 Note that these estimates could be different from group to group. Therefore please give reasoning for your estimates. 29 After collecting the cost data, model an ILP for your transshipment problem and answer the questions below 30 a) Your model should be capable of assigning a combination of loads into three trucks such that using land or Ro-Ro modes of trans 33 b) For the given problem data what is the best loading plan how much profit could the company made from this plan? Bonus c1) Modify the model for possible loads from Trieste to Frankfurt, or Vienna to Franfurt? How do you price such plans 34 c2) If delivery time for each load could be different how could you update your model. Consider using double driver, that will increas 36 37 MODEL nn B H 5 6 7 8 9 20 21 2 3 25 25 7 8 20 0 H R 38 H 35 35 38 30 14 15 16 17 Time 18 19 22 31 32 20 ght of 15 tons. The marketing department gets in the table below. As the company's the highest revenue. 1 2 ensions of packages. Therefore as long as sum of the volumes of a number of packages is less than 30 m3, then it will fit into 3 4 13 14 15 16 17 18 19 20 TOTAL 5 4 3 3 3 7 2 4 4 70 6 4 5 2 2 1 3 3 2 65 7 14 16 13 12 9 12 4 4 8 istanbul Istanbul istanbul istanbul istanbul istanbul istanbul istanbul 9 Frankfurt Vienna Vienna Vienna Frankfurt Trieste Trieste Trieste 10 26 e, include the queue times at the borders and/or loading unloading if Ro-Ro ships are used. 28 ites. 30 odes of transportation these trucks will able to deliver the loads within 5 days to their destinations. 31 35 it will increase your daily transportation time and shorten the delivery delay. 002330003EEEEP333333333338 11 12 13 14 15 16 17 18 19 21 22 24 25 27 29 34 36 27 Your Company Name Model Assumptions 17 What is the optimum 18 loading plan MASSA HASS15 10 11 12 13 14 16 82272225 19 20 21 23 24 26 27 28 29 30 31 32 33 34 Any thought or solution for BONUS What are the limitations of your model. B D E F G H I B C D E F GH I J Problem BauLog Trucking Co. has 3 identical trucks. Ecach truck has a capacity of 20 m3, and could carry at the maximum weight of 15 tor reguest for 20 load orders, where the volume, weight and the corresponding revenue expected from each are given in the table operations manager choose the best loads (orders) such that you will not exceed the limits of each truck and obtain the highest Assume that the shapes of packages are uniform, so that volume is the constraint not individual dimensions of 1 2 3 4 Package 1 2 3 4 5 6 7 8 9 10 11 12 13 5 Volume 4 4 3 3 4 1 2 3 4 2 4 6 4 6 Weight 2 1 3 4 5 4 3 3 4 5 6 3 4 7 Revenue ($) 40 23 13 25 17 12 13 11 16 15 18 15 14 8 Origin stanbul Istanbul stanbul istanbul istanbul istanbul istanbul Istanbul istanbul Istanbul istanbul istanbul istanbul is 9 Destination Frankfurt Trieste Trieste Trieste Frankfurt Frankfurt Frankfurt Frankfurt Vienna Frankfurt Frankfurt Vienna Frankfurt 10 Istanbul Vienna Trieste Frankfurt 11 Distance 12 istanbul 13 Vienna Trieste Frankfurt istanbul Vienna Trieste Frankfurt stanbul Vienna Trieste Frankfurt 23 24 Note: A decision variable could be zero one such that do you assign a load into the container of truck number-i or not? 26 First calculate the time and distance between these nodes on the map (i.e., cities listed in the above tables). While estimating time, include th 27 Use a constant cost of 1,5 Euro/km for land transportation and 1200 Euro for Ro-Ro transshipment between Istanbul and Trieste. 28 Note that these estimates could be different from group to group. Therefore please give reasoning for your estimates. 29 After collecting the cost data, model an ILP for your transshipment problem and answer the questions below 30 a) Your model should be capable of assigning a combination of loads into three trucks such that using land or Ro-Ro modes of trans 33 b) For the given problem data what is the best loading plan how much profit could the company made from this plan? Bonus c1) Modify the model for possible loads from Trieste to Frankfurt, or Vienna to Franfurt? How do you price such plans 34 c2) If delivery time for each load could be different how could you update your model. Consider using double driver, that will increas 36 37 MODEL nn B H 5 6 7 8 9 20 21 2 3 25 25 7 8 20 0 H R 38 H 35 35 38 30 14 15 16 17 Time 18 19 22 31 32 20 ght of 15 tons. The marketing department gets in the table below. As the company's the highest revenue. 1 2 ensions of packages. Therefore as long as sum of the volumes of a number of packages is less than 30 m3, then it will fit into 3 4 13 14 15 16 17 18 19 20 TOTAL 5 4 3 3 3 7 2 4 4 70 6 4 5 2 2 1 3 3 2 65 7 14 16 13 12 9 12 4 4 8 istanbul Istanbul istanbul istanbul istanbul istanbul istanbul istanbul 9 Frankfurt Vienna Vienna Vienna Frankfurt Trieste Trieste Trieste 10 26 e, include the queue times at the borders and/or loading unloading if Ro-Ro ships are used. 28 ites. 30 odes of transportation these trucks will able to deliver the loads within 5 days to their destinations. 31 35 it will increase your daily transportation time and shorten the delivery delay. 002330003EEEEP333333333338 11 12 13 14 15 16 17 18 19 21 22 24 25 27 29 34 36 27 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started