Load Profit Calculator

What it does

Brokers quote a linehaul; you need to know what is left after fuel, deadhead, driver pay, factoring and your fixed costs for the days you are on the load. This spreadsheet does that math for every load you are offered, then logs the ones you book.

• Load Calculator: type origin, destination, loaded miles, deadhead, linehaul, fuel surcharge, accessorials, tolls, lumper, days on load and any quick-pay fee
• Shows gross revenue, revenue per loaded mile and per all miles, fuel cost, maintenance/tire reserve, driver pay, factoring + quick-pay fees, dispatch fee, fixed cost allocated for the days, and tolls + lumper
• NET PROFIT, net per mile and net per day — and a big color-coded verdict: TAKE IT (green), NEGOTIATE (orange) or PASS (red) against your target profit per day
• "What rate do I need?" — the minimum linehaul (and per loaded mile) that hits your target, plus the breakeven linehaul and how far the offer is from it
• Load Log: 100 rows with the same inputs → profit per load, running net profit, a 12-month summary (loads, miles, revenue, net profit, net per mile) and your best / worst lane
• Driver pay by per-mile (all or loaded miles), percent of linehaul, or flat per load — or set it to what you pay yourself

What's included

• 1 Excel workbook (.xlsx) with 4 tabs: Start Here · Load Calculator · Load Log · Settings
• Settings tab for MPG, fuel price, variable cost per mile, fixed cost per day, factoring %, dispatch %, fuel-surcharge basis, driver pay model and target profit per day
• 12 realistic example loads already logged and a worked example load on the calculator, so you see it working on first open
• Start Here tab with 5 steps and a color legend
• Instant digital download — no subscription, no macros

Tabs

• Start Here
• Load Calculator
• Load Log
• Settings