In one of my most popular posts 5 Excel Functions That Every Logistics Manager Should Know I provided practical examples of the VLOOKUP, TRIM, CONCATENATE, NETWORKDAYS Excel functions and instructions on how to calculate the WEEK BEGINNING DATE in Excel. In this post I look at a 3 More Excel Functions That Every Logistics Manager Should Know – these include: SUMIF and SUMIFS COUNTIF and COUNTIFS AVERAGEIF and AVERAGEIFS As per my previous post I have also created a spreadsheet that provides some real life examples of each of the below mentioned Excel functions – to download a copy of the spr ..read more

The annual update to the Armstrong and Associates Top 25 Global Freight Forwarders List has been released. Global freight forwarding companies are ranked based on a combination of 2020 gross revenue and freight forwarding volume. DHL, Khune and Nagel, DB Schenker, DSV Panalpina, Sinotrans, Expeditors and Nippon Express continue to dominate the Top 25 Global Freight Forwarders list New entrants to the list include the China based CTS International Logistics and the USA based Apex Logistics International The below table is the full list of the top 25 global freight forwarders showing gross reven ..read more

Understanding how to calculate the landed cost of imported goods is essential for anyone involved in global trade Not understanding. or not taking all of the relevant costs into account will have a negative impact on the profitability of the products that you are importing. This guide will help you to understand: The definition of landed cost What elements should be included in the landed cost of imported products How to calculate the landed cost of imported goods The definition of landed cost The landed cost of imported products includes all of the costs associated with getting the products ..read more

The key to sustaining healthy 3PL relationships is very much dependent on the person that is given the role to manage the relationship with the 3PL service provider. One of the biggest mistakes that many organizations make when they move from the DIY to 3PL model is in the selection of the person they choose to manage the relationship. Quite often the warehouse manager is given the job and in many cases they don’t have all the skills required to make the transition from managing an operation to effectively managing 3PL relationships. This is not to say that their o ..read more