Explaining the impact of Sales Price, Volume, Mix and Quantity Variances on Profit Margin Current year vs Last Year

To combat this, rather than producing more just for the sake of lower production costs per unit, a business should only produce what it can realistically sell. However, if you produce 10 units, the overhead cost per unit will go down to $500. If you only produce 1 unit of product, the overhead cost per unit will be $5,000. This means that most of them stay as is no matter how many you produce. In cost accounting, a standard is a benchmark or a “norm” used in measuring performance.

In some instances, production volume variance can be considered to be a stale statistic. You’re able to calculate it against a budget that might have been created months or years prior. From the data available, you can easily calculate the selling price per unit of each fruit (Amount of Sales ($) for each fruit sold divided by the number of units sold). So, for example for Apples, the selling price for 2018 is $11 ($660 Sales / 60 units sold). Another problem with this variance is that it tends to encourage management to manufacture more units, so that the overhead cost per unit is reduced.

Join PRO or PRO Plus and Get Lifetime Access to Our Premium Materials

If the fixed overhead cost applied to the actual production using the standard fixed overhead rate is bigger than the budgeted fixed overhead cost, the fixed overhead volume variance is the favorable one. This means that the company’s actual production volume measured in units or hours during the period is more than the budgeted production volume that the company has previously planned. Fixed overhead volume variance is the difference between the budgeted fixed overhead cost and the fixed overhead costs that are applied to the actual production volume using the standard fixed overhead rate. While fixed overheads are supposed to be fixed, to facilitate timely reporting, the budgeted fixed overhead cost needs to be applied to units produced at a standard rate. The standard overhead rate is the total budgeted overhead of $10,000 divided by the level of activity (direct labor hours) of 2,000 hours.

  • However, doing so increases the working capital investment in inventory, since more inventory will be kept on hand.
  • Connie’s Candy used fewer direct labor hours and less variable overhead to produce 1,000 candy boxes (units).
  • Adding these two variables together, we get an overall variance of $3,000 (unfavorable).
  • This is due to the actual production volume that it has produced in August is 50 units lower than the budgeted one.

Standard fixed overhead applied to actual production is the fixed overhead cost that is applied to the actual production volume using the standard fixed overhead rate. Adding the two variables together, we get an overall variance of $4,800 (Unfavorable). 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. This enables the effect of changes in the production mix to be measured.

Fixed Overhead Volume Variance

Suppose Connie’s Candy budgets capacity of production at 100% and determines expected overhead at this capacity. Connie’s Candy also wants to understand what overhead cost outcomes a full range of bookkeeping online services will be at 90% capacity and 110% capacity. The following information is the flexible budget Connie’s Candy prepared to show expected overhead at each capacity level.

Labor Variance

The chart below (Illustration C.1) illustrates this by showing how the variances for volume, mix and rate total to the COGS variance of $6.7M. The chart below (Illustration B.1), further analyzes COGS variance by product type, showing volume, cost and price rate for both budget and actual, revealing the total variance of -$6.7M. Breaking down the impacts that volume, mix and price have on COGS variance adds more complexity and enhances analysis. It also allows you to decompose the volume and pricing performances by product type between budgets and actual values. Variance analysis usually involves comparison of many time periods or benchmarks.

Which of these is most important for your financial advisor to have?

This could be for many reasons, and the production supervisor would need to determine where the variable cost difference is occurring to better understand the variable overhead reduction. For example, let’s say that a business has a budgeted overhead rate of $5 per unit. While overhead costs are not usually directly attributable to a certain product, since they are production costs, they still contribute to the final cost of a product. Rather than that, these costs are attributed to the production process as a whole. We refer to these costs as the factory overhead, manufacturing overhead, or overhead costs.

Determination and Evaluation of Overhead Variance

This is because of inefficient use of the fixed production capacity. Figure 8.5 shows the connection between the variable overhead rate variance and variable overhead efficiency variance to total variable overhead cost variance. It assesses how changes in the quantity of units produced affect a company’s costs and, ultimately, its profitability. Production volume variance is especially relevant when a company incurs fixed overhead costs that are spread over its units of production. If a company produces more units than expected, it spreads these fixed costs over a larger number of units, reducing the fixed overhead cost per unit.

Direct Labor Efficiency Variance:

Calculating Mix variance separately in this way is important because each product has a different profit margin. This calculation of impact of increase in quantity while maintaining the same mix as last year is really our next variance, the Quantity Variance. Calculating Mix variance also helps when trying to explain Profit Margin % changes over the years, or vs budget because Quantity variance has neutral impact on % Profit Margin. Variable overhead efficiency variance refers to the difference between the true time it takes to manufacture a product and the time budgeted for it, as well as the impact of that difference.

Although it may sound immaterial, when applying these rates against the millions of units sold, we create a large variance that would cause concern for both management and shareholders. Looking further into this product, we see that the planned mix was 38% and actual sales mix was 39%, resulting in a 0.6% increase. Applying this mix increase in our mix calculation shows the change in volume impact was -445K units, which we then multiply against the budget rate of $0.57, resulting in our final mix impact of -$252K.

Think about it for a little while, internalize it and if you still do not understand, leave a comment and I will try to explain further. It may be calculated against a budget that was drafted months or even years before actual production. For this reason, some businesses prefer to rely on other statistics, such as the number of units that can be produced per day at a set cost. Actual production volume is the production that the company actually achieves (in hours) or produces (in units) during the period. The figure in hours here can either be labor hours or machine hours depending on which one is more suitable for the measurement in the production.