Assignment: Supply Chain and Logistics
Imagine that you are a company engaged in international road transportation. Suppose you carry LTL freights to a few customers located in various countries on the same route that you specify. The vehicle starts to journey from Istanbul, Turkey.
First, try to determine the approximate cost of a trailer trip to the country at the end of your route. You can do internet-based research. After that, set a transportation rate for an FTL vehicle by adding a profit rate that you deem appropriate. Then create unit transportation prices for partial (LTL) loads corresponding to specific tonnage ranges. (As an example, for the freight whose weight is between 1.000 kg and 2.000 kg, your price may be 25 euros per 100kg.)
Currently, loads are waiting to be carried in your warehouse. Information about these loads:
o The total load you have is around three times the vehicle capacity,
o They belong to at least 15 different shippers (i.e., 15 various freights) and cannot be divided while being loaded to the TIR,
o They can be of the type that can be measured with pallet and loadingmeter,
o Some of the loads may occur in the ADR class, and a reasonable extra fee may be charged for them.
Determine the highest revenue for a one-way trip of the TIR by making a combination from the current freights. Be careful not to exceed the capacity of TIR in terms of volume and weight. Find the total income by calculating the revenues of each chosen freight.
Document content to be delivered
o Students can discuss among themselves, but assignments will be prepared individually.
o You need to deliver a report in Word format and a calculation page in Excel format.
o You should make all the calculations in Excel and include the parts you consider necessary in the report (Word). You should describe your case, the steps you followed, and the results in detail.
o First of all, you should prepare a scenario and give details such as the route you will follow, the type, quantity, characteristics, and destination countries of the cargos you have.
Format your assignment according to the following formatting requirements:
(1) The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
(2) The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
(3) Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.