Volume Variance

Publication Date :

Blog Author :

Download FREE Volume Variance Excel Template and Follow Along!
Volume Variance Excel Template.xlsx

Table Of Contents

arrow

What is Volume Variance?

Volume Variance is an assessment tool that checks if there is a difference in actual quantity consumed or sold and its budgeted quantities. It is usually expressed in monetary terms by multiplying the difference between the two with the standard price per unit. The volume variance is considered favorable if the actual number of units consumed is lower than the standard number of units required as raw materials. On the other hand, if the actual number of units consumed is more than the standard number of units, it is considered unfavorable or adverse.

Volume Variance
You are free to use this image on your website, templates, etc.. Please provide us with an attribution link

How to Calculate Volume Variance?

It can be calculated by using the following steps:

Step 1:  Firstly, determine the actual number of units consumed in material yield variance or the actual number of units sold in case of sales volume variance.

Step 2: Next, determine the budgeted number of units planned for consumption in case of material yield variance or the budgeted number of units planned to be sold in case of sales volume variance.

Step 3: Next, calculate the Variance in the number of units consumed by the actual number of units (step 1) from deducting the budgeted number of units (step 2) for material yield variance. On the other hand, the Variance in the number of units sold by deducting the budgeted number of units (step 2) from the actual number of units (step 1) for sales volume variance.

Step 4: Next, determine the budgeted cost per unit and budgeted price per unit for material yield variance and sales volume variance, respectively.

Step 5: Finally, the formula for material yield variance can be calculated by multiplying the Variance in the number of units consumed (step 3) and the budgeted cost per unit (step 4), as shown below,

Material yield variance = (Budgeted no. of units consumed - Actual no. of units consumed) x Budgeted cost per unit.

The formula for sales volume variance can be calculated by multiplying the variance in the number of units sold (step 3) and the budgeted price per unit (step 4) as shown below,

Sales Volume Variance = (Actual no. of Units Sold - Budgeted no. of Units Sold) * Budgeted price per unit.

🎓 Unlock Strategic FP&A Skills for Career Growth!

Elevate your financial acumen with WallStreetMojo’s Financial Planning & Analysis Course- Designed for aspiring FP&A professionals, this program offers over 11 hours of expert-led video tutorials covering budgeting, forecasting, cost management, and advanced financial modeling. Enhance your proficiency in Excel and automation tools to streamline financial planning processes. Learn through real-world case studies and gain insights into the role of FP&A in mergers, acquisitions, and investment strategies. Upon completion, earn a prestigious certificate to bolster your resume and career prospects.

Learn More →

Examples

Let us understand the examples.

Example #1

Let us take the example of a manufacturing unit to illustrate the concept of material yield variance. As per the industry benchmark, the unit estimated that it would require 100 tons of limestone at $75 per kg for the previous month. However, the unit used only 95 tons during the month. Therefore, determine the material yield variance in this case.

Given,

  • Budgeted no. of units consumed = 100 tons
  • Actual no. of units consumed = 95 tons
  • Budgeted cost per unit = $75 * 1000 = $75,000 per ton

Volume Variance Example 1

Therefore, the material yield variance for the previous month can be calculated as,

Volume Variance Example 1-1

  • = (100 – 95) * $75,000
  • = $375,000

Therefore, the material yield variance was $375,000 favorable.

Example #2

Let us take the example of a departmental store to illustrate the concept of sales volume variance. The store estimated that it would be able to sell 4,000,000 bottles of mineral water during the Q2FY19 at an estimated price of $1.10 per bottle. The budget was based on the sales volumes achieved during the last few quarters. However, when the real results of the quarter unfolded, the store realized it would achieve sales of 3,500,000 bottles. Determine the sales volume variance in this case.

Given,

  • Budgeted no. of units sold = 4,000,000
  • Actual no. of units sold = 3,500,000
  • Budgeted price per unit = $1.10

Volume Variance Example 2

Therefore, the sales volume variance for Q2FY19 can be calculated as,

Volume Variance Example 2-1

  • = (3,500,000 – 4,000,000) * $1.10
  • = -$550,000
Financial Planning & Analysis Course
Master the essentials of financial planning and analysis with our comprehensive course. Delve into key topics such as capital budgeting, cost accounting, financial forecasting, and ratio analysis. Benefit from practical case studies, downloadable Excel templates, and one year of unlimited access to course materials. This course is ideal for finance students, professionals, and business consultants aiming to enhance their FP&A skills and make informed financial decisions.
Learn More →

When can it Arises?

A volume variance arises only when a business decides the budgeted plan based on theoretical standards, which are practically not achievable due to various operational shortcomings. However, It can be avoided by setting budgeted plans according to attainable standards, wherein all the operational challenges are accounted for with reasonable assumptions.

Advantages

Some of the major advantages are as follows:

  • It can set standards for cost, price, and quantity.
  • It facilitates management review of operational performance vis-à-vis budget.
  • It helps investigate the root cause for variation in the contribution and profitability of a business.

FP and A.png