Stockouts, Overstock, and the Cost of Bad Timing

Inventory decisions balance two expensive failures. Too little stock loses sales, rank, and advertising efficiency. Too much stock traps cash, increases storage exposure, and can force markdowns.

The target is not maximum stock. It is enough resilient cover to absorb demand and supply uncertainty at an acceptable cash cost.

1. Use days of cover, not units alone

One hundred units can be abundant or nearly empty depending on sales velocity. Calculate days of cover from available stock and a demand rate appropriate to the product. Use recent demand, seasonal context, promotions, and trend direction rather than one static average.

Show when velocity is unknown. New products require a launch assumption and tight review cycle; zero sales on an old listing may indicate a demand problem rather than safe inventory.

2. Build the reorder point from time and uncertainty

The reorder point should cover supplier lead time, receiving time, marketplace transfer time, and a safety buffer. Separate average lead time from variability. A supplier promising 20 days but delivering between 18 and 45 days needs a different buffer from a stable 25-day supplier.

Include minimum order quantities and shipment cadence. A mathematically precise reorder date is useless if it ignores how purchasing actually works.

3. Put a euro value on stockouts

Estimate lost contribution, not only lost revenue. Include the duration, expected sales rate, and margin. Consider secondary effects: interrupted campaign learning, lost organic visibility, wasted clicks near depletion, and customer substitution.

Do not overstate unknowable ranking effects as exact euros. Keep direct loss and directional strategic risk separate.

4. Put a euro value on overstock

Overstock consumes working capital and may add storage, handling, obsolescence, or discount costs. Segment it by age and demand outlook. A seasonal product with 120 days of cover after its peak is more urgent than an evergreen product with stable replenishment economics.

Use landed cost, not only supplier price, when measuring tied-up cash. Freight, customs, and allocated costs belong to the inventory investment.

5. Connect procurement receipts to margin truth

Purchase orders describe intent; receipts describe what arrived and when. Partial receipts and extra costs change the weighted landed cost. Record shipping, customs, and other allocations through a consistent method.

Preserve manual cost overrides when finance has better evidence, but make the source visible. Inventory and profit reporting should agree on the resolved product cost.

6. Prioritize inventory actions

Use product groups or supplier groups to find systemic problems. Repeated late receipts may justify different safety stock or supplier terms.

7. Close the loop with demand changes

Recalculate advice after meaningful price, promotion, listing, or advertising changes. Demand is not fixed. An ad campaign can accelerate depletion; a Buy Box loss can make an old reorder recommendation excessive.

Set review frequency by risk. High-velocity, long-lead-time products need frequent review. Slow, stable products can use a lighter cadence.

8. Worked example: the purchase order that creates two risks

A supplier requires a minimum order of 1,000 units across three products. Product A sells quickly with stable demand, Product B is seasonal, and Product C recently lost the Buy Box. Splitting the order evenly is simple but economically weak.

Calculate days of cover using current velocity and expected arrival date. Add open purchase orders and marketplace-held stock. Product A may need most of the quantity to avoid a stockout during lead time. Product B needs only enough to reach the seasonal peak plus a controlled buffer. Product C should not be replenished from its old sales rate until competitiveness recovers.

Then calculate landed cost. Freight and customs allocated by quantity may differ from allocation by value or weight. Record the chosen method so finance and inventory use the same resolved cost. Test whether the new landed cost changes acceptable pricing or advertising.

Create scenarios for supplier delay and demand deviation. If a two-week delay creates a material stockout on A, consider expedite or additional safety stock. If a 20% demand miss leaves B with post-season overstock, reduce the order or plan a transfer and clearance trigger before purchasing.

Purchase review record

• Current and projected days of cover at receipt.
• Demand window, trend, and seasonal assumption.
• Lead-time average and variability.
• Open orders, partial receipts, and marketplace stock.
• Landed-cost allocation method.
• Stockout and overstock scenario costs.
• Reorder decision, owner, and next review.

9. Practical checklist

• Days of cover uses a documented demand window.
• Seasonality and active promotions adjust the forecast.
• Lead-time variability is included in safety stock.
• Stockout cost uses contribution, not only revenue.
• Overstock uses landed cost and aging.
• Receipts, partials, and extra costs update product economics.
• Unknown velocity is visible.
• Advertising and availability decisions are coordinated.
• Supplier-level patterns feed future purchasing rules.

Inventory quality is timing quality. The best decision balances service, margin, cash, and uncertainty instead of optimizing one measure in isolation.

Create a cross-functional inventory rhythm

Review the highest-risk products with procurement, commercial, finance, and advertising together. Procurement brings lead-time and supplier constraints; commercial brings promotions and pricing; finance brings working-capital limits; advertising brings planned demand changes. A recommendation based on only one view can be mathematically correct and operationally wrong.

Use separate horizons. Daily review protects imminent availability. Weekly review manages purchase and transfer actions. Monthly review examines aging, supplier performance, landed cost, and assortment decisions. Seasonal planning should start far enough ahead for the real lead-time distribution, not the supplier’s best-case promise.

After each material stockout or clearance, record the forecast, decision, actual outcome, and missed assumption. Over time this creates better safety buffers and purchasing rules. The purpose is not perfect forecasting; it is making uncertainty explicit and improving how the business responds to it.