T4W Dispatch

⚙️ Setup Required

Before using the T4W Dispatch System, complete these 3 steps:

Step 1

Run the SQL Schema in Supabase

Open your Supabase project → SQL Editor → paste and run the contents of schema.sql

Step 2

Enter Your Supabase Credentials

In this file, find SUPABASE_URL and SUPABASE_KEY near the top of the script and paste your project URL and anon key from Supabase → Settings → API

Step 3

Set Your Password

In this file, find APP_PASSWORD and change it to a strong password of your choice

📦 Loads

🚛 Carriers

👤 Drivers

🤝 Brokers

🏭 Shippers

📋 Onboarding

🔧 Equipment

🧮 CPM

📊 Reports

Total Loads

—

All time

Active

—

In progress

Gross Revenue

—

Total billed

Net Profit

—

Your earnings

Unpaid

—

Outstanding

Load #	Status	Carrier	Driver	Route	Pickup	Delivery	Outcome	Gross	Net Profit	$/mi	Payment	Actions
Loading loads...

Loading loads...

Loading carriers...

Driver	Carrier	Phone	Truck Type	Truck #	Loads	Avg $/mi	On Time %	Issues	Status	Actions
Loading drivers...

Cost Per Mile (CPM) Calculator

Enter all costs and monthly miles to find the minimum rate needed to break even. Use this with carriers who don't know their numbers.

Fixed Monthly Costs (same every month)

Truck / Equipment Payment ($)

Insurance ($/mo)

ELD / Subscriptions ($/mo)

Maintenance Reserve ($/mo)

Tire Reserve ($/mo)

Other Fixed ($/mo)

Variable Costs (change based on miles/loads)

Fuel Price ($/gallon)

Miles Per Gallon (MPG)

Driver Pay ($/mile) — if applicable

Tolls (estimated $/mile)

Lumper / Misc ($/load avg)

Avg Miles Per Load

Monthly Miles

Estimated Miles Per Month

Estimated Loads Per Month

CPM Breakdown

Total Cost Per Mile (Break-Even)

$0.0000/mi

You must charge MORE than this per mile to profit

Fixed CPM$0.0000/mi

Fuel CPM$0.0000/mi

Driver Pay CPM$0.0000/mi

Tolls CPM$0.0000/mi

Lumper CPM (per mile)$0.0000/mi

Total Monthly Costs$0.00

Minimum Load Rate Needed$0.00

Load Rate Profitability Checker

Load Rate ($)

Load Miles

Enter a load rate and miles above to see profit or loss

Financial Snapshot

Gross Revenue

—

Net Profit

—

Avg Net / Load

—

per load

Avg Dispatch %

—

across all loads

Total Loads

—

Delivered

—

completed

In Progress

—

active now

Avg Miles/Load

—

miles

Cash Flow

Paid — Collected

—

Factored — Pending

—

Unpaid — Outstanding

—

Performance

On-Time Rate

—

of delivered loads

Late Deliveries

—

loads

Issues Logged

—

during or at delivery

Avg Rate/Mile

—

per mile

Load Status Snapshot

Weekly / Monthly Breakdown

Week	Loads	Gross	Net	Avg $/mi

Broker Revenue

Broker	Loads	Gross	Net to You	Avg $/load

Carrier Leaderboard

Carrier	Loads	Net	On Time	Issues

Driver Leaderboard

Driver	Loads	Avg $/mi	On Time	Issues

Top Lanes by Net Profit

Route	Loads	Avg Gross	Avg Net	Avg $/mi

Outstanding Invoices — Aging

Load #	Carrier	Broker	Net Due	Age

Broker	MC #	Contact	Phone	Avg Pay Days	Quick Pay	Loads	Total Paid	Rating	Penalties	Status	Actions
Loading brokers...

Shipper	City / State	Contact	Phone	Commodity	Dock Hours	Appt Required	Rating	Actions
Loading shippers...

Loading onboarding clients...

Year	Make	Model	VIN	Status	Notes	Actions
Loading equipment...