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.

123456565 Your Company Name Model Assumptions 17 What is the optimum 18 loading plan 19 Any thought or solution What are the limitations 7 8 9 10 11 29222222 20 21 23 24 Team 25 26 for BONUS 27 28 29 30 31 32 of your model 33 34 B C BA3464 PRoject [Korumal Grnm)- Excel (rn Etkinletirilemedi) Grnm Ne yapmak istediinizi syleyin... Giri Ekle Sayfa Dzeni Formller Veri Gzden Geir 0 Problem Baitog Trucking Co. tas 3 dental trucks. Ecach truck has a capacity of 20 md, 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 1 2 Assume that the shapes of packages are uniform, so that volume is the constraint not individof dimensions of packages. Therefore an long as sum of the wokenes of a number of packages is less than 30 m3, then it will fit into the truck 1 4 Package 1 2 1 4 5 6 7 1 9 10 11 12 13 14 15 16 17 18 19 20 TOTAL Volone 4 4 3 J 4 1 2 3 4 2 6 4 3. 3 3 7 2 4 4 70 1 3 A 5 A 3 3 5 3 4 S Weight 75 2 2 1 FT 3 2 49 40 23 11 25 17 12 11 11 16 15 18 35 14 26 11 12 9 12 4 4 Ongle istanbul and tanbur istanbul istanbul Istanbul Istanbul Istanbul istanted stanbul istanbul tanbel tarbel Istanbul istanbul istanbul tantud stanhol htanbul istanbul Destination Frankfurt Trieste Trieste Trede frekfurt Frankfurt Frankfurt Frankfurt Vienna frankfurt Frankfurt Vienna Frankfurt Vienna Venna Vienna Frankfurt Trieste Trieste Trieste 11 Distance stand Ves Treneraator 17 istedad LE Vers 14 15 Frankfurt 16 17 Time tasby veres Treterantur 10 litarby 19 Viema 300 Trista 24 22 23 24 Not Adevarule could be ero one such that do you assign a load into the container of truck number or not? 25 24 Fint calculate the time and datance between these nodes on the mape, cities listed in the above tables) Whe estimating time, include the queue times at the borders on/or bading unloading of Ro-Ro igo are used 27 the a constant cost of 1.5 Eur/kro 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. 25 Mercollecting the cost data, model LP for your transhipment problem and answer the questions below Your model thodd be capable of asughing a combination of leads into three trucks such that uung land or Ro Ro modes of tramportation these tracks will able to deliver the loads witten 3 days to their destinations 31 b for the given problem data what is the best bading plan how much profit coult the company made from this plan? bunus (1) Modify the model for posible loads from Trieste to rarafurt, or Venta to Prandart? How do you price such plam 2)if delivery time for each lood could be aferent fow could you update your model, Consider uung double driver, that will increase your day transportation time and shorten the delivery delay 37 MODEL Project Report Problem Dosya 837 2 4 6 Win wind 123456565 Your Company Name Model Assumptions 17 What is the optimum 18 loading plan 19 Any thought or solution What are the limitations 7 8 9 10 11 29222222 20 21 23 24 Team 25 26 for BONUS 27 28 29 30 31 32 of your model 33 34 B C BA3464 PRoject [Korumal Grnm)- Excel (rn Etkinletirilemedi) Grnm Ne yapmak istediinizi syleyin... Giri Ekle Sayfa Dzeni Formller Veri Gzden Geir 0 Problem Baitog Trucking Co. tas 3 dental trucks. Ecach truck has a capacity of 20 md, 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 1 2 Assume that the shapes of packages are uniform, so that volume is the constraint not individof dimensions of packages. Therefore an long as sum of the wokenes of a number of packages is less than 30 m3, then it will fit into the truck 1 4 Package 1 2 1 4 5 6 7 1 9 10 11 12 13 14 15 16 17 18 19 20 TOTAL Volone 4 4 3 J 4 1 2 3 4 2 6 4 3. 3 3 7 2 4 4 70 1 3 A 5 A 3 3 5 3 4 S Weight 75 2 2 1 FT 3 2 49 40 23 11 25 17 12 11 11 16 15 18 35 14 26 11 12 9 12 4 4 Ongle istanbul and tanbur istanbul istanbul Istanbul Istanbul Istanbul istanted stanbul istanbul tanbel tarbel Istanbul istanbul istanbul tantud stanhol htanbul istanbul Destination Frankfurt Trieste Trieste Trede frekfurt Frankfurt Frankfurt Frankfurt Vienna frankfurt Frankfurt Vienna Frankfurt Vienna Venna Vienna Frankfurt Trieste Trieste Trieste 11 Distance stand Ves Treneraator 17 istedad LE Vers 14 15 Frankfurt 16 17 Time tasby veres Treterantur 10 litarby 19 Viema 300 Trista 24 22 23 24 Not Adevarule could be ero one such that do you assign a load into the container of truck number or not? 25 24 Fint calculate the time and datance between these nodes on the mape, cities listed in the above tables) Whe estimating time, include the queue times at the borders on/or bading unloading of Ro-Ro igo are used 27 the a constant cost of 1.5 Eur/kro 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. 25 Mercollecting the cost data, model LP for your transhipment problem and answer the questions below Your model thodd be capable of asughing a combination of leads into three trucks such that uung land or Ro Ro modes of tramportation these tracks will able to deliver the loads witten 3 days to their destinations 31 b for the given problem data what is the best bading plan how much profit coult the company made from this plan? bunus (1) Modify the model for posible loads from Trieste to rarafurt, or Venta to Prandart? How do you price such plam 2)if delivery time for each lood could be aferent fow could you update your model, Consider uung double driver, that will increase your day transportation time and shorten the delivery delay 37 MODEL Project Report Problem Dosya 837 2 4 6 Win wind