Guides › Trades & Field Services

Spot cheaper routes and fewer half-empty loads

Paste a month of shipment data and get a short list of loads to combine, routes to rethink and savings to test.

Logistics coordinatorBeginner15 minAI assistantExcel
Open the interactive guideBrowse all guides

When to use it

Monthly, or when transport costs creep up

Step by step

  1. Export your shipments

    From your transport system or spreadsheet, export a month of shipments with date, origin, destination, weight or pallets, vehicle type, carrier and cost. Remove customer names.

  2. Ask for an efficiency review

    Paste the table into your AI assistant with this prompt.

    Prompt to copyYou are helping a logistics coordinator review a month of shipments. Using the data below: 1) find shipments on the same lane within [2] days that could have been combined, and estimate the saving using the costs shown; 2) list the 5 lanes with the highest cost per pallet; 3) flag loads under [60]% vehicle fill; 4) suggest 3 practical changes to test, such as fixed delivery days or a different vehicle size. Show your calculations in a table so I can check them, and say clearly where you are estimating. Data: [paste table]
  3. Check before you act

    Spot-check the suggested combinations against real delivery windows and customer promises, which the data may not show.

  4. Test one change

    Pick one idea, try it for a month and compare the next export to see if costs actually moved.

What you get

Combine: Leeds to Bristol on 3rd and 4th (6 + 5 pallets) could share one 26-pallet trailer, est. saving 310. High cost lane: Hull to Exeter at 58 per pallet. Test: fixed Tuesday and Thursday runs to the South West.

Tips

More Trades & Field Services guides