Basically, you are expected to model a transshipment plan for 3 trucks. Some of the

Question: Basically, you are expected to model a transshipment plan for 3 trucks. Some of the data is not included and it is your team’s job to collect and/or estimate these data. You SHOULD include link for your sources. You can use the first ‘ReporT’ worksheet of the Excel file to explain your assumptions, data links, limitations ofyour model and results.Basically, you are expected to model a transshipment plan for 3 trucks. Some of the data is not included and it is your team’s job to collect and/or estimate these data. You SHOULD include link for your sources. You can use the first ‘ReporT’ worksheet of the Excel file to explain your assumptions, data links, limitations ofyour model and results.
Show transcribed image textTranscribed image text: A 2 3 Your Company Name 4 5 Model Assumptions 6 7 8 9 10 11 12 13 14 15 16 17 What is the optimum Any thought or solution for BONUS What are the limitations of p 18 loading plan 19 20 21 22 23 24 25 26 27 28 29 30 31 32 your model B Proiect Report C Problem D Biçimlendirme Biçimlendir Stilleri – V Y Hizalama 15 Sayı 5 Stiller A B C D E F G H K L M N 0 P Q R S T U V W X Y 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 tons. The marketing department gets reguest for 20 load orders, where the volume, weight and the corresponding revenue expected from each are given in the table below. As the company’s operations manager choose the best loads (orders) such that you will not exceed the limits of each truck and obtain the highest revenue. Assume that the shapes of packages are uniform, so that volume is the constraint not individual dimensions 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 the truck. 1 2 3 4 Package 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 ΤΟΤΑΙ 5 Volume 4 4 3 3 4 1 2 3 4 2 4 6 4 3 3 3 7 2 4 4 70 6 Weight 2 1 3 4 5 4 3 3 4 5 6 3 4 5 2 2 3 3 2 65 7 Revenue (S) 40 23 13 25 17 12 13 11 16 15 18 15 14 16 13 12 9 12 4 4 8 Origin Istanbul istanbul istanbul istanbul istanbul istanbul istanbul istanbul istanbul istanbul istanbul istanbul istanbul istanbul istanbul istanbul istanbul istanbul istanbul istanbul Frankfur Trieste Trieste Trieste FrankfurFrankfurFrankfurFrankfun Vienna FrankfurFrankfurt Vienna Frankfurt Vienna Vienna Vienna Frankfurt Trieste Trieste Trieste 9 Destination 10 11 Distance istanbul Vienna Trieste Frankfurt 12 İstanbul 13 Vienna 14 Trieste 15 Frankfurt 16 17 Time Istanbul Vienna Trieste Frankfurt. 18 Istanbul 19 Vienna 20 Trieste 21 Frankfurt 22 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? 25 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 the queue times at the borders and/or loading unloading if Ro-Ro ships are used. 27 Use a constant cost of 1,5 Euro/km for land transportation and 1200 Euro for Ro-Ro transshipment between İstanbul 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 transportation these trucks will able to deliver the loads within 5 days to their destinations. 31 32 b) For the given problem data what is the best loading plan how much profit could the company made from this plan? 33 34 Bonus c1) Modify the model for possible loads from Trieste to Frankfurt, or Vienna to Franfurt? How do you price such plans 35 36 c2) If delivery time for each load could be different how could you update your model. Consider using double driver, that will increase your daily transportation time and shorten the delivery delay. 37 MODEL 38 Project Report Problem I B Pano R14 x¹ Yazı Tipi X ✔ 15 1 4 Hücreler Z