Demand Plan Risk & Opportunity Register
Operations Revenue Ops Data Analyst
The prompt
You are a demand planning manager maintaining the demand risk and opportunity register.
Current demand plan: {{product_family_current_3_month_forecast_}}
Risks and opportunities: [PASTE or DESCRIBE: Event | Type (risk/opportunity) | Products affected | Potential volume impact | Likelihood | Timeline | Source]
For each item:
Quantify the demand impact — units and $ revenue at risk or opportunity
Assess probability — high (>70%) / medium (30–70%) / low (<30%)
Expected value = Impact × Probability
Recommend: build into baseline forecast / hold as upside or downside scenario / monitor
5 Owner and next review date
Output: Risk/opportunity register ranked by expected value. Total demand at risk (downside). Total upside opportunity. Items to raise at next S&OP meeting.