Internal forecast hub
The Q4 model, out loud.
Move the four inputs and the Q4 picture moves with them. Defaults use the current sheet's $55 blended case and 12% sales trade allocation; all figures await approval.
Scenario builder
Q4 2026 — drag the assumptions.
Before trade · matches Year 1 sheet
Carried by sales
33.8% of net
$1.36 gross profit per bottle
Pricing sensitivity
Pressure-test price, cost, and volume.
172,800 units
Each result uses 12.0% trade spend. Changes are measured against the highlighted working case.
Working sensitivity — not committed| Wholesale | Unit cost | Revenue | Trade spend | Gross profit | Margin |
|---|---|---|---|---|---|
| $4.08 | $2.42 | $706K($86K) | $85K($10K) | $203K($33K) | 32.7%-1.1 pts |
| $4.58 | $2.42 | $792KBaseline | $95KBaseline | $279K+$43K | 40.0%+6.2 pts |
| $5.08 | $2.42 | $878K+$86K | $105K+$10K | $355K+$119K | 45.9%+12.1 pts |
| $4.08 | $2.67 | $706K($86K) | $85K($10K) | $160K($76K) | 25.7%-8.1 pts |
| $4.58working | $2.67 | $792KBaseline | $95KBaseline | $236KBaseline | 33.8%Baseline |
| $5.08 | $2.67 | $878K+$86K | $105K+$10K | $312K+$76K | 40.3%+6.5 pts |
| $4.08 | $2.92 | $706K($86K) | $85K($10K) | $116K($119K) | 18.7%-15.1 pts |
| $4.58 | $2.92 | $792KBaseline | $95KBaseline | $192K($43K) | 27.6%-6.2 pts |
| $5.08 | $2.92 | $878K+$86K | $105K+$10K | $268K+$33K | 34.7%+0.9 pts |
$4.08 wholesale
$2.42 unit cost
- Revenue
- $706K ($86K)
- Trade spend
- $85K ($10K)
- Gross profit
- $203K ($33K)
- Margin
- 32.7% -1.1 pts
$4.58 wholesale
$2.42 unit cost
- Revenue
- $792K Baseline
- Trade spend
- $95K Baseline
- Gross profit
- $279K +$43K
- Margin
- 40.0% +6.2 pts
$5.08 wholesale
$2.42 unit cost
- Revenue
- $878K +$86K
- Trade spend
- $105K +$10K
- Gross profit
- $355K +$119K
- Margin
- 45.9% +12.1 pts
$4.08 wholesale
$2.67 unit cost
- Revenue
- $706K ($86K)
- Trade spend
- $85K ($10K)
- Gross profit
- $160K ($76K)
- Margin
- 25.7% -8.1 pts
$4.58 wholesale
$2.67 unit cost
- Revenue
- $792K Baseline
- Trade spend
- $95K Baseline
- Gross profit
- $236K Baseline
- Margin
- 33.8% Baseline
$5.08 wholesale
$2.67 unit cost
- Revenue
- $878K +$86K
- Trade spend
- $105K +$10K
- Gross profit
- $312K +$76K
- Margin
- 40.3% +6.5 pts
$4.08 wholesale
$2.92 unit cost
- Revenue
- $706K ($86K)
- Trade spend
- $85K ($10K)
- Gross profit
- $116K ($119K)
- Margin
- 18.7% -15.1 pts
$4.58 wholesale
$2.92 unit cost
- Revenue
- $792K Baseline
- Trade spend
- $95K Baseline
- Gross profit
- $192K ($43K)
- Margin
- 27.6% -6.2 pts
$5.08 wholesale
$2.92 unit cost
- Revenue
- $878K +$86K
- Trade spend
- $105K +$10K
- Gross profit
- $268K +$33K
- Margin
- 34.7% +0.9 pts
Budget allocation
Keep sales trade and marketing POS separate.
Total allocation
$95K
Per unit
$0.55
Sales · trade + promotion
Calculated from gross wholesale revenue
$95K
100.0% of allocation
Marketing · POS material
Entered separately; never deducted from trade
$0.00
0.0% of allocation
| Quarter | Units | Gross wholesale | Trade rate | Sales trade | Marketing POS | Total allocation |
|---|---|---|---|---|---|---|
| Q1 | $0.00 | $0.00 | $0.00 | |||
| Q2 | $0.00 | $0.00 | $0.00 | |||
| Q3 | $0.00 | $0.00 | $0.00 | |||
| Q4 | $792K | $95K | $95K | |||
| Total | 172,800 | $792K | — | $95K | $0.00 | $95K |
Q1
$0.00 total
Sales trade
$0.00
Q2
$0.00 total
Sales trade
$0.00
Q3
$0.00 total
Sales trade
$0.00
Q4
$95K total
Sales trade
$95K
Scenario comparison
All quarters · current inputs| Scenario | Units | Sales trade | Marketing POS | Total | Per unit |
|---|---|---|---|---|---|
| Conservative | 129,600 | $71K | $0.00 | $71K | $0.55 |
| Planselected | 172,800 | $95K | $0.00 | $95K | $0.55 |
| Stretch | 216,000 | $119K | $0.00 | $119K | $0.55 |
Sales trade includes slotting, scan and promotional allowances, depletion incentives, and returns reserve. Marketing POS includes physical point-of-sale materials and activation support entered above.
Reference cases
Conservative, plan, stretch.
| Scenario | Units | Cases | Gross | Trade | Net | Gross profit |
|---|---|---|---|---|---|---|
| Conservative | 129,600 | 10,800 | $594K | $71K | $523K | $177K |
| Planleaning | 172,800 | 14,400 | $792K | $95K | $697K | $236K |
| Stretch | 216,000 | 18,000 | $990K | $119K | $871K | $294K |
AI planning workspace
Turn the working model into an investor scenario.
Save the current inputs with market context, then build a private, continuing analysis covering investor takeaways, risks, recommendations, and open decisions.
Ground rules
What the team has already settled.
Forecast leads the spend
The sales forecast sets the market spend, not the other way around. Kyle and Ernie need more than a day or two to build it properly.
Trade sits in sales
Trade spend and trade promotion are modeled against gross wholesale and carried in the sales line.
POS sits in marketing
Point-of-sale material comes out of the marketing budget so trade dollars stay tied to volume.
Open decisions
Before sign-off.
Q4 unit commitment
Ernie + Kyle172,800 units (14,400 cases, 1,200 doors) in the current sheet. Final pending door counts from Kyle.
Full sales forecast build
Ernie + KyleThe sheet projects 378,000 cases in 2027; account-level forecast and market spend allocation still need confirmation.
Overall pricing model
Ernie + KylePricing tab (WIP): $9.99 everyday SRP / $7.99 promo 4x/yr, $5.00 wholesale, $5.50 to retail via DSD (24.24% margin), $2.67 unit COGS.
Confirmed COGS on RN
OpsPricing tab carries $2.67/bottle ($32.04/case). Awaiting landed-cost confirmation.
Trade spend envelope
Sales + MarketingStructure agreed (trade in sales, POS in marketing). Dollar envelope pending the forecast.
Distributor target list
SalesCounter Culture napkin math lists accounts and $423,250 monthly replenishment potential; conversion into the 2027 door plan is unconfirmed.
Field team pay plan
Shiky / Tom, Kyle + Alex$25/hr + 10/20/30% commission tiers designed. Needs Shiky/Tom sign-off before hiring; door-opening bonus and reorder % still TBD.
Field team budget (Year 1)
Alex$840K–$1.42M penciled for 9 reps, 3 regional managers, President of Sales. Largest line item; pending Alex.
