Don‘t Let Sales Variance Sink Your Revenue Ship

As a sales leader, you‘re the captain of your company‘s revenue ship. You‘ve charted a course, rallied the crew, and set sail with a hold full of sales targets to reach your destination. But along the journey, shifting winds and currents can blow you off course. One of the most pernicious is sales variance – the difference between the sales results you expected and the ones you actually achieved.

Sales variance is a fact of life in any sales organization. Experienced leaders know they‘ll never nail their forecast with perfect precision. But that doesn‘t mean you should just shrug your shoulders and accept whatever variances come your way. In fact, proactively managing sales variance is one of the most powerful levers you have for steering your revenue ship to its goals.

In this post, we‘ll give you everything you need to master the art and science of sales variance analysis. We‘ll dive deep into formulas and examples, root causes and corrective actions, benchmarks and best practices. By the end, you‘ll have a clear understanding of:

• What sales variance is and why it matters
• How to calculate sales price and volume variance
• What causes variances and how to diagnose them
• Strategies and tactics to correct unfavorable variances
• Benchmarks and KPIs for sales variance in different industries
• A step-by-step process to implement sales variance analysis

So batten down the hatches and get ready to decode the DNA of your sales results. Your revenue ship depends on it.

Sales Variance 101

Before we get into the nitty gritty of variance analysis, let‘s define some key terms:

• Sales variance is the umbrella term for any difference between actual and planned sales results. It can refer to revenue, volume, price, mix or margin.

• Sales price variance measures the portion of an overall revenue variance caused by selling at a different price than expected.

• Sales volume variance measures the portion caused by selling more or fewer units than expected.

Together, price and volume are the key drivers of topline revenue. If you sell 100 units at $10 each, that‘s $1000 of revenue. If you sell 110 units at $9 each, that‘s $990. The first scenario has a positive volume variance and the second has a positive price variance, but they end up at roughly the same place.

Things get more complicated when you layer on product mix (the blend of different products you sell), discounting, and other real-world factors. But at its core, sales variance boils down to understanding how many units you sold and how much you sold them for relative to your plan.

Calculating Price and Volume Variance

With those definitions in hand, let‘s look at how to actually crunch the numbers. The basic formulas are straightforward:

Price Variance = (Actual Price – Standard Price) x Actual Volume

Volume Variance = (Actual Volume – Standard Volume) x Standard Price

Where:

• Actual Price is the real average selling price per unit
• Standard Price is the budgeted or expected price per unit
• Actual Volume is the real quantity sold
• Standard Volume is the budgeted or expected quantity

A positive variance means you did better than plan (higher price or volume) while a negative variance means you did worse.

Here‘s a quick example:

Let‘s say you planned to sell 1,000 widgets this quarter at an average price of $100 each, for a total of $100,000 in revenue. But when the dust settled, you actually sold 1,200 widgets at an average price of $90.

Plugging into the formulas:

• Price Variance = ($90 – $100) x 1,200 = -$12,000
• Volume Variance = (1,200 – 1,000) x $100 = $20,000

In this case, you had an unfavorable price variance of -$12K, meaning you realized less revenue than planned due to lower prices. But you made up for it with a favorable volume variance of $20K from selling more units. The net result is $108,000 in actual revenue, $8,000 above your plan.

Simple enough. But as you might imagine, real world sales variance analysis is usually more complex, with many moving pieces to track:

• Multiple products with different prices and volumes
• Regional, channel or segment reporting cuts
• Frequency of measurement – variance can be calculated weekly, monthly, quarterly or annually
• Interdependencies between price and volume (raising prices often reduces volume and vice versa)
• Comparison choices – variances can be calculated relative to different baselines like prior year, budgets, forecasts

The key is to start with the fundamentals and gradually layer on more sophistication as you climb the learning curve. Let‘s look at a few intermediate sales variance concepts.

Mix and Quantity Variance

A common extension to the basic price and volume variance formulas is to split volume variance into two pieces:

• Mix variance due to selling a different blend of products than expected
• Quantity variance due to selling more or less of each product than expected

The formulas get gnarly, so we‘ll spare you the math. But the basic idea is to isolate the impact of product mix shifts on revenue, either positive (shifting to higher priced products) or negative (shifting to lower priced ones).

Here‘s an example:

Say you sell three types of widgets – Basic at $100, Pro at $200, and Premium at $300. You expect to sell 50% Basic, 30% Pro, and 20% Premium. Your plan was for $1M in revenue based on the following mix and quantities:

Product	Price	Plan Qty	Plan Mix	Plan Rev
Basic	$100	500	50%	$50,000
Pro	$200	300	30%	$60,000
Premium	$300	200	20%	$60,000
Total		1000	100%	$170,000

But your actual results come in like this:

Product	Price	Actual Qty	Actual Mix	Actual Rev
Basic	$100	600	60%	$60,000
Pro	$200	250	25%	$50,000
Premium	$300	150	15%	$45,000
Total		1000	100%	$155,000

Your total revenue of $155,000 is below plan by $15,000. The culprit is an unfavorable mix – you sold a higher percentage of low-price Basic and a lower percentage of high-price Premium. The total quantity sold was the same, so your volume variance nets out to zero. Mix variance lets you see how "trading down" in your assortment hurt the top line.

Mix variance analysis is a mainstay for any company with a diverse product portfolio. In some industries it‘s even more important than straight price or volume. Think airlines constantly optimizing their mix of first class vs coach seats, or software companies shifting from on-premise licenses to cloud subscriptions.

Standard Costing and Margin Variance

Another common twist to variance analysis is to compare actual costs to planned "standard costs". This reveals how much of a variance is driven by cost changes vs. price or volume changes.

The formulas mirror the revenue side:

Cost Price Variance = (Actual Unit Cost – Standard Unit Cost) x Actual Volume

Cost Efficiency Variance = (Actual Volume – Standard Volume) x Standard Unit Cost

The variances are favorable if actual costs are lower than planned and unfavorable if higher. You can think of them as measures of production efficiency and economies of scale.

Here‘s a simplified example:

Using the same widget data as before, let‘s say your standard unit costs are $50 for Basic, $100 for Pro, and $150 for Premium. So your planned gross margin was:

Product	Price	Unit Cost	Plan GM	Plan GM%
Basic	$100	$50	$50	50%
Pro	$200	$100	$100	50%
Premium	$300	$150	$150	50%
Total			$85	50%

But when you tally up actual costs, they come in higher than expected:

Product	Actual Price	Actual Cost	Actual GM	Actual GM%
Basic	$100	$60	$40	40%
Pro	$200	$110	$90	45%
Premium	$300	$170	$130	43%
Total			$62	40%

Yikes – overall margins dropped by 10 points! Some quick variance math shows why:

Cost Price Variance:

• Basic = ($60 – $50) x 600 = $6,000
• Pro = ($110 – $100) x 250 = $2,500
• Premium = ($170 – $150) x 150 = $3,000
• Total = $11,500 unfavorable

Cost Efficiency Variance:

• Basic = (600 – 500) x $50 = $5,000
• Pro = (250 – 300) x $100 = ($5,000)
• Premium = (150 – 200) x $150 = ($7,500)
• Total = ($7,500) favorable

In this case, you had an unfavorable cost price variance from your actual unit costs being higher than standard. This was only partially offset by a favorable cost efficiency variance from the total volume being lower than plan (so you spent less overall). Net result was $4,000 of unfavorable cost variance eroding your margins.

Analyzing price, volume and cost variances together gives you a complete picture of what‘s driving your profitability. If you have a big unfavorable cost variance, you know you need to either raise prices, drive costs back down, or both. Many companies calculate variances at the gross margin level for this reason – it tells the whole story.

Putting a microscope on your margins also clarifies the tradeoffs between different growth levers. Maybe you‘re willing to sacrifice price to chase volume. Maybe you‘ll pay higher costs for better products that command premium prices. With variance analysis, you can model out those scenarios and make data-driven decisions.

Benchmarking Sales Variance

Variance analysis isn‘t just an internal exercise – you also need to know how you stack up to competitors and the broader market. That‘s where benchmarking comes in.

The key questions to ask are:

• What are typical price and volume variances in my industry?
• How do my variances compare to direct competitors?
• Are there seasonal, geographic or channel trends to watch out for?
• What are best-in-class companies doing to minimize negative variances?

The answers will vary by sector, but here are some ballpark figures to get you oriented:

Consumer Packaged Goods

• Typical price variance: -2% to +2%
• Typical volume variance: -5% to +5%
• Key trends: Consumers trading down to private label, pricing pressure from retailers

Enterprise Software

• Typical price variance: -5% to -10%
• Typical volume variance: +10% to +20%
• Key trends: Discounting to close Q4 deals, shift from perpetual licenses to SaaS

Manufacturing

• Typical price variance: -1% to +3%
• Typical volume variance: -10% to +10%
• Key trends: Raw materials inflation, supply chain disruptions

Sources: Gartner, McKinsey, Bain & Company

Of course, these are just rough guides. To get true apples-to-apples benchmarks, you need to find companies with similar products, segments, and business models to yours. Many industries have third-party firms that aggregate anonymized sales data to create detailed variance benchmarks. If you have the budget, it‘s well worth the investment.

The gold standard is to integrate competitor and market data right into your own variance dashboards and reports. That way you‘re not only tracking your results vs. plan, but also vs. peers. Seeing those deltas in real-time is incredibly valuable for making pricing and promotional decisions on the fly.

For a real-world parable in the power of benchmarking, look no further than the auto industry. Ford CEO Alan Mulally famously instituted weekly meetings where executives had to report their performance against competitors using a standard set of metrics. The increased transparency and accountability helped Ford avoid bankruptcy and emerge stronger from the 2008 financial crisis.

Bringing It All Together

We‘ve covered a lot of ground in this ultimate guide to sales variance. You should now have the tools and frameworks to:

1. Calculate basic price and volume variances
2. Understand root causes like mix, cost, and efficiency
3. Benchmark your variances against internal and external data
4. Make better decisions to manage variances in real-time

None of this is rocket science – it‘s about applying a few core formulas with rigor and consistency. The hard part is building it into the fabric of your sales operations.

Here‘s a step-by-step playbook to make sales variance a key part of your revenue management system:

1. Define your key metrics and reporting frequency
2. Establish clean data flows from your CRM, ERP, and billing systems
3. Create standardized variance reports and dashboards
4. Train your sales managers on concepts and calculations
5. Set variance targets and triggers for corrective action
6. Review variances in weekly and monthly sales meetings
7. Coach reps on the behaviors that drive positive variances
8. Roll up variances to the executive level for forecasting and planning
9. Rinse and repeat each sales period

The companies that do this well have sales variance analysis in their DNA. Their plans are dynamic and their forecasts are scary accurate. They identify risks and opportunities early and pounce without hesitation. While their competitors are still scratching their heads at the end of the quarter, they‘re already taking action to bend the curve in their favor.

Steering the Ship

Sales will always be part art, part science. The human elements of emotion, relationships, and intuition are essential to great selling. No formula or algorithm can replace them.

But make no mistake, sales is also a numbers game. Routinely missing your revenue or margin targets is a recipe for a short tenure as a sales leader. The more command you have of the underlying math, the more degrees of freedom you have to make savvy decisions.

That‘s what mastering sales variance is all about. With a firm grasp of the mechanics, you can quickly diagnose root causes, stress test what-if scenarios, and prescribe solutions to keep your team on track. You can speak the language of the business with fluency and credibility.

Most important, you can be proactive instead of reactive. You‘re not just reporting the news, but making it. Spotting a softening price trend or a product mix shift gives you precious time to adjust the sails and keep your revenue ship on course and picking up speed. When the headwinds are stiff, variance analysis is your compass, map, and North Star wrapped into one.

Now it‘s time to put these tools to work. Review your latest results and see where your variances are taking you. Compare them to your industry benchmarks and see where you stand. Double click into your biggest deltas and brainstorm ways to attack them.

The wind is always changing out there. But with sales variance analysis as your guide, you can navigate the choppiest waters with confidence. Here‘s to clear skies, following seas, and realized revenue dreams.