The Brokerage P&L: Gross Margin by Customer, Overhead, Break-Even Loads & a Chart
This lesson is part of the course
In this lesson
You summarise a month's loads by customer with SUMIFS, compare gross margin and margin % per customer, subtract overhead to get the operating profit, work out the break-even loads per month and chart margin by customer.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Margin per Load: Shipper Rate, Carrier Pay, Margin % and Margin per Mile Locked
- Quoting a Lane: Market Range from Past Loads, Target Margin & a Floor Price Locked
- Accessorials: Detention, Extra Stops & Unloading – Billed vs Paid and Leakage Locked
- Fuel & Mileage: All-In Rates vs Linehaul plus Fuel Surcharge Locked
- Quick-Pay & Factoring: Carrier Discounts, Payment Terms and the Cash Gap Locked
- Choosing a Carrier: On-Time %, Claims, Tender Acceptance & Price in a Weighted Score Locked
- Desk Productivity: Loads per Broker per Day, Margin per Broker & Commission Tiers Locked
- The Brokerage P&L: Gross Margin by Customer, Overhead, Break-Even Loads & a Chart Locked