Overview
It systematically analyzes the difference between Budget and Actual to provide insights needed for management decision-making. It decomposes revenue variance, cost variance, and profit variance by item, identifies the causes of the difference (price, quantity, efficiency, exchange rate, etc.), and derives improvement recommendations.
Disclaimer: This skill is an AI-assisted analysis and does not replace professional advice from a certified public accountant.
Trigger Keywords
Variance analysis, budget versus actual, performance variance, cost analysis, financial KPI, profitability analysis, cost reduction, budget-actual analysis, budget overrun, revenue shortfall
Workflow
Step 1: Collect analysis data
Request the following data from the user:
- Analysis period (monthly/quarterly/semiannual/annual)
- Budget vs Actual figures by item
- Prior period performance (for trend analysis)
- Whether to break down by division/product/region
Step 2: Overall variance summary
Total variance = Actual - Budget
- Favorable variance (Favorable, F): Revenue exceeds budget, costs fall short of budget
- Unfavorable variance (Unfavorable, U): Revenue falls short of budget, costs exceed budget
분산 분석 요약표 (예시)
| 항목 | 예산 | 실적 | 분산 | 분산율 | 판정 |
|------|------|------|------|--------|------|
| 매출액 | 100억 | 95억 | -5억 | -5.0% | U |
| 매출원가 | 60억 | 58억 | -2억 | -3.3% | F |
| 매출총이익 | 40억 | 37억 | -3억 | -7.5% | U |
| 판관비 | 20억 | 22억 | +2억 | +10.0% | U |
| 영업이익 | 20억 | 15억 | -5억 | -25.0% | U |
Step 3: Revenue Variance decomposition
Revenue variance = Price variance + Volume variance
-
Price Variance = (Actual unit price - Budget unit price) × Actual sales volume
- Causes: Changes in discount policy, competitive pressure, changes in product mix
-
Volume Variance = (Actual sales volume - Budget sales volume) × Budget unit price
- Causes: Changes in market demand, sales capability, marketing effectiveness
Special factor check:
- Impact of minimum wage increase (2026: 10,320 KRW/hour)
- Impact of exchange rate fluctuations (if there is export exposure)
- Seasonal factors (holiday effects such as Chuseok and Seollal)
Step 4: Cost Variance decomposition
Labor cost variance = Wage rate variance + Efficiency variance
- Wage rate variance = (Actual wage rate - Budget wage rate) × Actual labor hours
- 2026 note: Check whether the 0.5%p increase in the National Pension is reflected in the budget
- Efficiency variance = (Actual labor hours - Budget labor hours) × Budget wage rate
Check variance in the four major insurance costs (2026 changes):
| Item | 2025 employer burden | 2026 employer burden | Change |
|---|---|---|---|
| National Pension | 4.5% | 4.75% | +0.25%p |
| National Health Insurance | 3.545% | 3.595% | +0.05%p |
| Long-term care | 12.81% of health insurance premiums | 12.95% of health insurance premiums | +0.14%p |
Manufacturing cost variance:
- Material cost variance: material price variance + material usage variance
- Manufacturing overhead variance: separate analysis of fixed and variable costs versus budget
Step 5: KPI tracking and benchmarking
Financial KPI dashboard:
| KPI | Budget | Actual | Prior period | Industry average |
|---|---|---|---|---|
| Gross profit margin | ||||
| Operating profit margin | ||||
| EBITDA margin | ||||
| Labor cost ratio | ||||
| SG&A expense ratio |
Reference operating profit margin by industry (as of 2025):
- IT services: 10-20%
- Manufacturing average: 5-8%
- Distribution: 2-5%
- Services: 8-15%
- Startups (growth stage): negative to 5%
Step 6: Generate variance analysis report
# [기간] 예산 대비 실적 분산 분석 보고서
## 경영진 요약
- 영업이익 분산: xxx원 (예산 대비 xx% 미달/초과)
- 핵심 원인 Top 3
## 항목별 분산 상세
## 원인 분석 및 책임 부서별 액션
## 수정 전망 (Rolling Forecast)
- 연간 예상 영업이익: xxx원
## 개선 권고안
Usage examples
Example 1: "Analyze March actuals versus budget" → Enter budget and actual data → Calculate variance → Analyze causes → Recommend improvements
Example 2: "Revenue fell short by 5%, analyze the cause" → Price and quantity variance → Identify causes → Response measures
Example 3: "Costs exceeded by 10%. Where is the problem?" → Variance by cost item → Labor, material, SG&A → Identify causes → Cost reduction measures
Deliverables
- Variance analysis summary table (including favorable/unfavorable determination)
- Detailed variance analysis by revenue, cost, and profit item
- KPI tracking dashboard
- Cause analysis and improvement recommendations
- Rolling Forecast
Precautions
Disclaimer: This is AI-assisted analysis and does not replace professional advice from a certified public accountant.
Principles for using variance analysis
- Materiality principle: In-depth analysis only for variances of 5% or more versus budget or above an absolute amount threshold
- Cause decomposition: Decompose "why the difference occurred" into at least two levels
- Responsibility attribution: Distinguish controllability of variances (internal factors vs external factors)
- Leading indicators: Analyze revenue variances in connection with pipeline and order data
- Action-oriented: Connect variance reporting to future improvement actions, not just explanations of the past
Problem solving
- Unable to confirm tax rate changes: If labor cost variances versus budget arise from changes in the four major insurance rates or minimum wage, separately check the latest 2026 rates. This skill uses rates as of 2026.
- Prior data not provided: Trend analysis is impossible without prior-period actuals. Providing at least two quarters of budget and actual data enables more accurate analysis.
- Need to segment data by business unit: If only company-wide consolidated data is available, segmentation by business unit, product, and channel is difficult. If you have P&L data by department, please provide it as well.
- Non-recurring item handling: Analyze one-time costs (restructuring, asset disposals, etc.) separately from recurring variance drivers.
Related skills
- moai-finance:financial-statements: Preparation of K-IFRS financial statements
- moai-finance:close-management: Month-end and payroll closing tasks
- moai-finance:tax-helper: Tax filing, HomeTax guidance
Post-processing chain (narrative deliverables such as variance analysis reports, executive summaries, improvement recommendations, etc.)
After producing sentence-based deliverables such as executive summaries, cause analysis comments, improvement recommendations, and revised forecast explanatory statements, finish with the chain below.
variance-analysis (보고서 서술 부분) → moai-core:ai-slop-reviewer → moai-content:humanize-korean
- moai-core:ai-slop-reviewer: Review and revise AI-sounding expressions, exaggeration, and clichés
- moai-content:humanize-korean: Korean naturalness correction (limited to narrative deliverables)
Table and numeric deliverables such as variance analysis summary tables and KPI dashboards are not subject to the chain themselves; if Excel conversion is needed,
moai-office:xlsx-creator, and if visualization is needed,moai-data:data-visualizerroute to. The chain applies only to explanatory, recommendation, and summary sentences surrounding tables.
When not to use this skill
- Official financial statement preparation: For preparation of financial statements under K-IFRS, use the
moai-finance:financial-statementsskill. - Month-end closing and payroll settlement: For accounting closing tasks, the
moai-finance:close-managementskill is more appropriate. - Tax calculation: For tax-related inquiries, use the
moai-finance:tax-helperskill. - Investment feasibility analysis: Investment decision analysis such as IRR and NPV requires separate financial modeling.