3C · Offer Automation Table (COGS Model)

LOFI BLUEPRINT · Section 3C · Tier 1locked

Purpose: Model the cost-to-deliver per phase × step and enforce the ≥75% gross margin rule.

Inputs → Output

Sources

SPBIG-PAPI.offer_automation

Reads

section_3b.output

Writes

brand.what.offer_automation (jsonb)brand.what.cogs (jsonb)

Pipeline

Load anchors

SP loaded as system message (voice anchor, Rule 4). Task prompts: SP · BIG-PAPI.offer_automation. Pull ≥3 reference IDs (Rule 2). Reads locked upstream: 3B.

Generate

Automation table per phase×step: Type (Strategic/Management/Execution) · Talent ($1/$10/$100/$1000-per-hr tier) · Tools · Hr Estimates · Budget · Automation Suggestions + total revenue/costs/profit per client

Enforce caps

≥75% gross margin (Rule 9).

QA gate

Section 25 auto-runs QA L1 (24 checkpoints) + L2 (6 brand gates). Any L2 fail = REJECT → rewrite.

Technical Reference

Generation contract (machine-executable)

section: "3C"
id: s03c-offer-automation
state: LOFI_BLUEPRINT
tier: 1
sources: ["SP", "BIG-PAPI.offer_automation"]
inputs:
    - section_3b.output
output: "Automation table per phase×step: Type (Strategic/Management/Execution) · Talent ($1/$10/$100/$1000-per-hr tier) · Tools · Hr Estimates · Budget · Automation Suggestions + total revenue/costs/profit per client"
caps:
    - ≥75% gross margin (Rule 9)
cascades_from: [3B]
cascades_to: []

Supabase sync map (from Part 10)

Section 3C ->
  brand.what.offer_automation (jsonb)
  brand.what.cogs (jsonb)

SCHEMA NOTE: verify all jsonb paths + brand.assets type values against live Supabase before write. Flag missing columns in the PR; never create new columns without review.

Note

This is a LOFI artifact: its consumer is the next generation call, not a customer. Reviewed at the Doc/wizard LOFI gate before any HIFI section reads it. Source of truth: Master Template Part 3 + the Master Index. To change this page, edit content/docs/roadmap/_sections.json and re-run the compiler.