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.

Defaults are placeholders, not agreed numbers
$792K
Blended case sales

Before trade · matches Year 1 sheet

$95K
Trade spend

Carried by sales

$697K
Sales after trade
$461K
COGS
$236K
Gross profit

33.8% of net

14,400
Cases (12 ct)

$1.36 gross profit per bottle

Pricing sensitivity

Pressure-test price, cost, and volume.

Q4 volume scenario

172,800 units

Each result uses 12.0% trade spend. Changes are measured against the highlighted working case.

Working sensitivity — not committed

$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

working
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.

Planning scenario

Total allocation

$95K

Per unit

$0.55

POS budget awaiting allocation

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

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
ScenarioUnitsSales tradeMarketing POSTotalPer unit
Conservative129,600$71K$0.00$71K$0.55
Planselected172,800$95K$0.00$95K$0.55
Stretch216,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.

ScenarioUnitsCasesGrossTradeNetGross profit
Conservative129,60010,800$594K$71K$523K$177K
Planleaning172,80014,400$792K$95K$697K$236K
Stretch216,00018,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.

Checking access…

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 + Kyle

172,800 units (14,400 cases, 1,200 doors) in the current sheet. Final pending door counts from Kyle.

Full sales forecast build

Ernie + Kyle

The sheet projects 378,000 cases in 2027; account-level forecast and market spend allocation still need confirmation.

Overall pricing model

Ernie + Kyle

Pricing 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

Ops

Pricing tab carries $2.67/bottle ($32.04/case). Awaiting landed-cost confirmation.

Trade spend envelope

Sales + Marketing

Structure agreed (trade in sales, POS in marketing). Dollar envelope pending the forecast.

Distributor target list

Sales

Counter 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.