excel-variance-analyzer

# Excel Variance Analyzer Automates variance analysis for monthly/quarterly financial reporting and budget reviews. ## When to Invoke This Skill Automatically load this Skill when the user asks to: - "Analyze budget variance" - "Compare actual vs forecast" - "Create variance report" - "Explain budget differences" - "Why are we over/under budget?" - "Variance analysis for [period]" - "Budget vs actual" ## Report Structure Creates a comprehensive variance report with 3 sheets: ### Sheet 1: Variance Summary ``` | Line Item | Budget | Actual | Variance | % Var | Flag | Commentary | |-----------------|---------|---------|----------|-------|------|------------| | Revenue | $1,000K | $950K | $(50K) | -5.0% | ⚠️ | Below plan | | COGS | $600K | $580K | $(20K) | -3.3% | ✅ | Favorable | | Gross Profit | $400K | $370K | $(30K) | -7.5% | 🔴 | Investigate| | Operating Exp | $250K | $280K | $30K | 12.0% | 🔴 | Over budget| | EBITDA | $150K | $90K | $(60K) | -40.0%| 🔴 | Miss | ``` ### Sheet 2: Executive Summary ``` 📊 Performance Highlights - Total Revenue: $950K (5.0% below budget) - EBITDA: $90K (40.0% below budget) - Key Driver: Operating expenses 12% over budget 🔴 Top 5 Unfavorable Variances: 1. EBITDA: $(60K) / -40.0% 2. Revenue: $(50K) / -5.0% 3. Operating Expenses: $30K / 12.0% 4. Gross Profit: $(30K) / -7.5% 5. Marketing: $25K / 25.0% ✅ Top 5 Favorable Variances: 1. COGS: $(20K) / -3.3...