Clevity Blog - What Is Your Logistics Data Worth?

What Is Your Logistics Data Worth?

What Is Your Logistics Data Worth?

Most areas of your organization are generating data faster than ever, and your supply chain and logistics functions are no exception.  However, we often find that this data is used to make more simple daily decisions, such as which trucks to send via existing lanes and providers, rather than more complex changes that result in significant ROI for the organization.  Here are a few analytics techniques that we find useful, and can greatly reduce your shipping and logistics costs.

Use Case 1: Company A decided to engage in a project to better understand what it is paying for its shipping lanes, which are a mix of truckload and less-than-truckload lanes across the United States.

The logistics group has built long-standing relationships with certain providers and, although they are not the lowest cost providers available, the combination of service and value makes sense to the group.  Additionally, being the loyal group that they are, they feel that they owe it to these providers to maintain the long-term relationships that they worked so hard to build.  Besides, changing the network is a grueling task and it is difficult to get the information to prove a change should be made.

This is common, and often works just fine for the business.  However, just how much are you leaving on the table when you take this approach?  The answer typically lies in the combination of your historical shipment data and other third-party data sources.

For one, you can check load boards, such as DAT, to check the current rates for lanes that you want to question.  In addition to load boards, there are myriad companies offering third-party benchmark data where you can enter lane and product information to determine what others in the industry are paying.

You should use your historical shipment data in conjunction with these third-party data sources to 1) benchmark shipments against industry standards, and 2) benchmark your shipment lanes against one another.

Using both of these methods provides you with a couple of data points to determine which 3PL providers you may be overpaying.  Particularly, when both internal and external benchmarks point to lanes with high costs relative to other lanes (after factoring in product dimensions and density, lane frequency, etc), there is a significant opportunity to decrease costs in your network.

Many organizations that take this approach realize savings of 10% or more in their annualized shipment costs.

 

Use Case 2: Company B makes pricing decisions based on either material margin or gross margin excluding shipping costs, due to the complexity of determining shipping cost at the product level.

How can you determine the optimal price for your products if you do not have a full view of the cost to deliver them to the customer?  Businesses often ignore or make general assumptions about shipping costs for one reason: they are not available at the product or transaction level.  Due to the nature of shipments, these costs are typically available at the shipment waybill level, meaning dozens of products may fall under the same cost umbrella.

The good news is, with some careful planning, there is a way to more accurately view shipment costs at the product and/or transaction level.

First, you need to bridge the gap between your sales transaction data and your shipment data.  Typically, this involves merging multiple data sets together based on nothing but date, waybill/shipment #, and little else.

Second, you need to determine the best way to allocate shipments across products for your organization.  Depending on the types of products that you sell, you may chose to allocate based on product weight, dimensions, quantity, or some other measure.  It is recommended to keep your allocation logic flexible so that you can test out each of these methods until you find the measure or measures that work best.

Finally, you need to write the logic to perform the allocation so that you can add the allocated cost to your transaction data.  This is usually best completed using an automated SQL script or similar method so that it can be reproduced on a daily, weekly, or monthly basis.

Once you have solidified the allocation of shipment costs into your transaction level data, you can now roll it up to the product level for a better understanding of total costs.  Although you may not find surprises across the board, there will likely be some significant opportunities to increase prices based on your deeper understanding of total costs.

 

Do you have additional suggestions for how to turn logistics data into higher margins?  Please let us know in the comments, or visit us at http://www.clevity.com to learn more!

Pingbacks are open.

Trackbacks
  1. insert your data on 03/05/2017 12:17 p.m. #

    Clevity

  2. browse around this web-site on 03/10/2017 1:08 a.m. #

    Clevity

  3. Kobe bryant Shoes on 03/11/2017 10:56 a.m. #

    Clevity

  4. http://edenderham.xyz on 03/11/2017 12:43 p.m. #

    Clevity

  5. Carpet Cleaning Melbourne on 03/12/2017 7:49 a.m. #

    Clevity

  6. Going Here on 03/15/2017 2:54 p.m. #

    Clevity

  7. beneficios da corrida diariamente on 03/18/2017 9:21 p.m. #

    Clevity

  8. buy car no title fort worth tx on 03/19/2017 3:58 a.m. #

    Clevity

  9. her latest blog on 03/23/2017 2:24 p.m. #

    Clevity

  10. similar site on 03/25/2017 1:13 p.m. #

    Clevity

  11. Bagoes Teak Furniture on 03/30/2017 2:43 a.m. #

    Clevity

  12. wildlife removal on 03/30/2017 6:01 p.m. #

    Clevity

  13. http://gregoryskbr765422.soup.io/ on 04/02/2017 7:24 a.m. #

    Clevity

  14. cheappsychicguy43.total-blog.com on 04/03/2017 4:27 a.m. #

    Clevity

  15. click the following internet page on 04/05/2017 2:43 a.m. #

    Clevity

  16. מסגר on 04/07/2017 2:17 a.m. #

    Clevity

  17. here I googled it on 04/15/2017 5:34 p.m. #

    Clevity

  18. mouse click the up coming document on 04/15/2017 6:23 p.m. #

    Clevity

  19. johnson and johnson xarelto patient assistance on 04/15/2017 8:36 p.m. #

    Clevity

  20. citation on 04/16/2017 7 a.m. #

    Clevity

  21. Tyrant box set on 04/16/2017 8:27 p.m. #

    Clevity

  22. tour lithograph on 04/17/2017 9:31 a.m. #

    Clevity

  23. Elsa on 04/21/2017 12:26 p.m. #

    Clevity

  24. Preturi Instalatii GPL on 04/25/2017 11:52 a.m. #

    Clevity

  25. 遺品整理 on 04/26/2017 5:21 a.m. #

    Clevity

  26. clash clans free gems on 04/27/2017 11:08 a.m. #

    Clevity

  27. Medicare Supplemental Insurance 2018 on 04/27/2017 11:27 p.m. #

    Clevity

  28. why not try this out on 04/28/2017 1:22 p.m. #

    Clevity

  29. canvas on 05/10/2017 10:06 a.m. #

    Clevity

  30. My Home Page on 05/13/2017 2:31 p.m. #

    Clevity

  31. http://www.skin-disease.org on 05/20/2017 4:07 p.m. #

    Clevity

  32. www.teamfc3s.org on 05/20/2017 4:08 p.m. #

    Clevity

  33. like it on 05/20/2017 4:54 p.m. #

    Clevity

  34. www.skin-disease.org on 05/21/2017 6:07 a.m. #

    Clevity

  35. roblox hack on 08/22/2017 4:02 a.m. #

    Clevity

Trackback URL

Comments

Powered by Clevity

© Clevity, Inc. 2017