Amazon FBA Restock Planner & IPI Score Optimizer

Your IPI score is tanking your storage limits and you still don't know which SKUs to restock before you stock out.

Amazon FBA restock planner and IPI score optimizer built for private label and wholesale sellers managing 20–500 SKUs across one or more marketplaces.

If you've ever stared at Seller Central wondering why your IPI score dropped overnight — or scrambled to restock a top seller only to hit your storage limit because of dead inventory eating up cubic feet — this planner was built for exactly that moment.

You were supposed to be growing your Amazon business. Instead, you're doing triage. Stranded listings, excess ASIN flags, restock recommendations that don't match reality, and a storage limit that seems designed to punish your best months. Most FBA sellers don't have a demand problem. They have an inventory intelligence problem. This fixes that.

---

**WHAT'S INSIDE THE FBA RESTOCK & IPI SCORE PLANNER**

**📦 Restock Demand Forecasting**
Enter your sales velocity by SKU — daily, weekly, or 30/60/90-day averages — and the planner calculates exactly when each ASIN will hit zero stock. No more gut-feel reorders. No more stockouts on your hero products while low-velocity SKUs pile up in fulfillment centers costing you money every single day.

**📊 IPI Score Impact Simulator**
The IPI optimizer shows you which inventory health factors are dragging your score down. Excess inventory ratio, sell-through rate, stranded inventory percentage, and in-stock rate are all tracked in one place. You can model what happens to your IPI score if you liquidate a slow mover, reduce inbound shipments on flagged ASINs, or improve sell-through on stale stock — before you make the move.

**🔴 Stranded and Excess Inventory Dashboard**
See every SKU flagged as stranded or excess in a single view. The dashboard surfaces which ASINs are actively hurting your IPI score so you can prioritize removals, price adjustments, or liquidation before Amazon reduces your storage allocation.

**📐 Storage Limit Planner**
Know your current storage utilization versus your storage limit in real time. The planner factors in pending inbound shipments alongside your current on-hand inventory so you can see exactly how much space you have available — and which SKUs to hold back from your next shipment to avoid overflow fees.

**💸 COGS and Margin Tracker Per SKU**
Track your landed cost, Amazon referral fees, FBA fulfillment fees, and storage fees per ASIN so you always know your true margin — not just your revenue. If a SKU's margin is being eaten alive by long-term storage fees, the tracker makes that visible before it becomes a quarterly surprise.

**📅 Restock Timeline and Lead Time Calculator**
Input your supplier lead time, shipping days, and target safety stock buffer. The planner tells you the exact date you need to place your next purchase order to avoid a stockout — accounting for both transit time and current velocity. Works for domestic suppliers, freight from overseas, and 3PL hand-off timelines.

**📋 Multi-SKU and Multi-Marketplace View**
Managing ASINs across US, UK, CA, or other Amazon marketplaces? The planner supports separate marketplace tabs so you can track inventory health, restock timing, and IPI factors independently per region — critical for sellers who can't afford a stockout on one marketplace to cascade across their whole account.

**📈 Sell-Through Rate Tracker**
One of the four IPI pillars is sell-through rate — and it's the one most sellers underestimate. The tracker calculates your rolling sell-through rate per ASIN so you can spot slow movers before Amazon flags them, run promos with real data behind the decision, and defend your IPI score proactively rather than reactively.

---

**WHO THIS IS FOR**

This planner is built for Amazon FBA sellers who are past the scrappy spreadsheet stage but not yet running a full warehouse management system. If you're managing 20 to 500 SKUs — whether private label, wholesale, or a mix of both — and you've lost storage capacity, taken an IPI hit, or stocked out on a top seller in the last 90 days, this is your operational backbone.

---

**WHAT YOU GET**

- Instant digital download — Excel (.xlsx) and Google Sheets compatible
- No macros, no VBA, no plugins required — works in your browser or desktop
- Lifetime access with free updates pushed to your download link
- Personal and single-business use license included
- Step-by-step setup guide included in the file

---

**HOW IT WORKS**

1. Download instantly after purchase — no waiting, no account creation
2. Enter your SKU list, sales velocity, lead times, and current inventory levels
3. The planner calculates your restock dates, IPI impact, and storage utilization automatically
4. Make smarter restock decisions, protect your IPI score, and stop paying for inventory that's hurting your account

---

**A NOTE ON COMPATIBILITY**

This template is fully formula-based with no macros. It works in Microsoft Excel (2016 and later) and Google Sheets. No special software required — open it on any device and start entering your data immediately.

---

**LICENSE**

This template is licensed for personal and single-business use only. Please review Etsy's digital download policies for full terms.

---

Questions before purchasing? Drop a message in the shop — response time is typically within 24 hours.

→ Find more operational tools for FBA and resale businesses at **@bizgrid_co**

Perfect for: Amazon FBA private label and wholesale sellers managing 20-500 SKUs across one or more marketplaces

Why now: Amazon tightened IPI thresholds and storage fee structures in 2024, forcing sellers to actively manage inventory health or face suppressed listings and capacity restrictions

✓ Instant digital download
✓ Works with Microsoft Excel (Mac & PC) and Google Sheets
✓ No technical skills required
✓ Formulas and calculations already built in

📋 LICENSE: Personal and single-business use only. This template may not be resold, redistributed, or used to create derivative products for sale.