The question
Suppose a product has limited stock and replenishment is expected in 21 days. How much additional demand could an advertising test create before that delivery arrives?
The exercise explores alternative assumptions for the same proposed test. There is no before-and-after performance story. Its purpose is to connect a budget decision with inventory capacity and a clear review trigger.
The assumed inputs
- Available, sellable stock today: 300 units
- Stock buffer the operator wants to retain: 30 units
- Time until replenishment becomes sellable: 21 days
- Expected baseline demand without the proposed test: 8 units per day
- Proposed additional advertising budget: $40 per day
- Assumed cost per click: $1.20
- Assumed click-to-order conversion rate for the initial calculation: 10%
- Units per order: 1
All amounts are in US dollars. Baseline demand covers all demand already expected without this additional test, including any existing advertising. The example assumes no other inventory movements and treats the modeled test orders as fully additional for the stock-capacity check. Those are simplifying assumptions, not established facts about advertising attribution.
Calculate the available headroom
Expected baseline demand before replenishment is 8 units × 21 days = 168 units.
The units available for additional demand while preserving the chosen buffer are 300 − 30 − 168 = 102 units.
Spread evenly across 21 days, that is approximately 4.9 additional units per day. Actual demand will not arrive evenly, and the 30-unit buffer is simply an input chosen for this exercise. It is not a generally recommended safety-stock level.
Test one spending assumption
At $40 per day for 21 days, the proposed test would spend $840 if the full budget were used.
- Modeled clicks: $840 ÷ $1.20 = 700
- Modeled orders at 10% conversion: 700 × 10% = 70
- Modeled additional units at one unit per order: 70
- Modeled stock remaining: 300 − 168 − 70 = 62 units
Under these assumptions, the calculation leaves 32 units above the chosen 30-unit buffer. This is an arithmetic check, not confirmation that the budget is safe. Costs, conversion, daily demand and the replenishment date can all differ from the assumptions.
The same assumptions imply $12 in advertising cost per modeled order: $1.20 ÷ 10%. Whether that cost is economically acceptable needs product contribution data, which this inventory exercise does not supply.
Stress-test stronger conversion
Keep the proposed budget, click cost and baseline demand unchanged, but assume 15% conversion instead of 10%.
- Modeled clicks: 700
- Modeled orders: 700 × 15% = 105
- Modeled additional units: 105
- Modeled stock remaining: 300 − 168 − 105 = 27 units
That leaves three units less than the chosen stock buffer. A higher conversion rate can increase inventory pressure even when spend stays the same. Neither conversion assumption is a predicted result.
A replenishment delay or higher baseline demand would reduce the available headroom further. Lower conversion could reduce stock pressure while increasing advertising cost per order. Inventory capacity and advertising economics need separate checks.
Define the operating decision
The model supports a bounded test only if its assumptions are credible enough for the operator's risk tolerance. It does not select a universal launch budget.
- Confirm sellable units by variation, existing commitments, the replenishment date and when incoming stock will actually be available to buy.
- Check that the listing clearly answers essential product questions and that the advertised variation can fulfill the demand.
- Choose a test budget and stock buffer using realistic demand and delivery uncertainty, rather than the example's inputs.
- Review available stock and projected demand while the test runs. Adjust or pause expansion if projected stock at replenishment would fall below the chosen buffer.
- Reassess the budget when delivery timing, conversion, cost per click, product economics or baseline demand changes materially.
Any stock trigger should be calculated at the product or variation level that can actually fulfill an order. An account-wide stock total can conceal a shortage in the advertised item.
What the model leaves out
The exercise assumes that the full daily budget is spent, every modeled order contains one unit and all test orders add to baseline demand. It omits daily demand variation, cancellations, stock adjustments, multiple-item orders and delays beyond the assumed replenishment date.
An ad-attributed order is not automatically an incremental order. Real decisions need a defensible demand forecast, current inventory records and a way to avoid double-counting baseline and advertising demand. They also need product-level costs before making any claim about profitability.
The practical lesson is to set the learning question, spending boundary and stock review trigger together before expanding advertising.