What Is Variance Analysis?
Key Takeaways
- Variance analysis compares actual results with a defined baseline, such as a budget, forecast, prior period, or standard cost.
- Raw variance signs show direction, while favorability depends on account type. Higher revenue is usually favorable, while higher expenses are usually unfavorable.
- Using the absolute baseline in percentage variance calculations preserves direction when accounting systems store expenses or other balances as negative values.
- Price and volume analysis can reconcile a headline revenue variance by separating changes caused by selling price from changes caused by unit volume.
- Materiality keeps variance reviews focused on movements that affect decisions, forecasts, margins, risk, or accountability instead of every small difference.
PwC’s May 2025 Pulse Survey found that 65% of CFOs were adjusting financial forecasts and budgets in response to volatility. For Financial Planning and Analysis teams, this makes actual-versus-plan review part of the forecasting cycle rather than a backward-looking reporting exercise.
A revenue miss caused by timing may reverse next month. A persistent pricing, volume, labor, or supplier-cost variance can point to a structural change requiring a new forecast assumption.
The calculation identifies the gap. Driver analysis determines whether finance should update the outlook, assign an action, or simply monitor the movement.
In this guide, we explore how variance analysis works, how to interpret favorable and unfavorable results, how price and volume effects reconcile to the headline variance, and how materiality, ownership, and commentary connect the monthly review with the next forecast.
The Variance Analysis Formula
The arithmetic is simple, but the sign convention needs to be defined before finance starts interpreting the result. A consistent baseline also matters because a budget variance and a forecast variance answer different questions.
The basic raw variance formula is:
Variance = Actual − Baseline
The baseline might be a budget, forecast, prior-period result, or standard.
For percentage analysis:
Percentage Variance = (Actual − Baseline) ÷ |Baseline| × 100
Using the absolute value of the baseline keeps the denominator consistent when an accounting system stores expense accounts or other values as negative numbers. Percentage variance is not meaningful when the baseline is zero. In that case, report the dollar difference and explain the change directly.
Under the raw Actual − Baseline convention, the sign describes direction rather than favorability:
- Positive revenue variance: Actual revenue above the baseline
- Negative revenue variance: Actual revenue below the baseline
- Positive expense variance: Actual expense above the baseline
- Negative expense variance: Actual expense below the baseline
Finance can then label the result as favorable or unfavorable based on the account and business context.
A budget variance compares actual results with the approved budget, while a forecast variance compares actual performance with the latest financial forecast. A standard-cost variance compares actual cost, rate, or usage with the standard established for the actual output achieved.
Avoid switching baselines inside one calculation. If management needs both budget and forecast comparisons, present them as separate variance columns rather than blending the two benchmarks.
Favorable vs. Unfavorable Variances
A favorable variance represents a result that is better than the chosen baseline, while an unfavorable variance represents a worse result. The account type determines the interpretation.
For revenue, actual performance above plan is normally favorable:
Budgeted revenue = $500,000
Actual revenue = $540,000
Raw variance = $40,000
Status = Favorable
For expenses, actual spending above plan is normally unfavorable:
Budgeted operating expense = $300,000
Actual operating expense = $325,000
Raw variance = $25,000
Status = Unfavorable
This distinction is why a positive dollar variance should never be labeled favorable automatically.
Context can change the interpretation further. Higher labor expense may be unfavorable against the original budget, but reasonable if additional labor supported substantially higher production or revenue. Finance needs the operating driver before assigning accountability.
Flux Analysis
Flux analysis, or fluctuation analysis, is closely related to variance analysis. It focuses on explaining changes between two financial values, often during the accounting close or management-reporting process.
Common comparisons include:
- Current month vs. prior month
- Current quarter vs. prior quarter
- Current year vs. prior year
- Actual vs. budget
- Actual vs. forecast
Flux analysis often presents both the dollar movement and percentage change, then investigates material account movements. Controllers may use it to identify unusual general-ledger activity, late accruals, reclassifications, or balances that need supporting commentary.
Variance analysis can refer broadly to performance against budgets, forecasts, standards, or prior results. Flux analysis usually emphasizes the movement between balances or reporting periods.
Revenue & Cost Variances: Price vs. Volume
A total revenue or cost variance identifies how far performance moved from the plan. Driver decomposition explains what produced the movement.
For a simple revenue model with price and unit volume:
Price Variance = (Actual Price − Budgeted Price) × Actual Volume
Volume Variance = (Actual Volume − Budgeted Volume) × Budgeted Price
These formulas create a bridge from budgeted revenue to actual revenue without double-counting the interaction between price and volume.
For revenue:
- Price variance isolates the effect of selling above or below the planned price
- Volume variance isolates the effect of selling more or fewer units than planned
Similar logic applies to cost analysis. Finance may separate vendor-price changes from quantity used, wage-rate changes from labor hours, or other rate and usage effects.
Businesses with multiple products, customer segments, or channels may also need mix analysis. A higher total sales volume can still reduce margin if the business shifts toward lower-margin products.
Driver-based planning makes these relationships easier to maintain because financial outcomes stay connected to the operational assumptions behind them.
Calculating Variances
Worked examples make the sign convention and driver formulas easier to interpret. All examples below use Actual − Budget or Standard as the raw variance convention and then assign favorable or unfavorable status separately.
1. Revenue variance example
Assume the revenue plan budgeted 10,000 units at $50 per unit. Actual results were 11,000 units at $48.
Budgeted Revenue = 10,000 × $50 = $500,000
Actual Revenue = 11,000 × $48 = $528,000
Total Revenue Variance = $528,000 − $500,000 = $28,000 favorable
The total result does not explain what happened. Separating price and volume does:
Price Variance = ($48 − $50) × 11,000 = −$22,000 unfavorable
Volume Variance = (11,000 − 10,000) × $50 = $50,000 favorable
The two drivers reconcile:
−$22,000 + $50,000 = $28,000 favorable
Higher unit volume more than offsets the lower average selling price.
2. Price variance example
Price variance measures the effect of paying a different price from the standard or budgeted rate for the actual quantity purchased or used.
Price Variance = (Actual Price − Standard Price) × Actual Quantity
Assume:
Standard material price = $10 per unit
Actual material price = $12 per unit
Actual quantity = 100 units
Then:
Price Variance = ($12 − $10) × 100 = $200 unfavorable
The actual input cost was $200 above the standard-price expectation for the quantity used.
3. Quantity variance example
Quantity variance measures whether the actual amount of material used differs from the standard quantity allowed for the actual production output.
Quantity Variance = (Actual Quantity − Standard Quantity Allowed) × Standard Price
Assume:
Standard quantity allowed = 90 units
Actual quantity used = 100 units
Standard price = $10
Then:
Quantity Variance = (100 − 90) × $10 = $100 unfavorable
Production used 10 units more than the standard allowed for the output achieved.
4. Efficiency variance example
Labor efficiency variance compares actual labor hours with the standard hours allowed for the actual production output.
Efficiency Variance = (Actual Hours − Standard Hours Allowed) × Standard Rate
Assume:
Standard hours allowed = 40
Actual hours = 45
Standard labor rate = $20 per hour
Then:
Efficiency Variance = (45 − 40) × $20 = $100 unfavorable
The work required five more labor hours than the standard allowed.
5. Budget vs. actual variance report example
A useful variance report connects the arithmetic with interpretation, ownership, and commentary. The example below keeps the budget as the comparison baseline throughout.
|
Line Item |
Budget |
Actual |
$ Variance |
% Variance |
Favorable/Unfavorable |
Owner |
Commentary |
|
Revenue |
$500,000 |
$528,000 |
$28,000 |
5.6% |
Favorable |
Sales |
Higher unit volume offset the lower average price |
|
Materials |
$120,000 |
$132,000 |
$12,000 |
10.0% |
Unfavorable |
Operations |
Actual input prices exceeded standard cost |
|
Labor |
$85,000 |
$80,000 |
−$5,000 |
−5.9% |
Favorable |
Operations |
Actual labor cost came in below budget |
|
Operating Expense |
$150,000 |
$162,000 |
$12,000 |
8.0% |
Unfavorable |
General and administrative (G&A) |
Spend exceeded the approved operating plan |
Table: A useful budget-vs.-actual report combines the size and direction of each variance with ownership and a concise explanation of the underlying driver.
The commentary should explain the cause. Repeating “revenue was $28,000 above budget” adds little because the table already contains that information.
The Variance Analysis Cycle & Materiality
Variance analysis becomes useful when it leads from calculation to explanation and action. A recurring review process prevents teams from producing lengthy reports that identify differences without resolving what they mean.
A disciplined cycle typically covers:
- Calculate the variance against the correct baseline
- Apply the agreed materiality criteria
- Identify the underlying driver
- Separate timing effects from structural changes
- Assign an accountable business owner
- Document concise commentary
- Decide whether an action or forecast change is required
- Review the outcome in the next cycle
Materiality can be based on dollar value, percentage movement, margin impact, forecast impact, regulatory exposure, or management importance. There is no universal percentage threshold that works for every organization.
A 2% variance on a large payroll line may deserve immediate review. A 25% variance on a small miscellaneous account may have little effect on management's decisions.
The choice of budget also affects interpretation. A static budget keeps the original target unchanged. Flexible budgeting adjusts expected revenue or costs for the actual activity level, helping finance separate basic volume effects from price, rate, efficiency, mix, and other execution differences.
Variance commentary should answer four questions:
- What changed
- Why it changed
- Who owns the response
- Whether the latest forecast should change
That gives management information it can act on rather than another reconciliation schedule.
Types of Variances
Variance analysis can be applied to revenue, expenses, margins, headcount, cash, and operational metrics. Standard-cost environments add a more formal set of material, labor, and overhead variances.
1. Material variance
Material variance measures differences in the price and usage of raw materials or other production inputs.
The two common components are:
- Material price variance: Difference between actual and standard material prices for the actual quantity
- Material usage variance: Difference between actual material usage and the standard quantity allowed for actual output, valued at the standard price
Material price differences can come from supplier pricing, contract terms, freight, purchase timing, scarcity, or input quality.
Usage differences can point to scrap, yield, rework, quality problems, production methods, or an outdated standard.
2. Labor variance
Labor variance separates changes in labor cost into rate and efficiency effects.
The two common components are:
- Labor rate variance: Difference between actual and standard labor rates for the actual hours worked
- Labor efficiency variance: Difference between actual hours and standard hours allowed for actual output, valued at the standard rate
Rate variances can reflect overtime, staffing mix, contractor use, wage changes, or different skill levels.
Efficiency variances can reflect training, scheduling, equipment availability, process design, rework, or production conditions.
3. Overhead variance
Overhead variance analyzes differences in indirect production costs. The calculations depend on whether the cost is variable or fixed and on the allocation base used in the standard-cost system.
Typical categories include:
- Variable overhead spending variance: Difference caused by the actual overhead rate
- Variable overhead efficiency variance: Difference caused by the activity base used compared with the standard allowed
- Fixed overhead budget variance: Difference between actual fixed overhead and budgeted fixed overhead
- Fixed overhead volume variance: Difference associated with production volume and capacity utilization
Overhead analysis needs operational context because several cost categories can move in opposite directions within the same total.
Variance Analysis in Standard Costing
Standard costing establishes expected prices, quantities, labor rates, labor hours, and overhead rates before actual production occurs. Variance analysis then separates the gap between standard and actual cost into components that operations and finance can investigate.
The main standard-cost variances include:
- Material price and usage variances
- Labor rate and efficiency variances
- Variable overhead spending and efficiency variances
- Fixed overhead budget and volume variances
At the total-cost level:
Total Cost Variance = Actual Cost − Standard Cost Allowed for Actual Output
Under this raw sign convention:
- Positive cost variance: Actual cost above standard, normally unfavorable
- Negative cost variance: Actual cost below standard, normally favorable
Comparing actual material or labor cost with the standard for the originally budgeted production volume can mix a volume difference with a price or efficiency difference.
Standards also need maintenance. Supplier prices, wage rates, production methods, product mix, and process efficiency can change enough to make an old standard a poor performance benchmark.
Standard costing is therefore most useful where production relationships are stable enough for the standard to remain meaningful.
Variance Analysis in Different Industries
The baseline and analytical logic stay consistent across industries, but the operating drivers behind the variance change. Finance should decompose the result using measures that reflect how each business actually earns revenue and incurs costs.
1. Manufacturing
Manufacturing variance analysis often focuses on:
- Material price and usage
- Labor rate and efficiency
- Variable and fixed overhead
- Production volume
- Yield and scrap
- Capacity utilization
- Product mix and margin
A material-cost overrun, for example, could come from a supplier-price increase, excessive usage, higher freight, poor-quality inputs, or a combination of several drivers.
2. Services
Service businesses usually have fewer physical-input variances and more labor, utilization, project, and margin drivers.
Common areas include:
- Billable hours
- Utilization
- Staffing mix
- Billing rates
- Project scope
- Contractor use
- Delivery hours
- Gross margin
A project can exceed its labor budget because rates increased, more hours were needed, or the staffing mix shifted toward senior employees. Each cause requires a different response.
3. Multi-department FP&A
Corporate FP&A teams use variance analysis across departments, cost centers, business units, entities, and other management dimensions.
A monthly review may compare:
- Revenue vs. budget and forecast
- Operating expenses by department
- Headcount and compensation
- Gross margin
- Capital spending
- Key operational drivers
These findings often feed the next forecasting cycle. A persistent variance may indicate that the latest expected outcome has changed, while a timing variance may reverse without requiring a full-year forecast adjustment.
Challenges in Variance Analysis
Variance analysis can produce mathematically correct results and still lead management to the wrong conclusion. Most problems come from weak baselines, poor data, timing differences, or incomplete driver analysis.
Common problems include:
- Incomplete actuals or late accounting entries
- Inconsistent account mappings between budget and actual data
- Budget structures that no longer match the operating model
- Reclassifications mistaken for operating changes
- Timing differences treated as permanent performance gaps
- Several underlying drivers combined into one total variance
- Outdated standard costs
- Materiality thresholds that generate too much or too little investigation
- Commentary that describes the number without explaining the cause
Revenue is particularly easy to oversimplify. Price, volume, timing, product mix, customer mix, churn, foreign exchange, and billing cutoffs can all affect the same line.
The same problem appears in expenses. A cost overrun may reflect a vendor-rate change, higher business activity, an accrual, a planned purchase that shifted between periods, or true overspending.
Where the outlook is uncertain, scenario planning can help finance distinguish the reported variance from the range of outcomes management still needs to prepare for.
Improving Variance Analysis Procedures
Better variance analysis comes from a controlled process rather than more commentary. Finance should standardize the baseline, calculation rules, ownership, review cadence, and level of explanation required for a material variance.
Useful practices include:
- Run variance reviews on a defined monthly or quarterly cadence
- Keep budget, forecast, prior-period, and standard-cost comparisons clearly separated
- Review material favorable and unfavorable variances
- Document the sign convention used in every recurring report
- Apply driver-level analysis to material revenue, cost, labor, and margin lines
- Assign each material variance to an accountable business owner
- Separate timing effects from structural changes
- Document the cause, financial impact, action, and forecast implication
- Follow up on agreed actions in the next operating review
Consistency matters more than producing a long explanation for every account. Management should be able to see which deviations matter, why they occurred, and what is changing as a result.
Visuals can make patterns easier to scan, but dashboards cannot replace root-cause analysis. A chart identifies where to look. The commentary still needs to explain the driver.
How Limelight Supports Variance Analysis
Variance analysis becomes harder to maintain when actuals, budgets, forecasts, and commentary sit in separate spreadsheets. Limelight FP&A software keeps planning and reporting in a shared finance-owned environment so teams can compare results without rebuilding the same report every cycle.
Limelight's integrations connect financial and operational source systems with the FP&A environment. Once actuals are available, its reporting capabilities support actual-vs.-budget, actual-vs.-forecast, prior-period comparisons, variance analysis, and drill-through to transaction-level detail.
Finance teams can also attach comments and variance explanations to reports, which keeps the business context beside the number instead of distributing it through separate email threads.
When a material variance changes the expected outlook, Limelight's planning and forecasting capabilities let finance update drivers and assumptions and see the effect flow through forecasts, reports, dashboards, and variance views.
That creates a connected review cycle: actuals identify the difference, drill-down helps finance investigate it, commentary records the explanation, and updated assumptions carry the new information into the forecast.
Video placement: Keep the existing Limelight VideoObject in this product section in WordPress and update all page URL references to the corrected canonical slug.
See Limelight in action. Book a demo.
Frequently Asked Questions
The questions below address common interpretation issues that can cause otherwise correct variance reports to be read incorrectly.
What is variance analysis?
Variance analysis compares actual business results with a defined baseline, such as a budget, forecast, prior period, or standard. Finance teams use the difference to identify material performance changes, investigate the underlying drivers, and decide whether management action or a forecast update is required.
What is the variance analysis formula?
The basic raw formula is:
Variance = Actual − Baseline
For a nonzero baseline:
Percentage Variance = (Actual − Baseline) ÷ |Baseline| × 100
Favorability should then be determined from the account type and business context rather than the arithmetic sign alone.
What is the difference between a favorable and unfavorable variance?
A favorable variance represents performance better than the comparison baseline. An unfavorable variance represents worse performance. Higher revenue than budget is usually favorable, while higher expense than budget is usually unfavorable.
Is flux analysis the same as variance analysis?
Flux analysis is a type of variance analysis, but the terms are not completely interchangeable. Flux analysis usually focuses on explaining movement between periods or account balances, while variance analysis can also compare actual results with budgets, forecasts, or standards.
Is variance analysis the same as statistical variance?
No. Financial variance analysis explains the difference between business performance and a comparison baseline. Statistical variance measures dispersion within a set of numerical observations.
What is a budget vs. actual variance report?
A budget-vs.-actual report places actual performance beside the approved budget and calculates the dollar and percentage differences. A useful report also identifies favorable or unfavorable status, ownership, and commentary for material variances.
Table of Contents
Ready to put an end to outdated FP&A?
Get a personalized demo