At a glance
- Compares actual figures systematically against plan, budget, or prior-year data, and quantifies differences by cause, direction, and amount.
- Aims to uncover the underlying causes, such as volume, price, mix, or structural effects.
- Analyzed variances enable targeted corrective action.
What question do you have about variance analyses?
Your input is sent to an AI service to answer it and is stored to improve the answers. Please do not enter any personal data. Privacy policy
Variance analysis: definition and classification
Variance analysis examines the difference between a reference value – such as a plan, budget, prior-year figure, or forecast – and the value actually achieved (actual). It answers a fundamental question in controlling: Why did the result turn out differently than expected?
Companies plan on the basis of assumptions: expected sales volumes, prices, costs, exchange rates, or market developments. In practice, actual figures routinely deviate from those assumptions. Variance analysis makes these differences visible, quantifies them, and clarifies their causes – transforming a simple numerical comparison into genuine management information.
Variance analysis is closely related to the plan-actual comparison, but goes significantly further. While a plan-actual comparison merely shows that a difference exists, variance analysis explains how that difference came about and which factors contributed to it – and to what degree.
„With DeltaMaster's graphical tables, we spot variances between plan and actual immediately and no longer have to search through long columns of figures. Breaking down causes into price, volume, and mix effects has noticeably accelerated our monthly reporting.“Head of Controlling
Industrial company
What are the different types of variances?
In practice, variances can be classified along several dimensions:
By direction
- Favorable variance: The actual value exceeds the planned value – for example, higher revenue or lower costs than budgeted.
- Adverse variance: The actual value falls short of the planned value – for example, lower margins or higher overhead than planned.
By cause
- Price variance: Actual prices (for purchasing or sales) deviated from the plan.
- Volume variance: More or fewer units were produced, sold, or consumed than planned.
- Mix variance: The composition of the sales or product portfolio shifted relative to the plan, affecting contribution margins or overall profitability.
- Structural variance: Changes in organizational structure, production methods, or distribution channels affected the outcome.
- Exchange rate variance: For internationally active companies, currency fluctuations affect reported results.
- Efficiency variance: Deviations in productivity or resource utilization compared to planned assumptions.
By controllability
- Controllable variances that can be influenced by management decisions.
- Non-controllable variances attributable to external factors such as economic conditions, commodity prices, or regulatory changes.
This distinction is essential for meaningful performance assessment and for deriving appropriate responses.
Trusted by market leaders and hidden champions





What are the different methods of variance analysis?
The most important methods of variance analysis are as follows:
- Simple plan-actual comparison: The most straightforward approach: planned value minus actual value yields the absolute variance. Adding the percentage deviation provides an initial picture. This is often sufficient for operational steering purposes, but insufficient for deeper analytical work.
- Variance decomposition: Complex variances are broken down into their component parts. A revenue shortfall, for example, may consist of a price decline, a volume decline, and a mix shift – each with a different sign and magnitude. Decomposition makes these effects individually visible and quantifiable.
- Bridge analysis (waterfall analysis): Like variance decomposition, bridge analysis breaks a total variance into smaller segments. It shows step by step how one moves from the planned value to the actual value, with each influencing factor represented as a separate bar that accounts for part of the overall effect.
- Commentary and narrative: A variance analysis is only complete when deviations are accompanied by causes and proposed actions. Good controlling does not end with “revenue was below plan.” It ends with: “The revenue shortfall of €2.3 million is attributable 60% to price erosion in Segment B and 40% to the loss of a key account. Countermeasures X and Y have been initiated.”
How to conduct a variance analysis – A step-by-step example
The following example illustrates the process using a revenue analysis in monthly reporting.
Step 1: define the reference base
Before any analysis begins, the question must be answered: What are we comparing against? Possible reference values include plan/budget, prior-year figures, or the current forecast. The choice determines the analytical direction: a budget comparison assesses goal attainment; a prior-year comparison reveals business development; a forecast comparison measures forecast accuracy. In practice, several reference values are often used in parallel.
Example: A company generates revenue of €9.2 million in October. The planned value was €10.0 million; the prior-year figure was €8.8 million.
Step 2: calculate the variance
| Metric | Value |
|---|---|
| Plan | €10.0 million |
| Actual | €9.2 million |
| Absolute variance | –€0.8 million |
| Relative variance | –8.0% |
| vs. Prior year | +€0.4 million (+4.5%) |
Compared to the prior year, the result is positive: the company is growing. Yet it has missed its own target. Both perspectives tell a different story – and both matter.
Step 3: analyze the causes
This is where the actual analysis begins. The total variance of –€0.8 million is broken down into its drivers:
- Price effect: Selling prices were 3% below plan due to increased competitive pressure → –€0.5 million
- Volume effect: Slight shortfall caused by a delayed large order → –€0.2 million
- Mix effect: Disproportionately high sales of higher-margin products partially offset the decline → +€0.1 million
The conclusion is clear: the problem lies in pricing, not in volume. Countermeasures must be directed accordingly.
Step 4: assess materiality
Not every variance requires immediate action. Controlling assesses whether a deviation is material in absolute terms, affects a core business area or critical cost position, and represents a one-time effect or a sustained trend. In this example, the price effect is relevant on all three dimensions – it requires substantive commentary and a clear management response.
Step 5: comment and define actions
The analysis does not end with a number. It ends with a statement:
“October revenue of €9.2 million was €0.8 million (–8%) below plan. The primary driver is a price decline in Segment B resulting from intensified competition; the volume shortfall reflects a large order deferred to November. Pricing stabilization measures have been initiated; the deferred order is confirmed for calendar week 46.”
This commentary names the variance, explains its causes, weights the effects, and closes with a concrete outlook. That is precisely what distinguishes professional controlling from mere number reporting.
What are the common mistakes in variance analysis?
Despite its central importance, variance analysis is frequently not applied with sufficient rigor in practice. Typical weaknesses include:
Application examples: where is variance analysis used?
Variance analysis accompanies nearly every management process in a company. The following examples show typical fields of application in various areas and industries.
Where would you like to use variance analyses?
Your input is sent to an AI service to answer it and is stored to improve the answers. Please do not enter any personal data. Privacy policy
Variance analysis with Bissantz
With DeltaMaster, Bissantz’s decision intelligence platform, variances can be calculated automatically, their causes traced through to semantic context, and corrective actions derived immediately – with AI support and full transparency.
At the heart of this approach is the principle of graphical tables: variances are not merely reported as numbers, but made immediately visible through integrated micro-charts embedded directly within the table – for example, sparklines and typographically scaled figures. The eye detects patterns and outliers in seconds, where a conventional table would require minutes of interpretation.
In DeltaMaster, variance analysis is not an end in itself. It is the starting point for precise, fast, and AI-assisted decisions.
| Function | Benefit |
|---|---|
| Automatic variance calculation | Differences between plan and actual are determined without manual effort |
| Graphical tables | Variances are made visually apparent directly in the table |
| Micro charts and sparklines | Patterns and outliers are recognizable in seconds |
| Root cause analysis in semantic context | Drivers of variances can be traced and measures derived |
„We can trace variances all the way into their respective context and derive measures directly from them. This turns the plan-actual comparison into a genuine basis for decision-making for our management.“BI Manager
Retail company
Frequently asked questions
What is variance analysis?
Variance analysis is a controlling method that systematically compares actual results with planned, budgeted, or forecasted values, and identifies the causes.
What is the difference between variance analysis and a plan-actual comparison?
A plan-actual comparison shows that a difference exists. Variance analysis explains why it exists – by decomposing the deviation into its contributing factors.
What methods are used in variance analysis?
Common methods include the simple plan-actual comparison, variance decomposition, bridge (waterfall) analysis, and structured commentary with defined corrective actions.
How does variance analysis support management?
It transforms raw data into management information: by revealing which factors are driving results, it enables informed decisions and targeted interventions.
How does DeltaMaster support variance analysis?
DeltaMaster calculates variances automatically, visualizes them clearly, and supports AI-assisted commentary – enabling faster and more reliable analyses.
Summary
Variance analysis is one of the most important methods in controlling: it transforms the gap between plan and actual into actionable management information. By systematically decomposing deviations into their causes – price, volume, mix, structure – it enables targeted and well-founded decisions. With DeltaMaster, Bissantz makes this process faster, more transparent, and AI-assisted: variances are visualized directly in graphical tables, their causes are traceable, and corrective actions can be derived immediately.
Related topics
Turn reports into clear signals
The data analysis tool by Bissantz turns reports and key figures into clear signals. It allows users to make faster, data‑driven decisions across the entire company.
Data analysis tool for clear insights