Amazon FBA Restock Planning: Build a SKU Worksheet

For an established US Amazon brand, restocking is a recurring decision about demand, cash, and timing. A healthy total inventory number can conceal a stockout next week. A purchase order can also leave you with more supplier stock than your next FBA shipment can accommodate.

Build a SKU worksheet that answers three questions: when does replenishment need to start, how much supply is needed, and which units should go to Amazon now? Keep the assumptions visible so your team can revise the decision when demand or receiving changes.

01Separate stock by availability

Start with actual sellable FBA units. Record reserved and unavailable units separately, then list each inbound shipment with quantity, status, expected sellable date, and confidence. Amazon’s FBA Inventory report includes working, shipped, and receiving quantities alongside recent sales metrics. A working shipment is not proof that stock is moving.

Use this planning definition: inventory position = sellable FBA units + confirmed inbound expected within the planning horizon. Define that horizon on the worksheet. Exclude speculative receipts and flag delays. If your sellable figure already excludes reserved customer orders, do not subtract those orders again.

Keep supplier and 3PL stock in separate columns. It can satisfy a replenishment need without a new purchase, but it is not yet sellable FBA inventory. When a batch enters confirmed inbound, remove it from its previous bucket. Count every unit once.

02Build a worksheet your team can act on

Use one decision row per SKU and a supporting receipt schedule. The following fields connect the calculation to an owner and a next action.

Choose demand from a reasonably stable period when the product was available. Observed sales during a stockout can understate demand because customers could not buy. Annotate unavailable days instead of treating that reduced rate as the new normal.

Adjust explicitly for planned promotions, seasonality, price changes, or a sustained trend. A short promotion spike should not automatically become the permanent forecast. Record both the base rate and the temporary adjustment so purchasing can see what drives the quantity.

03Measure lead time through sellable stock

The relevant lead time ends when replenishment becomes sellable. Add supplier production or procurement, preparation, transportation, and Amazon check-in/receiving. Use your own observed elapsed times and a visible contingency, rather than assuming delivery immediately restores availability.

Amazon’s shipping guidance describes the inbound transportation process. Its receiving guidance distinguishes in-transit, delivered, checked-in, receiving, and closed statuses. Track these milestones; none establishes a universal supplier-to-sellable timetable.

Maintain a separate transfer lead time when stock is already at your 3PL. It may support a faster shipment decision than a new supplier purchase. The purchasing and shipment clocks should describe the actual starting location of the units.

04Distinguish the trigger from the target

Our illustrative worksheet uses a buffer expressed in demand days. Safety stock = daily demand × buffer days. The reorder point is daily demand × total replenishment lead time + safety stock. It is a trigger for action, not the quantity to order.

The target inventory position adds the review interval: daily demand × (lead time + review interval + buffer days). The supply gap is max(0, target − inventory position). Check existing supplier/3PL supply and commitments before treating that gap as a new purchase requirement.

Assume a hypothetical SKU sells four units daily, with 35 days from supplier to sellable FBA, a seven-day review interval, and five buffer days. Safety stock is 20 units. The reorder point is 160 units; the target is 188.

With an inventory position of 120 units, made up only of sellable FBA plus confirmed inbound within the horizon, the gap is 68 units. If no separate stock or commitments cover it, a 12-unit case pack rounds the proposed purchase to 72, subject to MOQ. These are Go Massive planning formulas, not Amazon formulas or a guarantee of an optimal order.

Before approving it, test forecast confidence, cash, existing supply, and capacity. A 72-unit purchase proposal does not automatically mean a 72-unit FBA shipment.

05Check receipt timing and capacity

Phase receipts against demand by date. For example, the same hypothetical 120-unit position could contain 40 sellable units and 80 inbound expected on day 15. At four units daily, the initial stock covers ten days. The total conceals a possible gap before receipt; investigate earlier available supply or adjust the commercial plan.

Then check the applicable storage type in Capacity Monitor. Amazon’s FBA capacity guidance describes current usage, remaining capacity, and future estimates. Open shipments count toward usage. Close shipments that will not be sent and check the account’s actual limits before allocating a new shipment.

Capacity varies by account and storage type, with factors including sales, seasonality, forecasts, deals, IPI, and fulfillment-center capacity. Use live Seller Central values; a fixed IPI threshold or assumed fee cannot substitute for that check.

06Reconcile recommendations every week

Compare your decision with Amazon’s Restock Inventory quantity and recommended ship date. Amazon uses sales history, demand forecasts, seasonality, and replenishment settings. Review lead time, case pack, replenishment frequency, and supply-chain type when the two views differ.

Assign an owner to each exception. Review weekly and more frequently for volatile or fast-moving SKUs. Reforecast after a material demand change or delayed receipt. Explore Go Massive’s Amazon account management services for help connecting replenishment decisions with account and advertising priorities.

Official Amazon sources observed October 13, 2026. Scope: established US Amazon brands. Worksheet formulas and operating recommendations are Go Massive’s analysis; confirm account-specific settings and current guidance in Seller Central.