can somone please help me.

This case involves determining the best way to transport an initial 25 articulated bus order from Prague Czech where they are produced, to Santos Brazil. The units will be available for transport from Prague on October 15 and must be in Santos by November 15. It is critical these units arrive on time. The second part of the case is to determine the most effective transport plan to move the remaining first order of 199 vehicles to Santos within the next 15 months This case is full of information that is not relevant. It demonstrates how logistical decisions are almost always a part of the larger business picture. In this case, for example, because the first shipment of 23 units is so critical, it would be a pour business decision to save a few nickelson transportation. After all the transportation costs in general are only a small percentage of the revenue available to the company. Let's look at the facts. For the first 25 units, the revenue will be 124.500 euros X 25 units - 3.IM. The entire first order is worth 27.9M. If the company receives the follow on order of 568 units, the additional revenue is worth over 70M! This case will not use any of the questions in the text. Please complete cach section of this spreadsheet. 1. Read the case and make detailed notes regarding all relevant facts. The first part of the case will focus on the first 25 units to answer the question, what is the most effective route for this order and how much will it cost 2. Let's begin by working backwards. Please fill in the following boxes: 2a 12 pts) The first 25 units must arrive in Santos by what date? 2b [3pts List available dates for shipping from cach city: Hamburg Rotterdam Bremerhaven 2c 12 pts) Is Bremerhaven a viable alternative (yes no) Explain why 20 (2 pts). Given the ocean transit times, what is the latest date the shipment must leave each city? Hamburg (18 days on the ocean) Rotterdam (17 days on the ocean) 2018 pts) Let's develop a viable schedule for Hamburg and Rotterdam using either train or water routes Train Water Hamburg Rotterdam Hamburg Rotterdam Arrival date if leave Prague on Oct 15 Availability to ship (+1 day for handling) Ship date from European port (choose best one available, see question 2b) Arrival date in Santos Brazil Hamburg Rotterdam 215 pts) Let's look at costs associated with each of the alternatives suggested in 2d Train Hamburg Rotterdam Total transport cost for 25 units from Prague to European port Handling at the European port ( 45 per bus) Load and pack at the European port ( 25 per bus plus 15 per bus for overtime for each unit > 20 per day) Transoceanic shipping cost (note that Rotterdam is 5% less expensive than Hamburg) Handling and unloading cost in Santos ( 48 per bus) Total Cost of cach alternative 2g 15 ptsPlease summarire belowing complete sentences, your recommendation for the first 25 unit shipment and why: 3. Let's continue by looking at the best method to transport the remaining 199 vehicles. The situation is that they must be in Santos over the next 15 months, which is actually 12 months because the first three months are taken by the first 25 unit order. This is roughly 17 units per month, which should not be a problem for the logistics solution and will likely match the production output of the factories employed Assume that for the remaining order of 199 units 2016 (40 units) will come from Prague and 159 units will come from Munich. Assume the railway cost from Munich to Rotterdam is 1855 per flatcar and from Munich to Hamburg is 1750 per flatcar. Assuming to overtime costs will be incurred and water offers the same savings over rail (E 48 per bus), determine the the total cost for the train versus water options from both Munich and Prague 31. Frem Prague Factory Train Hamburg Rotterdam Hamburg Water Rotterdam Total transport cost for 40 units from Prague to European port Handling at the European port ( 45 per bus) Load and pack at the European port ( 25 per bus) Transoceanic shipping cost (note that Rotterdam is 5% less expensive than Hamburg) Handling and unloading cost in Santos ( 48 per bus) Total Cost of each alternative 35. [MFrom Munich Factory Train Water Rotterdam Hamburg Rotterdam Hamburg Total transport cost for 159 units from Munich to European port Handling at the European port ( 45 per bus) Load and pack at the European port ( 25 per Transoceanic shipping cost (note that Rotterdam is 5% less expensive than Hamburg) Handling and unloading cost in Santos ( 48 perbus) Total Cost of cach alternative 3 ptsPlease describe the best low cost solution for the remaining 199 unit onder 3d [6 pts) The case also states that NAM'S line of credit is 10% per year. This indicates a "cost of money that was not considered when looking at the lowest cost solution. Assuming a bus costs 75,000 each a yearly cast of money is roughly 7500 or 20 per day. How would this impact your best solution? 4a 17 pts] What other non-financial factors would you consider to make this decision? This case involves determining the best way to transport an initial 25 articulated bus order from Prague Czech where they are produced, to Santos Brazil. The units will be available for transport from Prague on October 15 and must be in Santos by November 15. It is critical these units arrive on time. The second part of the case is to determine the most effective transport plan to move the remaining first order of 199 vehicles to Santos within the next 15 months This case is full of information that is not relevant. It demonstrates how logistical decisions are almost always a part of the larger business picture. In this case, for example, because the first shipment of 23 units is so critical, it would be a pour business decision to save a few nickelson transportation. After all the transportation costs in general are only a small percentage of the revenue available to the company. Let's look at the facts. For the first 25 units, the revenue will be 124.500 euros X 25 units - 3.IM. The entire first order is worth 27.9M. If the company receives the follow on order of 568 units, the additional revenue is worth over 70M! This case will not use any of the questions in the text. Please complete cach section of this spreadsheet. 1. Read the case and make detailed notes regarding all relevant facts. The first part of the case will focus on the first 25 units to answer the question, what is the most effective route for this order and how much will it cost 2. Let's begin by working backwards. Please fill in the following boxes: 2a 12 pts) The first 25 units must arrive in Santos by what date? 2b [3pts List available dates for shipping from cach city: Hamburg Rotterdam Bremerhaven 2c 12 pts) Is Bremerhaven a viable alternative (yes no) Explain why 20 (2 pts). Given the ocean transit times, what is the latest date the shipment must leave each city? Hamburg (18 days on the ocean) Rotterdam (17 days on the ocean) 2018 pts) Let's develop a viable schedule for Hamburg and Rotterdam using either train or water routes Train Water Hamburg Rotterdam Hamburg Rotterdam Arrival date if leave Prague on Oct 15 Availability to ship (+1 day for handling) Ship date from European port (choose best one available, see question 2b) Arrival date in Santos Brazil Hamburg Rotterdam 215 pts) Let's look at costs associated with each of the alternatives suggested in 2d Train Hamburg Rotterdam Total transport cost for 25 units from Prague to European port Handling at the European port ( 45 per bus) Load and pack at the European port ( 25 per bus plus 15 per bus for overtime for each unit > 20 per day) Transoceanic shipping cost (note that Rotterdam is 5% less expensive than Hamburg) Handling and unloading cost in Santos ( 48 per bus) Total Cost of cach alternative 2g 15 ptsPlease summarire belowing complete sentences, your recommendation for the first 25 unit shipment and why: 3. Let's continue by looking at the best method to transport the remaining 199 vehicles. The situation is that they must be in Santos over the next 15 months, which is actually 12 months because the first three months are taken by the first 25 unit order. This is roughly 17 units per month, which should not be a problem for the logistics solution and will likely match the production output of the factories employed Assume that for the remaining order of 199 units 2016 (40 units) will come from Prague and 159 units will come from Munich. Assume the railway cost from Munich to Rotterdam is 1855 per flatcar and from Munich to Hamburg is 1750 per flatcar. Assuming to overtime costs will be incurred and water offers the same savings over rail (E 48 per bus), determine the the total cost for the train versus water options from both Munich and Prague 31. Frem Prague Factory Train Hamburg Rotterdam Hamburg Water Rotterdam Total transport cost for 40 units from Prague to European port Handling at the European port ( 45 per bus) Load and pack at the European port ( 25 per bus) Transoceanic shipping cost (note that Rotterdam is 5% less expensive than Hamburg) Handling and unloading cost in Santos ( 48 per bus) Total Cost of each alternative 35. [MFrom Munich Factory Train Water Rotterdam Hamburg Rotterdam Hamburg Total transport cost for 159 units from Munich to European port Handling at the European port ( 45 per bus) Load and pack at the European port ( 25 per Transoceanic shipping cost (note that Rotterdam is 5% less expensive than Hamburg) Handling and unloading cost in Santos ( 48 perbus) Total Cost of cach alternative 3 ptsPlease describe the best low cost solution for the remaining 199 unit onder 3d [6 pts) The case also states that NAM'S line of credit is 10% per year. This indicates a "cost of money that was not considered when looking at the lowest cost solution. Assuming a bus costs 75,000 each a yearly cast of money is roughly 7500 or 20 per day. How would this impact your best solution? 4a 17 pts] What other non-financial factors would you consider to make this decision