In the course of a given week, I speak to a handful of our clients and invariably, I find one common theme that separates exceptional shipping departments from their average counterparts. Simply put, the exceptional departments have access to concrete data that give them unique insights into their operation, and — this is the key part — they act on that data to enact substantial and meaningful change. Even more impressively, when I talk to our clients who have implemented change based on the data provided, I’m amazed at how one simple report can generate such a monumental difference in the day-to-day operations of most facilities. In short, good data engenders great results.
We depend on having visibility to the data, and not just shipment/piece count, and averages for weights and zones, but rather detailed reports that paint a holistic picture of an organization’s distribution operation. But with myriad data to sort through and ability to slice it six ways from Sunday, how is any busy shipping manager supposed to know which reports can have the biggest impact? After all — the data is great, but if it doesn’t tell you anything, it’s nothing but a bunch of numbers. To that end, I’ve detailed the four most critical reports that any organization should access regularly in order to make informed decisions:
- Detailed Zone Analysis Report: This report provides the shipment count by service level, zone and weight, in addition to a summary of the volume and cost by service level and zone. This essential report offers an organization insight into the activity for each zone and the respective costs that are associated with shipping to each zone. Why is this essential? By tracking trends by zone, you can spot areas that may help you to reduce cost. For example, if there is a package that is typically shipped air, a Zone Analysis Report will show if you can save costs without sacrificing service by changing that shipment to ground. Without that report, you may go on uninformed — unknowingly paying two to three times the amount per shipment.
- Charge Mix Summary: This report will provide a breakdown of all costs by service level. It will then split out all accessorial charges including common fees such as fuel, residential surcharges, delivery area surcharges, and the “surprise fees” like address correction, late fees, large package, residential adjustments, and shipping charge corrections. This helps manage overall expenses and address the cost of fees either through negotiations or internal changes.
- Dashboards for C-level Employees: Comprehensive dashboards that offer clear and precise high-level summary-level information, typically focused on KPIs, can offer an “at-a-glance” strategic review of operations. In addition, dashboards help to measure the overall health of an organization’s transportation spend as measured against the cost of goods sold.
- Billing Mix Summary: This report helps identify invalid and unexpected charges. This can often be for “sub-services” such as 3rd party, freight collect, returns, and inbound shipments, which may not be receiving discounts. It is common for agreements to contain pricing for some of these services, while ignoring others. Most people are often surprised by the unexpected charges that they come across in these reports which is why it’s essential to constantly monitor this area and ensure that you’re getting the appropriate refunds from the carriers.
Depending on your organization, having access to other reports such as mode-optimization, GL code summaries, consolidated shipments, and others, can also be extremely beneficial. Although it’s a challenge to create and manage these reports on your own, your freight audit company should have this information available to you and should review this with you regularly. If not, finding a way to access these reports will offer an overall strategic view of the operation that most organizations can’t live without. After all, the consequences of living without good reporting could be costing you thousands.