How to Calculate Air Cargo Chargeable Weight and Estimate Freight Costs (Spreadsheet Template + Step‑by‑Step Workflow)
chargeable weightvolumetric weightair freight ratesshipping cost templatefreight quoting

How to Calculate Air Cargo Chargeable Weight and Estimate Freight Costs (Spreadsheet Template + Step‑by‑Step Workflow)

GGMG Air Editorial Team
2026-11-11
7 min read

Learn how to calculate air cargo chargeable weight, compare volumetric and gross weight, and estimate freight costs with a spreadsheet workflow.

Air cargo chargeable weight is the figure carriers use to price a shipment when its space is more expensive than its physical weight. This guide shows how to measure and calculate it, compare it with gross weight, build a repeatable air freight cost estimate, and use a simple spreadsheet template before requesting an air freight quote.

Overview

Most air freight quotes begin with two measurements: the shipment’s actual gross weight and its volumetric, or dimensional, weight. The carrier usually charges on the higher of the two, subject to its rounding rules, minimum chargeable weight, rate break, and applicable surcharges. That higher figure is the chargeable weight.

For example, a lightweight carton with substantial dimensions may occupy more aircraft space than its scale weight suggests. Conversely, a dense carton may be priced from its gross weight because it weighs more than its calculated volume would imply.

A chargeable-weight calculation is an estimate, not a final invoice. The confirmed amount can change after a carrier, consolidator, or warehouse remeasures the cargo. Service level, origin and destination, commodity, aircraft capacity, security requirements, customs services, pickup and delivery, and the agreed Incoterm can also change the total.

Use this workflow to prepare better inputs for an air freight cost calculator or to compare quotes on a like-for-like basis.

How to estimate air cargo chargeable weight

Step 1: Pack the shipment as it will travel

Measure the finished transport package, not the product before packing. Include the carton, pallet, protective materials, straps, outer wrapping, and any other packaging that will remain with the shipment. Record the number of pieces and whether every piece has the same dimensions.

Step 2: Measure every piece

For each package, record the greatest external length, width, and height. Use one unit consistently, such as centimetres. Irregular or overhanging cargo may require a carrier’s specific measuring method, so note anything that could affect the final dimensions.

Step 3: Record gross weight

Weigh each packed piece and add the results. Gross weight should represent the cargo as tendered to the carrier. If a pallet or shipping platform is included in the transport unit, clarify whether its weight is included in the quoted weight.

Step 4: Convert volume into volumetric weight

A common metric formula is:

Volumetric weight per piece (kg) = length (cm) × width (cm) × height (cm) ÷ dimensional divisor

The divisor is set by the carrier, service, route, or rate agreement. A divisor of 6,000 is often used as a starting assumption for air shipments, but it is not universal. Some services or rate schedules may use a different divisor. Always replace the assumed divisor with the one shown in the carrier’s quotation or tariff.

Step 5: Apply rounding and minimum rules

Carriers may round dimensions, piece weights, volumetric weights, or the final chargeable weight. They may also apply a minimum chargeable weight or a minimum transportation charge. Do not silently use a preferred rounding method in your spreadsheet; create a separate field for the carrier’s rule and confirm it when requesting an air freight quote.

Step 6: Select chargeable weight and estimate the freight line

Compare total gross weight with total volumetric weight after the carrier’s stated rounding. The larger figure is normally the estimated chargeable weight. Multiply it by the applicable rate per kilogram, then add known surcharges and service fees. Keep transportation charges separate from customs duties and taxes, which are generally determined by the destination authorities and shipment details rather than chargeable weight alone.

Spreadsheet template

You can create a practical CSV template by copying the following headings into a spreadsheet. The formulas below assume dimensions are in centimetres, weight is in kilograms, and the divisor is entered in cell B2.

Dimensional divisor,6000
Piece ID,Length cm,Width cm,Height cm,Gross kg,Volume cm3,Volumetric kg,Chargeable kg,Rate per kg,Freight amount
1,60,40,40,12,=B3*C3*D3,=F3/$B$2,=MAX(E3,G3),0,=H3*I3

For multiple pieces, add one row per piece and use the same formulas for each row. Add separate input cells for fuel or security surcharges, pickup, delivery, handling, documentation, customs clearance, insurance, and currency conversion where applicable. Label every input as either included, excluded, estimated, or confirmed. This prevents a low transportation rate from being mistaken for a low all-in cargo shipping cost.

For a ready-made workflow, see how air freight rates are combined into a total cargo shipping cost.

Inputs and assumptions to confirm

Before comparing air freight rates, assemble a complete shipment profile. A quote based only on total kilograms may be too incomplete to compare accurately.

  • Package data: piece count, packed dimensions, gross weight, stackability, and pallet details.
  • Routing: airport-to-airport or door-to-door, origin and destination, collection and delivery postcodes, and any transit points.
  • Service: general cargo, express air cargo, priority handling, or a time-sensitive booking.
  • Commodity: a clear description, quantity, value, harmonized classification where known, and any batteries, liquids, perishables, dangerous goods, or controlled items.
  • Commercial terms: currency, validity period, payment terms, and the selected Incoterm. The air freight Incoterms guide explains how responsibility for transport and import processes can be allocated.
  • Included charges: line-haul freight, fuel or security surcharges, terminal handling, screening, pickup, delivery, customs clearance, storage, and documentation.

The following comparison is a planning reference only. It describes common patterns, not guaranteed carrier rules. Confirm the divisor, minimums, rounding, and surcharge names in the quote for the exact service and route.

Service or rule typePlanning assumptionWhat to verify
Express parcel serviceA metric divisor such as 6,000 may be usedPiece-level rounding, minimum billable weight, remote-area fees, fuel, and residential or delivery charges
General air cargoDivisors such as 6,000 or another published factor may applyRate breaks, minimum charge, terminal handling, screening, and consolidation fees
Palletized or dense freightGross weight may exceed volumetric weightWhether pallet weight, height limits, and stackability affect acceptance or pricing
Special cargoBase weight calculation may still applyDangerous-goods, temperature-control, live-animal, oversized, or security-related surcharges

Worked examples

Example 1: Volumetric weight is higher

Assume four cartons measure 60 × 40 × 40 cm each and weigh 12 kg each. Using a planning divisor of 6,000:

Volumetric weight per carton = 60 × 40 × 40 ÷ 6,000 = 16 kg.

Total gross weight is 48 kg, while total volumetric weight is 64 kg. Before any carrier-specific rounding or minimum, the estimated chargeable weight is therefore 64 kg. If a quoted transportation rate is entered as 4.20 per kilogram, the estimated freight line would be 64 × 4.20 = 268.80 in the quote currency. That figure does not include other charges unless the quote explicitly includes them.

Example 2: Gross weight is higher

Assume two dense cartons measure 50 × 40 × 30 cm and weigh 30 kg each. At the same planning divisor, volumetric weight per carton is 10 kg. Total volumetric weight is 20 kg, but total gross weight is 60 kg. The estimated chargeable weight is therefore 60 kg, subject to the carrier’s rounding and minimum rules.

Example 3: Packaging changes the result

If the first example is repacked so each carton measures 50 × 35 × 35 cm, its volumetric weight at a 6,000 divisor becomes about 10.2 kg. Four cartons would produce approximately 40.8 kg of volumetric weight. With the same 48 kg gross weight, the shipment would now be estimated at 48 kg chargeable weight. The saving is not automatic: smaller packaging may change protection, handling, palletization, or product damage risk. Use the comparison to evaluate packaging decisions, not to remove necessary protection.

When to recalculate

Recalculate the estimate whenever the shipment or pricing inputs change. The most important triggers are a new carton size, a different pallet configuration, a revised gross weight, a new origin or destination, a change from airport-to-airport to door-to-door service, or a change in express versus general cargo handling.

Also revisit the spreadsheet when a carrier provides a new divisor, rounding method, minimum chargeable weight, rate break, surcharge, or quote validity period. Fuel, security, handling, customs, and delivery charges can change independently of the base air freight rate. Refresh currency assumptions when comparing quotes in different currencies.

Before booking, run this checklist:

  1. Re-measure the final packed pieces.
  2. Reweigh the tender-ready shipment.
  3. Confirm the carrier’s divisor, rounding, and minimum rules.
  4. Separate freight from surcharges, customs, duties, taxes, and local delivery.
  5. Check that the quote uses the same service, route, currency, and Incoterm as competing quotes.
  6. Save the dimensions and assumptions with the booking and later use the AWB for shipment records and tracking.

For related preparation, review the air cargo booking workflow, the international cargo documentation checklist, and the AWB tracking guide. Re-running the calculation after each packaging or quote change gives your team a more consistent basis for choosing air freight rates and controlling the final cargo shipping cost.

Related Topics

#chargeable weight#volumetric weight#air freight rates#shipping cost template#freight quoting
G

GMG Air Editorial Team

Senior SEO Editor

Senior editor and content strategist. Writing about technology, design, and the future of digital media. Follow along for deep dives into the industry's moving parts.