budget-variance-analysis
Analyze budget vs. actual variances, identify root causes, and recommend corrective actions. Use when an accountant or finance professional says "explain this variance", "budget vs. actual analysis", "why did we miss budget", "favorable / unfavorable variance", "price volume variance", "management reporting commentary", "explain the P&L variance to the CFO", "what drove the cost overrun", "revenue shortfall analysis", or needs to write the narrative behind a financial result. Also trigger when someone shares a table of actuals vs. budget and needs to explain the gaps - even if they don't use the word "variance".
qa-aman · 已有静态检查记录
安装与使用
运行命令前先阅读来源与依赖说明。复制命令不会自动安装或执行。
npx skills add qa-aman/claude-skills --skill budget-variance-analysis技能说明
name: budget-variance-analysis description: > Analyze budget vs. actual variances, identify root causes, and recommend corrective actions. Use when an accountant or finance professional says "explain this variance", "budget vs. actual analysis", "why did we miss budget", "favorable / unfavorable variance", "price volume variance", "management reporting commentary", "explain the P&L variance to the CFO", "what drove the cost overrun", "revenue shortfall analysis", or needs to write the narrative behind a financial result. Also trigger when someone shares a table of actuals vs. budget and needs to explain the gaps - even if they don't use the word "variance".
Overview
Based on "Cost Accounting: A Managerial Emphasis" by Horngren, Datar, and Rajan - the standard reference for management accounting and variance analysis. Variance analysis is not about flagging numbers that are off; it is about explaining why they are off in a way that leads to a decision.
Horngren's principle: decompose variances into their components (price, volume, mix, efficiency) before drawing conclusions. A single unfavorable revenue variance could be caused by lower prices, lower volume, or a worse product mix - and each cause has a completely different corrective action.
Workflow
Step 1: Establish the variance summary
Before decomposing, calculate the total variance for each line and flag direction.
VARIANCE SUMMARY - [Period]
Actual Budget Variance % F / U
Revenue $[X] $[X] $[X] [%] [F/U]
Cost of Goods Sold $[X] $[X] $[X] [%] [F/U]
Gross Profit $[X] $[X] $[X] [%] [F/U]
Gross Margin % [%] [%] [%pts] [F/U]
Operating Expenses $[X] $[X] $[X] [%] [F/U]
Operating Income $[X] $[X] $[X] [%] [F/U]
F = Favorable (better than budget). U = Unfavorable (worse than budget). Apply F/U correctly: higher-than-budget revenue is F; higher-than-budget expense is U.
Focus investigation on variances that are:
- More than [materiality threshold] in absolute dollars
- More than 5-10% of the budgeted line
- Unexpected directionally (e.g., revenue up but gross margin down)
Step 2: Decompose revenue variances
Revenue variance has three components: price, volume, and mix.
Price variance - Did we sell at the price we planned?
Revenue Price Variance = (Actual Price - Budget Price) x Actual Volume
Favorable if actual price > budget price
Volume variance - Did we sell the quantity we planned?
Revenue Volume Variance = (Actual Volume - Budget Volume) x Budget Price
Favorable if actual volume > budget volume
Mix variance (multi-product businesses) - Did we sell the right mix of products?
Revenue Mix Variance = (Actual Mix % - Budget Mix %) x Total Actual Volume x (Product Margin - Avg Margin)
Favorable if actual mix skewed toward higher-margin products
After decomposing, write a one-paragraph explanation:
Revenue was [F/U] by $[X] vs. budget.
- Price: [favorable/unfavorable] by $[X] - [explanation: discounting, pricing change, FX, etc.]
- Volume: [favorable/unfavorable] by $[X] - [explanation: market demand, sales execution, etc.]
- Mix: [favorable/unfavorable] by $[X] - [explanation: product mix shift, channel mix, etc.]
Net: $[X] [F/U]
Step 3: Decompose cost variances
For COGS and direct costs, decompose into spending (price) and efficiency (usage) components.
Spending variance (price effect) - Did inputs cost more or less per unit than planned?
Spending Variance = (Actual Rate - Budget Rate) x Actual Quantity
Efficiency variance (usage effect) - Did we use more or fewer inputs per unit of output than planned?
Efficiency Variance = (Actual Quantity - Budget Quantity) x Budget Rate
For labor:
Labor Rate Variance = (Actual Hourly Rate - Budget Hourly Rate) x Actual Hours
Labor Efficiency Variance = (Actual Hours - Budget Hours) x Budget Hourly Rate
For materials:
Material Price Variance = (Actual Unit Cost - Budget Unit Cost) x Actual Quantity
Material Usage Variance = (Actual Quantity - Budget Quantity) x Budget Unit Cost
Step 4: Explain operating expense variances
For fixed and discretionary costs (SG&A, R&D, headcount), the decomposition is simpler:
Expense Variance = Actual Expense - Budget Expense
Explain by category:
- Headcount: [actual HC vs. budget HC] x [avg cost per head]
- Timing: expenses budgeted in this period but shifted (or pulled forward)
- One-time items: [legal, severance, project costs not in budget]
- Inflation / rate: [vendor price increases above budget assumption]
- Volume-driven: [variable costs that moved with revenue]
Step 5: Write the management commentary
Translate the numbers into narrative for leadership:
BUDGET VARIANCE COMMENTARY - [Period]
HEADLINE
[One sentence: net result and whether it was above or below budget, by how much]
REVENUE: [F/U $X vs. budget]
[2-3 sentences: what drove it, broken into price/volume/mix where relevant]
GROSS MARGIN: [F/U $X / [X]pts vs. budget]
[2-3 sentences: COGS drivers - materials, labor, overhead absorption, mix]
OPERATING EXPENSES: [F/U $X vs. budget]
[2-3 sentences: key lines that moved, timing vs. structural, headcount context]
KEY RISKS / OPPORTUNITIES
- [Forward-looking risk or opportunity suggested by the variance analysis]
- [Forward-looking risk or opportunity]
CORRECTIVE ACTIONS (where applicable)
- [Specific action, owner, timeline]
- [Specific action, owner, timeline]
Anti-Patterns
1. Describing variances without decomposing them Bad: "Revenue was $500K unfavorable vs. budget due to lower sales." Good: "Revenue was $500K unfavorable: $200K price (average selling price declined 3% due to competitive discounting), $300K volume (unit sales 8% be
阅读完整来源 ↗