Billing
Greater value
Actual or volumetric
Cost reduction template
Compare the true delivered cost of every route
The workbook compares volumetric weight with actual weight and includes factory price, domestic freight, export paperwork, international freight, tariff, destination clearance, and delivery fees.
chargeable weight
full cost
route comparison
best option
If you need team collaboration, mobile data entry, photo uploads, corrective action reminders, or dashboards, view the systemized version.
Costs
7 lines
Full cost
Compare
Multi-route
One view
Recommend
Lowest cost
Bold highlight
Input example
Route comparison input example
Route, chargeable weight, and total landed cost are visible in one row.
Route
Chicago to Dallas
Owner
Emily Carter
Chargeable weight
1,280 kg
Total cost
$84,600
Best option
Rail plus truck
Free download
Put hidden route costs into one comparison
Compare ocean, air, rail, and truck routes on the same landed-cost basis.
File
Landed Cost and Freight Route Comparison Template.xlsx
File name: supply_chain_landed_cost_freight_comparison_template_en.xlsx
Sheets
5
Use case
Landed cost modeling and freight route comparison
Chargeable weight uses the greater of actual and volumetric weight.
Seven major cost lines are included.
The lowest-cost route appears in the best option box.
Enter each route and cost line; the lowest-cost route is highlighted in bold.
Workflow
Landed cost comparison flow
Enter weight and volume, fill all cost lines, then compare total cost by route.
1
Enter weight and volume
Calculate actual and volumetric weight together so freight is not underestimated.
2
Fill total cost lines
Combine factory price, freight, paperwork, tariff, clearance, and delivery fees.
3
Compare routes
Convert every freight option to the same landed-cost basis.
4
Choose the best option
The lowest total cost route is bolded for quick decisions.
System mapping
How the workbook can become a system
Use the workbook to align inputs first, then systemize the alerts, approvals, and cross-team sync that repeat often.
Workbook field
System module
Reason to move
Workbook field
Weight and volume
System module
Freight rate rules
Reason to move
Standardize chargeable weight.
Workbook field
Cost lines
System module
Costing center
Reason to move
Avoid judging routes by freight alone.
Workbook field
Best route
System module
Logistics decision flow
Reason to move
Move the comparison into execution.