Accounting & Financial Statement Analysis Budgeting & Variance Analysis Flexible-budget variance analysis (contribution-margin basis)

Sales Volume & Sales Price Variance Calculator

A revenue miss is never one thing. This calculator separates it into the two effects a sales review has to argue about separately: the price variance, from realising a different price than you planned, and the volume variance, from selling a different number of units. Because a price cut and a volume gain often arrive together, it values volume at the budgeted contribution margin rather than at revenue, so the components add up to the change in profit rather than to the change in sales. It also reports how many units you would have needed at your actual price and cost to match the plan.

Calculator

This calculator runs in your browser. Enable JavaScript for live results — the inputs, formula and worked example below remain fully readable without it.

Inputs this calculator takes, with typical values
InputWhat to enterExample
Budgeted selling price per unitThe net price per unit in the approved plan, after the discounts and allowances the plan assumed.50 $
Actual selling price per unitActual net revenue divided by actual units sold, so realised discounts and rebates are already inside it.48 $
Budgeted units soldQuantity in the approved plan for the same period and the same product or group.10000 units
Actual units soldUnits actually invoiced in the period, on the same recognition basis as the budget.11000 units
Budgeted variable cost per unitStandard material, labour, variable overhead and per-unit selling cost. Exclude anything that does not move with volume.30 $
Actual variable cost per unitSet it equal to the budgeted figure for the classic two-variance answer; enter the real number to see the cost effect separately.30.5 $

It returns

  • Total static-budget variance in contribution margin — Actual contribution margin minus the static budget. Positive is favorable, because every component is stated as its effect on profit.
  • Sales price variance
  • Sales volume variance
  • Variable cost variance — Zero when actual variable cost per unit equals budget. When it does not, this is what makes the three components reconcile.
  • Actual contribution margin
  • Flexible-budget contribution margin — Actual units sold at the budgeted contribution per unit: what the plan says this volume should have delivered.
  • Static-budget contribution margin
  • Units needed to match the budgeted contribution — At your actual price and actual variable cost. Compare it against budgeted units to see how much volume your realised economics now require.

The formula

SPV=(PaPb)QaSVV=(QaQb)(PbVb)
VCV=(VbVa)Qa
Vtotal=CMactualCMstatic

In plain text: SPV = (Pₐ − Pᵇ) × Qₐ ; SVV = (Qₐ − Qᵇ) × (Pᵇ − Vᵇ)

  • PᵇBudgeted net selling price per unit ($)
  • PₐActual net selling price per unit ($)
  • QᵇBudgeted units sold (units)
  • QₐActual units sold (units)
  • VᵇBudgeted variable cost per unit ($)
  • SPVSales price variance; positive is favorable ($)
  • SVVSales volume variance; positive is favorable ($)

Both variances are stated as their effect on contribution margin, so positive is favorable — the opposite of the cost-variance convention. The volume variance is valued at the budgeted contribution margin per unit, never at the selling price.

Updated Category Budgeting & Variance Analysis Verified against published test cases Reading time 13 min

What the sales price and volume variances measure

Two sales teams can miss the same revenue number for opposite reasons. One sold the planned quantity at a lower price. The other held price and sold fewer units. The revenue line looks identical; the diagnosis, the owner and the fix are completely different. Splitting the miss into a price effect and a volume effect is what makes the number usable.

The split has one rule that surprises people: value the volume effect at contribution margin, not at revenue. Selling 1,000 units more than plan does not add 1,000 × the selling price to profit, because those units also consume variable cost. It adds 1,000 × the budgeted contribution per unit. Value volume at revenue and your components will reconcile to the revenue line while overstating the profit effect by the whole variable cost of the extra units.

The sign convention here is the reverse of the cost variances. Every component is expressed as its effect on contribution margin, so positive is favorable. That is deliberate: it lets you add price, volume and cost effects together and land exactly on the difference between actual and budgeted contribution. The direct material and direct labor variance calculators use actual minus standard instead, where positive means an overspend.

The formulas and the three levels of variance analysis

Standard practice builds the answer in levels, and knowing which level you are on prevents most arguments in a sales review.

Level 1 is the static-budget variance: actual contribution margin minus the contribution margin in the approved plan. One number, no explanation.

Level 2 splits that into two. The sales volume variance = (QaQb) × (PbVb) moves you from the static budget to the flexible budget, which is what the plan says the volume you actually achieved should have earned. Everything left over is the flexible-budget variance: the part caused by prices and costs rather than by quantity.

Level 3 opens the flexible-budget variance. The sales price variance = (PaPb) × Qa uses actual units, because the price difference applied to every unit you actually invoiced. The variable cost variance = (VbVa) × Qa catches the rest, and this is the piece most quick calculations drop. Price variance plus volume variance only equals the total when your variable cost per unit came in exactly on budget, which it rarely does. The three together always reconcile.

Notice which price sits in which formula. The volume variance uses the budgeted contribution margin, so a manager selling more units is credited at planned economics and never rewarded or punished for a price move. The price variance uses actual units, so it measures the whole realised effect of the price you achieved. Mixing those two multipliers is the single commonest error, and it produces components that do not add up.

Worked example: 11,000 units at $48 against a plan of 10,000 at $50

A plan calls for 10,000 units at $50 with a variable cost of $30, so budgeted contribution is $20 per unit. The quarter closes at 11,000 units sold, an average realised price of $48 after a promotional discount, and an actual variable cost of $30.50 because a material contract repriced.

  1. Budgeted contribution per unit. $50 − $30 = $20.00.
  2. Actual contribution per unit. $48 − $30.50 = $17.50.
  3. Static-budget contribution. 10,000 × $20.00 = $200,000.
  4. Flexible-budget contribution. 11,000 × $20.00 = $220,000. This is what 11,000 units should have earned at planned economics.
  5. Actual contribution. 11,000 × $17.50 = $192,500.
  6. Sales volume variance. (11,000 − 10,000) × $20.00 = $20,000 favorable, which is exactly $220,000 − $200,000.
  7. Sales price variance. ($48 − $50) × 11,000 = $22,000 unfavorable.
  8. Variable cost variance. ($30 − $30.50) × 11,000 = $5,500 unfavorable.
  9. Total. $20,000 F − $22,000 U − $5,500 U = $7,500 unfavorable, equal to $192,500 − $200,000.
  10. How much volume would have covered it? $200,000 ÷ $17.50 = 11,429 units. You were 429 units short of standing still.

The headline is that revenue rose. Revenue budgeted at $500,000 came in at $528,000, a 5.6% beat, and a report that stops at the top line calls this a good quarter. Contribution fell $7,500. The 10% volume gain was real and worth $20,000, but a 4% discount on a product carrying a 40% contribution margin costs 10% of contribution, so the promotion never paid for itself even before the cost increase. That gap between a revenue beat and a contribution miss is the whole reason to run this split rather than eyeballing the sales line.

How to read the result: who owns what, and what the pattern means

Assign each component before you interpret it. The price variance belongs to whoever controls discounting and list price, usually sales leadership and pricing. The volume variance is shared: demand, marketing and capacity all move it, and a stock-out makes it a supply-chain result rather than a sales one. The variable cost variance belongs to operations and purchasing and has nothing to do with the sales team at all, which is precisely why it is worth separating rather than leaving inside a blended margin number.

Read the price and volume signs as a pair, because they usually move in opposite directions:

  • Volume favorable, price unfavorable is discounting. The test is arithmetic, not judgement: compare the two amounts. In the worked example the discount cost more than the extra volume earned, so the promotion destroyed contribution.
  • Price favorable, volume unfavorable is a price rise or a mix shift towards premium. Often the better trade in the short run, but watch it across several periods, because price gains land immediately while volume lost to a competitor compounds.
  • Both favorable almost always means the market moved, a competitor withdrew, or the budget was set too low. Check the budget before you credit the team.
  • Both unfavorable is a demand or competitive problem that a sales incentive will not fix.

On size, treat roughly 5% of budgeted contribution as the point where a written explanation is due, together with a dollar floor that matters at your scale — the same two-part materiality test used in ordinary budget versus actual analysis. Also check the volume variance against the margin of safety: the same unfavorable volume variance is survivable at 40% margin of safety and serious at 5%.

One structural caution. A favorable volume variance is only genuinely good if the extra units were profitable and fixed costs did not step up to serve them. Adding a shift, a warehouse or a freight lane to deliver the volume can consume the whole gain, and none of that appears in a contribution-margin variance.

Five outcomes against the same $200,000 plan

Every row runs against the same plan: 10,000 units at $50 with $30 of variable cost, so budgeted contribution is $20 per unit and the static-budget contribution margin is $200,000.
Actual resultActual CM per unitPrice varianceVolume varianceVariable cost varianceTotal vs plan
11,000 at $50, cost $30$20.00$0$20,000 F$0$20,000 F
11,000 at $48, cost $30$18.00$22,000 U$20,000 F$0$2,000 U
11,000 at $48, cost $30.50$17.50$22,000 U$20,000 F$5,500 U$7,500 U
9,000 at $53, cost $30$23.00$27,000 F$20,000 U$0$7,000 F
12,500 at $45, cost $30$15.00$62,500 U$50,000 F$0$12,500 U

The last row is the one to remember: a 25% volume increase alongside a 10% discount still loses $12,500 of contribution. Volume rarely rescues price on a product with a 40% contribution margin.

How much extra volume a discount has to buy

A $50 product with $30 of variable cost, budgeted at 10,000 units. Required volume is the number of units at the discounted price that produces the same $200,000 of contribution margin.
DiscountNet priceContribution per unitVolume increase neededUnits needed
0%$50.00$20.0010,000
2%$49.00$19.005.3%10,526
5%$47.50$17.5014.3%11,429
10%$45.00$15.0033.3%13,333
15%$42.50$12.5060.0%16,000
20%$40.00$10.00100.0%20,000
30%$35.00$5.00300.0%40,000

The multiplier is contribution before the discount divided by contribution after it. The thinner your contribution margin, the more brutal the arithmetic: at a 20% contribution margin a 10% discount needs volume to double.

Mistakes that break a sales variance

  • Valuing the volume variance at selling price. The most common error. It credits the extra units with revenue they did not keep and overstates the profit effect by their whole variable cost.
  • Using budgeted units in the price variance. The price you realised applied to the units you actually invoiced, so the multiplier is actual volume. Use budgeted units and the components stop adding up.
  • Dropping the variable cost variance. Price plus volume equals the total only when variable cost per unit lands exactly on budget. Otherwise the difference has to go somewhere.
  • Comparing gross prices against a net budget. Rebates, freight allowances and settlement discounts belong in the realised price. Mixing gross and net turns a rebate accrual into a fake price variance.
  • Running the split across a whole product portfolio at once. An average price across a mix of products hides a mix variance inside the price variance. Split by product or group, then aggregate.
  • Confusing a volume variance with a market-share story. Selling fewer units in a market that shrank faster is a favorable share outcome and an unfavorable volume variance at the same time.
  • Forgetting that fixed costs are not in here. This is a contribution-margin analysis. If serving the extra volume required overtime, a shift or extra freight capacity, the fixed-cost spending variance sits outside it.

No accounting standard governs a sales variance

Sales variances are internal management information. Neither US GAAP nor IFRS prescribes a format, a threshold or a required decomposition, so the convention you adopt is whatever your finance function documents. The framework used here — static budget, flexible budget, and the price, volume and cost variances between them — is the standard treatment in the managerial accounting texts listed as sources below. The one thing worth writing into policy is the sign convention: state explicitly that a favorable variance is positive and that volume is valued at budgeted contribution margin, because those two choices are exactly where hand-built spreadsheets diverge from each other.

Where several products share a market, the volume variance can be split again. The sales quantity variance holds the budgeted product mix constant and measures the effect of total market units alone; the sales mix variance measures the effect of selling a different blend than planned, valued at the difference between each product's contribution and the average. Add them and you get exactly the volume variance on this page. Do the two-variance split first: if the volume variance is small, decomposing it further buys nothing but arithmetic.

What you do next depends on the diagnosis. If price is the problem, contribution per unit is the number to defend, so work through the contribution margin calculator and the gross profit margin calculator. If volume is the problem, the question is how much cushion you have: use the break-even point calculator, and note that a business with high fixed costs converts a small volume miss into a large profit miss, which the degree of operating leverage calculator quantifies. If the cost side is driving it, the standard-cost split belongs upstream in the material and labor variance calculators.

Finally, be honest about the limits. This is a contribution-margin bridge for one period and one product or group. It says nothing about whether the discount bought a customer who will renew, whether the volume was pulled forward from next quarter, or whether the fixed-cost base moved to serve it. Those are the questions the variance is meant to raise, not answer.

Key terms

Static budget
The plan as approved, at the volume it assumed. Comparing actual against it mixes the volume effect with everything else.
Flexible budget
The plan recalculated at the volume you actually achieved, holding budgeted prices and costs. The fair benchmark for price and cost performance.
Sales volume variance
The unit shortfall or surplus valued at budgeted contribution margin per unit. Moves you from the static budget to the flexible budget.
Sales price variance
The realised price gap multiplied by actual units sold. Also called the selling price variance.
Sales mix variance
The part of the volume variance caused by selling a different blend of products than planned rather than a different total quantity.

Frequently asked questions

Why is the volume variance valued at contribution margin instead of selling price?

Because the extra units consumed variable cost as well as generating revenue. A unit sold above plan adds its contribution margin to profit, not its full price. Valuing volume at price would make the components reconcile to the revenue line while overstating the profit effect by the whole variable cost of those units. Some organisations do publish a revenue-based volume variance for sales reporting; if yours does, label it clearly as a revenue variance so nobody adds it to a profit bridge.

Do the price and volume variances always add up to the total?

Only when your actual variable cost per unit equals the budgeted figure. If costs moved, a third component is needed, and this calculator computes it as the variable cost variance: budgeted minus actual variable cost, times actual units sold. With all three the reconciliation is exact: they always sum to actual contribution margin minus static-budget contribution margin. That is why the calculator asks for actual variable cost rather than assuming it.

Does this give me the operating income variance?

It gives the contribution-margin variance, which equals the operating income variance whenever fixed costs come in on budget. If fixed costs also moved, add the fixed-cost spending variance — budgeted fixed cost minus actual fixed cost — to the total shown here. Keeping fixed costs out of this analysis is deliberate: fixed spending is a separate decision with a separate owner, and folding it into a sales variance hides both.

Is a favorable sales volume variance always good news?

No. Three cases break it. If contribution per unit is negative, selling more units makes the result worse, and the calculator reports the volume variance as unfavorable when that happens. If the extra volume required a step-up in fixed cost — a shift, a lane, a warehouse — the gain can be consumed outside this analysis. And if the volume was bought with a discount, compare the volume variance against the price variance before you celebrate: in the reference table above a 25% volume gain with a 10% discount still loses $12,500.

What is the difference between a sales volume variance and a sales quantity variance?

The sales quantity variance is a subdivision of the volume variance. It isolates the effect of total units sold while holding the budgeted product mix constant; the sales mix variance isolates the effect of a different blend of products. The two add back to the volume variance this calculator reports. You only need the finer split when you sell several products with materially different contribution margins and the mix moved.

Which price should I enter as the actual selling price?

Net revenue for the period divided by actual units sold, so every realised deduction is already inside it: volume rebates, promotional allowances, settlement discounts and any freight you absorbed. Enter the budgeted price on the same basis. Comparing a gross list price against a net budget is the fastest way to invent a price variance that is really a rebate accrual, and it is the error most often found in a sales review pack.

How large does a sales variance have to be before it needs explaining?

Around 5% of budgeted contribution margin together with a dollar floor that matters at your scale is the common rule of thumb, and this calculator flags that threshold. Apply the percentage to contribution rather than to revenue: on a product with a 40% contribution margin, a 2% price move is a 5% contribution move, so a variance that looks trivial on the revenue line is already material on the profit line.

Can I use this for a subscription or services business?

Yes, with the right unit. For subscriptions, use the number of customers or seats as units and the monthly or annual contribution per customer as the margin, and the price variance then measures realised discounting against list. For services, use billable hours or engagements as units and the contribution per unit after direct delivery cost. The one thing to watch is period alignment: a mid-period start or a churned customer has to be counted the same way in both the budget and the actual figures.

References

  • Cost Accounting: A Managerial Emphasis (flexible budgets, sales variances) — Pearson (Horngren, Datar & Rajan)
  • Managerial Accounting — McGraw-Hill (Garrison, Noreen & Brewer)
  • Statements on Management Accounting series — Institute of Management Accountants
  • Management and Cost Accounting — Cengage (Drury)