Air freight quoting
Build air freight quotes from email, weight breaks and your own rates.
Freitt extracts the shipment, calculates chargeable weight, selects the valid band, adds the applicable charges and prepares the customer reply for review.
- Chargeable weight
- Weight breaks
- Minimum charges
- Traced to the rate line
Where this number comes from
- 1
Actual weight 2 pallets · 420 kg gross
- 2
Volume 1.68 cbm from 120 × 100 × 140 cm × 2
- 3
Volumetric 1.68 cbm ÷ 0.0035 divisor = 480 kg
- 4
Chargeable greater of 420 and 480 → 480 kg
- 5
Band +300 kg break · 3.90 per kg · row 47, valid to 30 Sep
- 6
Rated 480 × 3.90 = 1,872.00 · above the 285.00 minimum
- 7
Rule Air · Oceania · +12% → 2,096.64
Illustrative sample data. Fuel, security, pickup and delivery are quoted as their own lines.
No matching rate: LAX → PER
No valid lane in your sheets for this airport pair. Draft the rate inquiry to your carrier?
The greater-of rule, by hand, on every request.
Air pricing is arithmetic before it is judgement: volume against weight, the band that arithmetic lands in, and the minimum underneath both. It is not difficult. It is just done ten times a day, from dimensions typed into an email by somebody in a hurry.
- 01Read the dimensions out of the email, or out of a photographed packing list.
- 02Convert them if the customer used inches and your sheet is metric.
- 03Calculate volumetric weight on the divisor for that lane.
- 04Compare with actual weight and take the greater.
- 05Find which weight break that lands in — and check it is not just under the next one.
- 06Check the minimum charge does not beat both.
- 07Add fuel and security, then the pickup and delivery legs.
Air arithmetic, shown rather than assumed.
Every step of the calculation is on the quote, so a figure can be checked in seconds instead of recalculated.
- 01Read the shipment.Pieces, dimensions, actual weight, airports or doors, readiness date and Incoterms — from the email and its attachments.
- 02Calculate chargeable weight.Volumetric weight on the divisor your sheet uses, compared with actual weight, with the greater-of applied and both figures shown.
- 03Select the valid band.The weight break that the chargeable weight falls into, from a rate line that has not expired.
- 04Check the minimum.The minimum charge is applied where it beats the rated figure, rather than being remembered later.
- 05Add the charges your sheet lists.Fuel, security, pickup and delivery as their own lines, in the currency your sheet is written in.
- 06Draft the reply.Your format, terms and validity line, with every figure traceable back to the row it came from.
Chargeable weight, and the row it was rated on.
This is an air quote opened up: the volumetric calculation, the comparison that decided the chargeable weight, the band it landed in, the sheet and row it was rated from, the validity date, and the margin rule on top. Every one of those is a question a customer or a colleague can ask.
Read from the request
- Airports or doors
- Pieces
- Gross weight
- Dimensions
- Readiness date
- Incoterms
Calculated
- Volume
- Volumetric weight
- Divisor applied
- Chargeable weight
- Weight break
- Minimum charge
Added from your sheet
- Fuel surcharge
- Security surcharge
- Pickup leg
- Delivery leg
Recorded against the figure
- Source sheet
- Row
- Validity date
- Margin rule applied
What happens when something is missing.
This is the half of automation worth interrogating. Freitt says so rather than filling the gap — no invented rate, no assumed weight, nothing sent unread.
Air pricing you can check in seconds.
- 01Both weights are shown, not just the chargeable one.
- 02The divisor used is stated on the quote.
- 03The applied band and minimum are visible.
- 04Every charge names its source rate row.
- 05A person reviews and sends.
Use this when
- Air RFQs arrive by email with dimensions in the body or an attachment.
- Your airline and consolidator rates live in spreadsheets with weight breaks.
- Minimum charges and the greater-of rule are being applied from memory.
- You quote door-to-door as well as airport-to-airport.
Look elsewhere when
- You need live airline capacity and direct eBooking — that is a carrier-connectivity platform.
- You need spot market rates rather than your own contracted ones.
- Charter and project air, where the price comes from a phone call rather than a sheet.
- Your air rates exist only as PDF tariffs and have never been in a spreadsheet.
Air freight quoting, answered.
Something else on your mind? Bring it to a live quote session — thirty minutes, no deck, on one of your own RFQs.
The one your rate sheet is written on, per lane where your sheet varies it. The divisor used is stated on the quote so you can see which one was applied rather than inferring it from the result.
Yes. Actual and volumetric weight are both calculated and both shown, and the greater is used as the chargeable weight for band selection.
Applied where the minimum beats the rated figure. It is visible on the quote as the reason for the number rather than being an adjustment somebody remembers to make.
Yes, where your sheets carry the pickup and delivery legs. They appear as their own lines rather than being folded into the air freight figure.
The units are read as given and converted for the calculation. If the units are genuinely ambiguous, the field is flagged rather than assumed — an assumed unit is how a shipment gets quoted at a third of its real chargeable weight.
It is only as good as the sheet behind it.
Your airline and consolidator sheets are mapped in their existing layout, with weight breaks, minimums and validity read as they are written.
See rate-sheet automationLAX-AU_Air_Q3.xlsx
Qantas Freight · 214 rate lines
Column mapping
| Lane | Basis | Rate | Valid to | Status |
|---|---|---|---|---|
| LAX → SYD | per kg | 3.90 | 30 Sep | live |
| LAX → MEL | per kg | 4.15 | 30 Sep | live |
| LAX → BNE | per kg | 4.40 | 31 Jul | expired |
Expired lines are held back from quoting until you refresh the sheet.
See it live
Bring one air RFQ and your airline sheet.
We will run the chargeable weight, the band and the minimum in front of you.
30 minutes · no deck · your rates stay private