Sales Tool 32

Retail
Sell-Through
Estimator

Forecast sell-through performance across retail accounts to predict reorders and revenue. Model by velocity tier, seasonal adjustment, and channel type to produce a forward revenue estimate.

1Account Base

Total Retail Accounts (#)

Avg Units Placed per Account

WS Price per Unit ($)

2Velocity Tier Mix

Tier A - High Velocity (% of accts)

Expected 80%+ ST in 90 days

Tier B - Mid Velocity (% of accts)

Expected 50-80% ST in 90 days

Tier C - Low Velocity (% of accts)

Expected <50% ST

Tier A Sell-Through Rate (%)

Tier B Sell-Through Rate (%)

Tier C Sell-Through Rate (%)

3Reorder Assumptions

Reorder Rate at 70%+ ST (%)

% of fast accounts that reorder

Avg Reorder Qty (% of initial)

Reorder Cycle (days)

Blended Sell-Through Rate—

Blended
ST Rate

—

Units
Sold

—

Reorder
Revenue

—

Sell-Through by Tier

Tier A units × ST rate—

Tier B units × ST rate—

Tier C units × ST rate—

Total Units Sold—

WS revenue from initial placement—

Reorder revenue (est.)—

Total Projected Revenue—

Remaining Inventory Risk

Units unsold after placement—

Unsold value at COGS—

P23-EDU · TWENTY3 IntelligenceSales Tool 32·Retail Sell-Through Estimator·Velocity Tier Analysis · A/B/C Mix·Reorder Projection & Revenue Forecast·P23-EDU · TWENTY3 IntelligenceSales Tool 32·Retail Sell-Through Estimator·Velocity Tier Analysis · A/B/C Mix·Reorder Projection & Revenue Forecast·

Sell-Through Rate Calculator