Freight Brokerage by the Numbers: Load Margins, Carrier Rates, Quick-Pay & Factoring Fees, Accessorials & Desk Productivity
Run a freight brokerage desk by the numbers: shipper rate vs carrier pay, margin per load and per mile, accessorials, quick-pay discounts, payment gaps and loads per broker, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
This course runs a fictional freight brokerage desk in a spreadsheet. You calculate margin %, markup and margin per mile with XLOOKUP on a lane table, quote a lane from the median of past carrier payments with a target margin, a floor price and CEILING, find accessorial leakage with IF and SUMIFS, compare all-in rates with linehaul plus a fuel surcharge step table, date quick-pay with WORKDAY and price the cash gap with a fictional factoring fee, score carriers with weights and RANK.EQ, measure desk productivity and commission tiers, and finish with a P&L by customer, break-even loads and a chart.
Lessons
- Margin per Load: Shipper Rate, Carrier Pay, Margin % and Margin per Mile Pro
- Quoting a Lane: Market Range from Past Loads, Target Margin & a Floor Price Pro
- Accessorials: Detention, Extra Stops & Unloading – Billed vs Paid and Leakage Pro
- Fuel & Mileage: All-In Rates vs Linehaul plus Fuel Surcharge Pro
- Quick-Pay & Factoring: Carrier Discounts, Payment Terms and the Cash Gap Pro
- Choosing a Carrier: On-Time %, Claims, Tender Acceptance & Price in a Weighted Score Pro
- Desk Productivity: Loads per Broker per Day, Margin per Broker & Commission Tiers Pro
- The Brokerage P&L: Gross Margin by Customer, Overhead, Break-Even Loads & a Chart Pro