Sales Variance Analysis in Accounting

Sales variance analysis is used by managers for identifying and understanding the reasons why the actual sales performance of a business differs from its original budgeted sales.

Sales Variance Formula

The sales variance sometimes referred to as the sales value variance or revenue variance is the difference between the actual sales and the budgeted sales of the business.

The variance is calculated using the total sales variance formula.
Sales value variance = Actual sales – Budgeted sales

If actual sales are greater than budgeted sales the formula gives a positive result and therefore the sales variance is referred to as a favorable sales variance.

In contrast, if actual sales are lower than budgeted sales the formula will give a negative result and the sales variance is said to be unfavorable.

Components of Sales Variance

Furthermore the total sales variance can be split into two main components.

  1. Sales volume variance
  2. Sales price variance

As can be seen the sales value variance is equal to the sum of the sales volume variance and the sales price variance.

sales variance analysis

Sales value variance = Sales volume variance + Sales price variance

Sales Volume Variance Analysis

The sales volume variance results from the actual volume of sales being different from the budgeted volume of sales. The variance is calculated by taking the difference between the actual sales volume and the budgeted sales volume and multiplying this by the budgeted price to give a monetary amount.

The sales volume variance formula is as follows.

Sales volume variance = (Actual volume – Budgeted volume) x Budgeted price

It should be noted that the term standard is also used when referring to unit prices, so budgeted price in the above formula could be replaced with the term standard price.

If actual volume is greater than budgeted volume the sales volume formula gives a positive result and the sales volume variance is a favorable variance. If actual volume is lower than budgeted volume the formula will give a negative result and the sales volume variance is said to be unfavorable.

The sales volume variance can be further split into the sales mix and quantity variances.

Sales Price Variance Analysis

The sales price variance results from the actual price of a sales unit being different from the budgeted (or standard) price. The variance is calculated by taking the difference between the actual price and the budgeted price and multiplying this by the actual sales volume to give a monetary amount.

The sales price variance formula is as follows.

Sales price variance = (Actual price – Budgeted price) x Actual volume

Again the term standard price could be used instead of budgeted price in the formula above.

If the actual price is greater than the budgeted price the formula gives a positive result and the sales price variance is a favorable variance. If the actual price is lower than the budgeted price the formula will give a negative result and the sales price variance is said to be unfavorable.

Sales Variance Example

A business provides the following information relating to its sales.

Sales information
UnitsPrice
Actual sales13,5005.50
Budgeted sales15,0004.80

How to Calculate Sales Volume Variance

The sales volume variance is calculated as follows.

Sales volume variance = (Actual volume - Budgeted volume) x Budgeted price
Sales volume variance = (13,500 - 15,000) x 4.80
Sales volume variance = -1,500 x 4.80 = -7,200

The sales volume variance formula shows that the variance is negative and therefore an unfavorable variance. The actual volume (13,500) is less than the budgeted volume (15,000) by 1,500 units.

When multiplied by the budgeted price (4.80) the sales volume variance is determined as -7,200.

How to Calculate Sales Price Variance

The sales price variance is calculated as follows.

Sales price variance = (Actual price - Budgeted price) x Actual volume
Sales price variance = (5.50 - 4.80) x 13,500
Sales price variance = 0.70 x 13,500 = 9,450

The sales price variance formula shows that the variance is positive and therefore a favorable variance. The actual price (5.50) is greater than the budgeted price (4.80) by 0.70 per unit.

When multiplied by the actual volume 13,500 the sales price variance is determined as 9,450.

How to Calculate Sales Variance

The total sales variance or sales value variance is calculated as follows.

Sales variance = Actual sales - Budgeted sales
Sales variance = Actual volume x Actual price - Budgeted volume x Budgeted price.
Sales variance = 13,500 x 5.50 - 15,000 x 4.80
Sales variance = 74,250 - 72,000 = 2,250

The sales variance formula shows that the variance is positive and therefore a favorable variance. The actual sales (74,250) are greater than the budgeted sales (73,000) by 2,250.

Total Sales Variance Proof

The total sales variance should equal the sum of the sales price and sales volume variances.

Sales variance = Sales volume variance + Sales price variance
Sales variance = -7,200 + 9,450 = 2,250

The total sales variance is 2,250 the same as calculated above using the sales variance formula.

Last modified October 14th, 2022 by Michael Brown

About the Author

Chartered accountant Michael Brown is the founder and CEO of Double Entry Bookkeeping. He has worked as an accountant and consultant for more than 25 years and has built financial models for all types of industries. He has been the CFO or controller of both small and medium sized companies and has run small businesses of his own. He has been a manager and an auditor with Deloitte, a big 4 accountancy firm, and holds a degree from Loughborough University.

You May Also Like