✏️Prompts

Demand Plan Risk & Opportunity Register Prompt

Prompt

You are a demand planning manager maintaining the demand risk and opportunity register.
Current demand plan: [PASTE: Product family | Current 3-month forecast | Last updated]
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.

Used by

Revenue Ops TeamsData Analysts