Skip to Content

DuPont Strategic Value Tree & Causal Attribution Engine

The Strategic Value Tree is SweetNight DXP’s macro financial and operational decomposition engine. Grounded in classic DuPont Analysis, it unpacks the enterprise North Star metric—Return on Equity (ROE)—top-down into over 60 interconnected operational nodes. Executives can trace how macro financial health is driven by bottom-up factors such as SKU pricing elasticity, ocean demurrage, and plant foaming yield.

DXP Strategic Value Tree and Causal DAG

DuPont 3-Factor Core Multiplicative Model

The value tree is mathematically anchored by the classic 3-factor DuPont equation:

ROE = Net Profit Margin × Asset Turnover × Equity Multiplier

Based on current Google BigQuery production lakehouse settlements:

ROE (28.40%) = 22.50% (Net Profit Margin) × 1.42x (Asset Turnover) × 1.58x (Equity Multiplier)

Factor Diagnostics:

  1. Net Profit Margin (22.50% · 🟡 WARNING)
    Compressed by +8.2% commodity polyol inflation and Long Beach port demurrage (-0.65pp), showing an 80 bps negative variance from the 24.40% budget baseline.
  2. Total Asset Turnover (1.42x · 🟢 HEALTHY)
    Accelerated inventory velocity across US forward warehouses optimized Days of Inventory (DOI) to 42.5 days, maintaining top-decile capital efficiency.
  3. Equity Multiplier (1.58x · 🟢 STABLE)
    Prudent balance sheet leverage with an asset-to-debt ratio of approximately 36.7%, preserving an ample solvency safety buffer.

60+ Node Causal Tree Hierarchy

Omnichannel DTC vs. 3P Dual-Engine Comparison

DimensionAmazon & 3P EngineShopify DTC Brand Store Engine
Monthly MTD Net Revenue$36.51M (81.3% share)$6.84M (15.2% share)
Average Order Value (AOV)$285.00$438.00 (Premium bundles)
Channel Gross Margin20.80% (FBA fees & commissions)34.20% (Sovereign pricing)
Blended Ad ROAS3.20x (Intense PPC bidding)4.35x (First-party Klaviyo flows)
Customer Data AssetPlatform-owned customer profilesFull 1st-party email/SMS database
Strategic SynergiesScale foundation to lower supply costsHigh margin engine to buffer inflation

Gross Margin Waterfall Decomposition

Clicking “Margin Attribution” renders the waterfall breakdown powered by com_margin_attribution:

Net Revenue = Gross GMV - Refunds & Returns - Discounts
Contribution Margin = Net Revenue - BOM Costs - Manufacturing Fees - Ocean Freight - Fulfillment

Current Period Variance Breakdown:

  • Gross GMV Booked: $48.20M
  • Customer Returns (-6.9%): -$3.32M (Top decile in online mattress retail)
  • Net Revenue: $44.88M
  • Direct Material BOM: -$22.44M (Polyol, pocket springs, jacquard fabrics)
  • Factory Assembly & Labor: -$4.48M
  • Ocean Freight & Demurrage: -$4.26M
  • Warehouse Drayage & Delivery: -$3.60M
  • Contribution Profit Margin: $10.10M (22.50%)

Interactive Tree Navigation

  1. Color Coded Node Health: Green denotes outperforming baseline; yellow flags minor variance (< 100 bps); red signals stress (> 100 bps variance).
  2. Node Expansion: Clicking any node (e.g., Ocean Freight) expands sub-dimensions like Port of Long Beach container demurrage.
  3. Physical Table Inspection: Click “Inspect Table” to preview raw records in com_margin_attribution.
  4. Agent Causal Reasoning: Right-click any node to query Copilot for automated 90-day time-series attribution.