Sales Price Variance calculation formula

Sales variance is the difference amid authentic sales and financial plan sales. It is used to calculate the performance of a sales function, and/or investigate transaction results to better understand advertise conditions.

There are two reasons authentic sales can vary from designed sales: Either the volume sold varied from mean (sales volume variance), or sales were next to a discrete set a price from come again? Was designed (sales set a price variance). Both scenarios can furthermore in chorus be part of the cause to the variance.

For illustration: The mean was to sell like hot cakes 5 widgets next to $3 apiece, representing a budgeted sales of: (5*$3)=$15. During certainty, 6 widgets were sold next to $2 apiece, representing an authentic sales of: (6*$2)=$12. The out-and-out variance was therefore ($12-$15)=$3 (U)nfavourable or minus $3, since out-and-out sales was a reduced amount of than designed.
Sales set a price variance

Sales Price Variance: The sales set a price variance reveals the difference in out-and-out revenue caused by charging a discrete advertising set a price from the designed or standard set a price. The sales set a price variance is calculated as: Actual quantity sold * (actual advertising set a price - designed advertising price). During the illustration, the sales set a price variance was 6*($2-$3)= -$6 (U)nfavourable or minus $6, since the sales set a price was a reduced amount of than designed.
Sales volume variance

Sales Volume Variance is calculated as: Budgeted distinctive merchandise contribution margin for every unit*(actual sales volume-budgeted sales volume)

Sales Volume Variance is foster sub-divided into two variances.

    Sales Mix Variance
    Sales Quantity Variance

Total variance

The out-and-out variance can therefore be seen algebraically to be (minus $6) plus (plus $3), giving (minus $3). Or: -6+3=-3.

This effect tells us to facilitate the unconstructive effect of advertising next to a sink set a price was twice the upbeat effect of advertising next to a senior volume than designed. This might own occurred wherever prices were lowered to spread volume, but authentic volume increases did not touch expectations, perhaps due to competitors furthermore callous their prices, or changes in customer preferences.

Share This
Previous Post
Next Post