Understanding Sales Variance Formula + Examples

This formula is applied in situations where variable costing approach is used. This formula is applied in situations where absorption costing approach is used. The turnover method is used more frequently but the profit method is more informative.

Sales Quantity Variance Formula

As this method does not consider the cost variances, all costs are assumed to be standard costs. It helps businesses optimize their sales, marketing, and production strategies to maximize future profits. An unfavorable quantity variance occurs when the budgeted sales are more than actual sales at the standard mix, meaning that the company earned less contribution than expected.

Contents

During this sales period, your company sells all 100 potted pothos plants for $35. Using the formula, we can calculate the sales variance for the potted pothos plants. Sales quantity variance analysis is a powerful tool for analyzing sales performance, but it has limitations. Sales volume variance and sales quantity variance are two different types of metrics used when measuring the performance of a business’s sales strategy.

Add variances of both commodities:

• It wants to know whether its projected sales for the launch of a new product were accurate.
• However, we need to still calculate it, as well as the two sub Volume variances, which are Quantity and Mix.
• If the actual price attained is more than the standard price, the variance shall be favourable and vice-versa.
• The method shows the effect of changes in sales quantities and/or selling price on the profit expected by a company from its sales.
• It is the difference between actual and expected unit selling price multiplied by actual quantity.
• When the sales quantity variance is negative, it is an unfavorable variance.

In fast-paced technological environments, it is highly unlikely to gain access to successful standard inside data. It is that portion of total sales margin variance which is due to the difference between standard profit and budgeted profit. This method of sales variances measures the effect of actual sales and budgeted sales on profit.

Sales Mix Variance

(b) Sales Quantity Variance- It is that part of sales volume variance which arises due to the difference between revision of a standard sales quantity and budgeted sales quantity. It is to be noted here that both budgeted profit and actual profit are calculated on the basis of standard cost (It is to be noted that actual cost is not taken into consideration for calculation of actual profit). Under this method all variances are calculated on the basis of sales margin /profit.

• In other words, it is the difference between actual and expected profit per unit multiplied by actual quantity sold.
• On the other hand, when the sales quantity variance is favorable, the organization is on the right track.
• He has been a manager and an auditor with Deloitte, a big 4 accountancy firm, and holds a degree from Loughborough University.
• 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.
• In a multi-product business the sales volume variance can be separated into sales mix and quantity variances.
• This will leave you with either a positive number (indicating a favorable sales variance) or a negative number (indicating an adverse variance).
• Sales quantity variance analysis is a useful tool for businesses looking to gain insight into the effectiveness of their sales strategies.

Using the formula, we can calculate sales volume variance for the music service subscription. Sales volume variance measures the difference between expected units sold and actual units sold. There is always a variance between the estimate and actual sales, but we try to reduce it to the minimum level.

If you’ve exceeded your forecast’s expectations, it could mean there’s a bigger demand for your product than you thought, or that new sales activities within your team have had beneficial effects. Research on competitor products could show there’s room to increase your sales price while still remaining more affordable than the competition. Calculating sales variance for the products your company offers is a worthwhile activity for each sales period to ensure you are on track with your revenue goals.

By understanding what each type can tell you about your own business you can use them together to maximize profits and gain detailed insights into customer behavior over time. This step involves calculating the number of units of each commodity that should have been sold to achieve the targeted profit. The example uses data for 2017 and 2018 (current year vs last year) to calculate the variances. However, if you are trying to calculate variances versus budget, simply replace last year (2017) with Budget data and the calculation will work just fine.

The overall increase of $268 in Profit margin can be clearly explained with Price increase resulting in fav. It is that portion of Sales Value Variance which arises due to the difference between the actual price and standard price of sales. If the actual price attained is more than the standard price, the variance shall be favourable and vice-versa. The variance of $750 (F) arises due to a difference between the budgeted and actual profit. A company sells coffee tables as well as dining tables and earns a standard profit per unit of $25 and $50 on each type of table respectively. Sales volume variance is an excellent way to feed sales results back into your larger data collection sales quantity variance efforts.

It is that portion of sales margin volume variance which is due to the difference between the budgeted profit and revised standard profit. 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.