• Understanding How Variances Vary

    Posted Date February 1, 2024 Posted Time 12:00 pm Published in

    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


    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.


Copyrights @ 2024 James O. Taylor