Logistics companies operate on thin margins in a highly competitive, fast paced business environment. This increases the importance of analyzing ongoing operations, making tactical decisions and refining governance structure to help improve operational efficiency and remain competitive.
As part of this blogpost, we will be sharing analyses ideas for US domestic 3PL companies, who deal in air shipments and ground linehaul with the help of Tableau software (advanced mapping functionality and insightful visual display of data) to better understand their operational constraints and subsequently identify areas for operational efficiency.
Let us look at hypothetical data for a 3PL company and analyze shipments being moved across major hubs. As part of this exercise, let’s analyze the price per pound, cost per pound, volume, and average weight per load for all the major transportation lanes with LAX as either origin or destination.
FYI, all the charts we've displayed in this blog post are dynamic. Please feel free to click around and interact with the charts.
Shipping Rate is highest in LAX-JFK and LAX-ORD lanes
Cost is highest in LAX-JFK lane
Higher for LAX – ATL lane; Lowest for LAX – SFO lane
This graph gives an idea about the split between shipments received by air and ground modes by each hub. Looking at the following graph, we can observe that the balance is tilted in favor of air shipments as compared to ground shipments for the LAX hub.
The following graphs show shipments that move from LAX to a different hub based on their service level. The first graph shows shipments that move via a 1 day service level, the second graph shows shipments that move by a 3 day service level and the third graph displays shipments that have 5 day delivery. Majority of shipments are either being delivered using a 1-day express delivery mode or through a standard 5-day delivery service.
It is clear from the dashboard that LAX is the biggest dispatcher of shipments domestically since most of the US imports arrive in US at the LAX port facilities which are then distributed domestically. Also, the number of incoming shipments into JFK is larger than the outgoing shipments which holds to reason. Such volume analysis helps companies in planning and allotting receiving and dispatching staff to airports accordingly.
Such analysis can help operational planning departments of 3PL companies in improving their efficiencies. Please visit our dashboard and reporting page for more information.
Product Startup: How to Build a Minimum Viable Product
In this article, you will learn about the Minimum Viable Product. Its meaning, steps of creation, advantages, etc.
6 Reasons to Move on from your MS Access Workflow
There are several reasons behind migrating from MS Access to other PowerApps. In today's data-centric world where real-time updates are the norm the offline small DB features of MS Access are no longer relevant. In this article, we will take a look at the top 6 reasons why MS Access is no longer relevant.
PowerBI vs Tableau: What Should I Choose for my Business?
Sometimes, it is difficult to choose between PowerBI and Tableau. This article will tell you the difference between them. So, you can make a wise choice between them.