FBA Inventory Forecast Tool
Amazon EU Marketplaces · DE · UK · FR · IT · ES · PL · SE

How the forecast is calculated

A plain-language overview of each step the tool runs through when generating your results.

Algorithm steps

Blended Daily Velocity

The tool combines your 30-day and 90-day sales figures into a single estimated daily sell rate. Recent data is given more weight since it reflects current demand. The result is then scaled by a seasonal multiplier — higher during peak periods, lower in off-season — so the forecast adapts to predictable demand swings.

Stockout Detection

If a product shows zero sales in the last 30 days but had sales over the past 90 days, the tool checks whether that silence is caused by running out of stock rather than genuine low demand. When a stockout is detected, only the longer-term 90-day rate is used so demand is not accidentally underestimated for the next order.

Restock Quantity (Whole Boxes)

The tool calculates how many units are needed to cover your target period plus the lead time buffer. That number is always rounded up to the nearest complete transport box — a partial box is never sent. This prevents underfilling cartons and keeps your shipment plan clean for carrier booking.

Overstock & Removal Orders

When available stock would last longer than the aged-inventory threshold you set, Amazon begins charging a long-term storage surcharge per unit. The tool identifies exactly how many boxes to remove to stay just below that threshold. Removal quantities are rounded down to be conservative and avoid pulling out more stock than necessary.

New Products (No Sales History)

For listings that have never sold before, there is no velocity to calculate. Instead, the tool uses the monthly search volume of the product's main keyword as a proxy for potential demand, and recommends a conservative initial batch. The idea is to create a live listing and gather real sell-through data before committing to a larger stock position.

Coverage After Replenishment

After calculating the shipment, the tool projects how many days of coverage remain once those units arrive at FBA. This acts as a final sense-check: the projected coverage must stay below the aged-inventory threshold, otherwise the tool flags that you are about to create the exact overstock problem it was trying to solve.

Status thresholds
CRITICAL
< 14 days
Stockout imminent — act immediately
LOW
14 – 30 days
Order now before stock runs out
OK
30 – 90 days
Healthy — monitor weekly
GOOD
90d → threshold
No action needed this cycle
OVERSTOCK
> aged threshold
Removal order advised

Insert Data

Configure global parameters and add products. Fields marked * are required.

Global forecast parameters
90d
Days of FBA stock to maintain
21d
Transit + FBA check-in time
60%
Recent vs historical data weighting
1.00×
Adjust for peak / off-peak season
180d
Amazon.de: surcharge after 181d
For report labelling
Products 
Product name* ASIN UPB* Box wt kg* S30d* S90d KW vol In stock* Price € New?
No products yet — click "+ Add product" to begin, or use "Load example".

No data entered yet

Go to Insert Data, add your products
and click Calculate results.