Basically, you are expected to model a transshipment plan for 3 trucks. Some of the data is not included and it is your teams 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.

Your Company Name Model Assumptions 17 What is the optimum 18 loading plan Any thought or solution 26 for BONUS 27 What are the limitations 55HD as Aw 10 11 12 13 14 15 16 82272225 19 20 21 23 24 20228E 29 30 31 32 of your model. 33 34 B D E F G H I B C D E F G H I J 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 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 istanbul Istanbul istanbul 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 11 Distance Istanbul Vienna Trieste Frankfurt Istanbul Vienna Trieste Frankfurt 16 17 Time istanbul Vienna Trieste Frankfurt 18 stanbul Vienna Trieste Frankfurt 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 27 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 Use a constant cost of 1,5 Euro/km for land transportation and 1200 Euro for Ro-Ro transshipment between Istanbul and Trieste. Note that these estimates could be different from group to group. Therefore please give reasoning for your estimates. After collecting the cost data, model an ILP for your transshipment problem and answer the questions below 28 29 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 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 38 30 1 23 HANSSA222222222228583538 12 13 14 15 19 20 21 31 A Problem 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. 002330303PEEEP3333333523333F 11 12 13 14 15 16 17 18 19 21 24 27 29 34 36 37 Your Company Name Model Assumptions 17 What is the optimum 18 loading plan Any thought or solution 26 for BONUS 27 What are the limitations 55HD as Aw 10 11 12 13 14 15 16 82272225 19 20 21 23 24 20228E 29 30 31 32 of your model. 33 34 B D E F G H I B C D E F G H I J 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 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 istanbul Istanbul istanbul 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 11 Distance Istanbul Vienna Trieste Frankfurt Istanbul Vienna Trieste Frankfurt 16 17 Time istanbul Vienna Trieste Frankfurt 18 stanbul Vienna Trieste Frankfurt 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 27 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 Use a constant cost of 1,5 Euro/km for land transportation and 1200 Euro for Ro-Ro transshipment between Istanbul and Trieste. Note that these estimates could be different from group to group. Therefore please give reasoning for your estimates. After collecting the cost data, model an ILP for your transshipment problem and answer the questions below 28 29 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 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 38 30 1 23 HANSSA222222222228583538 12 13 14 15 19 20 21 31 A Problem 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. 002330303PEEEP3333333523333F 11 12 13 14 15 16 17 18 19 21 24 27 29 34 36 37