What went wrong in peak season and how a revised reorder model prevented repeat stockouts.

Case Study: Q4 Stockout Lessons and a Better Reorder System

Context

This is a case study about a mistake that was entirely preventable, and the system that was built afterward to make sure it never happened again.

The seller ran a mid-sized FBA business in the home goods category. Flagship product was a stainless steel insulated travel mug that had been selling consistently for seven months before Q4 2024. Monthly revenue through September was averaging $18,400. The product was sitting at BSR position 12 in its subcategory with 94 reviews and a 4.7-star average. PPC was running efficiently at 22% ACoS. Everything was working.

The seller knew Q4 was going to be bigger than anything he had seen. He had read the playbooks. He understood that October through December typically represented 35–40% of annual FBA revenue in his category. He had even built a rough forecast — 40 units per day was the Q4 projection, up from 22 units per day in September. He ordered accordingly: 1,800 units shipped in late September, plus 600 units already in the warehouse from the previous order.

What he had not accounted for was that his Q4 projections were conservative. Actual velocity in the first three weeks of October ran at 51 units per day — 27% above forecast. By October 23, inventory was at 178 units. Reorder lead time from his factory in Ningbo to the Amazon fulfillment center was 28 days on a normal cycle. On October 23, he placed the reorder.

The math did not work. At 51 units per day and 178 units in stock, he had 3.5 days of inventory remaining.

The Stockout: What Happened

Inventory hit zero on October 28. The listing went inactive.

The timing was brutal. October 28 fell in the week leading up to Halloween — one of the early-season gift purchase windows. The listing was indexed but unsellable. Shoppers who found it through organic search or PPC (which was still spending against the ASIN on autopilot for 18 hours before being paused) were arriving at an out-of-stock page.

BSR degraded immediately. On October 28 the BSR was position 12 in the subcategory. By November 2 — five days into the stockout — it had fallen to position 47. Organic rank for the primary keyword, which had been on page one position 7, disappeared from the first two pages entirely.

The second shipment checked in at the fulfillment center on November 19 — 22 days after the stockout began. The listing went back to active. But it did not return to position 12. It returned to something closer to position 38, and the primary keyword organic rank came back on page two, position 14.

Rebuilding to pre-stockout position took 18 additional days of aggressive PPC spend and a temporary coupon discount to accelerate velocity. The listing returned to BSR position 12 by approximately December 8.

The Financial Damage

The seller ran the numbers carefully after the fact, because understanding the true cost of the stockout was important for calibrating how much to invest in prevention going forward.

Lost revenue during the stockout (October 28 – November 19, 22 days): At 51 units per day and $34.99 selling price, the daily revenue projection was $1,784.49. Over 22 days, the estimated lost revenue was $39,258. Against a 28% net margin, that represented approximately $10,992 in lost profit.

Incremental PPC spend for rank recovery (November 19 – December 8, 18 days): Normal PPC spend during this period should have been approximately $520. Actual PPC spend to rebuild velocity and recapture rank was $1,140. Incremental overspend: $620.

Coupon discount cost: A 10% coupon was run for 12 days during the recovery period. At an average of 47 units per day during the coupon period, the discount cost approximately $1,978.

Total estimated cost of the stockout: approximately $13,590 in lost profit and incremental recovery spend.

That number is what drove the investment in a new inventory system. If a better reorder model cost $200 in spreadsheet time and tool setup, the ROI calculation was straightforward.

Why the Old System Failed

Post-mortem analysis identified three structural failures:

1. Static velocity assumption. The reorder point had been calculated at launch using the average daily sales at the time — 22 units per day. It had never been updated as velocity grew. By October, the seller was effectively running a reorder system calibrated for September's sales pace.

2. No velocity review cadence. There was no scheduled check of current average daily sales against the reorder formula. The reorder point lived in a spreadsheet that had not been opened in six weeks.

3. Q4 forecast was treated as a ceiling, not a floor. The 40 unit/day projection was the number used for planning. When actual performance exceeded it by 27%, the system had no mechanism to catch the gap and adjust.

The New Reorder System

The replacement system was built over three days in mid-November while the second shipment was in transit. It is simple enough to run in a spreadsheet, but the discipline of running it on schedule is what makes it work.

Core formula:

Reorder Point = (Current Average Daily Sales × Supplier Lead Time in Days) + Safety Stock

Safety Stock = Current Average Daily Sales × 14 days (two weeks of buffer regardless of season)

How "Current Average Daily Sales" is defined: Not the all-time average, not the launch-period average. The rolling 14-day average, recalculated every Monday morning. This is the number that feeds everything else. If velocity is accelerating, the reorder point moves up automatically. If velocity slows, the reorder point adjusts down and prevents overordering.

Example from December 2024 (post-recovery):

• Rolling 14-day average: 48 units/day
• Supplier lead time: 28 days (confirmed, not assumed)
• Safety stock: 48 × 14 = 672 units
• Reorder Point: (48 × 28) + 672 = 2,016 units

When the Monday morning check shows inventory at or below 2,016 units, a purchase order goes out that day. Not the next day. Not when it is convenient. That day.

Reorder quantity: Sized at 60 days of projected sales at current velocity, adjusted for known Q4 multipliers. In Q4, the multiplier is 1.3x applied to current velocity for the first order of the season, dropping back to 1.1x for subsequent orders once real velocity is confirmed.

Supplier Lead Time Tracking

One of the structural changes made after the stockout was building a supplier communication log that is updated with every interaction. Before November 2024, lead time was treated as a fixed number — "28 days." After the rebuild, lead time is tracked as a range with variance: the factory's confirmed production start date, the booking date for ocean freight, the estimated arrival at port, the estimated check-in at the Amazon fulfillment center.

LaunchFast's Supplier Hub became useful here for organizing these timelines across multiple SKUs. When you are managing one product, a spreadsheet is sufficient. When you are managing three or more products with different suppliers and different seasonal velocity profiles, a centralized tool that tracks reorder status and lead time confirmation in one place reduces the cognitive overhead that causes the kind of missed-check that led to the October stockout.

Q4 Inventory Planning Checklist

The following checklist was built directly from the lessons of the 2024 stockout. It runs on a fixed schedule, starting in August.

August (90 days before peak):

• Pull prior Q4 daily sales data by week. Calculate peak week velocity and average Q4 velocity.
• Identify supplier lead time for Q4 batch — confirm production availability and freight booking windows. Do not assume last year's lead time still applies.
• Calculate initial Q4 order quantity: (Peak Q4 weekly velocity × 12 weeks) × 1.2 safety multiplier.
• Place initial Q4 order no later than August 31 for air freight or September 15 for ocean freight.

September:

• Confirm shipment is in production. Get tracking when goods leave factory.
• Review current year velocity trend vs. prior year Q4 start velocity. Adjust Q4 forecast if current trend is running significantly above or below prior year.
• Calculate whether a second Q4 shipment will be needed. If yes, book supplier capacity now.

October:

• Switch reorder cadence from weekly check to daily check starting October 1.
• Recalculate reorder point using rolling 7-day average daily sales (not 14-day — shorter window captures acceleration faster in peak season).
• Have purchase order template for second Q4 shipment ready to send. Waiting to prepare it wastes time when inventory signals urgency.

November–December:

• Daily inventory check. No exceptions.
• If inventory falls within 20% of reorder point, place order immediately rather than waiting for the exact trigger.
• Monitor inbound shipment status daily. Amazon check-in delays during Q4 are common — builds 3–5 extra buffer days into planning during November.

Results: Q4 2025

The seller ran the new system through Q4 2025. Two purchase orders were placed: one in August for 3,200 units, one in early October for 1,400 units after actual October velocity came in at 58 units per day — again above forecast. Neither shipment ran out before the next arrived. Inventory stayed above the reorder point throughout November and December.

Q4 2025 revenue: $284,000. Net margin: 26%. Zero stockout days.

The comparison to Q4 2024 — where the stockout erased an estimated $13,590 in profit during the highest-demand period of the year — made the new system's value concrete and permanent.

Lessons

The real cost of a stockout is never just the lost units. It is the rank recovery, the PPC overspend, the discount cost, and the compounding effect of a weakened position heading into the highest-demand weeks of the year. In this case, that multiplier turned a 22-day stockout into roughly five weeks of degraded performance.

Velocity must be recalculated regularly, not set once. A reorder point calculated at 22 units per day is wrong at 51 units per day. The formula is not the problem. The cadence of updating the inputs is the problem.

Q4 lead time is not the same as off-season lead time. Factories are busier. Freight lanes are fuller. Amazon check-in queues are longer. Every lead time assumption should be confirmed with the supplier in August, not assumed from prior experience.

Buffer is not excess — it is insurance. Two weeks of safety stock felt wasteful when the seller first built the new formula. After experiencing a $13,590 stockout, it felt cheap.

For the broader framework on managing a product launch through its first 90 days — including how to set inventory triggers that grow with velocity rather than staying static — see the Amazon FBA First 90 Days Launch Plan. For sellers who want to understand how PPC spend during a rank recovery period compounds the cost of a stockout, Amazon PPC for Beginners covers the relationship between sales velocity and advertising cost in the early weeks of a listing.