Amazon FBA Inventory Management: Formulas, Strategies, and IPI Optimization

Why Inventory Management Makes or Breaks FBA Businesses

Inventory management is the unsung hero of Amazon FBA profitability. Get it right and your products stay in stock, storage fees stay low, cash flow stays healthy, and organic rank stays strong. Get it wrong and you face one of two expensive problems:

Stockouts destroy momentum. When you run out of inventory, you lose the Buy Box, your organic ranking drops (sometimes permanently for competitive keywords), your advertising pauses, and customers buy from competitors. Studies suggest it takes 2-4 weeks of full-price sales to recover the organic rank lost during a single week of stockout.

Overstocking destroys cash flow. Excess inventory ties up capital you could use for new products or advertising, and Amazon's escalating storage fees punish slow-moving inventory aggressively. Inventory sitting past 180 days incurs surcharges that can erase months of profit.

The goal is a precise middle ground: enough inventory to avoid stockouts, not so much that you pay excessive storage fees. This guide gives you the formulas, strategies, and frameworks to achieve that balance.

The Reorder Point Formula

The reorder point is the inventory level at which you should place a new order with your supplier. When your available inventory drops to this level, it is time to reorder.

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

Components explained:

Average Daily Sales: Your average units sold per day over the last 30-90 days (depending on how variable your sales are). Use 30 days for products with consistent demand, 90 days for products with higher variability.

Lead Time: The total number of days from placing an order with your supplier to having inventory available for sale on Amazon. This includes:

• Manufacturing time (typically 15-30 days for custom products)
• Quality inspection time (1-3 days)
• Shipping to port and ocean freight (25-40 days from China to US)
• Customs clearance (2-7 days)
• Last-mile delivery to Amazon warehouse (3-7 days)
• Amazon receiving and processing (5-14 days — this varies widely and has been a significant pain point)

Example lead time calculation:

Many sellers underestimate lead time, especially Amazon's receiving time. Build in a buffer — if your supplier says 15 days, plan for 20. If Amazon typically receives in 7 days, plan for 14.

Safety Stock: Extra inventory to protect against variability in both demand and lead time. We will cover the calculation below.

Complete example:

• Average daily sales: 12 units
• Lead time: 69 days
• Safety stock: 120 units (calculation shown below)

Reorder Point = (12 x 69) + 120 = 828 + 120 = 948 units

When your FBA inventory drops to 948 units, place your next order.

Calculating Safety Stock

Safety stock protects against two types of uncertainty: demand variability (sales spikes) and supply variability (shipping delays).

Simple safety stock formula:

Safety Stock = (Maximum Daily Sales - Average Daily Sales) x Maximum Lead Time

This method is easy but tends to overestimate. For most FBA sellers, a more practical approach is:

Practical Safety Stock = Average Daily Sales x Buffer Days

Where buffer days is a number you choose based on your risk tolerance:

• Conservative (low risk of stockout): 14-21 buffer days
• Moderate (balanced): 7-14 buffer days
• Aggressive (minimize storage costs): 3-7 buffer days

Which buffer to choose:

• Products where stockout = disaster (your best sellers, products with strong organic rank that took months to build): Use 14-21 day buffer
• Standard products: Use 7-14 day buffer
• Slow movers or products with low margin: Use 3-7 day buffer
• Products approaching Q4: Add 7 extra buffer days in September-October to account for demand spikes and shipping delays

Example:

Average daily sales: 12 units, moderate risk tolerance (10 buffer days)

Safety Stock = 12 x 10 = 120 units

Calculating Reorder Quantity

Once you know when to reorder, you need to know how much to order.

Reorder Quantity = Average Daily Sales x Days Between Orders

"Days Between Orders" is the period you want each order to cover. Common approaches:

Fixed order interval: Order every 30, 60, or 90 days based on your cash flow and supplier minimums.

Economic Order Quantity (EOQ): Balances ordering costs against storage costs.

EOQ = Square Root of (2 x Annual Demand x Order Cost / Holding Cost per Unit per Year)

Where:

• Annual demand = average daily sales x 365
• Order cost = freight, customs, inspection per shipment (not per unit)
• Holding cost = Amazon storage fees + capital cost per unit per year

Example EOQ calculation:

• Annual demand: 12 x 365 = 4,380 units
• Order cost per shipment: $2,500 (freight, customs, handling)
• Holding cost per unit per year: $3.00 (storage fees + opportunity cost)

EOQ = Square Root of (2 x 4,380 x $2,500 / $3.00) = Square Root of (7,300,000) = 2,702 units

This means ordering about 2,700 units at a time minimizes your combined ordering and storage costs. At 12 units per day, this is about 225 days of supply — likely too much. In practice, most sellers cap orders at 60-90 days of supply to avoid aged inventory surcharges and maintain cash flow flexibility.

Practical reorder quantity = Average Daily Sales x Target Days of Supply

Target days of supply: 45-75 days for most products. This gives you enough runway without excessive storage costs.

Example: 12 units/day x 60 days = 720 units per order

Amazon IPI Score: What It Is and How to Optimize It

The Inventory Performance Index (IPI) is Amazon's scorecard for how well you manage your FBA inventory. It ranges from 0 to 1000, and your score determines whether Amazon limits your storage capacity.

IPI thresholds (2026):

• Above 450: No storage volume limits. Full access to FBA capacity.
• 350-450: Potential storage limits during peak seasons.
• Below 350: Storage limits applied. You cannot send in as much inventory as you might need.

The four factors that determine IPI score:

1. Excess inventory percentage

Inventory Amazon considers excess based on your sales rate. The lower, the better.

How to improve: Remove or liquidate inventory with more than 90 days of supply. Run promotions on slow movers. Reduce reorder quantities for slow-selling SKUs.

2. Sell-through rate

Units sold and shipped over the past 90 days divided by average inventory during that period. Higher is better.

How to improve: Reduce slow-moving inventory, increase sales velocity through advertising and pricing, remove dead stock.

3. Stranded inventory percentage

Inventory in FBA that is not available for sale due to listing issues (suppressed listings, incomplete listings, etc.). Should be as close to 0% as possible.

How to improve: Check the "Fix stranded inventory" page in Seller Central weekly. Resolve listing issues immediately. Set up automated notifications for listing suppression.

4. In-stock rate

The percentage of time your replenishable FBA ASINs are in stock. Higher is better. Only considers products Amazon identifies as "replenishable" (regular, recurring sales).

How to improve: Maintain safety stock, improve demand forecasting accuracy, reduce lead times where possible, set reorder alerts.

IPI optimization priority order:

1. Fix all stranded inventory immediately (this is free points)
2. Remove excess inventory that has been sitting 90+ days
3. Ensure your top sellers never stock out
4. Improve sell-through rate by promoting or removing slow movers

Avoiding Stockouts: An Action Plan

Stockouts are the most costly inventory mistake. Here is a systematic approach to preventing them:

1. Set up reorder alerts

Calculate your reorder point for each SKU and set alerts when inventory approaches that level. You can do this through:

• Amazon's restock recommendations (in FBA Inventory dashboard)
• Third-party inventory management tools
• A simple spreadsheet with daily inventory checks

2. Monitor sales velocity changes

A sudden increase in sales velocity (from a viral moment, a competitor stockout, or seasonal demand) can deplete inventory faster than expected. Track daily sales against your forecast and adjust reorder timing if actual sales exceed forecast by 20%+.

3. Maintain backup supplier relationships

Having a secondary supplier (even at slightly higher cost) gives you an emergency option if your primary supplier faces delays. For critical products, this insurance is worth the effort.

4. Use air freight for emergency restocks

Air freight costs 5-10x more than ocean freight, but a 2-week stockout on a $25 product selling 15 units per day costs you $5,250 in lost revenue plus organic rank damage. If air freight for 500 units costs $2,000, it is often the better financial decision.

5. Reduce advertising when inventory is low

When you have fewer than 14 days of supply:

• Reduce PPC budgets by 50%
• Pause broad and auto campaigns (keep only your most profitable exact match keywords running)
• Consider a small price increase (3-5%) to reduce demand slightly and extend your runway

When you have fewer than 7 days of supply:

• Pause all advertising
• Raise price by 10-15% (this preserves the listing and Buy Box while slowing sales to extend inventory)

6. Plan for Amazon receiving delays

Amazon's receiving time has become increasingly unpredictable, ranging from 3 to 21+ days depending on the fulfillment center and season. Always build at least 10-14 days of Amazon receiving time into your lead time calculation.

Avoiding Overstocking: Storage Fee Optimization

The flip side of stockouts is overstocking, which incurs escalating costs:

Regular monthly storage: $0.87 per cubic foot (Jan-Sep), $2.40 per cubic foot (Oct-Dec)

Aged inventory surcharges: Start at 181 days, escalate to $6.90+ per cubic foot or $0.15 per unit at 365+ days

Strategies to minimize storage costs:

1. Right-size your reorder quantities

Do not order 6 months of inventory to get a bulk discount. The storage fees and aged inventory surcharges often exceed the manufacturing savings. Aim for 45-75 days of supply per shipment.

2. Use the Inventory Age report

Check the Inventory Age report in Seller Central weekly. It shows inventory segmented by how long it has been in Amazon's warehouse:

• 0-90 days: Healthy
• 91-180 days: Watch list — promote or plan removal
• 181-270 days: Danger zone — aged surcharges apply
• 271-365 days: Critical — surcharges escalate rapidly
• 365+ days: Emergency — highest surcharges, remove immediately

3. Create removal orders before surcharges hit

Set a calendar reminder to check the Inventory Age report on the 1st and 15th of every month. Any units approaching 180 days should be either promoted (temporary price cut or coupon) or removed.

4. Leverage Amazon's outlet and liquidation programs

Amazon Outlet lets you offer deep discounts on overstocked items to Amazon's deal shoppers. Liquidation sells your excess inventory to bulk buyers at 5-10% of retail. Both are better than paying months of surcharges on inventory that is not selling.

5. Time Q4 inventory carefully

Storage fees nearly triple in Q4 ($2.40 vs $0.87 per cubic foot). If your product does not see a Q4 sales increase (not all products do), minimize Q4 inventory. Ship Q4 stock in late September, sell through by late December.

Seasonal Inventory Planning

Seasonal demand requires adjusted forecasting:

Step 1: Calculate your seasonality index

If you have 12+ months of sales data, calculate monthly sales as a percentage of annual average:

Seasonality Index = Month's Sales / (Annual Sales / 12)

A December index of 1.8 means December sales are 80% above average. A February index of 0.6 means February sales are 40% below average.

Step 2: Apply the index to your forecast

Base forecast (average daily sales) x Seasonality Index = Adjusted daily sales forecast

Step 3: Adjust reorder quantities and timing

For months with index above 1.2 (peak demand):

• Increase reorder quantity by the index multiplier
• Order earlier to account for longer shipping times during peak seasons (carriers are busier)
• Build extra safety stock (15-20 buffer days instead of 10)

For months with index below 0.8 (low demand):

• Reduce reorder quantity by the index multiplier
• Consider skipping an order cycle if existing inventory will cover the slow period
• Reduce safety stock to minimize storage during the low-demand period

Step 4: Plan for Prime Day and Black Friday specifically

These events cause 2-4x normal sales velocity for many products. Plan inventory to arrive at Amazon at least 3 weeks before the event (4 weeks is safer due to receiving delays during pre-event rushes).

Inventory Metrics to Track Weekly

Monitor these metrics to maintain optimal inventory levels:

1. Days of supply by SKU: Current inventory / average daily sales. Target: 30-75 days.

2. Inventory turnover rate: Units sold / average inventory (monthly or quarterly). Target: 6-12 turns per year.

3. Aged inventory percentage: Units over 180 days / total units. Target: below 5%.

4. IPI score: Check bi-weekly. Target: above 500.

5. Restock urgency: Number of SKUs below their reorder point. Target: zero.

SellerPilot AI tracks all of these metrics automatically, pulling daily inventory snapshots from Amazon's SP-API and flagging SKUs that are approaching stockout or aging past the 180-day surcharge threshold. This gives you an early warning system so inventory problems are caught before they become expensive.

Key Takeaways

1. Reorder Point = (Average Daily Sales x Lead Time) + Safety Stock. Calculate this for every SKU and set alerts.
2. Lead time includes manufacturing, shipping, customs, last-mile, and Amazon receiving. Build in buffers — Amazon's receiving times are unpredictable.
3. Safety stock = Average Daily Sales x Buffer Days (7-21 days depending on risk tolerance and product importance).
4. Aim for 45-75 days of supply per shipment. More than 90 days risks aged inventory surcharges.
5. Maintain IPI above 450 by fixing stranded inventory, removing excess, and keeping top sellers in stock.
6. When inventory runs low, reduce ad spend and consider small price increases to extend runway.
7. Use the Inventory Age report to catch aging inventory before surcharges hit at 181 days.
8. Plan seasonal inventory using a seasonality index based on your historical sales data.

Good inventory management is not glamorous, but it directly impacts every aspect of your Amazon business: profitability, organic rank, advertising efficiency, and cash flow. The sellers who master it operate with lower costs, fewer emergencies, and more consistent growth than those who manage inventory by gut feeling.