Multi-Carrier LTL Rate Comparator
Rate one LTL shipment against every carrier tariff you have on file and get a ranked, all-in comparison so your coordinator books the cheapest sensible option in seconds, not three browser tabs.
A logged-in internal tool where a coordinator enters a shipment, sees every carrier ranked by all-in cost (base + fuel + accessorials, after discount and minimum), approves one, and gets a saved booking record plus an emailed confirmation.
Before you start
- A free Vercel account
- A free Supabase account
- A free Resend account
- One rate sheet (CSV or Google Sheet) per carrier you ship with
The problem this kills
Every LTL quote is the same grind. Your coordinator opens three carrier portals, keys the same origin, destination, weight, and freight class into each one, copies the numbers into a spreadsheet, tries to remember which carrier had the better fuel surcharge this month, and forgets to add the liftgate fee until the invoice comes in $90 over. Multiply that by every shipment, every day. The "cheapest carrier" decision ends up being whichever portal loaded first.
The rate sheets you already negotiated are sitting in spreadsheets nobody rates against consistently. The knowledge of "which carrier wins for the Southeast under 1,000 lbs" lives in one person's head. When they're out, quoting slows to a crawl.
What you'll build
A single internal screen where a coordinator types in one shipment - origin and destination zip, weight, freight class, and any accessorials like liftgate or residential delivery - and instantly sees every carrier you have on file ranked by true all-in cost. The tool applies each carrier's zone or zip-band rate, minimum charge, discount off base, and current fuel surcharge percentage, adds the accessorial fees, and shows you the ranked list with the math broken out so you trust it.
The coordinator picks the winner, approves it, and the tool saves a booking record and emails a confirmation. No more three-tab quoting. No more forgotten liftgate fees.
What's inside the Implementation Plan
The plan opens by interviewing you about your business - your carriers, how their rate sheets are actually shaped (zone tables vs. zip bands), your real freight classes, your accessorial names and fees, your typical and peak shipment volumes, and the messy edge cases like guaranteed delivery or over-length surcharges. It reads a short tailored spec back to you and waits for your thumbs-up. You are not getting a generic template; you are getting a tool shaped to your tariffs and your TMS column names.
From there it walks you, prompt by prompt, through building the database, the rate-sheet importer, the rating engine that handles minimums and fuel and discounts correctly, the ranked comparison screen, the approval gate, and the booking record with its emailed confirmation. Every build step ends with a ready-to-paste prompt.
The governance it includes (this is the point)
- Login so only your team can rate and book.
- Row-level security so each organization only ever sees its own tariffs and bookings.
- A complete audit trail - who rated what, who approved which carrier, and when.
- A hard human-in-the-loop approval gate - the tool ranks and recommends, but no booking record is written until a coordinator reviews the comparison and approves the chosen carrier.
- Duplicate guards - a shipment ID built from origin, destination, ready date, and customer reference stops the same shipment from being booked twice.
- Gap flagging - if a zip doesn't map to a zone in a carrier's tariff, the tool flags the gap instead of silently quoting a wrong number.
Who it's for
Shipping coordinators, traffic managers, and small-business operations people who today open three carrier portals to compare a single LTL quote - and anyone who has ever been burned by an accessorial fee that didn't show up until the invoice.
You've got this - paste the first prompt and let the interview tailor the rest.