Calculation guide
Positive ocean-minus-air difference means air costs less including freight and capital.
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
| Input | Value |
|---|---|
| Inventory value | 365,000 |
| Annual carrying rate (%) | 10% |
| Air transit days | 2 |
| Ocean transit days | 22 |
| Air freight quote | 5,000 |
| Ocean freight quote | 2,000 |
| Result | Value |
|---|---|
| Ocean less air total cost | -1,000 |
| Air freight and carrying cost | 5,200 |
| Ocean freight and carrying cost | 4,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.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Inventory value | 365,000 | 401,500 | Ocean less air total cost | -1,000 | -800 |
| Annual carrying rate (%) | 10% | 11% | Ocean less air total cost | -1,000 | -800 |
| Air transit days | 2 | 3 | Ocean less air total cost | -1,000 | -1,100 |
| Ocean transit days | 22 | 24 | Ocean less air total cost | -1,000 | -800 |
| Air freight quote | 5,000 | 5,500 | Ocean less air total cost | -1,000 | -1,500 |
| Ocean freight quote | 2,000 | 2,200 | Ocean less air total cost | -1,000 | -800 |
