Inventory Restock Planner — FBA Reorder Guard

Tell me your sales velocity, lead time, and current stock, and I'll tell you exactly when to reorder, how much, and how close you are to a stockout or an overstock storage bill.

When to Use

• Reorder timing: You're not sure if it's time to place a PO yet, and need a clear reorder-by date instead of guessing.
• Reorder quantity: You know you need to restock but not how many units to cover demand without over-ordering.
• Stockout risk: A fast-moving SKU is running low and you need to know if you'll run dry before the next shipment lands.
• Lead time changed: Your supplier or freight lead time just got longer and you need to recompute safety stock and reorder points.
• Cash-constrained ordering: You have limited cash and need to prioritize which SKUs to reorder first by stockout urgency.
• Overstock / storage bleed: Inventory is piling up and you want to avoid long-term storage fees and aged-inventory surcharges.
• Seasonal ramp: A Q4 or seasonal spike is coming and you need to pre-build stock without guessing the multiplier.
• New product first reorder: An early SKU is selling and you need a data-driven second order instead of a gut call.
• Multi-SKU planning: You're juggling several SKUs with different velocities and lead times and want one prioritized restock list.
• IPI / capacity limits: You're managing FBA storage limits and need to balance cover days against restock-limit risk.

What You Provide

• Current on-hand units (and any inbound / in-transit)
• Recent sales velocity (units/day or week — ideally a couple of periods)
• Supplier + freight lead time in days
• MOQ and case-pack / lot size
• Any seasonality or promo spike, and your target cover period
• Constraints like a cash cap or storage limit

What You Get

• Average daily demand and a trend flag (up / flat / down)
• Effective lead time with a variability buffer, and the service-level assumption stated
• Safety stock, reorder point, and current days of cover
• A reorder-by date and a projected stockout date if you do nothing
• A recommended order quantity rounded to MOQ / case-pack and adjusted for trend and seasonality
• Stockout-risk and overstock/storage-risk flags
• For multiple SKUs, a prioritized table sorted by urgency, plus the single most urgent action

Example

Input:

Yoga mat, 420 units on hand, 0 inbound. Selling ~18/day over the last 30 days (was 14/day the 30 before). Lead time 28 days production + 18 days sea freight. MOQ 500, case pack 50. No promos. Want ~60 days of cover after restock. Cash not tight. When do I reorder, how many, and am I at risk of running out?

Output:

• Average daily demand and the up-trend flag (14 → 18/day)
• Effective lead time with buffer, plus the service-level assumption
• Safety stock, reorder point, and current days of cover
• Reorder-by date and projected stockout date
• Recommended quantity rounded to MOQ/case-pack, trend-adjusted
• Stockout and overstock/storage risk lines
• The single most urgent action with a one-line "why now"

Why This Skill is Different

• Reorder-by date, not just a reorder point: Turns the math into a calendar deadline you can act on, not an abstract threshold.
• Catches overstock, not just stockout: Flags when an order would bury cash in long-term storage, instead of only warning about running dry.
• Trend-aware: Compares recent velocity periods and adjusts for an up- or down-trend rather than assuming flat demand.
• Constraint-honest: Respects MOQ, case-pack, cash caps, and storage limits instead of an idealized number you can't actually order.
• Prioritized across SKUs: For a portfolio it ranks by urgency so you know what to PO first, not every SKU treated equally.

Who It's For

Amazon FBA private-label sellers managing reorder cycles; FBM and hybrid sellers balancing on-hand stock against lead times; operations and supply-chain leads running multi-SKU restock planning; brand owners avoiding both stockouts and long-term storage fees; sellers with long overseas lead times who need trustworthy safety-stock math; cash-constrained founders deciding which SKUs to reorder first; sellers ramping for Q4 or a seasonal peak; anyone managing FBA storage limits or inventory performance scores; wholesale and arbitrage sellers timing repurchases; and ops people who want one prioritized PO list across a catalog instead of weekly spreadsheet guesswork.

Disclaimer

This Skill is an AI-assisted planning tool. It does not access your Amazon Seller Central account, inventory feeds, supplier systems, or any live data, and it places no orders. All recommendations — reorder points, quantities, dates, safety stock, and risk flags — are estimates based solely on the inputs you provide and on standard inventory-planning formulas; they assume your velocity and lead-time figures are accurate and may be wrong if those inputs are stale or incomplete. Outputs are not financial or business advice and do not guarantee against stockouts, overstock, storage fees, or lost sales. Actual demand, lead times, supplier reliability, and Amazon's fees and limits can change without notice. Verify every number against your current Seller Central data and your supplier's terms before placing any purchase order. You are responsible for all inventory and purchasing decisions made using this output.