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

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

Example for: B2B services agency forecasting next quarter gross revenue

Scenario Matrix

Driver / MetricWorst CaseBase CaseBest Case
Active Client Retention75%88%96%
New Monthly Retainers1 new / mo3 new / mo6 new / mo
Average Retainer Value$4,500$6,000$7,500
Q2 Ending Monthly Revenue$62,000$94,000$138,000
Net Margin8%19%27%

Trigger Events

  • Worst Case Trigger: Two enterprise accounts enter renewal reviews without signing within 30 days of contract end.
  • Best Case Trigger: Referral inbound leads exceed 15 per month for two consecutive weeks.

Operational Action Plan

  • Worst Case Prep: Freeze contractor hiring immediately and renegotiate software seat licenses to preserve 6 months of operating cash.
  • Base Case Execution: Maintain current hiring cadence of 1 delivery specialist in month two.
  • Best Case Prep: Create a pre-vetted freelance bench so onboarding client work does not degrade delivery quality.
Written by AI from this prompt. Your results will vary.

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.

Keep exploring

More in Data Analysis
Data Analysis

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.