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 can rapidly generate first-draft deal execution documents—LOIs, purchase agreements, and closing checklists—while Claude maintains consistency across all exhibits, schedules, and legal definitions. The skill cross-references conditions and dependencies across documents, flags gaps or circular logic before legal review, and tracks completion status against your deal timeline to surface execution risk early.
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 construct earnings narratives that translate complex financial results into compelling business stories while maintaining strict SEC compliance. This skill helps you connect quarterly performance to long-term strategy, highlight operational drivers, address headwinds with transparency, and align messaging across press releases, earnings call scripts, and investor Q&A prep—preventing reactive defensiveness and enabling confident proactive storytelling.
by fastclaw-ai
Get structured, comprehensive analysis of any franchise opportunity covering financials, legal risks, operational requirements, and market viability. You receive a detailed evaluation report with scoring matrices, profitability projections, and a clear yes/no recommendation based on your investment criteria and risk tolerance.
by fastclaw-ai
You can generate detailed integration playbooks that map functional workstreams, synergy realization timelines, and critical dependencies across acquired and acquiring organizations. The skill creates role-specific integration blueprints that identify quick wins versus foundational changes, establish governance structures, and define integration KPIs—transforming deal strategy into an operational execution roadmap for your integration management office.
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
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