Sales Volume Variance: Formula, Worked Examples and What It Tells You

By the SalesLama Team
Start 7-day free trial
Person reviewing sales charts on a tablet

In spring 2013, Nintendo told investors it expected to sell 9 million Wii U consoles in the financial year ending March 2014. On January 17, 2014, it cut that forecast to 2.8 million. Its 3DS forecast dropped too, from 18 million units to 13.5 million. The company that had sold the Wii in enormous numbers now expected a loss of about 35 billion yen for the year. That gap is exactly what sales volume variance measures.

The price of the console hadn’t collapsed. The problem was volume. Nintendo simply wasn’t selling as many units as it had planned.

That gap between planned units and actual units has a name in accounting: sales volume variance. It’s one of the most useful numbers a sales leader can understand, because it separates “we sold fewer things” from “we sold things for less.” Those are very different problems with very different fixes.

Sales volume variance: office desk with smartphone and financial charts

A variance is just the gap between the plan and what actually happened. The useful part is understanding why.

What is sales volume variance?

Sales volume variance measures how much of the difference between budgeted and actual sales is caused by selling more or fewer units than planned. It holds price constant, so it isolates the effect of volume alone.

• If you sold more units than budgeted, the variance is favorable.
• If you sold fewer units than budgeted, the variance is unfavorable (sometimes called adverse).

The sales volume variance formula

The standard formula is:

Sales volume variance = (Actual units sold − Budgeted units) × Budgeted price per unit

Some businesses use budgeted profit or contribution margin per unit instead of price. That version tells you the impact on profit rather than revenue:

Sales volume variance (profit) = (Actual units sold − Budgeted units) × Budgeted contribution per unit

Both are correct. Use the revenue version when you’re explaining sales performance. Use the contribution version when you’re explaining profit.

“Plans are worthless, but planning is everything.”

— Dwight D. Eisenhower, speech to the National Defense Executive Reserve Conference, 1957

Eisenhower’s point fits variance analysis well. Your budget will be wrong. The value is in understanding exactly how it was wrong.

Sales price variance: the other half

Volume variance has a partner. Sales price variance measures the effect of selling at a different price than planned:

Sales price variance = (Actual price − Budgeted price) × Actual units sold

Add the two together and you get the total sales variance, the full gap between budgeted and actual revenue.

Sales volume variance: person using a tablet with charts

Split every revenue gap into volume and price. The fix depends on which one moved.

Worked example: step by step

Let’s take a small company selling a software add-on. These numbers are made up to show the method.

Budget for the quarter:

• 1,000 units at $50 each, so budgeted revenue is $50,000.

What actually happened:

• 900 units sold at $52 each, so actual revenue is $46,800.

Total sales variance is $46,800 minus $50,000, which is $3,200 unfavorable. Now let’s split it.

Step 1: Sales volume variance

(900 − 1,000) × $50 = −$5,000 (unfavorable)

Selling 100 fewer units than planned cost $5,000 of revenue.

Step 2: Sales price variance

($52 − $50) × 900 = +$1,800 (favorable)

Charging $2 more per unit than planned added $1,800.

Step 3: Check the total

−$5,000 + $1,800 = −$3,200, which matches the total variance. The math works.

Worked example: splitting a $3,200 revenue shortfall

Sales volume variance (unfavorable)

$5,000

Sales price variance (favorable)

$1,800

Total sales variance (unfavorable)

$3,200

Source: Illustrative numbers only, to show the method

The price increase helped, but not enough to cover the lost volume.

Here’s the insight a single revenue number would hide. On the surface, revenue was down 6.4%. Underneath, pricing was actually stronger than planned. The real problem was volume. That tells you to look at lead flow, conversion and follow-up, not at discounting.

The profit version

Now suppose each unit has a budgeted contribution margin of $20. The profit impact of the volume shortfall is:

(900 − 1,000) × $20 = −$2,000 (unfavorable)

Revenue fell $5,000 from lost volume, but profit fell $2,000. Both numbers are useful for different conversations.

A favorable example

Variances aren’t always bad news. Say a real estate team budgeted 40 closed deals in a quarter at an average commission of $9,000, and closed 46. The volume variance is (46 − 40) × $9,000 = +$54,000 (favorable). That’s worth understanding too. Did a new lead source work? Did faster follow-up lift conversion? Favorable variances tell you what to do more of.

Sales volume variance: laptop and smartphone used together at a desk

A favorable variance is a clue. Find out what caused it and repeat it.

Back to Nintendo

Nintendo’s revised forecast shows how volume variance can dominate everything else.

Nintendo unit forecasts for the year ending March 2014 (millions)

Wii U, original forecast

9M

Wii U, revised January 2014

2.8M

3DS, original forecast

18M

3DS, revised January 2014

13.5M

Source: Nintendo forecast revision, January 17, 2014, via Engadget

Nintendo’s Wii U forecast fell by 6.2 million units in a single revision.

A forecast miss of 6.2 million Wii U units is a volume variance problem on a massive scale. Even if every unit had sold at full price, the revenue plan was gone. When volume falls that far, price adjustments can’t close the gap. You need more buyers.

Most businesses face the same problem on a smaller scale. The question is always the same: why didn’t the expected number of customers buy?

What causes unfavorable sales volume variance?

• Not enough leads. Marketing generated fewer inquiries than planned.
• Lower conversion. Leads came in but fewer turned into customers.
• Slow or missing follow-up. Interested buyers went cold or bought elsewhere.
• Competition. A competitor launched a better or cheaper option.
• Market changes. Demand dropped for reasons outside your control.
• Unrealistic budget. The plan assumed growth that was never likely.

Sales volume variance: calculator app on financial report papers

Every unfavorable volume variance has a cause somewhere in the pipeline.

How to use volume variance to improve sales

1. Trace it back through the funnel

A volume shortfall is the end of a chain. Work backwards: how many leads did you plan for, how many came in, how many were contacted, how many became opportunities, how many closed? The stage with the biggest gap is where to act.

2. Separate controllable from uncontrollable

A market downturn isn’t the same as a team that took three days to call leads back. Be honest about which is which.

3. Review monthly, not yearly

Nintendo revised its forecast once the gap was enormous. Reviewing variance monthly lets you see a 5% shortfall before it becomes a 50% one.

Calendar on a desk

Put a monthly variance review in the calendar. Small gaps are easy to close early.

4. Set leading indicators

Volume variance is a lagging number. Track leading numbers that predict it: new leads per week, response time, follow-up completion and meetings booked.

“Only the paranoid survive.”

— Andrew S. Grove, title of his 1996 book on leading Intel

Grove’s warning applies to forecasts. Assume your volume plan is at risk, and watch the early signals that prove or disprove it.

Chess piece on a checkered board

Variance analysis turns a disappointing quarter into a specific next move.

Sales mix variance: a quick note

If you sell several products with different prices or margins, there’s a third piece: sales mix variance. It measures the effect of selling a different combination of products than planned. You might hit your total unit target but sell more of your cheapest product, which lowers revenue and profit. For single-product businesses you can ignore it. For multi-product businesses, it’s worth calculating separately.

Common mistakes

Using actual price in the volume formula. Volume variance always uses budgeted price, so price changes don’t leak in.

Looking only at the total variance. A small total can hide a large volume problem offset by price increases.

Ignoring the sign. Always label variances favorable or unfavorable so nobody misreads them.

Treating the budget as fact. If the budget was unrealistic, the variance says more about planning than performance.

Where SalesLama helps

Most unfavorable volume variances start with leads that weren’t followed up fast enough or long enough. SalesLama closes that gap. It captures leads from your forms, landing pages and ad campaigns, replies in seconds by email, SMS or WhatsApp, and runs follow-up sequences that stop automatically when someone replies. Pipelines, tasks and owner assignment show exactly where deals are stalling, so you can fix the volume problem while there’s still time in the quarter.

Protect your sales volume by making sure no lead goes cold. Try SalesLama free for 7 days.

Start your free trial
Colleagues reviewing work on a laptop

Fix the pipeline and the volume variance usually fixes itself.

Sales volume variance FAQs

What is the formula for sales volume variance?

(Actual units sold − Budgeted units) × Budgeted price per unit. Some businesses use budgeted contribution margin per unit instead of price to measure the profit impact.

What is the difference between sales volume variance and sales price variance?

Volume variance measures the effect of selling more or fewer units than planned. Price variance measures the effect of selling at a different price than planned. Together they make up the total sales variance.

Is a positive sales volume variance good?

Yes. A positive figure means you sold more units than budgeted, which is favorable.

What causes an unfavorable sales volume variance?

Fewer leads, lower conversion, slow follow-up, stronger competition, falling demand, or an unrealistic budget.

How often should I calculate sales volume variance?

Monthly is a good rhythm for most businesses. It catches problems early enough to act within the quarter.

The sales volume variance takeaway

Sales volume variance answers a simple question: how much of the revenue gap came from selling more or fewer units than planned? Calculate it with budgeted price so it isolates volume, pair it with price variance to see the full picture, and trace any shortfall back through your funnel. Nintendo’s Wii U shows how fast volume can move away from a plan. Reviewing variance monthly, and following up every lead, is how you keep your own numbers close to it. Related reading: TAM SAM SOM market sizing, the 7 sales process steps and CRM and sales enablement tools.

Sources

• Engadget: Nintendo slashes 2014 sales forecast for Wii U from 9 million to 2.8 million (January 17, 2014)
• Dwight D. Eisenhower, remarks at the National Defense Executive Reserve Conference, November 14, 1957. Andrew S. Grove, Only the Paranoid Survive (1996).

SL
Written by

The SalesLama Team

We build SalesLama, the lead automation and management platform that helps sales teams reply fast, follow up on schedule and hand hot leads to the right person. We write practical guides on email, follow-up and sales workflows based on what we see working for our customers.