Variance Analysis

Analysis of the difference between planned and actual numbers

Over 1.8 million professionals use CFI to learn accounting, financial analysis, modeling and more. Start with a free account to explore 20+ always-free courses and hundreds of finance templates and cheat sheets.

What is Variance Analysis?

Variance analysis can be summarized as an analysis of the difference between planned and actual numbers. The sum of all variances gives a picture of the overall over-performance or under-performance for a particular reporting period. For each item, companies assess their favorability by comparing actual costs to standard costs in the industry.

For example, if the actual cost is lower than the standard cost for raw materials, assuming the same volume of materials, it would lead to a favorable price variance (i.e., cost savings). However, if the standard quantity was 10,000 pieces of material and 15,000 pieces were required in production, this would be an unfavorable quantity variance because more materials were used than anticipated.

Revenue Variance Analysis Template Screenshot

Learn variance analysis step by step in CFI’s Budgeting and Forecasting course.

The Role of Variance Analysis

When standards are compared to actual performance numbers, the difference is what we call a “variance.” Variances are computed for both the price and quantity of materials, labor, and variable overhead and are reported to management. However, not all variances are important.

Management should only pay attention to those that are unusual or particularly significant. Often, by analyzing these variances, companies are able to use the information to identify a problem so that it can be fixed or simply to improve overall company performance.

Types of Variances

As mentioned above, materials, labor, and variable overhead consist of price and quantity/efficiency variances. Fixed overhead, however, includes a volume variance and a budget variance.

Materials Variance Analysis

Learn variance analysis step by step in CFI’s Budgeting and Forecasting course.

The Column Method for Variance Analysis

When calculating for variances, the simplest way is to follow the column method and input all the relevant information. This method is best shown through the example below:

XYZ Company produces gadgets. Overhead is applied to products based on direct labor hours. The denominator level of activity is 4,030 hours. The company’s standard cost card is below:

Direct materials: 6 pieces per gadget at $0.50 per piece

Direct labor: 1.3 hours per gadget at $8 per hour

Variable manufacturing overhead: 1.3 hours per gadget at $4 per hour

Fixed manufacturing overhead: 1.3 hours per gadget at $6 per hour

In January, the company produced 3,000 gadgets. The fixed overhead expense budget was $24,180. Actual costs in January were as follows:

Direct materials: 25,000 pieces purchased at the cost of $0.48 per piece

Direct labor: 4,000 hours were worked at the cost of $36,000

Variable manufacturing overhead: Actual cost was $17,000

Fixed manufacturing overhead: Actual cost was $25,000

Materials Variance

Example of Materials Variance Analysis

Adding these two variables together, we get an overall variance of $3,000 (unfavorable). It is a variance that management should look at and seek to improve. Although price variance is favorable, management may want to consider why the company needs more materials than the standard of 18,000 pieces. It may be due to the company acquiring defective materials or having problems/malfunctions with machinery.

Labor Variance

Example of Labor Variance Analysis

Adding the two variables together, we get an overall variance of $4,800 (Unfavorable). This is another variance that management should look at. Management should address why the actual labor price is a dollar higher than the standard and why 1,000 more hours are required for production. The same column method can also be applied to variable overhead costs. It is similar to the labor format because the variable overhead is applied based on labor hours in this example.

Learn variance analysis step by step in CFI’s Budgeting and Forecasting course.

Fixed Overhead Variance

Example of Fixed Overhead Variance Analysis

Adding the budget variance and volume variance, we get a total unfavorable variance of $1,600. Once again, this is something that management may want to look at.

Download the Free Template

Enter your name and email in the form below and download the free template (from the top of the article) now!

Variance Analysis Template

Download the free Excel template now to advance your finance knowledge!

The Role of Standards in Variance Analysis

In cost accounting, a standard is a benchmark or a “norm” used in measuring performance. In many organizations, standards are set for both the cost and quantity of materials, labor, and overhead needed to produce goods or provide services.

Quantity standards indicate how much labor (i.e., in hours) or materials (i.e., in kilograms) should be used in manufacturing a unit of a product. In contrast, cost standards indicate what the actual cost of the labor hour or material should be. Standards, in essence, are estimated prices or quantities that a company will incur.

Related Reading

This has been CFI’s guide to Variance Analysis. To help you advance your career, check out the additional CFI resources below:

0 search results for ‘