BXUP Track progress & test yourself — free
DevOps / SRE / Platform · Playbook · Core · ~4 min read
DEVOPS / SRE / PLATFORM · PLAYBOOK · CORE

Sanity-Check a Capacity Forecast with AI — Without Letting It Forecast

This playbook teaches a deliberate division of labor: statistical models forecast, LLMs critique.

Tier: Core · Hands-on time: ~30 minutes

LLMs are poor time-series forecasters — they pattern-match plausible curves and cannot be held to error bars — but they are excellent at interrogating a forecast's assumptions, spotting missing drivers, and stress-testing the story you are about to take into a capacity or budget review. Use the AI as the hostile reviewer your forecast never gets.

When to use

  • You built a capacity forecast (Prophet, Holt-Winters, cloud-native forecasting, or a spreadsheet trend) and are about to commit money or hardware to it.
  • Reviewing someone else's forecast — a vendor's growth projection, a client's capacity ask, a team's GPU request.
  • Pre-mortem before peak events (sale days, financial year-end, exam-results traffic) where the cost of being wrong is asymmetric.

Do NOT use this playbook to have an LLM produce the forecast numbers. If you have no statistical forecast yet, build one first — even a simple seasonal-naive baseline — then come back.

Prerequisites

  • A forecast artifact: the projected series, the historical data it was fit on, and (ideally) the model/method and its parameters.
  • The list of known future events the history cannot show: launches, migrations, marketing pushes, client onboardings, deprecations.
  • The decision the forecast feeds ("buy N nodes", "commit 3-yr Savings Plan", "reserve GPU quota") and the cost of over- vs under-provisioning.

The workflow

  1. State the decision and the asymmetry. Write one sentence: "This forecast decides X; overestimating costs us Y, underestimating costs us Z." Everything the AI critiques is judged against this asymmetry, not abstract accuracy.

  2. Feed the forecast, not the request for one.

    You are a skeptical capacity-review board member. Attached: 18 months of
    weekly peak utilization, a 6-month forecast produced by [method], and a
    list of known upcoming events.
    
    Do NOT produce your own forecast or adjust the numbers.
    
    Critique this forecast:
    1. Assumptions: what must be true for this projection to hold? List each.
    2. History checks: seasonality, trend breaks, or one-off spikes in the
       history that the method may have mis-learned. Point to specific dates.
    3. Missing drivers: which listed events are not reflectable in the history?
    4. Failure modes: 3 concrete scenarios where reality beats the forecast
       high, 3 where it comes in low, each with an early-warning metric.
    5. Questions a reviewer should ask the author before approving.
    
  3. Answer the critique in writing. For each assumption and question, write the actual answer. Where you cannot answer ("we don't know if the client migration lands in Q3"), that becomes an explicit scenario branch in the forecast, not a silent hope.

  4. Turn failure modes into tripwires. For each credible "reality beats forecast" scenario, define the early-warning metric and threshold (e.g., "if weekly peak grows >6% for 3 consecutive weeks, re-forecast"), and wire it as a real alert. This converts a static forecast into a monitored one.

  5. Stress the story, not just the curve. Ask a follow-up: "Given the decision costs stated, argue the strongest case that we are about to over-provision, then the strongest case for under-provisioning." Read both; the side that makes you uncomfortable is where to spend one more hour of analysis.

  6. Package for review. Have the AI condense into a one-page brief: forecast + method, assumptions register with answers, scenario branches, tripwire alerts. This is what goes to the capacity/budget meeting.

Remember:

If the AI's critique changes the numbers, change them by re-running the statistical model with corrected inputs — never by letting the LLM "adjust" the projection.

Tool variants

  • Chat assistant + CSV/chart upload: default path; attach the series and a chart image — models catch trend breaks well from both.
  • Notebook-integrated assistant: run the critique alongside the Prophet/statsmodels notebook so "re-run with corrected inputs" is one cell away; the assistant can also write the backtest cell (see Verification).
  • Observability-native forecasts (Datadog/CloudWatch): export the projected band and treat the vendor forecast as the artifact under critique — vendor models mis-learn one-off incidents into seasonality too.

Verification

  • Backtest: hold out the last 3 months of history, re-fit, and check the method would have predicted them within your tolerance — an AI critique cannot substitute for this number.
  • Every assumption in the register has a written answer, an owner, or a scenario branch.
  • Tripwire alerts actually exist in the monitoring system, with the thresholds from step 4.
  • The final brief states the decision asymmetry — a reviewer can see why the chosen buffer is sized the way it is.

Pitfalls

  • Sliding into "just give me your best forecast." The moment the LLM outputs projected numbers, you have an unaccountable model with no error bars — delete them and return to the critique frame.
  • Critique theater. A 15-item assumptions list you never answer is worse than none; the written-answers step is the work.
  • One-off spikes learned as seasonality. Incident-driven peaks in history inflate forecasts; the AI is good at flagging these if you tell it the incident dates.
  • Ignoring the asymmetry. Symmetric "accuracy" thinking buys the wrong buffer; under-provisioning a fintech peak and over-provisioning a batch farm are different failures.
  • Forecast rot. A forecast without tripwires is stale the week after the meeting.

Restricted-environment variant

  • Utilization histories from client systems are client telemetry: normalize to indexed values (baseline = 100) before pasting into public tools — the critique works identically on indexed data.
  • Client-safe path: local model via Ollama handles the critique-and-question format well; or use the client's approved enterprise tenancy.
  • For client-facing capacity asks, have the AI additionally draft the client-communication version: assumptions you need the client to confirm, in plain contract-friendly language.
Warning

The most expensive forecasting failure mode is a confident LLM curve with no backtest behind it — this playbook exists so that never reaches a purchase order.

Success criteria

  • A forecast heading into review now carries an assumptions register, scenario branches, and live tripwire alerts.
  • At least one material blind spot (missed driver, mis-learned spike) surfaced per review — if critiques keep coming back empty, your prompts are too soft.
  • The team can articulate the division of labor: models forecast, LLMs critique, humans decide.
  • No capacity or commitment decision in your area is based on LLM-generated numbers.
This is the free reading view. Open BXUP to track your progress, run the hands-on labs, and prove it with original, exam-pattern assessments.
© Anvi Innovate · BXUP — Be Exponentially Upskilled · BXUP is an independent learning platform, not affiliated with or endorsed by AWS, Microsoft, Google, NVIDIA, IBM, Salesforce, Databricks, Oracle or Anthropic. All trademarks belong to their respective owners. · bxup.in