Amazon Inventory Management & Demand Planning

Inventory is the lifeblood of Amazon selling, yet most sellers mismanage it. Overstock by 20% and you bleed cash into storage fees; understock by 10% and you lose Buy Box and rank. Data shows that 1 in 4 Amazon sellers experience either a stockout (lost sales, damaged ranking) or chronic overstock (excess fees, dead capital) in any given quarter. Strategic inventory management isn’t just about having enough stock; it’s about predicting demand, rightsizing shipments, calculating reorder points, and optimising the trade-off between service level and working capital. This article walks you through demand planning, FBA inventory limits, storage fees, and the operational metrics that drive sustainable profitable growth.

Why Inventory Management Matters: The Stockout and Overstock Problem

Inventory decisions ripple through your business. Poor inventory management cascades into three tangible failures.

The Stockout Trap: Lost Sales and Ranking Damage

When inventory runs out, your listing enters “Currently unavailable” status. During those stock-out days, you earn zero revenue, your best-seller momentum halts, and the algorithm deprioritises your listing because it cannot track conversions. Returning from a stockout takes 3-6 weeks of consistent sales velocity to rebuild rank. For competitive categories, this window often allows competitors to seize your rank and customers. Stockouts are especially damaging during peak seasons (Q4, seasonal spikes); losing 2-4 weeks of peak-season stock can crater annual profitability. The opportunity cost of a single 3-week stockout in November (peak Q4 season) often exceeds GBP 5,000-20,000 in lost revenue for mid-sized sellers.

The Overstock Trap: Storage Fees and Dead Capital

Conversely, overstock tying up excess inventory in Amazon FBA incurs escalating storage fees. January-September monthly storage is charged per cubic foot; October-December long-term storage (LTS) fees spike 5-10x higher per unit. Inventory sitting longer than 180 days incurs double LTS fees. A single SKU overstocked by 500 units for 6 months can cost GBP 1,500-3,000+ in storage alone, directly eroding margin. Beyond fees, overstocked capital is working capital trapped in low-selling inventory rather than invested in new products or paid back as distributions. Overstocking effectively locks cash at a negative return.

The Goldilocks Zone

Optimal inventory sits between these extremes. Maintain enough stock to cover demand during lead time, plus a safety buffer (typically 10-20% of monthly volume) to handle demand volatility and supplier delays. This “sweet spot” balances service level (fill rate, Buy Box eligibility) against working capital efficiency. Achieving this balance requires accurate demand forecasting, responsive supplier relationships, and disciplined monitoring.

FBA Inventory Limits and IPI Scoring

Amazon caps the total units you can hold in FBA based on your Inventory Performance Index (IPI). Understanding and maintaining IPI is critical.

What is Inventory Performance Index (IPI)?

IPI is Amazon’s quarterly scorecard for inventory health, measured on a 0-1000 scale. Amazon calculates IPI using four components: excess inventory (stock beyond 90 days of forecasted sales), stranded inventory (unsellable SKUs or unlinked listings), aged inventory (units 180+ days in FC without sales), and sell-through rate (units sold divided by total units held). A high IPI (800+) indicates you’re selling fast, keeping aged inventory minimal, and avoiding dead stock. A low IPI (below 350) signals poor sell-through, excess inventory pile-up, or stranded stock. Amazon publishes IPI quarterly (typically Jan, Apr, Jul, Oct). You can view your IPI score in Seller Central under Inventory Performance dashboard.

FBA Inventory Limits and Your IPI Score

Amazon enforces a tiered FBA inventory cap based on your IPI:

• IPI 500+: No unit limits. Send as much inventory as you wish (subject to FC space availability).
• IPI 350-499: Unit cap = (Sales last 90 days x 180) / 90. Example: If you sold 1,000 units in the last 90 days, your cap is (1,000 x 180) / 90 = 2,000 units.
• IPI below 350: Severe restrictions. Cap = (Sales last 90 days x 30) / 90 or 500 units, whichever is higher.

Hitting a unit limit is crippling. You cannot send new inventory to FBA, inventory-in-transit gets rejected, and your capacity to scale shrinks. Most sellers should prioritise maintaining IPI above 500 to avoid caps entirely. See Amazon Account Health for deeper guidance on monitoring health metrics.

Improving IPI: Practical Steps

If your IPI is low, take immediate action. First, remove stranded inventory: audit your inventory in Seller Central, identify unlisted or unsellable SKUs, and request removal (or liquidate via FBM and liquidation partners). Second, liquidate aged inventory (180+ days old) via coupons, price reductions, or removal. Third, improve sell-through by increasing Sponsored Products spend on slow-moving SKUs or bundling them with bestsellers. Finally, tighten forecasting and reorder logic so you stop overstocking. Improving IPI typically takes 1-2 quarterly cycles (3-6 months) if you’re aggressive.

Calculating Reorder Point and Safety Stock

The reorder point is the inventory level at which you trigger a new purchase order. Calculate it correctly and you’ll consistently hit the Goldilocks zone.

The Reorder Point Formula

Reorder Point = (Daily Sales Volume x Lead Time in Days) + Safety Stock

Example: You sell 10 units per day on average. Your supplier lead time is 30 days. You want a 10-day safety buffer (100 units). Reorder point = (10 x 30) + (10 x 10) = 300 + 100 = 400 units. When your inventory reaches 400 units, place an order. By the time stock arrives 30 days later, you’ll have sold roughly 300 units (30 days x 10/day), leaving your safety stock intact to cover any demand spike or supply delay.

Calculating Daily Sales Volume

Use historical data from Seller Central reports. Pull the last 90 days of sales data (Business Reports > Sales), sum total units sold, and divide by 90. Example: 2,700 units sold in 90 days = 30 units/day average. For seasonal products, use in-season data only. Garden furniture sold 2,000 units April-August (150 days) = 13 units/day for that season; Jan-Mar might be 2 units/day. Calculate seasonal reorder points separately.

Lead Time and Safety Stock

Lead time is the elapsed days from placing an order until inventory arrives at your fulfillment center (FBA warehouse or your storage). Typical lead times: UK suppliers 5-15 days, EU suppliers 10-20 days, Asia imports via sea freight 45-90 days, air freight 5-10 days. Longer lead times necessitate larger safety stock buffers. If lead time is 60 days, your reorder formula includes 60 days of sales plus buffer; if lead time is 15 days, you need much less buffer stock. Safety stock is typically 10-20% of monthly demand; for volatile categories, increase to 25-30%; for predictable categories, reduce to 5-10%. Quantify safety stock in units, not percentages: if daily sales are 20 units and monthly volatility is 15%, safety stock = 20 x 15 = 300 units.

Accounting for Lead Time Variability

Suppliers rarely hit exact lead times. Customs delays, shipping disruptions, or supplier backlog can add 10-30 days. Account for this by adding a buffer to your stated lead time. If supplier claims 45-day sea freight, plan for 55-60 days and reorder accordingly. Track actual lead times monthly to refine your forecasts. If you consistently receive shipments 15% later than estimated, adjust your reorder formula to account for that.

Demand Forecasting: Seasonal, Trend-Based, and Data-Driven

Accurate demand forecasting is the foundation of inventory optimisation. Three methods apply depending on your product and data maturity.

Historical Demand Forecasting

For established products with 12+ months of sales history, calculate seasonal indices. Pull monthly sales data for the past 2 years, identify average sales per month, then calculate month-over-month variance. Example: Product averages 1,000 units/month. January averaged 800 units (0.8x multiplier), July averaged 1,500 units (1.5x multiplier). Use these multipliers to forecast future months. If January baseline is 1,000 units, forecast January as 800 units. This method is simple, reliable, and requires no external data.

Seasonal and Trend-Based Forecasting

For seasonal products, identify the peak season and plan accordingly. Garden furniture peaks April-August; Christmas decorations peak September-November; swimwear peaks April-July. Plan inventory build 8-12 weeks before peak season starts, then monitor sell-through weekly during peak. If sell-through is faster than forecast (inventory depleting ahead of schedule), accelerate reorders or activate air freight. If sell-through is slower than forecast, reduce new orders and focus on liquidation. Post-peak season, clear overstocked inventory aggressively via price reductions or removal to avoid long-term storage fees.

Data-Driven Forecasting: Tools and Market Signals

Advanced sellers use third-party forecasting tools (Forecastly, DataDriven, Keepa) that apply machine learning to historical sales, seasonality, and market signals. These tools estimate demand 3-6 months forward and suggest inventory targets. You can also monitor external signals: search volume trends (Google Trends, Keepa search volume data), competitor inventory levels (if public), and market trends (trade publications, industry reports). If search interest for a product is rising 20% quarter-over-quarter, increase forecast accordingly.

Conservative vs Aggressive Forecasting

Conservative forecasting (estimate 20% lower than expected) protects against overstocking but risks stockouts and lost rank. Aggressive forecasting (estimate 20% higher) captures peak-season momentum but risks excess aged inventory and fees. For mature bestselling products with predictable demand, forecast conservatively. For new launches or highly seasonal products, forecast more aggressively to capture momentum. Adjust quarterly based on actual performance.

Managing Lead Times from Suppliers

Lead time management is the operational pillar holding inventory strategy together. Mismanage it and reorder calculations collapse.

Understanding Total Lead Time Components

Total lead time includes: supplier production (2-7 days), order processing and packing (2-5 days), transportation (5-90 days depending on method), customs clearance (1-10 days for imports), and your receipt/QC (1-3 days). If ordering from an Asian supplier: 5 days production + 3 days packing + 45 days sea freight + 5 days customs + 2 days receipt = 60 days total. Few suppliers disclose the full breakdown; ask your supplier for itemised lead time and track actual performance.

Multi-Supplier Sourcing and Lead Time Hedging

Relying on a single supplier with 60-day lead time is risky. If they delay 15 days, your safety stock evaporates. Mitigate by sourcing from two suppliers with staggered lead times. Example: Supplier A (China, 60-day sea freight) and Supplier B (UK, 10-day lead time). Split orders: 70% to Supplier A (cheap, slow), 30% to Supplier B (expensive, fast). This hybrid approach minimises average lead time (52 days weighted) and provides a backup if Supplier A delays. For high-velocity SKUs (100+ units/day), this hedging is essential.

Lead Time and Reorder Automation

Manual reorder tracking is error-prone at scale. Use tools like SkuVault, Brightpearl, or TraceLink to automate reorder triggers. Set reorder points in the system; the tool monitors inventory in real-time and sends alerts when you hit that threshold. This reduces human error and ensures you reorder at optimal times. For Amazon-only sellers without 3PL, a spreadsheet with monthly reorder date reminders is the minimum viable approach.

FBA Storage Fees: Monthly, Aged Inventory, and Long-Term Surcharges

FBA storage fees are complex and frequently misunderstood. Miscalculating them leads sellers to overpay or violate inventory policies.

Monthly Storage Fee Structure (January-September)

Amazon charges FBA monthly storage fees based on cubic feet occupied. On Amazon UK:

• Standard-size items: GBP 0.87 per cubic foot
• Large-size items: GBP 0.52 per cubic foot

Fees are charged on average daily inventory (total units x cubic feet per unit). Example: 500 units x 0.5 cubic feet/unit = 250 cubic feet average. Standard-size: 250 x GBP 0.87 = GBP 217.50 for the month. Fees are charged monthly, so recalculate your inventory footprint monthly and plan accordingly.

Long-Term Storage Surcharge (October-December, Peak Season)

From October 1 through December 31, Amazon applies an additional Long-Term Storage (LTS) fee on top of regular monthly fees:

• Standard-size items: GBP 4.40 per cubic foot
• Large-size items: GBP 3.30 per cubic foot

The LTS fee effectively replaces the monthly fee during Q4. On the same example above: 250 cubic feet x GBP 4.40 = GBP 1,100 during October-December, vs GBP 217.50 in summer months. This 5x spike is why clearing inventory before October is critical. Plan aggressive promotional campaigns (Lightning Deals, coupons, price reductions) in August-September to liquidate overstocked inventory before Q4 LTS kicks in.

Aged Inventory Surcharge (180+ Days)

Inventory sitting in FBA for 180+ consecutive days without a sale incurs a double LTS surcharge. Any aged unit tracked past 180 days is charged at double the standard LTS rate. Example: A unit held 190 days is charged at 2 x GBP 4.40 = GBP 8.80 per cubic foot. This escalation is designed to incentivise clearance of dead stock. If you have aged inventory, liquidate immediately: request removal from FBA and sell via FBM, donate to charity for tax write-off, or liquidate via third-party liquidators.

Calculating Actual Storage Cost per Unit

To internalise the true cost of holding inventory, calculate monthly storage cost per unit. Example: 1,000 units, 0.5 cubic feet each, GBP 0.87 standard storage. Monthly cost = (1,000 x 0.5) x GBP 0.87 = GBP 435. Cost per unit = GBP 435 / 1,000 = GBP 0.44/unit/month. In a 12-month cycle, holding one unit costs GBP 5.25 in storage. If profit per unit is GBP 8, storage consumes 66% of margin. Overstocking by 500 units for a year costs GBP 2,625 in pure storage waste. This calculation should inform your reorder discipline; overstock is expensive.

Inventory Performance Metrics and Seller Central Reports

Seller Central provides reports to monitor inventory health. Understand and monitor these metrics weekly.

Key Reports in Seller Central

• Inventory Health Dashboard: Shows IPI score, action items (stranded inventory, aged inventory, forecast low stock), and recommendations. Review weekly.
• Business Reports (Inventory): Daily reconciliation of units in FC, units in shipment, reserved units (pending orders). Use to verify inventory counts match physical records.
• Daily Inventory History: Shows daily snapshot of inventory by SKU. Export monthly and analyse trends to refine forecasting.
• Sales and Traffic: Daily sales by SKU. Use to calculate moving averages and seasonal indices.
• Manage Inventory: Overview of all active SKUs, showing low stock warnings, excess inventory flags, and recommended replenishment. Act on red flags immediately.

Monitoring Metrics: Days of Stock on Hand

Calculate Days of Stock on Hand (DSO) for each SKU: (Total units in FC) / (Average daily sales). Example: 450 units in FC, 10 units/day average = 45 days of stock. DSO of 45 days is healthy (covers 30-day lead time + 15-day safety buffer). DSO below 20 days signals risk of stockout; DSO above 120 days signals overstocking. Monitor DSO weekly by SKU and take action if trending outside healthy range.

Turnover Ratio and Sell-Through Rate

Turnover ratio = Annual sales / Average inventory. If you sell 12,000 units/year with average inventory of 1,000 units, turnover is 12x (inventory turns over 12 times annually). Fast-moving products should target 8-12x turnover; slow-moving products 2-4x. Sell-through rate = (Units sold / Units received) x 100%. A 80% sell-through means 20% of received inventory didn’t sell (either still in stock or removed). Aim for 85%+ sell-through; anything below 75% signals forecasting or product-market fit issues.

Multi-Channel Inventory: Amazon, eBay, Shopify Parity

Selling across multiple channels (Amazon FBA, Amazon FBM, eBay, Shopify) requires unified inventory management to prevent overselling.

The Multi-Channel Inventory Problem

If you allocate 500 units to FBA, 200 to eBay, and 100 to Shopify, and demand unexpectedly surges on eBay, you’ll oversell your total inventory pool. A single unit can only be sold once. Multi-channel sellers must maintain a single source of truth: real-time inventory tracking across all channels.

Solutions: Inventory Management Platforms

Use a unified inventory management platform (SkuVault, Brightpearl, Shopify with inventory syncing) that integrates Amazon Seller Central, eBay, and your Shopify store. These tools maintain a master inventory count and automatically sync across all channels. When you sell 1 unit on eBay, that unit is deducted from your total pool, reflected on Amazon and Shopify in real-time. This prevents overselling and simplifies reorder logic.

Inventory Allocation Strategy

Even with unified inventory, allocate intelligently. FBA (Amazon) typically has highest conversion rates and profitability, so prioritise FBA allocation. Allocate 60-70% of available inventory to FBA, 20-30% to FBM or eBay, 10-20% to direct/Shopify. Adjust these percentages based on channel profitability. If Shopify converts better (higher margin, lower fees), increase allocation there. Rebalance quarterly as channel performance evolves.

Frequently Asked Questions

What is an Inventory Performance Index (IPI) and why does it matter?

IPI is Amazon’s metric for inventory health, calculated quarterly and scored 0-1000. It factors in excess inventory, stranded inventory, aged inventory, and sell-through rate. An IPI below 350 triggers FBA inventory limits (unit caps). Maintain IPI above 500 to avoid limits and maximise FBA capacity. High IPI (800+) signals excellent inventory management and positions you for additional inventory headroom during peak seasons.

How are FBA storage fees calculated?

FBA charges monthly storage fees (per cubic foot) for January-September, then higher long-term storage fees (LTS) starting October. Standard-size items: GBP 0.87 per cubic foot (January-September), GBP 4.40 LTS (October-December). Large-size items: GBP 0.52 per cubic foot (January-September), GBP 3.30 LTS (October-December). Aged inventory (180+ days) incurs double LTS fees. Calculate your inventory dimensions and weight before sending to FBA; oversized or heavy products incur premium charges.

How do I calculate reorder point to avoid stockouts?

Reorder Point = (Daily Sales Volume x Lead Time in Days) + Safety Stock. Example: 10 units per day, 30-day supplier lead time, 10-day safety buffer = (10 x 30) + (10 x 10) = 400 units. Reorder when inventory reaches 400. Adjust lead time for seasonal demand spikes and supplier delays. Use Seller Central sales reports to calculate historical daily volume; update quarterly as demand evolves.

What is demand forecasting and how do I apply it to seasonal products?

Demand forecasting predicts future sales based on historical patterns, seasonal trends, and market signals. For seasonal products, identify peak season months (e.g., garden furniture peaks April-August), then calculate average sales during peak and off-peak. Overstock 20-40% during pre-peak period to capture demand surge without excessive aged inventory. Plan inventory build 8-12 weeks before peak season. Post-peak, liquidate overstocked inventory via coupons or price adjustments to avoid expensive long-term storage fees.

How do supplier lead times affect inventory planning?

Lead time is the elapsed days from ordering until stock arrives at your warehouse or Amazon FC. Longer lead times require larger safety stock buffers and earlier reorder triggers. If supplier lead time is 60 days, plan orders 60 days before anticipated inventory need. Multi-supplier sourcing reduces risk: split orders across two suppliers with staggered lead times. For imports from Asia, factor 45-90 days sea freight plus customs clearance; air freight costs 5-8x more but arrives in 5-10 days and is viable for high-velocity SKUs.