
FTL Load Pricing and Margin Analysis
Analyze FTL bids and optimize freight margins with data-driven pricing
What You Can Do
You can input freight lane data, carrier bids, and operating costs to generate competitive rate recommendations and margin analysis. The skill models market conditions, calculates profitability scenarios, and identifies pricing opportunities across your FTL portfolio to maximize revenue while remaining competitive.
Features
Input multiple carrier quotes for the same lane and receive ranked analysis with pricing breakdowns, margin implications, and competitive positioning
Automatically compute gross margin, net margin, and margin per mile based on revenue, line haul costs, accessorials, fuel surcharges, and overhead allocation
Compare your quoted rates against market trends by region, lane type, and cargo class to identify underpriced or premium opportunities
Factor in fuel costs, driver pay scales, equipment maintenance, insurance, and administrative overhead to establish break-even pricing and minimum margin thresholds
Analyze load-by-load and aggregate margin performance across lanes to identify high-priority pricing adjustments and volume targets
Receive data-driven bid price recommendations based on cost structure, market rates, target margin, and competitive positioning
Test how changes to rates, volumes, or cost assumptions impact profitability without committing to live pricing
Generate summaries with margin metrics, pricing tables, and visualizations ready for internal reviews or stakeholder reporting
Example Output
Bid Analysis for LA-Chicago Lane:
- Carrier A: $2,400 @ 840 miles = $2.86/mile, Gross Margin: 18% on $3,000 revenue
- Carrier B: $2,100 @ 840 miles = $2.50/mile, Gross Margin: 6% on $3,000 revenue
- Recommendation: Accept Carrier A; margin justifies operational risk
Portfolio Margin Summary:
- Total Volume: 145 loads, $486,000 revenue
- Gross Margin: 22.5% ($109,350), Net Margin: 8.2% ($39,912)
- Lanes Below Target: 12 lanes averaging 5% margin
- Action: Repricing recommended on Atlanta, Dallas, Denver routes
Cost Breakdown (Example Load):
- Line Haul Cost: $1,800 | Fuel: $280 | Driver: $400 | OH Allocation: $200 = Total Cost: $2,680
- Revenue: $3,100 | Gross Margin: $420 (13.5%)
- Recommended Price: $3,280 for 18% target margin
What's Included
- Bid Parsing and Normalization: Automatically structure quote data (rates, distances, accessorials, surcharges) into comparable format across multiple carriers
- Cost Database Integration: Built-in framework to organize fuel prices, driver pay rates, equipment costs, insurance premiums, and overhead allocations
- Margin Calculation Templates: Pre-built formulas for gross margin, net margin, margin per mile, break-even analysis, and margin contribution by lane or customer
- Pricing Decision Matrix: Structured output showing accept/reject recommendations with confidence scores based on cost coverage and margin targets
- Market Intelligence Framework: Guidance on incorporating spot market rates, contract benchmarks, seasonal trends, and regional demand signals into pricing logic
- Scenario Templates: Ready-to-use prompts for modeling fuel cost changes, volume commitments, margin floor adjustments, and competitive pricing shifts
Who It's For
- Freight Brokers
- Logistics Managers and Rate Analysts
- Carrier Operations and Dispatch Managers
- Pricing Specialists
- Supply Chain Managers
Best For
- Evaluating carrier bids on individual loads or lanes
- Calculating profitability margins across your freight portfolio
- Setting competitive yet profitable bid prices
- Identifying underpriced loads or margin-at-risk lanes
- Modeling the financial impact of cost and rate changes







