Skip to content
CalculatorZilo Logo
  • Home
  • CalculatorsExpand
    • Browse all calculators
    • Education
    • Real Estate
    • Chemistry
  • Finance
  • Math
  • Health & Fitness
  • Science
  • About
  • Contact
CalculatorZilo Logo
Home / Finance Calculators / Sales Quantity Variance Calculator
Accounting Calculators

Sales Quantity Variance Calculator

Published onSeptember 20, 2025 Updated onOctober 24, 2026 4:59 am

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.

Sales Quantity Variance Calculator
Budgeted vs actual volume, valued at standard profit per unit

Variance Results

Sales Quantity Variance Formula: SQV = (Actual Sales Volume − Budgeted Sales Volume) × Standard Profit/Contribution per Unit. Positive result = Favorable variance; negative result = Unfavorable variance.
Budgeted Volume
0 units
Actual Volume
0 units
Quantity Variance
0 units

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.
On this page
  • 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.

  1. 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.
  2. 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.
  3. 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.

SQV = (Actual Quantity − Budgeted Quantity) × Standard Profit per Unit
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.

1. Volume gap: 5,500 − 5,000 = +500 units→ 2. Value it: 500 × $8 standard profit→ 3. Monetary impact: +$4,000.00→ 4. Assessment: Favorable, sales above budget
RunModeUnit varianceMonetary impactAssessment
Budget 5,000, sold 5,500, $8 profitDetailed+500 units+$4,000.00Favorable
Budget 5,000, sold 4,500, $8 profitDetailed−500 units−$4,000.00Unfavorable
Budget 5,000, sold 5,000, $8 profitDetailed0 units$0.00Neutral, on target
Two products, mix pre-filled belowMix Analysis+1,000 units+$7,055.56Favorable

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.

VarianceFormulaQuestion it answers
Sales quantity variance(Actual qty at standard mix − budgeted qty) × standard profitDid total volume beat budget, mix held constant?
Sales mix variance(Actual qty − actual qty at standard mix) × standard profitDid we sell proportionally more of the profitable lines?
Sales volume varianceQuantity variance + mix varianceWhat did volume, in total, do to profit?
Sales price varianceActual 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

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.
  6. 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.
  7. 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.
  8. 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.
  9. 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.
  10. 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.

Related calculators

Accounting CalculatorsSales to Working Capital Ratio CalculatorEvery dollar of sales a business makes has to be carried for a while by money tied up in stock, unpaid customer invoices and the gap before suppliers are paid.Accounting Calculators Mca Calculator Give this calculator four numbers: the advance amount, the factor rate, the payback period and the payment...Accounting CalculatorsUnderpayment Penalty Calculator An underpayment penalty calculator answers two questions in order: do you actually owe the IRS a penalty for paying too little during the year, and if so, roughly how much?Accounting CalculatorsForm 2210 Penalty CalculatorA Form 2210 penalty calculator figures the IRS underpayment penalty the same way the form itself does: quarter by quarter, at the IRS rate in effect for each period.Accounting CalculatorsDiminishing Value Depreciation Calculator Straight-line depreciation spreads an asset’s cost evenly, but most assets lose value fastest in their first years.Accounting CalculatorsPercentage Profit CalculatorMargin and markup describe the same profit with different denominators, and confusing them is one of the most expensive pricing mistakes a seller can make.

We use cookies to analyze traffic. You can accept or decline cookies below. Learn more

calculatorzilo

CalculatorZilo

Free calculators for everyday life. No signup, no cost, just answers.

Categories

Finance Math Health & Fitness Education Science Real Estate Chemistry Browse all calculators

Popular tools

Mortgage Payment Calculator BMI Walking Calculator Salary Per Minute Calculator Percentage Off Calculator

Company

About Us Contact Us Privacy Policy Terms and Conditions
Disclaimer Cookie Policy DMCA Policy Affiliate Disclosure FAQ Accessibility Statement

© 2026 CalculatorZilo • Free calculators for everyone

  • Home
  • Calculators
    • Browse all calculators
    • Education
    • Real Estate
    • Chemistry
  • Finance
  • Math
  • Health & Fitness
  • Science
  • About
  • Contact
Search