Freight Class by Density

Excel Formulas › Logistics & Trucking

All versions

LTL freight class is driven largely by density — pounds per cubic foot. Higher density usually means a lower (cheaper) class. Density is weight over cubic feet.


Quick formula: density in pounds per cubic foot:
=weight_lb / (L*W*H / 1728)
Weight divided by cubic feet (cubic inches ÷ 1,728). Higher density maps to a lower freight class.

The example

150 lb, 48×40×48 in.

AB
1ItemValue
292,160 / 172853.3 cu ft
3150 / 53.3→ ~2.8 lb/ft³

The formula

The formula:

=weight_lb / ((L*W*H) / 1728) // weight ÷ cubic feet

How it works

How it works:

  1. Cubic feet = (L × W × H in inches) ÷ 1,728.
  2. Divide weight by cubic feet for density (lb/ft³).
  3. Higher density → lower freight class → cheaper rate (denser freight ships efficiently).
  4. Map density to a class table with a lookup if you need the NMFC class number.

Density rewards packing tight. LTL classes run from 50 (dense, cheap) to 500 (light, bulky, expensive), and density is the main driver: a denser shipment occupies less trailer per pound, so it costs less to haul. Computing lb/ft³ before booking lets you see your likely class — and shows when consolidating or re-packing to raise density would drop you into a cheaper class.

Try it: interactive demo

Live demo

Weight and dimensions (in).

Cu ft · Density

Variations

Cubic feet

From inches:

=(L*W*H) / 1728

Class lookup

Density to class:

=VLOOKUP(density, class_table, 2, TRUE)

Pallets of cube

Trailer fit:

=ROUNDUP(total_cuft / pallet_cuft, 0)

Pitfalls & errors

1,728. Cubic inches ÷ 1,728 = cubic feet.

Density ≠ class exactly. Class also weighs handling, stowability, liability.

Zero volume. Bad dimensions give #DIV/0!.

Practice workbook

📊
Download the free Freight Class by Density practice workbook
A freight-density sheet with the cubic-feet, class-lookup, and pallets variants, plus 4 challenges with answers. No sign-up required.

Frequently asked questions

How do I calculate freight density in Excel?
Weight over cubic feet: =weight_lb / ((L*W*H) / 1728). A 150 lb, 48×40×48 shipment is ~2.8 lb/ft³.
How does density affect freight class?
Higher density generally means a lower (cheaper) class, since dense freight uses less trailer space per pound.
How do I map density to a class?
Use an approximate VLOOKUP against a density-to-class table: =VLOOKUP(density, class_table, 2, TRUE).

Stop fighting formulas. Learn them in a day.

This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Related formulas: Dimensional weight · Truck capacity utilization · Convert units