Shipping Operations
Freight Rate Calculator
Five services, each with its own independent rate master. Pick the service, then the destination — the system works out chargeable weight and applies the published rate for that band.
Air · Temp Air · DHL · FedEx · Sea
3-letter code is the unique key
nothing rounded, scaled or estimated
Monthly Update
Upload Rate Master
One workbook can carry every service. Name each sheet after its service (General Air Cargo, Temperature, DHL, FedEx, Sea), or put everything on one sheet with a Mode column. Uploaded sheets are remembered on this computer.
30+/kg, 50+/kg, 100+/kg …
· every service can use its own bands, and adding one (e.g. 1000+/kg)
needs no code change. Sea sheets may use CBM bands or a single Rate per CBM column.
Rate Calculator
Calculate Freight Cost
Enter shipment details below. Volume weight is auto-calculated; the higher of actual vs. volume weight is used for billing.
Service
Destination
Shipment Details
Package Dimensions (for Volume Weight)
✦ Volume Weight = (L × B × H in cm) ÷ 6000 · Billing weight = higher of Actual vs. Volume Weight · Dimensions below are for one package
Quoting Rules — both on by default
Result
Freight Cost Estimate
Charged on the higher of actual vs. volume weight, at the applicable weight-break rate.
Weight Comparison
Weight Break Options
| Band | Rate | Billed Weight | Cost |
|---|
* Weight declared up to the break threshold. The cheapest row is the one applied.
Rate Breakdown
| Detail | Value |
|---|
Reference
Rate Master — Selected Service
Shows whichever service is selected above. A band applies from its figure upward.