SuperAPI AI Directory

variance-analysis

General & other

View repository

Updated 10-15 22:09

About this skill

Variance Analysis

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

  1. Materiality principle: In-depth analysis only for variances of 5% or more versus budget or above an absolute amount threshold
  2. Cause decomposition: Decompose "why the difference occurred" into at least two levels
  3. Responsibility attribution: Distinguish controllability of variances (internal factors vs external factors)
  4. Leading indicators: Analyze revenue variances in connection with pipeline and order data
  5. 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-statements skill.
  • Month-end closing and payroll settlement: For accounting closing tasks, the moai-finance:close-management skill is more appropriate.
  • Tax calculation: For tax-related inquiries, use the moai-finance:tax-helper skill.
  • Investment feasibility analysis: Investment decision analysis such as IRR and NPV requires separate financial modeling.