Container Liner Shipping & Maritime Finance
Container BAF Surcharge & TEU Slot Break-Even Formula
Calculate IMO-2020 Floating Bunker Adjustment Factor BAF = MAX(0, P_fuel - P_base) * Trade_Factor, All-In TEU Freight Rate, Breakeven Loaded TEUs, and Vessel Slot Utilization.
Pass through VLSFO fuel spikes cleanly and audit liner TEU slot utilization breakeven!
Post-IMO 2020 container liner contracts separate Base Ocean Freight F_base ($/TEU, benchmarked at Baseline Very-Low-Sulfur Fuel Oil price P_base) from a quarterly floating Bunker Adjustment Factor BAF = MAX(0, P_fuel - P_base) * f_trade, where Trade_Fuel_Factor f_trade (MT of fuel burned per carried TEU, e.g., 0.60 MT/TEU on Asia–North Europe vs 0.35 MT/TEU Transpacific) reflects route distance and transit speed! Subtracting Variable Terminal Handling & Stevedoring Cost C_var per loaded box from All-In Freight F_all = F_base + BAF gives Unit Slot Contribution Margin, dividing Fixed Round-Voyage Cost C_fixed ($ charter hire, crew, canal tolls, base steaming fuel) to pinpoint exact Breakeven Loaded TEUs and Breakeven Slot Utilization %!
Verify on Base_Ocean_Freight F_base = $1,200/TEU (B2), Baseline_Fuel_Price P_base = $400/MT (B3), Current_VLSFO_Price P_fuel = $650/MT (B4), Trade_Fuel_Factor f_trade = 0.60 MT/TEU (B5), Variable_Handling_Cost C_var = $350/TEU (B6), Fixed_Voyage_Cost C_fixed = $8,000,000 (B7), and Vessel_Nominal_Capacity Cap_teu = 10,000 TEU (B8): Floating BAF Surcharge is (650 - 400) * 0.60 = $150.00/TEU (E2); All-In Rate is $1,350.00/TEU (E3); Unit Contribution is $1,350 - $350 = $1,000/TEU, requiring 8,000,000 / 1,000 = 8,000 Breakeven TEUs (E4) or 0.8000 (80.00% Slot Utilization in E5)! Test a freight rate war dropping F_base to $950/TEU (All-In $1,100, Contribution $750/TEU): Breakeven jumps to 10,667 TEUs (> 10,000 capacity -> 1.0667, flagging an unprofitable voyage even at 100% full ship)!
| Container Liner Metric ($1,200 Base, $650 vs $400 VLSFO, f=0.60, $8M Fixed / 10k TEU) | Formula | Verified Output |
|---|---|---|
| Floating BAF Surcharge ($/TEU) | MAX(0, P_fuel - P_base) * f_trade | $150.00 / TEU |
| All-In Ocean Freight ($/TEU) | F_base + BAF | $1,350.00 / TEU |
| Breakeven Loaded Volume (TEU) | C_fixed / (F_all - C_var) | 8,000.00 TEU |
| Breakeven Slot Utilization | Breakeven_TEU / Cap_teu | 0.8000 (80.00% Full) |
Breakeven Loaded TEUs & Slot Utilization Formula
Guard against negative or zero unit contribution margin (F_base + BAF <= C_var), where loading extra containers loses variable cash on every box!
=LET(f_bs, B2, p_b0, B3, p_fl, B4, f_tr, B5, c_vr, B6, c_fx, B7, cp_t, B8, IF(OR(f_bs <= 0, p_b0 < 0, p_fl <= 0, f_tr <= 0, c_vr < 0, c_fx <= 0, cp_t <= 0), "Invalid Liner Tariff", LET(f_al, f_bs + MAX(0, p_fl - p_b0) * f_tr, IF(f_al <= c_vr, "Negative Box Contribution", ROUND(c_fx / (f_al - c_vr), 2)))))Vessel Slot Breakeven Utilization Ratio Formula
Monitor E5 <= 0.85 on headhaul legs because deadweight draft and empty-equipment repositioning typically cap practical commercial TEU load factors around 85%–92%!
=IF(ISTEXT(E4), E4, ROUND(E4 / B8, 4))Try the example
Use the original values or change them to test your understanding.