Deep-dive guide
Sea vs Air Freight Stock-Out Race: Lead Time, Cover and Lost Sales Simulator
Executive industry analysis
Every importer faces the same quiet trade-off. Sea freight moves a container for a fraction of what air costs per unit, but it keeps your stock on the water for many weeks. Air freight lands in days, yet its price can swallow the margin on a low-priced product. The cheapest freight rate on the quote is therefore rarely the cheapest outcome. What matters is the cost of freight together with the cost of being out of stock while the next shipment is still at sea, and with the money tied up in goods that are neither on the shelf nor in the warehouse.
The structure of the problem is a race between lead time and uncertainty. When you order, you must cover demand until the next order can arrive. The longer that window, the more your forecast can be wrong, and the more safety stock you need to avoid a shortage. If demand is steady, a long lead time is harmless. If demand swings, the same lead time becomes dangerous. Air freight shortens the window and reduces the damage of a wrong forecast, which is why the right air share rises with volatility and with the margin on each unit.
The domino cascade begins with the blend of sea and air, which sets the effective lead time. A longer effective lead time lowers the fill rate, because more demand arrives while the shelf is empty. Lost sales and customers who never return reduce the margin you earn. Freight and holding costs add to the cost of each unit you do sell, and the profit box at the end absorbs everything. Small changes at the start, such as a week of port delay, can cascade into a red month because each stage amplifies the one before it.
The iceberg separates what appears on the freight invoice from what hurts more. Above the waterline sit overhead, sea freight and air freight. Below it sit four costs that never arrive as an invoice: the margin on sales you could not make, the repeat customers who found another supplier, the capital tied up in goods in transit, and the cost of holding safety and cycle stock. Many businesses cut air freight to save money and later discover that the hidden layer grew faster than the freight bill shrank. The simulator helps you find the air share and lead time that actually maximise profit.
Formula and methodology blueprint
The model works per month with one replenishment order per month. The effective lead time is the volume-weighted average of the sea and air lead times. Demand uncertainty over the protection window, which is lead time plus the review period, is demand times volatility times the square root of window length in months. Safety stock covers a fixed number of days. The expected shortage is read from the standard normal loss function. Profit is margin on units sold minus overhead, freight, holding costs and the margin lost from customers who do not return.
- Effective lead time
- L = (1 − a) × sea days + a × 6 days
- A blend of the sea lead time and a six-day air lead time, weighted by the air share a.
- Demand uncertainty
- σ = demand × volatility × √((L + 30) ÷ 30)
- The standard deviation of demand over the window one order has to cover.
- Expected shortage
- Lost = σ × G(z) , z = safety stock ÷ σ
- G is the normal loss function. It converts safety cover into expected units lost each cycle.
- Freight and holding
- Cost = sea units × 1.10 + air units × (1.10 + premium) + holding
- Per-unit freight by mode plus the cost of capital and space for goods in transit and in the warehouse.
- Net profit
- Net = (demand − lost) × (margin − overhead) − freight − holding − repeat loss
- The monthly result. The breaking point is where this reaches zero.
Cascading elasticity
Margin per unit is the most elastic input, because it multiplies every unit sold and every unit lost. Demand volatility and sea lead time act together through the protection window, so a long lead time is much worse when demand is unstable. The air premium is linear in the units sent by air, which makes the air share a lever with a clear price and a diminishing return.
Three real-world case studies
Bootstrapped starter
A small importer testing a product
A new importer sells a few hundred units a month of a well-margined product and sends one fifth by air. Demand is uncertain, but volumes are small and freight is modest. Load it to see how a young importer can stay profitable while still running out of stock now and then.
Scaling mid-market
A scaling importer with a nearer hub
A growing importer moves twelve thousand units a month through an improved route with a shorter sea leg and a steady forecast. Volume multiplies every cost. Load it to see how a week of lead time or a point of volatility changes the month by thousands.
Black-swan crisis
A port disruption with volatile demand
Port congestion stretches sea lead time to three months just as demand becomes erratic, with no air backup and a very high air premium. Shelves empty and customers leave. Load it to see which lever, speed, price or demand control, rescues the month.
Industry benchmark matrix
| Metric | Danger zone | Industry average | Top 10% elite |
|---|---|---|---|
| Fill rate (demand served from stock) | Below 90% | 93–97% | Above 98% |
| Sea lead time, door to shelf | Above 70 days | 40–55 days | Below 35 days |
| Share of units shipped by air | Above 50% without need | 5–25% | Targeted, under 15% |
| Demand forecast error (monthly) | Above 50% | 20–35% | Below 15% |
| Freight and holding as share of unit margin | Above 45% | 25–35% | Below 20% |
Variables and levers
Demand per month
Average units customers want to buy in a month if the product is always on the shelf.
Lever: Do not scale demand before the supply chain can serve it; extra demand on a long lead time only multiplies the empty-shelf days.
Margin per unit
Selling price minus product cost, before freight, warehousing and overhead.
Lever: Protect margin before paying for speed, because air freight is only justified when each unit earns enough to carry it.
Sea lead time
Days from placing the order to having stock ready to sell when it comes by sea, including port and customs.
Lever: Negotiate earlier booking, a nearer port or a consolidation hub; every week removed from the lead time lowers the stock you must guard.
Demand volatility
How much monthly demand typically swings around its average, as a percentage of that average.
Lever: Smooth demand with better forecasts, pre-orders and fewer promotional spikes, because uncertainty is what makes lead time dangerous.
Share shipped by air
Part of each replenishment sent by air, which arrives in days instead of weeks.
Lever: Use air as a targeted top-up for fast sellers and for the late part of the cycle, not as a blanket policy for every unit.
Air freight premium per unit
Extra cost of sending one unit by air compared with sea.
Lever: Consolidate air shipments, use lighter packaging and compare forwarders, since the premium applies to every unit you send by air.
How to use this simulator
- 1Start from the realistic preset or enter your monthly demand, unit margin and typical sea lead time.
- 2Set demand volatility honestly, using the swings you see between months.
- 3Move the air share and read the five domino boxes to see where the chain turns red.
- 4Press Find my breaking point to learn which lead time, volatility or premium pushes profit to zero.
- 5Compare the current plan with the faster pipeline plan over 24 months in the Parallel universe tab.
Mistakes to avoid
- Choosing freight by price per unit alone. The cheapest rate on the quote ignores the stock-outs and tied-up capital that come with a long lead time.
- Sending everything by air after one stock-out. A blanket policy pays the premium on every unit, even those that would have arrived in time by sea.
- Planning with average lead time. Port congestion and customs holds make real lead times longer and more variable than the quoted number.
- Ignoring the customers who leave. A stock-out costs the sale today and often the next purchases as well, which is why lost-sales cost is larger than the margin of one unit.
Frequently asked questions
When is air freight worth the extra cost?
When the margin on each unit is high, demand is volatile and the cost of an empty shelf, including lost repeat customers, exceeds the premium. For low-margin, steady products, sea freight with more safety stock usually wins.
Why does volatility matter so much?
Lead time is only dangerous when demand is uncertain. With steady demand you can plan exactly, while with swinging demand you need safety stock or fast replenishment to avoid shortages.
What does the repeat-customer loss mean?
A share of customers who find a product out of stock buy elsewhere and do not return. The model counts that as lost future margin, in addition to the sale missed today.
Does the model include customs and duties?
No. Duty, tax and customs fees are assumed to be the same for sea and air and are left out. Check current rules and add them to your margin if they differ.
How is the breaking point found?
Press Find my breaking point. The tool moves each input towards its worse end and reports the value at which monthly profit reaches zero, ranked by closeness.
Is this a forecast of my business?
No. It is an educational model with simplified assumptions, not logistics or financial advice. Replace the inputs with your own data and test the answer against real shipments.
This is an educational planning model with stated assumptions. It is not financial, tax or legal advice. Replace the inputs with your own figures and verify important decisions with a qualified professional.