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

Download the Excel template

Billing

Greater value

Actual or volumetric

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

supply_chain_landed_cost_freight_comparison_template_en.xlsx

Sheets

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.

Download the Excel template

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.

Enter weight and volume

Calculate actual and volumetric weight together so freight is not underestimated.

Fill total cost lines

Combine factory price, freight, paperwork, tariff, clearance, and delivery fees.

Compare routes

Convert every freight option to the same landed-cost basis.

Choose the best option

The lowest total cost route is bolded for quick decisions.

Adoption boundary

Where spreadsheets are enough and where systems help

Supply-chain workbooks are good for aligning decision logic. When data sources, permissions, and reminders grow, move the repeated parts into a system.

Spreadsheet fit

One team aligning quickly

When data volume is small and the rule is still being tested, a workbook is the fastest shared layer.

Single team
Manual review
Short pilot

Partial systemization

More alerts and approvals

When the same result needs routing or approval, systemize the key checkpoints first.

Automatic alerts
Approval flow
Owner tracking

Full systemization

Cross-warehouse coordination

When data sources, permissions, and update frequency grow, move data and workflow into a shared system.

Multiple sources
Access control
Process history

FAQ

Supply-chain template FAQ

Review the inputs and operating boundary before downloading.

Why compare volumetric and actual weight?

Freight billing often uses the greater value, so actual weight alone can understate cost.

Can tariff rates be changed?

Yes. Tariff is an input so it can vary by product or destination.

Does the best option consider speed?

The default recommendation is lowest cost. Add transit time notes when service level matters.