Air versus ocean freight inventory carrying cost · Calculation guide

Use a simple annual carrying rate on cargo value for actual transit days over 365.

Calculation guide

Positive ocean-minus-air difference means air costs less including freight and capital.

Ocean less air total cost = ((Ocean freight quote − Air freight quote) + ((((Inventory value × Annual carrying rate (%)) ÷ 100) × (Ocean transit days − Air transit days)) ÷ 365)). Air freight and carrying cost = (Air freight quote + ((((Inventory value × Annual carrying rate (%)) ÷ 100) × Air transit days) ÷ 365)). Ocean freight and carrying cost = (Ocean freight quote + ((((Inventory value × Annual carrying rate (%)) ÷ 100) × Ocean transit days) ÷ 365))

Inputs

Inventory value

Example entry 365000 (in the selected currency).

Annual carrying rate (%)

Example entry 10 %. Allowed range 0 to 100.

Air transit days

Example entry 2.

Ocean transit days

Example entry 22.

Air freight quote

Example entry 5000 (in the selected currency).

Ocean freight quote

Example entry 2000 (in the selected currency).

Worked example

InputValue
Inventory value365,000
Annual carrying rate (%)10%
Air transit days2
Ocean transit days22
Air freight quote5,000
Ocean freight quote2,000
ResultValue
Ocean less air total cost-1,000
Air freight and carrying cost5,200
Ocean freight and carrying cost4,200

Calculation steps

Ocean less air total cost = ((Ocean freight quote − Air freight quote) + ((((Inventory value × Annual carrying rate (%)) ÷ 100) × (Ocean transit days − Air transit days)) ÷ 365))

((2,000 − 5,000) + ((((365,000 × 10) ÷ 100) × (22 − 2)) ÷ 365)) = -1,000

Air freight and carrying cost = (Air freight quote + ((((Inventory value × Annual carrying rate (%)) ÷ 100) × Air transit days) ÷ 365))

(5,000 + ((((365,000 × 10) ÷ 100) × 2) ÷ 365)) = 5,200

Ocean freight and carrying cost = (Ocean freight quote + ((((Inventory value × Annual carrying rate (%)) ÷ 100) × Ocean transit days) ÷ 365))

(2,000 + ((((365,000 × 10) ÷ 100) × 22) ÷ 365)) = 4,200

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Inventory value365,000401,500Ocean less air total cost-1,000-800
Annual carrying rate (%)10%11%Ocean less air total cost-1,000-800
Air transit days23Ocean less air total cost-1,000-1,100
Ocean transit days2224Ocean less air total cost-1,000-800
Air freight quote5,0005,500Ocean less air total cost-1,000-1,500
Ocean freight quote2,0002,200Ocean less air total cost-1,000-800
Air versus ocean freight inventory carrying cost →

Sources