Scroll Top

Understanding How Variances Vary

how to calculate VariancesVariance analysis is found by determining the difference between what was budgeted and what actually occurred. Additionally, when variances are added together, we get a better picture of how well a company is measuring its performance against expected metrics. It’s also important to be mindful that each metric is measured to determine what the actual cost is versus the industry’s standard cost.

Whether it’s materials, labor, electricity, or another metric, if the actual cost is lower than the standard cost for the same quantity of materials, it would be a favorable price variance. However, if the number of materials was more than the standard quantity, it would be considered an unfavorable variance. Examining variance allows us to analyze the price and quantity of the variable being analyzed. Always keep in mind that unusual or significant variances should be investigated to see why such anomalies exist.

It’s important to distinguish between variances and the types of inputs. When it comes to materials, labor, and similar variable overhead, variances to be analyzed are for price and quantity/efficiency. When it comes to fixed overhead, analysis looks at variances in budget and volume.

One way to conduct variance analysis is through the Column Method. The following example illustrates this:

A business produces widgets. The following assumptions are made:

  • 6,000 widgets are produced in a month
  • Direct labor hours are used as the basis to allocate overhead costs to products
  • Denominator level of activity is 8,060 hours, resulting in $48,360 in fixed overhead expenses budgeted.

Other cost assumptions include:

Direct Costs

Labor: 2.6 hours/widget @ $14 per hour

Materials: 10 pieces/widget @ $1/widget

Overhead

Variable: 2.6 hours/widget @ $8/hour

Fixed: 1.3 hours /widget @ $12/hour

However, the business saw the following costs for the month’s production:

Variable overhead manufacturing costs: $34,000

Fixed overhead manufacturing costs: $50,000

Both of the following are Direct Costs:

Material: 50,000 items bought @ $0.96/widget

Labor: 8,000 hours totaling $128,000

Materials Variance

Real Quantity x Real Price = 50,000 pieces x $0.96 per widget = $48,000

Real Quantity x Industry Price = 50,000 pieces x $1 per widget = $50,000

Standard Quantity x Industry Price = 36,000 pieces x $1 per widget = $36,000

Price Variance = $50,000 – $48,000 = $2,000

Quantity Variance = $50,000 – $36,000 = $14,000

When we find the difference between these two amounts, there’s an unfavorable variance of $12,000. Additionally, it’s worth looking at why there were 50,000 pieces used versus the standardized 36,000 pieces. It could be due to defective materials, problematic machinery, etc.

Labor Variance

Real Hours x Real Rate = 8,000 hours x $16 per hour = $128,000

Real Hours x Industry Rate = 8,000 x $14 per hour = $112,000

Standard Hours x Industry Rate = 7,800 x $14 hour = $109,200

Rate Variance = $112,000 – $128,000 = -$16,000

Efficiency Variance = $109,200 – $112,000 = -$2,800

Based on this calculation, there’s a total unfavorable variance of -$18,800. Management should look at why labor costs are higher than the standard and why production took more supplies than the industry standard.

While this is not all-encompassing, it does show the importance of understanding the nuances of calculating variances and how it’s essential to understanding a business’ (in)efficiency.


Disclaimer 

Leave a comment