Gross Margin Variance Analysis

0
2006

When a company improves their Gross Margin, they may wonder whether this was due to an increase in their sales (due either to an increase in volume or price), or a reduction in their cost of goods sold (COGS).  To assess where the improved Gross Margin has come from, variance analysis can be employed similar to the material price variance and material quantity variance used in managerial accounting.

By using the variance formulas Δ Sales Volume  = PM1 × ( S2 – S1 ) and Δ Margin = S2 × ( PM2 – PM1 ), an approximation can be made as to what contributed to the Gross Margin increase of $40 from Year 1 to Year 2.

There are two important things to note though:

  1. The sales volume increase may be due to either an increase in sales price or sales volume, and this can only be determined by a more fundamental analysis of your sales.
  2. The Gross Margin increase could be due to either an increase in the price, or reduction in the COGS, and this can only be determined by further analysis of per unit price and cost.

The objective is to increase Gross Margin through either an increase in price, an increase in sales volume, or a decrease in COGS.  If Δ Sales Volume has increased due to price, then the sales staff should not be rewarded for this unless they are directly responsible for the price increase through value selling.  And if Gross Margin is improved through the reduction in COGS, then any employee directly responsible for this should be rewarded at the same compensation level that a sales person would receive for an equivalent increase in sales.  Cost reduction is just as valuable as sales, but is seldom recognized and rewarded.

The Excel file used in this analysis can be downloaded here.

A PDF of this post can be downloaded Here.

©2018 Ben Etzkorn

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.