Sales Quantity Variance Calculator
Sales quantity variance puts a dollar figure on a simple question: what did selling more or fewer units than budgeted do to profit? This calculator runs the management-accounting formula, (actual quantity − budgeted quantity) × standard profit per unit, in three modes: a quick unit count, a detailed single-product analysis with the monetary impact, and a two-product analysis that holds the sales mix at budget proportions. It belongs to the variance report, not the sales floor: for everyday revenue totals, the sales calculator is the right tool.
Variance Results
Sign convention: this calculator follows the textbook rule, positive = favorable, in every mode. Earlier versions of this page computed budgeted minus actual, which printed a negative dollar impact on favorable results; that inversion has been corrected and the magnitudes are unchanged.
Quick Answer
Budgeted 5,000 units, sold 5,500, standard profit $8 per unit: the sales quantity variance is (5,500 − 5,000) × $8 = +$4,000, favorable. Selling 500 units over budget added $4,000 of standard profit. A negative result is unfavorable, zero is exactly on target, and the sign always follows the textbook rule used here: positive means you sold more than planned. Run your own volumes in Detailed mode above to get the same read-out.
Key takeaways
- SQV = (actual quantity − budgeted quantity) × standard profit per unit. Price and unit costs stay at standard, so the variance measures volume and nothing else.
- Positive is favorable, negative is unfavorable. If a calculator prints a negative dollar figure for a month when you beat budget, its sign convention is inverted. This page follows the textbook convention.
- Use standard profit per unit under absorption costing, standard contribution per unit under marginal costing. The two bases give different numbers, so state which one you used.
- With several products, quantity variance holds the mix at budget proportions; the mix effect is a separate variance. Quantity + mix = sales volume variance.
- Quick Answer
- How to use the three modes
- The sales quantity variance formula and the sign rule
- Worked example: beating budget by 500 units
- The two-product quantity variance: what Mix Analysis actually computes
- Quantity variance among its siblings: price, volume and mix
- What competing calculators miss
- Frequently asked questions
- Add This Calculator to Your Website
- References
How to use the three modes
Pick the mode that matches the question you are answering. All three are pre-filled with the worked example, and the result breakdown stays hidden until you calculate.
- Simple SQV: budgeted and actual units only. It returns the signed unit variance (for example +500 units) and the assessment, with no money attached. Use it for a fast volume check.
- Detailed Analysis: adds the standard profit per unit and returns the monetary impact as well. This is the mode that produces the +$4,000 favorable figure in the worked example, and the one most variance reports need.
- Mix Analysis: two products, each with budgeted and actual volumes and a standard profit. It computes the quantity variance at the standard (budget) mix and reports the totals: budgeted units, actual units, unit variance and total monetary impact.
Validation is strict and identical in spirit across modes: every volume and every standard profit must be greater than zero, and the calculator shows an alert naming the problem instead of guessing (“Please enter valid positive values for volumes.”, “Please enter a valid standard profit per unit.”). Blank and non-numeric entries are treated as zero and rejected the same way. One honest consequence: a product that genuinely sold zero units cannot be entered in any mode, so a discontinued line has to be carried as a manual line in the variance report. The budgeted figures themselves normally come from the sales budget, which is built from an expected sales forecast rather than from last year’s actuals.
The sales quantity variance formula and the sign rule
SQV = (actual quantity − budgeted quantity) × standard profit per unit. That is the formula in the standard-costing textbooks and in the ACCA and CIMA syllabuses, and it is the formula this calculator runs.
Actual above budget → positive → Favorable · Actual below budget → negative → Unfavorable (ACCA also calls this Adverse)
The sign rule is where published tools most often go wrong, including an earlier version of this page, which computed budgeted minus actual and so printed “Monetary impact: $−4,000” on a result it simultaneously called favorable. The magnitudes were right and the labels were right; the signed numbers contradicted both. The convention used here, actual minus budgeted, is the one in the worked examples of the professional syllabuses: when the ACCA examiner’s report works a three-product quantity variance, each product’s standard-mix actual is compared against its budget and the total comes out $6,220 favorable for a period when more was sold than planned. If your own textbook or tutor uses the word “adverse”, it means exactly what this page calls unfavorable.
The standard profit input deserves one careful sentence. It is the budgeted profit or contribution earned by one unit, taken from the standard cost card. It is not the selling price: valuing the volume gap at selling price overstates the profit effect by the whole variable cost of the extra units. Under absorption costing the volume variance is valued at standard profit per unit; under marginal costing, at standard contribution per unit.
Worked example: beating budget by 500 units
A single product budgeted at 5,000 units sells 5,500, at a standard profit of $8 per unit. The variance is +500 units and +$4,000, favorable. These values are pre-filled in Detailed mode above, and every figure below is a real run of this calculator.
| Run | Mode | Unit variance | Monetary impact | Assessment |
|---|---|---|---|---|
| Budget 5,000, sold 5,500, $8 profit | Detailed | +500 units | +$4,000.00 | Favorable |
| Budget 5,000, sold 4,500, $8 profit | Detailed | −500 units | −$4,000.00 | Unfavorable |
| Budget 5,000, sold 5,000, $8 profit | Detailed | 0 units | $0.00 | Neutral, on target |
| Two products, mix pre-filled below | Mix Analysis | +1,000 units | +$7,055.56 | Favorable |
The shortfall row is the mirror image, and it is the row to test any variance calculator with: a tool that reports a 500-unit shortfall as a positive $4,000 has its subtraction backwards, whatever its labels claim.
The two-product quantity variance: what Mix Analysis actually computes
Mix Analysis computes the quantity variance at the standard mix: it asks how much of the volume change is pure quantity, with the product proportions frozen at budget. It does not compute the mix variance itself, and knowing that boundary is what makes its output usable.
The pre-filled example budgets Product A at 7,000 units ($6.50 standard profit) and Product B at 2,000 units ($9.00), a 7:2 mix. Actual sales total 10,000 units (7,500 A and 2,500 B). At the standard mix, 10,000 units would have split 7,777.78 A and 2,222.22 B. The quantity variance per product is that standard-mix figure minus the budget: A contributes (7,777.78 − 7,000) × $6.50 = +$5,055.56 and B contributes (2,222.22 − 2,000) × $9.00 = +$2,000.00, for the tool’s reported totals of +1,000 units and +$7,055.56, favorable. The tool reports the totals only; the per-product split above is the same arithmetic done line by line.
Notice what the mode deliberately ignores: the actual mix (7,500:2,500, a 3:1 split) was richer in the lower-profit product than the standard mix, and that shortfall belongs to the sales mix variance, which this calculator does not compute. Quantity (+$7,055.56 here) plus mix equals the sales volume variance, so a complete report pairs this tool’s figure with a mix calculation done from the same data. A useful sanity check the mode passes: hold total actual equal to total budget while shifting the mix, and the quantity variance correctly reads zero, because pure quantity did not move.
Quantity variance among its siblings: price, volume and mix
Sales quantity variance is one member of a small family, and half the confusion around it comes from swapping the members. Each variance below answers a different question about the same period.
| Variance | Formula | Question it answers |
|---|---|---|
| Sales quantity variance | (Actual qty at standard mix − budgeted qty) × standard profit | Did total volume beat budget, mix held constant? |
| Sales mix variance | (Actual qty − actual qty at standard mix) × standard profit | Did we sell proportionally more of the profitable lines? |
| Sales volume variance | Quantity variance + mix variance | What did volume, in total, do to profit? |
| Sales price variance | Actual qty × (actual price − standard price) | Did realized prices beat the standard price? |
Two naming traps sit inside the family. First, some textbooks use “sales volume variance” for the single-product version of exactly this page’s calculation, so a single-product volume variance and a quantity variance can be the same number under two names. Second, none of these is a growth rate: a period-over-period comparison such as the comparable sales growth calculator measures this year against last year, while a variance measures actuals against the budget for the same period. Monthly, the variance belongs in the management pack next to the operational view from the monthly sales pace calculator: pace tells you the month is drifting, the quantity variance tells you what the drift cost in standard profit.
What competing calculators miss
The formula is standard, so rivals differ on sign discipline, mode coverage and honesty about limits:
- BraveCalculator’s SQV calculator: gets the sign right, (actual − standard) × standard profit with positive labeled favorable, and explains it well. It stops at the single-product case: no unit-only quick mode, no two-product standard-mix analysis.
- AccountingHub’s explainer: its worked two-product example quietly uses the correct standard-mix method, (standard-mix quantity − budgeted) × profit, while its own stated formula line prints the subtraction the other way round. Readers who copy the formula line instead of the example inherit the inversion. It is an explainer, not a tool.
- Textbook and exam-prep pages (ACCA, CIMA materials): authoritative on method, including the reconciliation quantity + mix = volume, but they are study text with fixed illustrations. Nothing to run your own month through, and the adverse/favorable vocabulary differs from US reporting.
- Generic variance templates: spreadsheet downloads that value the volume gap at selling price rather than standard profit, overstating every result by the variable cost of the extra units.
- The gap this page fills: all three modes in one tool, the textbook sign convention applied consistently to the unit figure, the dollar figure and the label, and the mix boundary stated plainly: this tool computes the quantity component, not the mix component.
Frequently asked questions
It is the profit effect of selling a different number of units than budgeted, valued at the standard profit or contribution per unit: (actual quantity − budgeted quantity) × standard profit per unit. It isolates the volume effect by holding price and unit costs at standard, so a pricing win or a cost overrun never contaminates it.
Subtract budgeted units from actual units and multiply by the standard profit per unit. Selling 5,500 units against a 5,000-unit budget at $8 standard profit gives (5,500 − 5,000) × $8 = +$4,000. A positive result is favorable, a negative result is unfavorable.
For sales quantity variance, yes, under the standard convention used here: positive means you sold more than budgeted. Cost variances run the other way, because a positive cost variance usually means overspending, which is why every variance should carry its favorable or unfavorable label, as this calculator’s assessment field does.
Sales volume variance is the parent measure. For a single product it is the same calculation as quantity variance: (actual − budgeted) × standard profit. With several products, volume variance splits into sales quantity variance, which assumes the budgeted mix held, and sales mix variance, which captures selling a different proportion of each product. Quantity plus mix reconciles back to volume.
Quantity variance values a change in units at the standard profit per unit. Price variance values a change in price on the units actually sold: actual quantity × (actual price − standard price). One asks whether you sold more, the other whether you sold it for more.
It depends on the costing system. Under absorption costing the volume variance is valued at standard profit per unit. Under marginal costing it is valued at standard contribution per unit, which is the convention the ACCA and CIMA syllabuses use. Enter whichever your standard cost card states, and say which one you used, because the two bases give different figures.
It holds the mix at budget proportions. The tool scales each product’s budgeted volume to the actual total (the standard mix), then values the gap between that standard-mix volume and the budget at each product’s standard profit. That is the textbook quantity variance for several products. It reports the totals; the per-product split is the same arithmetic product by product.
Every mode requires positive volumes and a positive standard profit, and shows an alert naming the problem instead of returning a misleading zero. That is a real limitation of this tool: a product that genuinely sold zero units cannot be entered in any mode, so a zero-sales line has to be carried as a manual line in the variance report.
Monthly, alongside the rest of the variance report, is the standard cadence: often enough to act on a drifting forecast, not so often that one large order dominates the read. Quarterly suits small product ranges with stable volumes.
Add This Calculator to Your Website
Embed this calculator on your own site with the code below. Pick a size to preview it live, then copy the code.
Powered by Calculator Zilo
References
- Association of Chartered Certified Accountants (ACCA). Performance Management (PM) Examiner’s Report, September/December 2023 (sales mix and quantity variances worked in full: quantity variance as actual quantity in the standard mix minus budgeted quantity, times standard margin, $6,220 favorable). Accessed October 24, 2026.
- aCOWtancy. ACCA PM Notes: Sales Price and Volume Variance (volume variance as actual minus budgeted units at standard profit under absorption costing and standard contribution under marginal costing, with favorable labeling). Accessed October 24, 2026.
- EduYush. Variance Analysis ACCA PM: Exam Guide (sales mix variance and sales quantity variance formulas and the reconciliation: volume variance = mix variance + quantity variance). Accessed October 24, 2026.
- AccountingHub. What Is the Sales Quantity Variance? (two-product worked example using standard mix ratios: quantity variance per product valued at standard profit). Accessed October 24, 2026.
- Accounting Terms Lexicon. Sales Margin Quantity Variance (definition and formula: actual sales quantity minus budgeted sales quantity, times standard profit margin; favorable when actual exceeds budget). Accessed October 24, 2026.
- Gevorg CPA. CPA Guide: Variance Analysis Explained (core variance table: sales quantity variance as actual quantity sold minus budgeted quantity sold, times budgeted contribution margin per unit). Accessed October 24, 2026.
- Accounting Tuition. Standard Costing (sales volume variance as the difference between actual and budgeted sales quantity valued at standard profit or contribution; favorable when volume exceeds budget, decomposed into quantity and mix effects). Accessed October 24, 2026.
- Under30CEO. Sales Volume Variance (budgeted quantity subtracted from actual quantity sold, times standard profit per unit; positive means actual volume exceeded plan). Accessed October 24, 2026.
- aCOWtancy. ACCA PM Variance Analysis: 5 Mistakes Costing You Marks in 2026 (value volume variances at standard contribution, not selling price, and label every variance favorable or adverse). Accessed October 24, 2026.
- Brainscape (ACCA study collection). Other Variances: Sales Mix and Quantity (quantity variance equation: actual volume at standard mix minus budgeted volume, times standard contribution; causes of favorable quantity variances). Accessed October 24, 2026.
