Truck Capacity Board: Match Available Drivers to Open Loads Before Capacity Goes to Waste
A live board of every truck and driver — status, location, and next available date — matched to your open loads, with deadhead and equipment factored in, so a dispatcher approves each assignment before it's committed.
A web tool where you update each truck/driver's status, location, and available date, the board suggests load-to-capacity matches ranked by deadhead and equipment fit, a dispatcher approves each match, and it commits the assignment and refreshes the board — plus a clean CSV export for your TMS.
Before you start
- A Supabase account (free)
- A Vercel account (free)
- A Resend account (free)
- A CSV of your trucks/drivers and a CSV of your open loads
- Claude Code or any AI coding agent
The problem this kills
Empty trucks are money on fire. A driver clears a delivery in Memphis at noon, your TMS still shows them "in transit," and the load that would have kept them loaded sits open on a board nobody is watching in real time. By the time someone connects the dots, the truck has deadheaded 200 miles to the wrong place, or sat idle a day, or a broker covered the freight you could have taken.
The information to prevent this almost always exists — it's just scattered. Driver statuses live in someone's head and a group text. Available dates are guessed. Open loads are on a whiteboard or a spreadsheet. Nobody has a single, current view of "who's free, where, and when" lined up against "what needs moving." So capacity gets wasted not because you don't have trucks, but because you can't see the match fast enough. You do not need to be a developer to build the thing that shows you.
What you'll build
A simple internal web tool for dispatch and brokerage. You keep each truck/driver's status, current location, and next available date current — by quick update or CSV import. You load your open loads the same way. The board lines available capacity up against open loads and ranks the matches: it factors deadhead distance (how far the empty truck has to drive to the pickup) and equipment type (a reefer load needs a reefer), so the best fit floats to the top. A dispatcher reviews each suggested match and clicks Approve or Skip. Only an approved match becomes an assignment — the load is marked covered, the truck's next-available rolls forward, and the board refreshes. You also get a clean CSV export in the exact columns your TMS or load board expects.
What's inside the Implementation Plan
The downloadable plan is a step-by-step file you paste into an AI coding agent. It opens by interviewing you about your business — how dispatch works today, what TMS or spreadsheets you run, the real fields and codes in your driver and load data, your equipment types and lanes, your typical and peak volumes, and your real rules for who may commit a load. It reads a short spec back to you for a thumbs-up, then builds the tool around your answers instead of a generic template. From there it walks the agent through the data model, the capacity and load imports, the deadhead-and-equipment matching engine, the dispatcher approval screen, the assignment commit, and the TMS-ready CSV export. Every step ends with a ready-to-copy prompt.
The governance it includes (this is the point)
This isn't a toy. The plan builds in the controls a real operation needs: login so only your dispatch team can use it, row-level security so people only see their own company's trucks and loads, a complete audit trail of every status change and every approve/skip decision (who, what, when), a hard human-approval gate so no load is committed to a truck until a dispatcher signs off, and duplicate guards keyed on truck/driver + date so the same capacity can't be double-booked or the same import processed twice. The AI suggests the match; a person makes the call.
Who it's for
Dispatchers, brokers, fleet coordinators, and small-carrier owners who are tired of empty miles and uncovered freight, and who want one current view of capacity against loads. If you can describe how you decide which truck takes which load, you can build this.
You've got this — open the plan, paste the first prompt, and you'll be matching your first real loads to available trucks this afternoon.