Welcome to Accounting For Management

Home » Cost Volume Profit CVP Relationship » Sale Mix and Break Even Analysis With Multiple Products

Sale Mix and Break Even Analysis With Multiple Products:

Learning Objectives:

  1. Calculate break even point when a company sells more than one product.

Sale mix--Definition and Explanation of the Concept:

The term sale mix refers to the relative proportion in which a company's products are sold. The concept is to achieve the combination, that will yield the greatest amount of profits. Most companies have many products, and often these products are not equally profitable. Hence, profits will depend to some extent on the company's sales mix. Profits will be greater if high margin rather than low margin items make up a relatively large proportion of total sales.

Changes in sales mix can cause interesting variation in profits. A shift in sales mix from high margin items to low margin items can cause profits to decrease even though total sales may increase. Conversely, a shift in sales mix from low margin items to high margin items can cause reverse effect-total profit may increase even though total sales decrease. It is one thing to achieve a particular sales volume; it is quite a different thing to sell most profitable mix of products.

Sales Mix and Break Even Analysis:

If a company sells multiple products, break even analysis is somewhat more complex than discussed in the topic break even point calculation. The reason is that the different products will have different selling prices, different costs, and different contribution margins. Consequently, the break even point will depend on the mix in which the various products are sold.

Example:1

AB Company
 

Product A

Product B

Total

Sales $20,000 100% 80,000 100% 100,000 100%
Less Variable expenses 15,000 75% 40,000 50% 55,000 55%
------- ----- ------ ----- ------ ----
Contribution margin 5,000 25% 40,000 50% 45,000 45%

Less fixed expenses
===== ===== ===== =====
27,000
          -------  
Net operating income 18,000
=====

Computation / Calculation of break even point:

Fixed expenses / Overall contribution margin

27,000 / 0.45

$60,000

$60,000 sales represent the break even point for the company as long as the sales mix does not changes. If the sales mix changes, then the break even point will also change. This is illustrated below.

Example:2

AB Company
 

    Product A         Product B   

     Total    

Sales 80,000 100% 20,000 100% 100,000 100%
Less variable expenses 60,000 75% 10,000 50% 70,000 70%
  ------- ----- ------ ----- ------ -----
Contribution margin 20,000 25% 10,000 50% 30,000 30%
  ====== ====== ====== ======   ======
Fixed expenses         27,000  
------
Net operating income 3,000

======

Computation / Calculation of break even point:

Fixed expenses / Overall contribution margin

$27,000 / 0.3

$90,000

Although sales have remained unchanged at $100,000, the sales mix is exactly the reverse of what it was in example1, with the bulk of sales now coming from the less profitable product A. Notice that this change in the sales mix has caused both the overall contribution margin and total profits to drop sharply. The overall contribution margin ratio (CM ratio) has dropped from 45% to 30% and net operating income has dropped from $18,000 to $3,000. The company's break even point is no longer $60,000 in sales. Since the company is now realizing less contribution margin per dollar of sales, it takes more sales to cover the same amount of fixed costs. Thus the break even point has increased from $60,000 to $90,000 in sales per year.
 
In Business | Benefiting from a Shift in Sales Mix:

Roger Maxwell grew up near a public course where he learned the game and worked as a caddie. After attending Oklahoma State on a golf scholarship, he became a golf pro and eventually rose to become vice president at Marriot, responsible for Marriot's  golf courses in the United States. Sensing an opportunity to serve a niche market, Maxwell invested his life savings in opening his own golf superstore, in Celebration of Golf (ICOG), in Scottsdale, Arizona. Maxwell says, " I'd rather sacrifice profit up front for sizzle...[p]eople are bored by malls. They are looking for something different." Maxwell has designed his store to be a museum-like Mecca for golfing fanatics. For example, maintenance work is done in a replica of a turn of the century club maker's shop.

Maxwell's approach seems to be working. In the second year of operation, Maxwell projected a profit of $81,000 on sales of $2.4 million as follows:

  Projected Percent of Sales
Sales $2,400,000 100%
Cost of Sales 1,496,000 62.33%
Other variable expenses 296,000 12.33%
  --------- ---------
Contribution margin 608,000 25.33%
Fixed expenses 527,000 ======
  ---------  
Net operating income $81,000  
  ======  


Happily for Maxwell, sales for the year were even better than expected--reaching $3.0 million. In the absence of any other change, the net income should have been approximately $233,000, computed as follows:
 

  Projected Percent of Sales
Sales $3,000,000 100%
Cost of sales 1,870,000 62.33%
Other variable expenses 370,000 12.33%
  --------- --------
Contribution margin 760,000 25.33%
Fixed expenses 527,000  
  ---------  
Net operating income $233,000  
  ======  
     


However net income for the year was actually $289,000--apparently because of favorable shift in sales mix toward higher margin item. A 25% increase in sales over the projections at beginning of the year resulted in a 356% increase in net income. That's leverage!

Source: Edward O. Welles, Going for the Green," Inc., July 1996, pp.68-75.

You may also be interested in other relevant articles:

 

Dear visitor! Do you like this article? If you like, then please bookmark this page and also share with your friends. Thank you for your support.

Bookmark and Share

 Follow us on Twitter

 

Back to Home Page | Back to Cost Volume Profit CVP Relationship Main Page


Bookmark and Share
 

Managerial Accounting Articles
» Business Improvement Programs
» Cost Terms, Concepts and Classification
» Job Order Costing system
» Process Costing System
» Process Costing System - Addition of Materials and Beginning Inventory
» Controlling and Costing Materials
» Materials and Inventory Cost Control
» By Products and Joint Products Costing
» Cost-Volume-Profit-Relationship
» Variable Costing System
» Activity Based Costing System
» Budgeting and Planning
» Standard Costing and Variance Analysis
» Gross Profit Analysis
» Linear Programming Technique
» Segment Reporting and Transfer Pricing
» Capital Budgeting Decisions
» Service Department Costing
» Preparing Cash Flow statement
» Financial statement Analysis
» Pricing Products and Services
» Managerial Accounting Terms and Definitions
» Managerial / Cost Accounting Formulas
Financial Accounting Articles
» Bookkeeping and Bookkeeping Terms
» Accounting Principles and Accounting Equation
» Journal
» Ledger
» Accounting For Bills of Exchange
» Subdivision of Journal
» Capital and Revenue Items
» Single Entry System/Accounting From Incomplete Records
» Accounting For Non-Trading Concerns

Currency Converter

Exchange Rates
Advertisement

 
 

 
Home | Advertise With Us | Privacy Policy | Disclaimer & Terms of Use | Site map | Links | Link to us About Us | Contact Us

No text of this website can be republished without permission of the owner of this site and the authors of these managerial, management, and cost accounting articles. Otherwise sever civil and criminal penalties shall be imposed. All rights reserved.
Copy right © 2009