🚛

Miler

Freight mileage & cost analyzer. Look up driving miles, log each load with its actual freight cost and case count, and see which loads cover the $1.84/case transportation target.

Load #

Customer / Consignee

Cases / order

Freight cost — actual $ paid

Weight (lb) — for $/lb

Rate $/lb (if quoted by weight)

Pallets

Weight (notes)

Freight class

Notes / freight description

Quoting rate / mile (optional)

0mi

🗺 Route map

Plot a lookup above, or tap 🗺 on any load below. Scroll/drag to explore.

No route plotted yet.

Freight Log

target/case $

Seeded with your freight workbook loads (L01–L09). Miles are blank until calculated — click Fill missing miles to look them up for all loads with a clear origin & destination (a few seconds each; Hawaii / TBD / unclear destinations are skipped). Add a load above to log new ones. $/mi = freight ÷ miles, $/case = freight ÷ cases, and vs target compares the actual freight cost to cases × the per-case target. Est. cost auto-fills the moment miles are run on any load with a weight (lb): booked $/lb where known (bk), otherwise the UNFI West distance model (~, $/lb = fixed + variable × miles) × weight. It's an estimate, not a quote.

UNFI Rate Reference — FF#41984

cases/pallet wt/case A (gross) lb wt/case B (UNFI 473/plt) lb

Live rebuild of the rate-conversion workbook, driven by the seeded UNFI lanes (U01–U21) — edit a lane's $/lb or miles with ✎ in the Freight Log and this updates automatically. $/case = $/lb × wt/case; $/pallet = $/case × cases/pallet; implied $/lb·mi = $/lb ÷ miles. The West fit is a least-squares regression of $/lb on miles.

Lot Movement Tracker

multi-move only

Log each move as it happens: enter the lot code, where it went, and the date — repeated entries build the lot's chain. A lot is flagged once it has been moved more than once (e.g. co-packer → 3PL → 3PL → customer = 3 moves). Paste lot codes from Cin7 below to pre-register them before any movement.

Lot code

Moved to (stop type)

Location

Date

Pre-register lot codes from Cin7 (comma or line separated)

Distances are estimated road miles between geographic centers, via OpenStreetMap (Nominatim) and the OSRM routing service. Requires an internet connection. For general logistics estimating — not legal/IFTA filing. The $1.84/case figure is the budgeted transportation cost when Sidari pays freight; inbound vendor/co-packer moves are tracked separately.