
Cannibalization & Halo Simulation for Extension Scenarios
📄 Prompt Template
Build a simple demand-transfer model to estimate cannibalization vs. incremental growth for [ProposedExtension] across [Channel] in [Region]. Use baseline sales for [MasterBrand] SKUs and top [CompetitorCount] competitors, elasticities, and proposed price/pack. Simulate three scenarios (Conservative, Base, Upside) and compute net incremental revenue, contribution, and brand equity “halo” proxy via distribution-weighted awareness lift. Set a decision guardrail: [CannibalizationTolerance] max cannibalization and [IncrementalRevenueTarget] minimum incremental.
Output format (deliverables):
Inputs/assumptions table; 2) Scenario results table with net incrementality and ROI; 3) Waterfall chart narrative (text) explaining sources of incrementality; 4) Recommendation with sensitivity table for price ±[PriceVariance] and distribution ±[DistVariance].