Trucking Sales Forecast Template

Once the base numbers look right, adjust the seasonality row in the Monthly Forecast sheet to match how your freight lanes actually move through the year. If you haul produce, your Q2 and Q3 might be your strongest months. If you run retail freight, Q4 is peak and January is slow. Adjust each month's multiplier up or down from 1.0 to reflect that pattern — the rest of the formulas handle the math. Then fill in the Scenario Planning sheet with your upside assumptions (getting that dedicated lane, adding a truck) and your downside assumptions (rate erosion, market softness).

A driver-based sales forecast grounds your revenue projections in the numbers you can actually control: load count per truck, average loaded miles, and the rate per mile you're negotiating or bidding. Industry benchmarks vary widely by lane type and equipment — dry van carriers typically run RPMs between $1.80 and $2.40 depending on market conditions, while flatbed and refrigerated freight can run higher. Fuel surcharge typically adds 8–15% on top of linehaul depending on diesel prices. Tracking those streams separately in your forecast means you can see clearly when a revenue shift is a rate problem versus a utilization problem.