Variance Analysis Diagnostic Framework
Diagnose budget variances with hierarchical decomposition and waterfall analysis
What You Can Do
You can decompose total variances into price, volume, mix, and timing components, then trace each component to specific business decisions or external factors. This skill prioritizes investigation by materiality and controllability, enabling you to build formal variance explanations for monthly/quarterly close cycles, reconcile contradictory narratives from business units, and create executive-ready waterfall bridges from forecast to actual P&L—transforming variance analysis from a time-consuming gathering exercise into a structured diagnostic process.
Features
breaks total variances into price, volume, mix, and timing drivers for precise root-cause isolation
creates visual bridges connecting forecasts to actuals with quantified intermediate steps
focuses investigation on variances exceeding thresholds (>2% or defined absolute amounts)
compares budget vs. forecast vs. actual to isolate organic vs. structural performance changes
distinguishes between variances driven by business decisions versus external factors for accountability
handles variances caused by multiple simultaneous business drivers with clear allocation logic
generates audit-ready variance explanations suitable for regulatory and stakeholder review
systematically walks through P&L line items to reconcile competing explanations from different business units
Example Output
Example 1: Revenue Variance Diagnosis
Total Q3 Revenue Variance: -$2.1M (actual vs. budget)
- Price Impact: -$1.2M (5% ASP reduction due to competitive pricing pressure)
- Volume Impact: +$0.4M (8% unit volume increase from new customer acquisition)
- Mix Impact: -$1.3M (shift toward lower-margin product lines)
- Timing Impact: +$0M (timing aligned with forecast)
Conclusion: Variance is 60% attributable to unfavorable product mix and 40% to price erosion. Volume growth partially offset but insufficient.
Example 2: Operating Expense Waterfall
Budget: $5.0M → +$0.2M (headcount) → -$0.1M (efficiency) → +$0.3M (contractors) → Actual: $5.4M
Driven by: Accelerated hiring (controllable) + unexpected consulting spend (external project requirement).
Example 3: Scenario Reconciliation
Budget assumed 12% market growth; actual market grew 8%. Organic performance: +3% vs. budget +4% (controllable underperformance: -1 point).
What's Included
- SKILL.md instruction file with diagnostic framework and decision logic:
- Variance Decomposition Template: structured worksheet for price/volume/mix/timing isolation
- Waterfall Analysis Workbook: step-by-step bridge model from forecast to actual with formula logic
- Materiality Threshold Checklist: guidelines for determining investigation scope by variance type and business unit
- Scenario Reconciliation Matrix: framework for comparing budget vs. forecast vs. actual across multiple dimensions
- Root Cause Assessment Framework: decision tree for distinguishing controllable vs. external drivers
Who It's For
- Financial Analysts (FP&A) — conducting monthly/quarterly close variance analysis and building recurring diagnostic templates
- Controllers and Finance Managers — reconciling business unit variance explanations and preparing executive summaries
- Budget Owners — explaining variances to leadership and identifying operational improvement areas
- Internal Auditors — documenting variance investigations for regulatory review and audit trails
- CFO/Finance Leadership — validating variance narratives and assessing forecast accuracy trends
Best For
- Monthly and quarterly close variance investigations (>2% thresholds)
- Waterfall bridges connecting budgets, forecasts, and actuals for executive reporting
- Multi-driver variance attribution when multiple factors contributed to a single line variance
- Reconciling contradictory variance explanations from different business units
- Building audit-ready variance documentation for regulatory or internal audit review
- Isolating organic performance changes from structural or timing-related variances
- Materiality-based triage of variances requiring formal investigation vs. standard tracking
You might also like
You systematically evaluate bank proposals against standardized criteria, uncovering pricing structures and covenant terms that impact your treasury strategy. The framework helps you compare commitment fees, arrangement fees, and facility structures across multiple term sheets, then generates data-backed talking points for renegotiating existing arrangements and consolidating redundant banking relationships.
by fastclaw-ai
You'll build comprehensive DCF models that automate explicit forecast periods, terminal value calculations, and weighted average cost of capital derivation. The skill produces audit-ready assumption documentation, multi-scenario sensitivity tables, and valuation ranges across bear/base/bull cases—all formatted for board presentations and fairness opinions. You'll stress-test equity value assumptions and compare DCF outputs to trading multiples and M&A precedent data.
by fastclaw-ai
You can conduct multi-scenario covenant stress testing to quantify financial headroom between current metrics and covenant thresholds, identify which covenants are most vulnerable to market downturns, and calculate the cost-benefit of proactive amendments versus reactive refinancing. This enables you to report covenant health to leadership with actionable mitigation strategies before breach risk materializes.
by fastclaw-ai
You can build 12-month rolling forecast models that automatically drop the oldest completed month and add a new forward month as actuals close each period. The skill calculates budget variances (favorable/unfavorable) with root cause drivers, reforecasts remaining quarters based on current spending patterns and run-rate assumptions, and generates executive dashboards highlighting key budget risks and opportunities before they become serious overruns.
by fastclaw-ai
You can generate a focused, investor-ready one-page startup plan that captures your business model, target market, revenue streams, and competitive advantage. Claude asks clarifying questions about your idea, validates key assumptions, and produces a structured document you can use for pitches, investor meetings, or internal alignment.
by fastclaw-ai
Create a structured one-page business model that captures your core value proposition, revenue model, and key partnerships. You will define your riskiest assumptions, design an MVP with prioritized features, and build a customer discovery roadmap with interview templates and validation experiments. This approach helps you move from theory to validated learning before investing significant resources.
by fastclaw-ai
This skill converts unstructured cash position data—bank balances, payables, receivables, and scheduled transactions—into structured liquidity analysis with clear decision frameworks. You'll identify liquidity gaps before they create operational friction, distinguish between structural and transactional funding needs, and receive specific recommendations for cash movements, investment opportunities, and contingency planning across multiple currencies and operational time zones.
by fastclaw-ai
You'll construct defensible, driver-based revenue forecasts that link operational metrics (customer count, contract value, churn, win rates) directly to revenue outcomes. Claude helps you build base, upside, and downside scenarios with transparent assumptions, perform sensitivity analysis to quantify business variable impacts, and automatically document variance explanations—enabling you to respond confidently to CFO and board-level scrutiny.
by fastclaw-ai