This Variance is also called Sales revenue variance. This is the net variance of sales as a whole. It is the difference between budgeted sales and actual sales.
The formula for computing this variance is:
Sales Value Variance = Actual Sales – Budgeted Sales
If actual sales are more than the budgeted sales a favourable variance would be reported and vice versa. This variance is on account of difference in price or volume of sales. It is further subdivided into two variances as – (i) Sales price variance and (ii) Sales volume variance.
(i) Sales Price Variance
This variance measures the impact of change in selling price on the turnover as a whole. It is measured by the difference between Standard sales and Actual sales.
The formula is:
Sales Price Variance =
Actual Quantity Sold X (Actual Selling Price – Standard Selling Price)
Sales Price Variance = Actual Sales – Standard Sales
(ii) Sales Volume Variance
This variance measures the impact of changes in quantum of products sold. Sales volume variance is the difference between the standard sales and budgeted sales. If the standard sales are more than the budgeted sales, it gives rise to favourable variance and vice versa. The formula is:Sales Quantity Variance =
Sales Volume Variance = Standard Sales – Budgeted Sales.
= Standard Price X (Budgeted Quantity – Actual Quantity)
Standard Sales = Standard Price X Actual Sales
This variance may arise due to unexpected competition, ineffective advertising, lack of proper supervision, etc.
In the case of multi product situations, Sales Volume Variance can be further subdivided into (i) Sales Quantity Variance and (ii) Sales Mix Variance. These two sub-variance can be calculated as follows:
(i) Sales Quantity Variance
It is the difference between the Budgeted Sales and Revised standard sales. The formula is:
Sales Quantity Variance = Revised Standard Sales – Budgeted Sales
= (Revised Standard Quantity – Budgeted Quantity) X Std. Price
RSQ = Total actual Quantity X Standard Ratio of Units
(ii) Sales Mix Variance
This variance arises when the proportion of actual sales mix. It is the difference between Revised Standard Sales and Standard Sales. The formula is:
Sales Mix Variance = Actual Sales – Revised Sales
= (Actual Quantity – Revised Standard Quantity) Std. price of each product
RSQ = Total Actual Quantity X Standard Ratio of units
Sales Value Variance = Price Variance + Volume Variance
Sales Volume Variance = Sales Mix Variance + Sales Quantity Variance
Sales Margins or Profit Variances Method
These can also be called profit variances, as sales margin is nothing but profit. Now, this variance is very essential as management takes key decisions based on profitability. Individually the cost variances or revenue variance (sales variances as based on turnover) cannot convey any clear meaning. But profit variances do so.
Sales Margin Variance
This can also be called as ‘Overall profit variance’. This represents the difference between the Budgeted Sales margin or Budgeted Profit and Actual Sales Margin or Actual Profit. The formula is:
Sales Margin Variance = Budgeted Sales Margin – Actual Sales Margin
Sales Margin Variance can be subdivided into:
1) Sales Price Variance and
2) Sales Volume Variance
1. Sales Price Variance (Based as Margins)
This variance arises due to the difference between the Standard Price of quantity of sales and actual price of sales. In other words, it is the difference between Standard Profit and Actual Profit.
Sales Price Variance = Standard Profit – Actual profit
= Actual Quantity (Standard Profit per unit – Actual Profit per unit)
Std. profit = A.Q X Std. profit per unit
If the actual profit is greater than the standard profit, the variance is favourable and vice versa. This variance can arise due to the following reasons:
1) Rise in price levels net anticipated earlier
2) Fall in price due to availing discounts and bulk buying
3) Intense competition not foreseen earlier
2. Sales volume Variance (based on Margins)
This variance arises due to quantity of goods being sold differing from quantity of goods budgeted to be sold. Now this can arise due to
- Intense competition unforeseen earlier or inefficiency of sales personnel
Symbolically this can be represented as:
Sales Volume Variance = Standard profit per unit (Standard Quantity – Actual Quantity)
If the actual quantity is greater than standard quantity, the variance is favourable and vice versa. This variance can be further sub-divided in case of multi-product selling units into:-
1) Sales Quantity variance
2) Sales Mix Variances
(i) Sales Quantity Variance
This is the difference between budgeted profit and revised standard profit.
Sales Quantity Variance =
Standard profit per unit X (Standard quantity – Revised Standard Quantity)
RSQ = Total AQ X Standard ratio
If RSQ is greater than SQ, the variance is favourable and vice versa.
(ii) Sales Mix Variance
This arises due to the proportion of these items constitution the standard mix different from the actual proportion. It is difference between Revised Standard Profit and Standard Profit.
Sales Mix Variance =
Standard Profit per unit X (Revised Standard quantity – Actual quantity)
If the actual quantity is more than RSQ, the variance is favourable and vice versa.
A toy company gives you the following data for a month. You are required to calculate the variance based on profit?
|Quantity||Rate||Cost per unit||Quantity||Rate|
Statement of Budged Profit and Actual Profit per unit
|Toy||SQ||SP ($)||Total sales ($)||Cost per unit ($)||Total cost unit ($)||Profit per unit ($)||Total profit ($)|
Revised Standard Quantity (RSQ) = Total Actual Quantity X Std. Ratio
= 2800 X (18:13:24)
A = 2800 X ----- = 916
B = 2800 X ----- = 662
C = 2800 X ----- = 1222
1) Sales Margin Variance = Budgeted Profit – Actual Profit
|Toy||Budgeted Profit ($)||Actual Profit ($)||Variance ($)|
2) Sales Price Variance = Standard Profit – Actual Profit
Standard Profit = Actual Quantity X Profit per unit
|Toy||Standard Profit ($)||Actual Profit ($)||Variance ($)|
3) Sales Volume Variance =
Standard Profit per unit X (Standard Quantity – Actual Quantity)
|Toy||Std. profit X Std. quantity ($)||Actual Quantity ($)||Variance ($)|
|A||5 X 900||1000||500 (F)|
|B||15 X 650||700||1000 (F)|
|C||10 X 1200||1100||1000 (A)|
4) Sales Quantity Variance =
Standard profit per unit X (Standard Quantity – Revised Standard Quantity)
|Toy||Std. profit X Std. quantity||RSQ||Variance ($)|
|A||5 X 900 -||916||80 (F)|
|B||15 X 650 -||662||180 (F)|
|C||10 X 1200 -||1222||220 (F)|
II Sales Mix Variance =
Standard profit per unit X (Revised standard quantity – actual quantity)
|Toy||Std. profit ($) X||Revised std. quantity -||Actual quantity|
Sales Volume Variance = Sales Quantity Variance + Sales Mix Variance
250 (F) = 480 (F) + 230 (A)
Sales Margin Variance = Sales Price Variance + Sales Volume Vaiance
5050(F) = 4800 (F) + 250 (F)
To Schedule a Accounting Sales Value Variance tutoring session click here