Sales

Budget is used as an instrument of planning and control. Hence analyzing the variance to budget is essential. This weekís assignment is to analyze the sales budget variance. The attached excel worksheet has budgeted and actual sales data. It also has template to analyze the sales budget variance. You are expected to input the data and formula in the right column. The columns highlighted in yellow need a formula.

SALES BUDGET VARIANCE REPORT

Budget Actual

Product SaleUnits $/Unit Sales Value in $ SaleUnits $/Unit Sales Value in $

A 750 4.00 3,000 1,100 3.50 3,850

B 750 5.50 4,125 1,000 5.70 5,700

C 750 6.00 4,500 900 6.50 5,850

Total 11,625 Total 15,400

Price Variance

Product Actual Sale Units Budget Price Actual Price Sale Price Variance Price Variance

A

B

C

Volume Variance

Product Actual Sale Units Budget Sale Units Budget Price Sale Unit Variance Volume Variance

A

B

C

Mix Variance

Product Budget Mix Actual Sale at Budget Mix Actual Sale Units Difference Budget Price Mix Variance

A

B

C

Quantity Variance

Product Actual Sale at Budget Mix Budget Sale Units Budget Price Difference in Units Quantity Variance

A

B

C

TAKE ADVANTAGE OF OUR PROMOTIONAL DISCOUNT DISPLAYED ON THE WEBSITE AND GET A DISCOUNT FOR YOUR PAPER NOW!