Variance Analysis Calculator
Split the gap from standard into price, quantity, rate and efficiency variances.
What this calculator does
Each variance computed on its own basis and reported separately; a positive figure costs more than standard and is labelled unfavourable. Standards are the organisation's own, never a benchmark or a target.
Inputs and what they mean
- Currency
- — Amounts are shown in the currency you pick. No exchange rate is applied..
- Actual material quantity used
- — number value.
- Actual price per material unit
- — number value.
- Standard quantity allowed for the output
- — number value.
- Standard price per material unit
- — number value.
- Actual labour hours
- — number value.
- Actual labour rate per hour
- — number value.
- Standard hours allowed for the output
- — number value.
- Standard labour rate per hour
- — number value.
How to use it
- Enter your own figures — the calculator never fills in a rate, price or benchmark for you.
- Press Calculate to see the result.
- Read the formula, variables, assumptions and source below the result before you rely on it.
Formula
Price variance = (Actual price − Standard price) × Actual quantity; Quantity variance = (Actual quantity − Standard quantity) × Standard price; Rate variance = (Actual rate − Standard rate) × Actual hours; Efficiency variance = (Actual hours − Standard hours) × Standard rate
Worked example
Material and labour variances for a period
Each variance is shown separately, against your own standards — not against a benchmark or a target.
Reading the result
The headline figure is the main answer. Any breakdown underneath shows the parts that make it up, so you can check the working and see what changes when you adjust an input.
Limitations and assumptions
Results depend entirely on the figures you enter and are rounded for display. They are for general information and education, not professional advice.
Reference: Rice University — Principles of Accounting, Volume 2: Managerial Accounting
Last reviewed:
Common questions
Formula, source and verification
The four classic variances, each shown separately and labelled favourable or unfavourable.
The question it answers: We came in over cost — was it price, usage, wage rates or time?
The formula
Price variance = (Actual price − Standard price) × Actual quantity; Quantity variance = (Actual quantity − Standard quantity) × Standard price; Rate variance = (Actual rate − Standard rate) × Actual hours; Efficiency variance = (Actual hours − Standard hours) × Standard rate
- AQ — Actual quantity
- (material unit). Material actually used.
- AP — Actual price
- (currency). Price actually paid per material unit.
- SQ — Standard quantity allowed
- (material unit). Standard for the output achieved.
- SP — Standard price
- (currency). The organisation's own standard price.
- AH — Actual hours
- (hour). Labour hours actually worked.
- AR — Actual rate
- (currency). Rate actually paid per hour.
- SH — Standard hours allowed
- (hour). Standard for the output achieved.
- SR — Standard rate
- (currency). The organisation's own standard rate.
Units: Currency; material units; hours.
What kind of calculation this is
Deterministic formula. The same inputs always give the same answer. The maths is fixed and does not depend on judgement.
Method
Each variance computed on its own basis and reported separately; a positive figure costs more than standard and is labelled unfavourable. Standards are the organisation's own, never a benchmark or a target.
Assumptions built into the result
- Industry: Every cost, rate and standard is the figure the user entered, in the currency they chose; no exchange rate is applied.
- Mathematical: Costs and output cover the same period or the same job.
Figures this calculator will never guess for you
- No industry average, benchmark or target cost is supplied.
- No standard rate, wage or material price is assumed on the user's behalf.
- Optional components are excluded from the result when left at zero.
- No standard price, rate, quantity or hour figure is supplied.
Limitations
- Arithmetic over the figures entered — it cannot tell whether the costs, standards or allowances behind them are right.
- A target cost, an industry benchmark and the organisation's own standard are different things; only the figures entered are used.
- Material and labour variances only; overhead variances are a separate analysis.
- A variance explains size and direction, not cause; the reason has to be investigated on the floor.
Source and version
- Standard or reference
- Managerial accounting — standard costs and variance analysis — OpenStax (Rice University) (Principles of Accounting, Volume 2: Managerial Accounting (OpenStax) — a standard cost is the expected quantity at the expected price; price and quantity (or rate and efficiency) variances separate the two causes of a difference from standard.)
- Published source
- Rice University — OpenStax (CC BY)
- Formula version
- Version 1
- Verification
- Reviewed against the cited source on
- How much weight the source carries
- Academic
- Applies to
- Currency
- Amounts stay in the currency you choose; no exchange rate is applied.
Related tools
Work out the hourly rate to charge a client so that target margin is met after overhead and non-billable time.
Find the true hourly cost of an employee once benefits, payroll cost and overhead are included.
Size a software application from its data and transaction functions before estimating effort or cost.
Estimate development effort, schedule and average team size for a software project of a known size.
Express cloud spend as a cost per customer, per transaction or per other business unit.
Set the rate used to apply manufacturing overhead to jobs for the coming period.