Current working model
2027, quarter by quarter.
The current shared workbook covers Q4 2026 and calendar 2027. Figures are working assumptions; FY2 and FY3 forecasts are not included in this sheet.
Year 1
The current retail plan.
4,536,000 units · $55.00 blended case
Assumption — finalizingKyle to update
Assumption — finalizing12 units per case
Assumption — finalizingAfter cost, trade, marketing and SG&A · sheet calls this net revenue
Assumption — finalizing2026 Q4
GA, PA, NJ
- Rolling doors
- 1,200
- Cases / door / month
- 4
- Cases
- 14,400
- Units
- 172,800
2027 Q1
IL, FL, RnR, WildSide
- Rolling doors
- 3,600
- Cases / door / month
- 4
- Cases
- 43,200
- Units
- 518,400
2027 Q2
VA, WI, NC, TBD
- Rolling doors
- 5,400
- Cases / door / month
- 4
- Cases
- 64,800
- Units
- 777,600
2027 Q3
TBD
- Rolling doors
- 7,650
- Cases / door / month
- 5
- Cases
- 114,750
- Units
- 1,377,000
2027 Q4
TBD
- Rolling doors
- 10,350
- Cases / door / month
- 5
- Cases
- 155,250
- Units
- 1,863,000
| Measure | 2026 Q4 | 2027 Q1 | 2027 Q2 | 2027 Q3 | 2027 Q4 | 2027 total |
|---|---|---|---|---|---|---|
| Markets | GA, PA, NJ | IL, FL, RnR, WildSide | VA, WI, NC, TBD | TBD | TBD | |
| Rolling retail doors | 1,200 | 3,600 | 5,400 | 7,650 | 10,350 | 10,350 |
| Velocity (cases / door / month) | 4 | 4 | 4 | 5 | 5 | |
| Cases | 14,400 | 43,200 | 64,800 | 114,750 | 155,250 | 378,000 |
| Units | 172,800 | 518,400 | 777,600 | 1,377,000 | 1,863,000 | 4,536,000 |
| Revenue | $792K | $2.38M | $3.56M | $6.31M | $8.54M | $20.79M |
Spend per case
- Blended case price
- $55.00
- COGS + freight · Pricing tab
- ($32.04)
- Trade spend (12%) — sales line
- ($6.60)
- Marketing spend (12%) — incl. POS
- ($6.60)
- SG&A (7%)
- ($3.85)
- Net per case
- $5.91
Blended $55 case less $32.04 cost, 12% sales trade, 12% marketing and 7% SG&A. The sheet's “net revenue” is actually the amount left after all four costs, not accounting net revenue.
Still open in the sheet
- Retail door counts and account-level forecast — Kyle to confirm
- 2027 Q2 lists WI, but the earlier legal-state screen excludes Wisconsin — confirm SKU and compliance before treating those doors as available
- Markets for 2027 Q3–Q4 and Q2's TBD market
- Ecommerce dollars per quarter
- COGS + freight per case — sheet still flags $32.04 for update
- The sheet's 28,200 'total doors' adds rolling quarter-end doors; it is not unique doors — use 10,350 year-end doors
Additional funded ask in this sheet: $0.00. This does not establish total working-capital needs.
From the same workbook
Distributor opportunity, not booked sales.
Counter Culture tab · illustrative, not additive to plan revenue
Assumption — finalizingNot the sum of rolling doors
Assumption — finalizingDoes not include a working-capital forecast
Assumption — finalizingFull detail
The complete current workbook.
Read the Year 1 plan, Pricing and Counter Culture tabs directly here, or open the workbook to edit them. Refresh to see new changes.
