Step 8: Check other results indicators: profit per customer (Figure 14), vessel container combination (Figure 15) and vessel utilization (Figure 16). Profit per customer helps to determine the contribution of each customer. Vessel container combination shows the optimal fleet size and provides general insights into weekly routes. Vessel utilization shows the utilization based on volume and weight capacity. Note: Please output the results before checking the vessel utilization. Figure : Fleet size optimization results: weekly profit per customer Figure : Fleet size optimization results: vessel container combination Figure : Fleet size optimization results: vessel utilization Step 9: Open to further analyze the results. “FleetSizeOptimization_Results.xlsm” 4. Weekly routing and scheduling In this illustration, we use the same case for the size optimization function. The transportation demand on the triangle network: Rotterdam, Hamburg and Immingham of 38 customers are shipped by 3 vessels. 4.1 Set weekly order information Step 1: Open file “Weekly_Order_Containter_Inventory.xlsm” Step 2: Set order information. Order information includes the leftover demand from week n-1 and demand of week n for each customer. The leftover demand is the demand available at origin terminal at week n-1 that is not delivered in week n-1. Figure 18 shows the order information for this specific case. Step 3: Set customer related information including TEU factor, average weight (ton/container), unit handling cost (€/container), unit outsourcing cost (€/container), order delay penalty (€/hour), unit price of own sailing (€/container), unit price with outsourcing (€/container), and due date in days or working days and how may days. Figure 17 shows the settings in this case. Step 4: Save and close “Weekly_Order_Containter_Inventory.xlsm” Figure : Customer related information
Step 8: Check other results indicators: profit per customer (Figure 14), vessel container combination (Figure 15) and vessel utilization (Figure 16). Profit per customer helps to determine the contribution of each customer. Vessel container combination shows the optimal fleet size and provides general insights into weekly routes. Vessel utilization shows the utilization based on volume and weight capacity. Note: Please output the results before checking the vessel utilization. Figure : Fleet size optimization results: weekly profit per customer Figure : Fleet size optimization results: vessel container combination Figure : Fleet size optimization results: vessel utilization Step 9: Open “FleetSizeOptimization_Results.xlsm” to further analyze the results. 4. Weekly routing and scheduling In this illustration, we use the same case for the size optimization function. The transportation demand on the triangle network: Rotterdam, Hamburg and Immingham of 38 customers are shipped by 3 vessels. 4.1 Set weekly order information Step 1: Open file “Weekly_Order_Containter_Inventory.xlsm” Step 2: Set order information. Order information includes the leftover demand from week n-1 and demand of week n for each customer. The leftover demand is the demand available at origin terminal at week n-1 that is not delivered in week n-1. Figure 18 shows the order information for this specific case. Step 3: Set customer related information including TEU factor, average weight (ton/container), unit handling cost (€/container), unit outsourcing cost (€/container), order delay penalty (€/hour), unit price of own sailing (€/container), unit price with outsourcing (€/container), and due date in days or working days and how may days. Figure 17 shows the settings in this case. Step 4: Save and close “Weekly_Order_Containter_Inventory.xlsm” Figure : Customer related information
Vessel-Planning-Tool-Yun-Fan-User_Manual.docx