LALI Business Consulting Pty Ltd

Buidling better business for today and the future

Variance analysis: Sales variance

Sales variance analysis is an important tool to manage and monitor the performance of the sales function of your business. It also used tool to analyse business results to better understand market conditions.

Sales variance analysis involve comparing the actual sales of a period to that of another or the actual sales to budgeted (planned) sales.

There are two reasons actual sales can vary from previous period sales: either the sales were at a different price from what was in the previous period (sales price variance), or the volume sold varied from previous period (sales volume variance). Both scenarios could also simultaneously contribute to the variance.

Sales price variance:

The sales price variance reveals the difference in total revenue caused by charging a different selling price from one period to another.

Price variance = (Price charged now – Price charged previously) x Qty sold this period

Sales volume variance:

The sales price variance reveals the difference in total revenue caused by changes in the quantities sold in different periods.

Volume variance = ( Qty sold in this period – Oty sold in previous period) x Price charged now

Using the variance analysis report, businesses can evaluate the financial risk to the company should those trends continue. Another is to address the reasons behind the significant variances identified in the variance analysis report.

A follow up to both of those steps may be to create new targets for performance improvement.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s


This entry was posted on 04/01/2012 by in Business Analysis.



Error: Twitter did not respond. Please wait a few minutes and refresh this page.

%d bloggers like this: