Build three scenarios for revenue and demand forecasts
Generate structured best, base, and worst-case forecast models to prepare for demand swings. Use this during annual planning or runway updates.
You getScenario Matrix, trigger Events and operational Action Plan
Prompt
Act as an operations and planning analyst. You will help me build three realistic operational forecast scenarios: best case, base case, and worst case.
Do not build the scenarios yet. First, ask me 3 numbered questions in one message:
1. What core metric are we forecasting, and what is its current baseline value?
2. What are the 2-3 biggest drivers or external risks that influence this metric?
3. What time period does this forecast cover?
After I reply, apply these rules:
- Define concrete assumptions for each scenario rather than arbitrary percentage shifts.
- Outline operational implications for each scenario, including staffing and cash considerations.
- General planning information only, not professional financial advice.
Output format:
- Scenario Matrix (table comparing Base, Best, and Worst across drivers and final output)
- Trigger Events (what signals you are slipping into the worst case or hitting the best case)
- Operational Action Plan (immediate steps to prepare for each outcome)Example output
Send the prompt into Claude, ChatGPT, or Gemini, then answer the three setup questions with your actual numbers. Follow up by asking what early leading indicators should be tracked weekly to detect which scenario is playing out.
Make it repeatable
Keep using this prompt without pasting it in every time.
Prompt details
- By
- Prompts-GPT editors
- Published
Did this prompt work?
Keep exploring
More like this
Evaluate past forecast variances to set accurate targets
Analyze past forecast misses to identify systematic over- or under-projection patterns. Use this before locking in next quarter's revenue or operational targets.
Isolate regional or platform drivers behind KPI drops
Break down aggregate product or revenue declines across platform and geographic dimensions. Use this when global numbers drop and leadership needs the root driver.
Convert monthly operations metrics to executive updates
Translate complex monthly performance metrics into a concise executive briefing. Use this before executive staff meetings to showcase key wins and blockers.
Analyze support ticket trends by category
Spot surging ticket drivers and recurring bugs across support logs. Use this to allocate team coverage and escalate product flaws quickly.
Summarize weekly metric anomalies into executive briefings
Convert raw week-over-week metric spikes and drops into concise executive briefs with business context and next steps.
Map and inspect an unfamiliar data export
Quickly understand the purpose, column types, and data quality risks of a messy raw CSV export. Ideal when inheriting unfamiliar operations sheets.
- Select three core KPIs for your business goal
- Audit driver-based models for compounding optimism bias
- Estimate potential revenue recovery across funnel drop-off points
- Map inconsistent export columns to target schemas
- Sanity check revenue projections against past baselines
- Summarize customer segment shifts for executive updates