Variance Analysis Calculator
Split the gap from standard into price, quantity, rate and efficiency variances.
In short
Split the gap from standard into price, quantity, rate and efficiency variances.
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
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.
Use it to turn Currency, Actual material quantity used, Actual price per material unit, Standard quantity allowed for the output, and the other shown inputs into a checked result you can compare, copy, or rerun with different assumptions.
The page shows the formula, a numeric worked example, and the assumptions that affect this professional & industry calculation.
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.
Inputs used: Currency, Actual material quantity used, Actual price per material unit, Standard quantity allowed for the output, Standard price per material unit, Actual labour hours, Actual labour rate per hour, Standard hours allowed for the output, and other shown inputs.
Edge handling: Actual material quantity used is required.; Actual material quantity used cannot be negative.; Actual material quantity used must be no more than 1000000000000.; Actual price per material unit is required.; Actual price per material unit cannot be negative..
Worked example
Material and labour variances for a period
- Start with Currency: USD, Actual material quantity used: 3100, Actual price per material unit: 3.35, Standard quantity allowed for the output: 3000, Standard price per material unit: 3.20, Actual labour hours: 920.
- Apply the method: 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.
- 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
- Inputs outside the supported range are rejected rather than forced into a result.
- The result depends on the values you enter for this variance analysis calculator; it does not supply missing rates, rules, prices, dates, or assumptions for you.
Reference: Rice University — Principles of Accounting, Volume 2: Managerial Accounting
Last reviewed:
Common questions
Where does this formula come from?
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. See the source link on this page.
What kind of calculation is this?
The four classic variances, each shown separately and labelled favourable or unfavourable. Check the formula, example, and limitations on this page before using the result for a real professional & industry decision.
What are its limits?
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.
How do I use the Variance Analysis Calculator?
Enter the required values for Currency, Actual material quantity used, Actual price per material unit, Standard quantity allowed for the output, Standard price per material unit, and the other fields shown. The calculator applies the formula on this page and shows the main result with any supporting breakdown so you can check the arithmetic.
What formula does the Variance Analysis Calculator use?
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 The visible formula section above lists the calculation path and the edge cases the page handles, so the result can be checked without relying on the form alone. Check the formula, example, and limitations on this page before using the result for a real professional & industry decision.
Can the Variance Analysis Calculator be used for exact decisions?
Use it as a calculation aid, not as a substitute for checking the underlying rule, contract, policy, or professional advice that applies to your situation. When a result depends on local rules, personal details, prices, or dates, enter those values yourself and confirm them before acting.
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.
Cite this page
Free Calculator. (2026, September 16). Variance Analysis Calculator. https://freecalculator.tech/tools/variance-analysis-calculator
"Variance Analysis Calculator." Free Calculator, 16 Sept. 2026, https://freecalculator.tech/tools/variance-analysis-calculator.
Variance Analysis Calculator — Free Calculator, https://freecalculator.tech/tools/variance-analysis-calculator
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.