P&L, cost structure, cash flow, and operational finance — tied to the Datahub.
2026 YTD vs Historical P&L
What this shows: Month-to-date P&L for 2026 (Jan–Feb), compared to full-year 2025 and 2024. All figures flow from fact_orders and fact_ad_spend in the Datahub, plus BOM-sourced COGS and budget-sourced G&A. Revenue is net (gross − discounts − returns − platform fees).
2026 YTD Net Rev
$316K
Jan–Feb (2 mo)
2025 Full Net Rev
$3.39M
Baseline year
2024 Full Net Rev
$2.48M
+36.7% YoY
NOI (2026 YTD)
-$156K
-49.4% of net rev
Last updated: —
📊 Revenue by Channel — 2024, 2025, 2026 YTD
Shopify is 80% of gross revenue. Amazon is 24% (after 32% fees). Wholesale is small but growing. All figures exclude fees and returns; net revenue is what's available for COGS and G&A.
📋 P&L Summary — 2026 Monthly Detail vs 2025/2024 Full Year
Line Item
2026 Jan
2026 Feb
2026 Total
% of Rev
2025 FY
% of Rev
2024 FY
% of Rev
Gross Revenue
$198,462
$186,482
$384,944
—
$7,670,790
—
$5,661,413
—
Shopify gross
$145,248
$131,943
$277,191
37.4%
$5,392,000
70.3%
$3,784,521
66.9%
Amazon gross
$50,000
$44,844
$94,844
12.8%
$1,950,000
25.4%
$1,600,892
28.3%
Wholesale
$3,214
$9,695
$12,910
1.7%
$328,790
4.3%
$276,000
4.9%
Discounts & Returns
-$20,141
-$18,704
-$38,845
-10.1%
-$779,234
-10.2%
-$512,104
-9.0%
Platform Fees (Sh/Az)
-$10,518
-$9,477
-$19,996
-5.2%
-$483,443
-6.3%
-$368,655
-6.5%
Net Revenue
$167,803
$148,296
$316,099
100.0%
$3,389,113
100.0%
$2,481,654
100.0%
COGS
$118,603
$102,303
$220,906
69.9%
$1,842,479
54.4%
$1,181,099
47.6%
Raw Materials
$32,844
$30,204
$63,048
19.9%
$527,394
15.5%
$349,872
14.1%
Shipping (COGS)
$26,942
$23,877
$50,819
16.1%
$432,185
12.7%
$289,564
11.7%
Warehouse Rent
$11,786
$11,786
$23,572
7.5%
$141,432
4.2%
$141,432
5.7%
Warehouse Labor
$46,031
$35,029
$81,060
25.6%
$741,468
21.9%
$400,231
16.1%
Gross Margin
$49,200
$45,993
$95,193
30.1%
$1,546,634
45.6%
$1,300,555
52.4%
G&A
$80,144
$76,133
$156,277
49.4%
$1,028,143
30.3%
$775,069
31.2%
Office Labor
$49,318
$46,008
$95,326
30.2%
$573,756
16.9%
$380,214
15.3%
Consultants / Contractors
$10,200
$9,591
$19,791
6.3%
$118,692
3.5%
$112,556
4.5%
Software & Subscriptions
$6,205
$6,205
$12,410
3.9%
$74,460
2.2%
$68,340
2.8%
Rent (Office)
$5,526
$5,526
$11,053
3.5%
$66,318
2.0%
$59,640
2.4%
Other G&A
$8,895
$8,803
$17,697
5.6%
$194,917
5.7%
$154,319
6.2%
Marketing / Advertising
$48,621
$46,394
$95,015
30.1%
$768,006
22.7%
$513,988
20.7%
Facebook / Instagram Ads
$39,118
$35,587
$74,705
23.6%
$621,354
18.3%
$412,665
16.6%
Google Ads
$8,877
$8,877
$17,754
5.6%
$106,488
3.1%
$89,456
3.6%
Shopify Collabs / Partnerships
$872
$1,683
$2,555
0.8%
$15,330
0.5%
$11,867
0.5%
Net Operating Income
-$79,565
-$76,534
-$156,099
-49.4%
-$249,515
-7.4%
$11,497
+0.5%
Other Income / (Expense)
-$3,429
-$3,428
-$6,857
-2.2%
$43,210
1.3%
$28,544
1.2%
Net Profit / (Loss)
-$82,994
-$79,962
-$162,956
-51.6%
-$206,305
-6.1%
$40,041
+1.6%
MER & Performance Metrics (2026 YTD)
📈 Marketing Efficiency Ratio (MER)
Shopify Gross MER0.34
Ad spend / Gross revenue. Target: <0.40
Shopify Net MER0.29
Ad spend / Net revenue after fees
Total Ad Spend$95K
Meta $75K + Google $18K + Shopify Collabs $2.5K
Cross-Reference: Revenue Validation
Shopify and Amazon revenue are validated against fact_orders in the Datahub. Shopify $277K gross = sum of all Shopify orders (Jan–Feb 2026, before discounts/fees). Amazon $95K includes pack decomposition. See the Dashboard for channel-level drill-down and customer metrics.
Cross-Reference: Ad Spend Detail
Meta and Google spend are pulled from fact_ad_spend in the Datahub. Weekly granularity. All amounts are actual spend, not attributed revenue. ROAS (revenue per $ spent) is calculated separately in the Quadruple Whale dashboard by attribution window (7d, 1d, etc.).
⚙️ Needs Config: Bank reconciliations and monthly close data. Monthly P&L is currently sourced from fact_orders + budget. When full accounting integration is available (QuickBooks MCP, Q2 2026), this will sync to actual GL balances.
Cost of Goods Sold & Bill of Materials
What this shows: Breakdown of COGS by category (Raw Materials, Shipping, Warehouse Rent, Warehouse Labor). All product costing is sourced from the BOM, which contains formulations, component costs (by supplier), labor rates, and packing materials. 127 ecommerce SKUs costed.
Raw Materials
$63K
19.9% of net rev
Shipping (COGS)
$51K
16.1% of net rev
Warehouse Rent
$24K
7.5% of net rev
Warehouse Labor
$81K
25.6% of net rev
📊 COGS Trend — 2024 vs 2025 vs 2026 YTD (% of Net Revenue)
Category
2024
2025
2026 YTD
Trend
Raw Materials
14.1%
15.5%
19.9%
↑ +4.4pp
Shipping
11.7%
12.7%
16.1%
↑ +3.4pp
Warehouse Rent
5.7%
4.2%
7.5%
↑ +3.3pp
Warehouse Labor
16.1%
21.9%
25.6%
↑ +3.7pp
Total COGS %
47.6%
54.4%
69.9%
↑ Deteriorating
🧭 BOM Inventory Summary
Ecommerce SKUs costed157
Retail SKUs113
Component records320
Formulation records364
Unique vendors48
Raw material pricing rows402
Cross-Reference: COGS per Unit
Every product in the Datahub has a cogs_per_unit field from dim_products. This is sourced from the BOM and includes Raw Materials, Packaging, and Labor. RM costs are YELLOW (need supplier verification against current pricing). Labor is flat $1.16/unit for all 5oz sprays YELLOW (directionally correct, not task-level accurate). Use for directional margin analysis but annotate variance.
⚠️ Data Quality Issues
Raw Material Costs (Yellow): BOM RM costs need verification against current supplier pricing. Last updated 6 months ago. Request current price lists from 48 vendors.
Labor Model (Yellow): BOM uses flat $1.16/unit for all 5oz sprays. This is directionally correct but doesn't account for task-level variation (filling vs. capping vs. QA). See BACKLOG.md for detailed labor modeling project.
Shipping Cost (Red): COGS shipping is estimated at 16.1% (based on average carrier rates). Not yet validated against actual invoice data. Need carrier reconciliation files.
Cash Flow & Liquidity
What this shows: Cash flow model and liquidity analysis. This is a directional guideline based on the P&L, operating cycles, and working capital assumptions. Actual cash is driven by payment terms, customer deposits, and inventory turns, which vary monthly.
💸 2026 YTD Cash Position (Placeholder)
Category
Jan
Feb
Cumulative
Operating Cash Inflow
$167,803
$148,296
$316,099
Net Revenue (collected)
$167,803
$148,296
$316,099
Operating Cash Outflow
$276,707
$258,027
$534,734
COGS (paid to suppliers)
$118,603
$102,303
$220,906
G&A (cash expenses)
$80,144
$76,133
$156,277
Marketing/Ads (media spend)
$48,621
$46,394
$95,015
Other / Contingency
$29,339
$33,197
$62,536
Net Cash Flow
-$108,904
-$109,731
-$218,635
Opening Cash
TBD
TBD
TBD
Ending Cash (est.)
TBD
TBD
TBD
📊 Working Capital Assumptions
Metric
Days
Notes
Days Sales Outstanding (DSO)
1–2
Shopify/Amazon are immediate settlement. Wholesale terms vary (net 30–60).
Days Inventory Outstanding (DIO)
35–45
Inventory turns ~8x/year. Seasonal peaks (summer, holiday) require higher working capital.
Days Payable Outstanding (DPO)
30–45
RM suppliers: net 30. Logistics: immediate or net 15. Depends on vendor mix.
Cash Conversion Cycle (CCC)
0–15
Generally positive due to quick AR and extended payables.
⚙️ Needs Config: Bank reconciliations and funding analysis. Once bank feeds are live (QuickBooks MCP), this will show actual cash position, deposits, and draws. For now, this is estimated from P&L assuming all revenue is collected and all expenses are paid.
General & Administrative (G&A) Expense Detail
What this shows: Detailed breakdown of G&A expenses: office labor, contractors, software subscriptions, facilities rent, insurance, legal, and miscellaneous. G&A is running 49.4% of net revenue in 2026 YTD vs. 30.3% in 2025 FY — a significant increase driven by headcount and consulting spend.
Hudson Valley office lease. Separate from warehouse rent (in COGS).
Other G&A
$154,319
6.2%
$194,917
5.7%
$17,697
5.6%
Insurance, legal, accounting, corporate registration, travel, office supplies, professional development
🎯 Key Observations
Office Labor jump (15.3% → 30.2%): 2026 YTD includes new hires (Drew — warehouse science, Katelyn — product ops). Full-year 2025 was spread over 12 months. In a full 12-month 2026 (annualized), expect ~18–20% of net revenue.
Consultant spike (3.5% → 6.3%): Nikita (finance advisor) and specialized contractors ramped for strategic projects. This will normalize to 3–4% once projects complete.
Warehouse Inventory Position
What this shows: Current raw materials on hand, finished goods, and control board inventory. This ties to production forecasting and the GRP (Grow Resource Planning) project, which will track stock levels by queue and health status.
📦 Current Inventory (March 2026 Snapshot)
Category
Count
Status
Notes
Raw Materials
899
Healthy
Component units on hand (bottles, caps, labels, fragrance, etc.). Supports ~4 weeks of production at current run rate.
Control Board Items
153
Monitor
Ingredient/component records under inventory control. Some items on backorder from suppliers.
Finished Goods (Amazon)
41
Low
Inventory held at Amazon FBA. Down 60% from EOY 2025 (241 units) due to strong Q1 selling. Consider replenishment if sales accelerate.
Finished Goods (Warehouse)
129
Healthy
Products in Hudson Valley warehouse. Supports Shopify orders + wholesale + sampling.
📊 Inventory Turnover Ratio
2024 Inventory Turns7.8x
Days Inventory Outstanding: ~47 days
2025 Inventory Turns8.1x
Strong -- improved from 2024. Faster sell-through.
Cross-Reference: GRP Integration
Current inventory snapshot will feed into the GRP (Grow Resource Planning) system. GRP tracks four queues: Fulfillment (outbound orders), Production (make-to-order), Assembly (kitting, labeling), and Purchasing (inbound). Each queue will have Green/Yellow/Red health status based on stock coverage and lead times. See GRP Design Spec.
⚙️ Needs Config: Physical inventory count and item-level tracking. Currently a high-level snapshot. When warehouse management system (WMS) is connected, inventory will update daily by SKU and location.
Labor Capacity & Efficiency
What this shows: Shop labor rates, capacity modeling, and time trial data. Labor costs are a major component of warehouse COGS (currently 25.6% of net revenue). This section ties to the labor costing model in the BOM and the GRP capacity queue.
Blended Shop Rate (2025)
$48.45
Labor + payroll tax per hour
Blended Shop Rate (2024)
$49.69
-2.5% YoY
Time Trial Data
375 rows
2024 production tasks
👥 Labor Cost Allocation by Task (from 2024 Time Trials)
Task
Avg Hours/Unit
Shop Rate
Cost/Unit
Utilization
Filling (5oz spray)
0.042
$49.69
$2.09
85%
Capping (5oz spray)
0.028
$49.69
$1.39
78%
Quality Assurance
0.015
$49.69
$0.75
72%
Labeling & Packing
0.025
$49.69
$1.24
68%
5oz Spray Total Labor
0.110
$49.69
$5.47
76% avg
Candle Pouring (3-wick)
0.035
$49.69
$1.74
81%
Candle QA & Packing
0.018
$49.69
$0.89
70%
3-Wick Candle Total
0.053
$49.69
$2.63
76% avg
📊 Capacity Model — Supply vs Demand (Annualized 2026)
Total Annual Capacity180K units
Summer 2026 Forecast33K units
Capacity Utilization (Summer)18%
Significant slack; can scale up if demand accelerates.
Estimated Full-Year 2026110K units
Utilization (Full Year)61%
Cost per Unit (avg)$3.84
Including all formats (sprays, candles, packs)
Cross-Reference: BOM Labor Model
BOM currently uses a flat $1.16/unit for all 5oz sprays. This is estimated from the blended shop rate and average task time. Actual task-level labor costs (filling vs. capping vs. QA) are available in the time trial data (375 rows, 2024). A more granular model would assign task-level labor to each format/SKU based on observed time trials. See BACKLOG.md for detailed labor costing project.
⚙️ Needs Config: Current 2026 time trial data. Last update was 2024. Recommend refreshing with Q1 2026 production tasks to validate rates for current product mix (new fragrances: Linen, Coconut Soleil).
Grow Fragrance Finance — Datahub v1.0 · March 2026 · Data sourced from DuckDB via finance_data.json