Variance 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:
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
These articles are intended to provide general resources for the tax and accounting needs of small businesses and individuals. Service2Client LLC is the author, but is not engaged in rendering specific legal, accounting, financial or professional advice. Service2Client LLC makes no representation that the recommendations of Service2Client LLC will achieve any result. The NSAD has not reviewed any of the Service2Client LLC content. Readers are encouraged to contact a professional regarding the topics in these articles. The images linked to these articles are protected by copyright and should not be copied for any reason.
FREE 30-Minute No-Obligation Consultation