Market sizing is often treated as a one‑off analytical sprint—assemble data, build a model, present a number, move on. That mindset works for small bets but breaks down when sizing becomes a continuous enterprise capability that informs M&A screens, product roadmaps, capital‑allocation cycles, and investor relations. To deliver consistent, audit‑ready outputs at speed, organizations need an operating system: clear roles, decision gateways, quality assurance protocols, and workflow tools that embed market sizing into the fabric of strategy and finance. This chapter lays out how to design and run that operating system so that every sizing exercise—no matter how novel or complex—follows a disciplined path from scoping to sign‑off.
10.1 Team Roles, Governance, and Decision Gateways
A market‑sizing project pulls in strategists, data scientists, finance partners, product managers, and sometimes external specialists. Without crisp division of labor and decision rights, projects drift, assumptions proliferate, and stakeholder trust erodes. Establishing a robust governance structure at the outset prevents those pitfalls.
Core Roles and Responsibilities
- Executive Sponsor
Owns the business question, secures funding, and resolves scope clashes. Sponsors rarely touch spreadsheets but make the go/no‑go calls at each stage gate. - Engagement Lead (EL)
Single point of accountability for day‑to‑day execution—sets the workplan, manages interdependencies, and presents interim findings. Typically a director‑level strategy or corporate‑finance leader. - Methodology Architect
Designs the analytical approach—top‑down, bottom‑up, supply‑side, or hybrid—and ensures consistency with the playbook. Serves as arbiter when methodological disputes arise. - Data Engineering & Analytics Team
Builds and maintains data pipelines, cleanses inputs, runs econometric or NLP models, and populates the dashboard. They enforce version control and reproducibility standards. - Subject‑Matter Experts (SMEs)
Provide domain context—regulatory insight, technical feasibility, customer behavior. SMEs validate driver trees and trigger assumptions. - Quality‑Assurance Reviewer (QA)
Operates independently from the core team; inspects logic, sources, and audit trail at predefined checkpoints. Think of QA as the in‑house red team. - Finance Partner
Integrates market‑size outputs into valuation models, budget allocations, and investor messaging. Finance ensures price bases, currency, and inflation treatments align with corporate standards.
Governance Cadence and Stage Gates
- Kickoff Gate – Sponsor, EL, Methodology Architect, and Finance approve the project charter: business question, boundary definition, precision target, and resource estimate.
- Scoping Gate (end of Week 1) – Driver tree, data source list, granularity plan, and initial order‑of‑magnitude check signed off. QA confirms that critical assumptions carry ownership tags.
- Methodology Gate – Choice of analytical lens (top‑down, bottom‑up, supply‑side) validated. Architects must document why alternatives were rejected and how triangulation will occur.
- Data‑Lock Gate – All primary sources ingested, cleaned, and logged; gaps highlighted with mitigation plans. Sponsor authorizes spend on any paid datasets at this gate only—curbing scope creep.
- First‑Draft Gate – Core numbers (TAM, SAM) produced; sensitivity tornado and basic scenario ranges generated. QA performs a full audit trace, flagging unresolved anomalies.
- Triangulation Gate – Independent lens outputs reconciled using the Three‑Lens Framework (Chapter 7). Any >15 percent delta must be resolved or explicitly carried as a caveat.
- Executive Review Gate – Sponsor and C‑suite review final numbers, scenario bands, and key risks. Decisions on investment, resourcing, or external disclosure are taken here.
- Post‑Mortem Gate – Two weeks after delivery, the team captures lessons learned, updates the playbook, and archives the model with documentation for future refresh.
Decision Rights and RACI at a Glance
- Responsible (R) – Engagement Lead, Data Team for building the model.
- Accountable (A) – Executive Sponsor for scope and go/no‑go; QA Reviewer for methodological integrity.
- Consulted (C) – Methodology Architect, SMEs, Finance Partner at each gate.
- Informed (I) – Product, Sales, IR teams—receive dashboard outputs and narrative summaries.
Quality‑Assurance Protocols
- Code freeze 48 hours before each gate for reproducibility.
- Automated linting catches hard‑coded numbers in calculation cells.
- Source Trace Audit ensures every external figure links to the Source Log.
- Bias Scan—peer reviewer checks for optimism bias, double counting, and denominator mismatches.
Tools and Documentation
- Project Charter template—one‑pager capturing scope, success metrics, and key stakeholders.
- Stage‑Gate Checklist auto‑generated from the charter, integrated with project‑management software (Jira, Asana).
- Decision Log records each gate verdict, rationale, and action items—vital for audit trails and Sarbanes‑Oxley compliance.
- Live Dashboard in Tableau or Power BI pulls from the master workbook; permissioned for read‑only access by broader stakeholders.
Common Governance Pitfalls and How to Avoid Them
- Role ambiguity—multiple leads editing the same assumptions. Fix with a crisp RACI and locking critical input sheets.
- Gate skipping—pressure to meet a board date tempts teams to merge gates. Enforce lightweight virtual check‑ins rather than skipping.
- Late SME engagement—domain experts brought in after numbers are baked. Schedule SME reviews before Methodology and Data‑Lock Gates.
- Uncontrolled version sprawl—files circulate via email. Mandate a single source‑of‑truth repository with branch control.
Quick‑Action Checklist
- Charter signed by Sponsor and EL.
- RACI is published and accessible to the whole team.
- Gate calendar scheduled with reminders.
- QA function staffed and independent.
- Tool stack defined—data lake, model workbook, dashboard platform.
- Decision Log initiated; audit trail enabled from Day 1.
With governance and stage‑gates institutionalized, market‑sizing shifts from artisanal craft to industrial discipline—delivering faster turnarounds, fewer surprises, and a credibility premium that compounds with every successful engagement.
10.2 Standard Workplan Templates and Effort Estimates
Predictable timelines and resourcing are the hallmarks of a mature market‑sizing capability. While every project varies in data availability and stakeholder complexity, experience shows that 80 percent of tasks follow a repeatable cadence. Codifying that cadence into standard workplan templates accelerates planning, aligns expectations, and lets leaders gauge whether the team is sized to deliver on schedule—or whether outside help is required.
Three Canonical Project Scales
- Flash Screen (2 weeks, light touch). Used for M&A triage or early‑stage venture scouting where ±30 percent accuracy suffices.
- Core Assessment (6 weeks, moderate depth). The workhorse for annual strategy off‑sites, product launches, and investor decks; targets ±15 percent accuracy.
- Deep Diligence (12 weeks+, high fidelity). Commissioned for billion‑dollar capex, IPO prep, or regulatory filings; aims for ±10 percent or better.
Each scale inherits the same eight stage gates (Section 10.1) but compresses or expands the effort within phases.
Phase‑by‑Phase Effort Breakdown (Core Assessment as Baseline)
Week 0 – Pre‑Kickoff Preparation (0.3 FTE)
Engagement Lead drafts the project charter, circulates boundary hypotheses, and books kickoff with sponsor. Minimal analyst time; leverage existing slides.
Week 1 – Scoping & Data Reconnaissance (2 FTE)
One strategist frames the driver tree, one data engineer mines source catalogs and secures dataset licenses. Output: finalized scope, assumptions register, order‑of‑magnitude check.
Weeks 2–3 – Data Ingestion & Cleaning (3 FTE)
Data engineer (1.5 FTE), analyst (1 FTE), and SME (0.5 FTE) ingest and normalize secondary sources, set up pipelines, and de‑duplicate records. QA runs spot checks. About 120 person‑hours.
Week 3 – Primary Research Sprint (variable, avg 1.5 FTE)
If needed, commission five expert interviews and field a 200‑respondent micro‑survey. Include procurement lead‑time in the calendar; interviews themselves fit within the week.
Weeks 4–5 – Model Build & Triangulation (3 FTE)
Data engineer codes the model skeleton; analyst calibrates drivers; SME validates inputs; Methodology Architect spends 0.5 FTE resolving edge cases. Deliverables: base‑case TAM/SAM, tornado, scenario ranges.
Week 6 – Executive Packaging & QA (2 FTE)
Designer polishes dashboards (0.3 FTE). Analyst and Engagement Lead refine storyline, stress‑test charts, and prep for the Executive Review Gate. QA performs final audit; average 40 person‑hours.
Typical Total Effort
Core Assessment: ~450 person‑hours spread across 4–5 individuals. Flash Screen compresses to ~120 hours; Deep Diligence expands to 1 000–1 400 hours with heavier primary research and econometric work.
Workplan Template Structure
Each template resides in the PMO’s project‑management platform (e.g., Asana, Monday, Jira) as a blueprint:
- Task name – parent phase label (Scoping, Data Ingestion…)
- Duration – calendar days with built‑in slack for QA rework.
- Owner – role, not person, to future‑proof against team changes.
- Dependencies – ensures, for example, that Data‑Lock cannot close before dataset contracts are executed.
- Output artifact – links to charter, driver tree PDF, Source Log, dashboard URL.
- Effort tag – small (≤10 h), medium (11–40 h), large (>40 h) so managers can auto‑roll budgets.
Project managers clone the template, adjust durations ±20 percent for holiday schedules or atypical data hurdles, and lock the baseline so variance tracking works.
Effort‑Sizing Heuristics
- Data complexity multiplier. For every additional 10 primary datasets beyond the baseline five, add 0.2 FTE weeks to ingestion.
- New geography factor. Entering a non‑English market increases translation and context effort by 15 percent.
- Primary research premium. Each 250‑respondent survey adds roughly $25 k and 1 FTE week (questionnaire design → field → cleaning).
- Machine‑learning modules. Econometric or NLP add‑ins impose an upfront 0.5 FTE week per model, plus 20 percent ongoing code QA.
- Regulatory sensitivity uplift. Projects destined for SEC filings carry a 10 percent QA overhead.
Check‑In Rhythm
- Daily stand‑up (15 minutes). Track blockers; adjust task owners.
- Weekly sprint demo. Show live model updates; gather SME feedback.
- Gate‑prep huddle (48 hours before). Freeze code, rehearse story, finalize Decision Log entries.
Success Metrics for the Workplan
- On‑time gate passage ≥95 percent.
- Rework hours <10 percent of total effort.
- QA audit findings resolved before Executive Review.
- Stakeholder satisfaction ≥4.5/5 on post‑mortem survey.
Quick‑Use Checklist
- Clone appropriate template (Flash, Core, Deep).
- Adjust task durations for known complexities; keep dependency logic intact.
- Populate role‑to‑name mapping and Slack channel invites.
- Approve budget tied to task‑level effort tags; secure PO for paid data by Data‑Lock Gate.
- Lock baseline; activate variance tracker; schedule daily stand‑ups and gate huddles.
With standard templates and empirically grounded effort estimates, project leaders can forecast staffing needs in hours, sponsors gain realism on timeline and budget, and teams avoid the twin evils of heroic weekend crunches and idle bench time—delivering market‑sizing outputs that are not just correct but also consistently on schedule and on cost.
10.3 Quality‑Assurance Checklists and Peer Review Protocols
No matter how brilliant the analysis, a single hidden error can wreck credibility, misdirect millions of dollars, and erode trust in the entire strategy function. Quality assurance (QA) therefore cannot be an ad‑hoc “final look” but a systematic, multi‑layer defense designed into every phase of the workplan. The goal is not perfection—markets are too uncertain for that—but defensible reliability: every assumption traceable, every formula auditable, every conclusion stress‑tested.
Three Lines of Defense
- Self‑check (line analyst). Automated code linting, source‑of‑truth links, and real‑time data validations catch mechanical errors as they happen.
- Peer review (independent analyst). A colleague uninvolved in the build walks through the driver tree, reproduces key outputs, and challenges logic.
- QA Reviewer (formal gate). A senior specialist outside the project team performs a structured audit against the master checklist before each decision gate.
Embedding all three lines creates overlapping catch nets: the first filters typos, the second exposes logical gaps, and the third confirms alignment with enterprise standards.
The 30‑Point QA Checklist
Data Integrity
- All external figures linked to the Source Log with publication date and page number.
- Currency conversions documented; FX rates match treasury guidelines.
- Inflation adjustments use company‑approved deflator series.
- Units standardized; no silent mixing of kW, MW, GW.
- Missing values flagged and imputed with transparent logic.
- Datasets pass duplicate and outlier scans (z‑score ±3).
Model Structure
- 7. Driver tree matches approved methodology diagram.
- 8. Each input cell uses blue font; formulas black; scenarios green.
- 9. No hard‑coded values inside formula cells (automated VBA scan).
- 10. Circular‑reference check returns zero.
- 11. Workbook opens without calculation errors or broken links.
Logic & Mathematics
- 12. Totals reconcile: sum of segments equals reported aggregate within ±0.01 %.
- 13. Ratio cascades verified: product of filters reproduces subtotal.
- 14. Growth rates back‑calculate correctly from level data.
- 15. Monte‑Carlo code seeds stored; reruns reproduce P50 within 1 %.
- 16. Scenario toggles alter only intended cells (trace precedents).
Triangulation & Sensitivity
- 17. Independent lens estimates converge within ±15 % or variance explained.
- 18. Tornado chart ranks drivers by correct elasticity.
- 19. Two‑way sensitivity tables match single‑driver deltas.
- 20. P10/P90 bounds include at least 90 % of Monte‑Carlo outcomes.
Documentation & Audit Trail
- 21. Assumption Register complete with owner, last‑validated date.
- 22. Change Log records every structural update with a timestamp.
- 23. Decision Log entry drafted for upcoming gate.
- 24. Version in Git or SharePoint matches file under review.
Compliance & Bias
- 25. Regulatory data usage and license terms respected; paid reports not redistributed.
- 26. Personally identifiable information stripped or masked.
- 27. Bias scan: penetration assumptions compared across demographics; no unjustified disparities.
- 28. Optimism bias check: compare base‑case CAGR to historical analogs; explain >2 × deviations.
Reproducibility
- 29. Fresh clone of repo reproduces dashboard with make all.
- 30. QA Reviewer signs digital checklist; Sponsor signs gate approval only after items
1–29 pass or are waived with documented rationale.
Peer Review Protocol
- Reviewer selection. Rotate among analytics staff to avoid “house‑eyes.” Reviewers must have no build tasks on the project.
- Time‑boxed review. Allocate 4–6 hours for Core Assessments; use the 30‑point checklist as agenda.
- Walk‑through session. Builder presents model logic; the reviewer asks “why” for each major assumption, “how” for each calculation.
- Re‑run key outputs. Reviewer executes the model, changes two high‑impact drivers, and verifies expected behavior.
- Issue log. Findings captured in Jira with severity (critical, major, minor) and due date. Builder cannot close issues—reviewer retests.
- Sign‑off. Peer‑review passport appended to Decision Log; QA Reviewer sees both build and review sign‑offs before gate.
Automation Aids
- Code linters (xltrail, flake8) flag hidden constants and unused variables.
- Data‑validation bots compare incoming CSV schemas against prior loads.
- CI/CD pipelines run regression tests on notebooks and Monte‑Carlo modules.
- Diff‑compare tools highlight cell‑level changes between workbook versions.
Embedding QA into Culture
- Training. All analysts complete a “Spreadsheet Defense” boot camp before the first assignment.
- Gamified scorecards. Teams earn QA badges for zero critical findings across three projects; public scoreboard fosters pride.
- Post‑mortem reviews. Each project documents QA pain points; playbook updated quarterly.
- Leadership reinforcement. Executive Sponsor publicly credits QA diligence in board meetings, reinforcing its strategic value.
Quick‑Reference Checklist for Project Leads
- Assign peer reviewer at project kickoff, not post‑hoc.
- Schedule QA sign‑off 48 hours before each gate.
- Enforce code freeze before QA starts.
- Require digital signatures on a 30‑point checklist.
- Archive signed checklist and logs in the project repository.
Systematic QA and peer review turn market‑sizing from a fragile craft into a reliable engineering discipline—one where numbers survive cross‑examination, earn stakeholder trust, and ultimately guide smarter strategic bets.