# Variance Analysis Calculator

> Split the gap from standard into price, quantity, rate and efficiency variances.

Page: https://freecalculator.tech/tools/variance-analysis-calculator
Last reviewed: 2026-09-16

## 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

- 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..

## Inputs

- 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
- Standard labour rate per hour

## 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.
1. 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.
2. 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.
3. Each variance is shown separately, against your own standards — not against a benchmark or a target.

## 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.

## 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.

## Sources

- Rice University — https://openstax.org/books/principles-managerial-accounting/pages/1-introduction

## Cite this page

- APA: Free Calculator. (2026, September 16). Variance Analysis Calculator. https://freecalculator.tech/tools/variance-analysis-calculator
- MLA: "Variance Analysis Calculator." Free Calculator, 16 Sept. 2026, https://freecalculator.tech/tools/variance-analysis-calculator.
- Link: Variance Analysis Calculator — Free Calculator, https://freecalculator.tech/tools/variance-analysis-calculator