Logistics KPI Dashboard Excel

A monthly scorecard for a carrier or brokerage: type twelve rows of inputs and read eleven KPIs by month, the latest month against the previous and the 12-month average, with trend charts.

WHAT YOU GET

• Inputs: loads, revenue, purchased transportation, loaded and empty miles, on-time counts, claims, fuel, operating expenses, trucks, drivers
• KPIs by month: revenue per loaded mile, deadhead %, on-time pickup and delivery %, claims per 100 loads, claims % of revenue, fuel % of revenue, operating ratio, gross margin % (brokers), revenue per truck, loads per truck
• Dashboard: latest month, previous, 12-month average and direction for every KPI; two trend charts
• Rules-of-thumb benchmarks listed for reference
• Two files: US (miles, US$) and metric (km, CA$)
• Quick-start PDF

378 formulas across the two workbooks, recalculated and checked for errors before listing. Sheets: Start here, Dashboard, Inputs, KPIs.

HOW TO USE

1. Buy, then download on the page that opens right after payment (your Stripe receipt email carries the same link).

2. Open the workbooks in Excel 2016 or later, Google Sheets or LibreOffice; the quick-start PDF opens in any PDF app.

3. Yellow cells are inputs, grey cells calculate. Replace the example rows with your own.

PLEASE NOTE

• Digital download only; nothing is shipped. Returns are not possible on digital files; if a file will not open, email [email protected] and it gets fixed.
• Works in Excel 2016 or later, Google Sheets and LibreOffice; drop-downs and charts included.
• Templates are not legal, tax or insurance advice. Have agreements reviewed by your own counsel and follow your own operating rules.
• For use in one business. Not for resale or redistribution.

Designed by A3E Studio (Ontario, Canada) and generated by our own software; every formula is recalculated and checked before listing.