# Variance Analysis Formula with Example

Variance analysis formula is the key to prepare variance analysis reports. For each type of variance, there is a plug and play variance formula to calculate. Variance analysis refers to the investigation of the reasons for deviations in the financial performance from the standards set by an organization in its budget. It helps the management to keep control on its operational performance.

## Types of Variance Analysis Formula

1. Material Variance – (Sub-Categories – Price and Usage Variance)
2. Labour Variance – (Sub-Categories – Rate and Efficiency Variance)
3. Variable Overhead Variance – (Sub-Categories – Efficiency and Expenditure Variance)
4. Fixed Overhead Variance – (Sub-Categories – Expenditure and Volume Variance)
5. Sales Variance – (Sub-Categories – Volume and Price Variance)

Now, let us look at the scenario of a company, say A, having the following standard and actual figures:

 Standard / Budgeted Actual Price \$ 10 per kg. \$ 8 per kg. Quantity 200 kgs. 150 kgs. Hours 250 300 Rate \$8 \$7 Output 100 kgs. 80 kgs. FOH Rate per hour \$12 \$11.67 FOH Rate per unit \$30 \$43.75 FOH \$3000 \$3500 Sales Price per unit 50 65

## Material Variance

The difference between the standard cost of direct materials and the actual cost of direct materials that an organization uses for production is known as material cost variance.

### Material Cost Variance Formula

Standard Cost – Actual Cost

In other words, (standard quantity for actual output x standard Price) – (Actual Quantity x Actual Price)

= {(200 x 80/100**)} x 10) – (150 x 8)

= (160 x 10) – (150 x 8) = 400 (Favorable)

** 80/100 is multiplied with standard quantity (200 Kgs) to adjust the standards as per the actual output levels. All the standard figures are mentioned for an output of 100 Kgs. Whereas, the actual output is 80 kgs. As per standards, we can see that 200 Kgs of Raw Material is required for producing 100 Kgs of output, making a yield of 50% (100 Kgs / 200 Kgs). In the actual situation, the yield is different i.e., 53% (80 kgs / 150 Kgs). In other words, if the actual output would have been 100 Kgs in place of 80 kgs, 160 (200 * 80 / 100) would have been the material quantity.

Material Variance is further sub-divided into two heads:

#### Material Price Variance

MPV = (Standard Price – Actual Price) x Actual Quantity

= (10 – 8) x 150 = 300 (Favorable)

#### Material Usage Variance

MUV = (Standard Quantity for actual output – Actual Quantity) x Standard Price

= (160 – 150) x 10 = 100 (Favorable)

## Labor Variance

It arises when there is a difference between the actual cost associated with a labor activity from the standard cost.

### Labor Variance Formula

Standard Wages – Actual Wages

In other words,

(Standard Hours for actual output x Standard Rate Per Hour) – (Actual Hours x Actual Rate Per Hour)

= {(250 x 80 /100) x 8} – (300 x 7)

= (200 x 8) – (300 x 7) = 500 (Adverse)

Labor Variance is further sub-divided into two heads:

#### Labor Rate Variance

LRV = (Standard Rate Per Hour – Actual Rate Per Hour) x Actual Hours

= (8 – 7) x 300 = 300 (Favorable)

#### Labor Efficiency Variance

LEV = (Standard Hours for Actual Out Put – Actual Hours) x Standard Rate

= (200 – 300) x 8 = 800 (Adverse)

A variance that arises due to the difference between the actual variable overhead and the standard variable overhead based on budgets are termed as a variable overhead variance.

In other words, (Standard Rate – Actual Rate) x Actual Output

= (8 – 7) x 80 = 80 (Favorable)

Similar to other variances, a variable overhead variance is further sub-divided into two heads:

VOEV = (Actual Output – Standard Output) x Standard Rate

= (80 – 100) x 8 = 160 (Adverse)

VOEV = (Standard Output x Standard Rate) – (Actual Output x Actual Rate)

= (100 x 8) – (80 x 7) = 240 (Favorable)

It arises when there is a difference between the standard fixed overhead for actual output and the actual fixed overhead.

= (Actual Output x Standard Rate per unit) – Actual Fixed Overhead

= (80 x 30) – 3500 = 1100 (Adverse)

= 3000 – 3500 = 500 (Adverse)

FOVV = (Actual Output x Standard Rate per unit) – Standard Fixed Overhead

= (80 x 30) – 3000 = 600 (Adverse)

## Sales Variance

This variance is the difference between the actual sales and budgeted sales of an organization.

### Sales Variance Formula

= (Budgeted Quantity x Budgeted Price) – (Actual Quantity x Actual Price)

= (100 x 50) – (80 x 65) = 200 (Favorable)

Similar to other variances, sales variance is further sub-divided into two heads:

#### Sales Volume Variance

SVV = (Budgeted Quantity – Actual Quantity) x Budgeted Price

= (100 – 80) x 50 = 1000 (Adverse)

#### Sales Price Variance

SPV = (Budgeted Price – Actual Price) x Actual Quantity

= (50 – 65) x 80 = 1200 (Favorable)

## Conclusion

Thus, correct knowledge and understanding of variance analysis formula is important to analyze the difference between the actual and planned behavior of an organization. If such analysis is not carried out at regular intervals, it may cause a delay in the management action to control its costs. 1,2

Sanjay Borad is the founder & CEO of eFinanceManagement. He is passionate about keeping and making things simple and easy. Running this blog since 2009 and trying to explain "Financial Management Concepts in Layman's Terms".

### International Business Strategy – All You Need to Know

International Business Strategy refers to the plans that guide the actions of a company that sells its products and services outside its home country. It

### International Business Environment – All You Need to Know

International Business Environment, or IBE, is basically the environment in which a company conducts its business. IBE plays a critical role in the success and

### International Business – Issues and Challenges

International business means producing and selling goods and services between/amongst various countries. A business is said to be international if it produces in its home

International business means taking the business beyond the boundary of a country. Or, in simple words, it means selling your product or service in other

OUR LATEST POSTS

###### International Business Strategy – All You Need to Know

International Business Strategy refers to the plans that guide the actions of a company that sells its products and services outside its home country. It

###### International Business Environment – All You Need to Know

International Business Environment, or IBE, is basically the environment in which a company conducts its business. IBE plays a critical role in the success and

###### International Business – Issues and Challenges

International business means producing and selling goods and services between/amongst various countries. A business is said to be international if it produces in its home

International business means taking the business beyond the boundary of a country. Or, in simple words, it means selling your product or service in other

### 5 thoughts on “Variance Analysis Formula with Example”

1. where 80/100 comes from on standard cost of material

• The same question has been replied above and in the content too. Please refer.

2. I don’t understand where the 80/100 is coming from please explain

• 80/100 is inserted there to adjust the standards as per the actual outputs. The content is 100% correct. But for the sake of a detailed explanation, we have added a detailed note there. You can go through it.

Related Posts

International Business Strategy refers to the plans that guide the actions of a company that sells its products and services outside its home country. It

International Business Environment, or IBE, is basically the environment in which a company conducts its business. IBE plays a critical role in the success and

International business means producing and selling goods and services between/amongst various countries. A business is said to be international if it produces in its home

International business means taking the business beyond the boundary of a country. Or, in simple words, it means selling your product or service in other

Latest Posts