6.3: CostVolumeProfit Analysis for MultipleProduct and Service Companies
 Page ID
 868
Skills to Develop
 Perform costvolumeprofit analysis for multipleproduct and service companies.
Question: Although the previous section illustrated costvolumeprofit (CVP) analysis for companies with a single product easily measured in units, most companies have more than one product or perhaps offer services not easily measured in units. Suppose you are the manager of a company called KayaksForFun that produces two kayak models, River and Sea. What information is needed to calculate the breakeven point for this company?
 Answer:

The following information is required to find the breakeven point:
 Monthly fixed costs total $24,000.
 The River model represents 60 percent of total sales volume and the Sea model accounts for 40 percent of total sales volume.
 The unit selling price and variable cost information for the two products follow:
Finding the BreakEven Point and Target Profit in Units for MultipleProduct Companies
Question: Given the information provided for KayaksForFun, how will the company calculate the breakeven point?
 Answer:

First, we must expand the profit equation presented earlier to include multiple products. The following terms are used once again. However, subscript r identifies the River model, and subscript s identifies the Sea model (e.g., S_{r} stands for the River model’s selling price per unit). CM is new to this section and represents the contribution margin.
$$\text{S = Selling price}\; per\; unit$$
$$\text{V = Variable price}\; per\; unit$$
$$\text{F} = Total\; \text{fixed costs}$$
$$\text{Q = Quantity of units produced and sold}$$
$$\text{CM = Contribution margin}$$
Thus
$$\begin{split} \text{Profit} &= \text{Total sales − Total variable costs − Total fixed costs} &= [ (S_{r} \times Q_{r}) + (S_{s} \times Q_{s})]  [ (V_{r} \times Q_{r}) + (V_{s} \times Q_{s} )] \end{split}$$
Without going through a detailed derivation, this equation can be restated in a simplified manner for KayaksForFun, as follows:
$$\begin{split} \text{Profit} &= \text{(Unit CM for River × Quantity of River) + (Unit CM for Sea × Quantity of Sea) − F} \\ &= \$ 400Q_{r} + \$ 150Q_{s}  \$ 24,000 \end{split}$$
One manager at KayaksForFun believes the breakeven point should be 60 units in total, and another manager believes the breakeven point should be 160 units in total. Which manager is correct? The answer is both might be correct. If only the River kayak is produced and sold, 60 units is the breakeven point. If only the Sea kayak is produced and sold, 160 units is the breakeven point. There actually are many different breakeven points, because the profit equation has two unknown variables, Q_{r} and Q_{s}.
Further evidence of multiple breakeven points is provided as follows (allow for rounding to the nearest unit), and shown graphically in Figure 6.3 :
$$\begin{split} \text{Profit} (\$ 0) &= (\$ 400 \times \textbf{30}\; \text{units of River}) + (\$ 150 \times \textbf{80} \; \text{units of Sea}) − \$ 24,000 \\ \text{Profit} (\$ 0) &= (\$ 400 \times \textbf{35}\; \text{units of River}) + (\$ 150 \times \textbf{67} \; \text{units of Sea}) − \$ 24,000 \\ \text{Profit} (\$ 0) &= (\$ 400 \times \textbf{40}\; \text{units of River}) + (\$ 150 \times \textbf{53} \; \text{units of Sea}) − \$ 24,000 \end{split}$$
Figure 6.3  Multiple BreakEven Points for KayaksForFun
BreakEven Point in Units and the Weighted Average Contribution Margin per Unit
Question: Because most companies sell multiple products that have different selling prices and different variable costs, the breakeven or target profit point depends on the sales mix. What is the sales mix, and how is it used to calculate the breakeven point?
 Answer:

The sales mix^{10} is the proportion of one product’s sales to total sales. In the case of KayaksForFun, the River model accounts for 60 percent of total unit sales and the Sea model accounts for 40 percent of total unit sales.
In calculating the breakeven point for KayaksForFun, we must assume the sales mix for the River and Sea models will remain at 60 percent and 40 percent, respectively, at all different sales levels. The formula used to solve for the break even point in units for multipleproduct companies is similar to the one used for a singleproduct company, with one change. Instead of using the contribution margin per unit in the denominator, multipleproduct companies use a weighted average contribution margin per unit. The formula to find the breakeven point in units is as follows.
$$\frac{\text{Total fixed costs + Target profit}}{\text{Weighted average contribution margin per unit}}$$
When a company assumes a constant sales mix, a weighted average contribution margin per unit^{11} can be calculated by multiplying each product’s unit contribution margin by its proportion of total sales. The resulting weighted unit contribution margins for all products are then added together.
At KayaksForFun, the weighted average contribution margin per unit of $300 is
$$ \$ 300 = (\$ 400 \times 60\; \text{percent}) + (\$ 150 \times 40\; \text{percent})$$
We can now determine the breakeven point in units by using the following formula:
$$\begin{split} \text{Breakeven point in units} &= \frac{\text{Total fixed costs + Target profit}}{\text{Weighted average contribution margin per unit}} \\ \\ &= \frac{\$ 24,000 + \$ 0}{\$ 300} \\ &= 80\; \text{total kayaks} \end{split}$$
KayaksForFun must sell 48 River models (= 60 percent × 80 units) and 32 Sea models (= 40 percent × 80 units) to break even. Again, this assumes the sales mix remains the same at different levels of sales volume.
Target Profit in Units
Question: We now know how to calculate the breakeven point in units for a company with multiple products. How do we extend this process to find the target profit in units for a company with multiple products?
 Answer:

Finding the target profit in units for a company with multiple products is similar to finding the breakeven point in units except that profit is no longer set to zero. Instead, profit is set to the target profit the company would like to achieve.
$$\text{Target profit in units} = \frac{\text{Total fixed costs + Target profit}}{\text{Weighted average contribution margin per unit}}$$
For example, assume KayaksForFun would like to know how many units it must sell to make a monthly profit of $96,000. Simply set the target profit to $96,000 and run the calculation:
$$\begin{split} \text{Target profit in units} &= \frac{\text{Total fixed costs + Target profit}}{\text{Weighted average contribution margin per unit}} \\ \\ &= \frac{\$ 24,000 + \$ 96,000}{\$ 300} \\ &= 400\; \text{total kayaks} \end{split}$$
KayaksForFun must sell 240 River models (= 60 percent × 400) and 160 Sea models (= 40 percent × 400) to make a profit of $96,000.
Review problem 6.2
International Printer Machines (IPM) builds three computer printer models: Inkjet, Laser, and Color Laser. Information for these three products is as follows:
Inkjet  Laser  Color Laser  Total  

Selling price per unit  $250  $400  $1,600  
Variable cost per unit  $100  $150`  $800  
Expected unit sales (annual)  12,000  6,000  2,000  20,000 
Sales mix  60 percent  30 percent  10 percent  100 percent 
Total annual fixed costs are $5,000,000. Assume the sales mix remains the same at all levels of sales

 How many printers in total must be sold to break even?
 How many units of each printer must be sold to break even?

 How many printers in total must be sold to earn an annual profit of $1,000,000?
 How many units of each printer must be sold to earn an annual profit of $1,000,000?
 Answer:

Note: All solutions are rounded.

 IPM must sell 20,408 printers to break even: $$\frac{\text{Total fixed costs + Target profit}}{\text{Weighted average contribution margin per unit}} = \frac{\$ 5,000,000 + \$ 0}{(\$ 150 \times 0.60) + (\$ 250 + \times 0.30) + (\$ 800 \times 0.10)} = \frac{\$ 5,000,000}{\$ 245} = 20,408\; \text{total units}$$
 As calculated previously, 20,408 printers must be sold to break even. Using the sales mix provided, the following number of units of each printer must be sold to break even:
 Inkjet: 12,245 units = 20,408 × 0.60
 Laser: 6,122 units = 20,408 × 0.30
 Color laser: 2,041 units = 20,408 × 0.10

 IPM must sell 24,490 printers to earn $1,000,000 in profit:$$\frac{\text{Total fixed costs + Target profit}}{\text{Weighted average contribution margin per unit}} = \frac{\$ 5,000,000 + \$ 1,000,000}{(\$ 150 \times 0.60) + (\$ 250 + \times 0.30) + (\$ 800 \times 0.10)} = \frac{\$ 6,000,000}{\$ 245} = 24,490\; \text{total units}$$
 As calculated previously, 24,490 printers must be sold to earn $1,000,000 in profit. Using the sales mix provided, the following number of units for each printer must be sold to earn $1,000,000 in profit:
 Inkjet: 14,694 units = 24,490 × 0.60
 Laser: 7,347 units = 24,490 × 0.30
 Color laser: 2,449 units = 24,490 × 0.10

Finding the BreakEven Point and Target Profit in Sales Dollars for MultipleProduct and Service Companies
A restaurant like Applebee’s, which serves chicken, steak, seafood, appetizers, and beverages, would find it difficult to measure a “unit” of product. Such companies need a different approach to finding the breakeven point. Figure 6.4 illustrates this point by contrasting a company that has similar products easily measured in units (kayaks) with a company that has unique products (meals at a restaurant) not easily measured in units.
Figure 6.4  Type of Good or Service Determines Whether to Calculate BreakEven Point and Target Profit Points in Units or Sales Dollars, © Thinkstock
BreakEven Point in Sales Dollars and the Weighted Average Contribution Margin Ratio
Question: For companies that have unique products not easily measured in units, how do we find the breakeven point?
 Answer:

Rather than measuring the breakeven point in units, a more practical approach for these types of companies is to find the breakeven point in sales dollars. We can use the formula that follows to find the breakeven point in sales dollars for organizations with multiple products or services. Note that this formula is similar to the one used to find the breakeven point in sales dollars for an organization with one product, except that the contribution margin ratio now becomes the weighted average contribution margin ratio.
$$\text{Breakeven point in sales dollars} = \frac{\text{Total fixed costs + Target profit}}{\text{Weighted average contribution margin ratio}}$$
For example, suppose Amy’s Accounting Service has three departments—tax, audit, and consulting—that provide services to the company’s clients. Figure 6.5 shows the company’s income statement for the year. Amy, the owner, would like to know what sales are required to break even. Note that fixed costs are known in total, but Amy does not allocate fixed costs to each department.
Figure 6.5  Income Statement for Amy’s Accounting Service
The contribution margin ratio differs for each department:
Tax \(70\; \text{percent} = (\$ 70,000 \div \$ 100,000)\) Audit \(20 \text{percent} = (\$ 30,000 \div \$ 150,000)\) Consulting \(50\; \text{percent} = (\$ 125,000 \div \$ 250,000)\)
Question: We have the contribution margin ratio for each department, but we need it for the company as a whole. How do we find the contribution margin ratio for all of the departments in the company combined?
 Answer:

The contribution margin ratio for the company as a whole is the weighted average contribution margin ratio^{12}. We calculate it by dividing the total contribution margin by total sales. For Amy’s Accounting Service, the weighted average contribution margin ratio is 45 percent (= $225,000 ÷ $500,000). For every dollar increase in sales, the company will generate an additional 45 cents ($0.45) in profit. This assumes that the sales mix remains the same at all levels of sales. (The sales mix here is measured in sales dollars for each department as a proportion of total sales dollars.)
Now that you know the weighted average contribution margin ratio for Amy’s Accounting Service, it is possible to calculate the breakeven point in sales dollars:
$$\begin{split} \text{Breakeven point in sales dollars} &= \frac{\text{Total fixed costs + Target profit}}{\text{Weighted average contribution margin ratio}} \\ \\ &= \frac{\$ 120,000 + \$ 0}{0.45} \\ &= \$ 266,667 \text{(rounded)} \end{split}$$
Amy’s Accounting Service must achieve $266,667 in sales to break even.The weighted average contribution margin ratio can also be found by multiplying each department’s contribution margin ratio by its proportion of total sales. The resulting weighted average contribution margin ratios for all departments are then added. The calculation for Amy’s Accounting Service is as follows:45 percent weighted average contribution margin ratio = (tax has 20 percent of total sales × 70 percent contribution margin ratio) + (audit has 30 percent of total sales × 20 percent contribution margin ratio) + (consulting has 50 percent of total sales × 50 percent contribution margin ratio)Thus 45 percent = 14 percent + 6 percent + 25 percent.
Target Profit in Sales Dollars
Question: How do we find the target profit in sales dollars for companies with products not easily measured in units?
 Answer:

Finding the target profit in sales dollars for a company with multiple products or services is similar to finding the breakeven point in sales dollars except that profit is no longer set to zero. Instead, profit is set to the target profit the company would like to achieve.
$$\text{Target profit in sales dollars} = \frac{\text{Total fixed costs + Target profit}}{\text{Weighted average contribution margin ratio}}$$
For example, assume Amy’s Accounting Service would like to know sales dollars required to make $250,000 in annual profit. Simply set the target profit to $250,000 and run the calculation:
$$\begin{split} \text{Target profit in sales dollars} &= \frac{\text{Total fixed costs + Target profit}}{\text{Weighted average contribution margin ratio}} \\ \\ &= \frac{\$ 120,000 + \$ 250,000}{0.45} \\ &= \$ 822,222 \text{(rounded)} \end{split}$$
Amy’s Accounting Service must achieve $822,222 in sales to earn $250,000 in profit.
Important Assumptions
Question: Several assumptions are required to perform breakeven and target profit calculations for companies with multiple products or services. What are these important assumptions?
 Answer:

These assumptions are as follows:
 Costs can be separated into fixed and variable components.
 Contribution margin ratio remains constant for each product, segment, or department.
 Sales mix remains constant with changes in total sales.
These assumptions simplify the CVP model and enable accountants to perform CVP analysis quickly and easily. However, these assumptions may not be realistic, particularly if significant changes are made to the organization’s operations. When performing CVP analysis, it is important to consider the accuracy of these simplifying assumptions. It is always possible to design a more accurate and complex CVP model. But the benefits of obtaining more accurate data from a complex CVP model must outweigh the costs of developing such a model.
Margin of Safety
Question: Managers often like to know how close expected sales are to the breakeven point. As defined earlier, the excess of projected sales over the breakeven point is called the margin of safety. How is the margin of safety calculated for multipleproduct and service organizations?
 Answer:

Let’s return to Amy’s Accounting Service and assume that Amy expects annual sales of $822,222, which results in expected profit of $250,000. Given a breakeven point of $266,667, the margin of safety in sales dollars is calculated as follows:
$$\begin{split} \text{Margin of safety} &= \text{Projected sales − Breakeven sales} \\ \$ 555,555 &= \$ 822,222  \$ 266,667 \end{split}$$
Thus sales revenue can drop by $555,555 per year before the company begins to incur a loss.
KEY TAKEAWAYS
 The key formula used to calculate the breakeven or target profit point in units for a company with multiple products is as follows. Simply set the target profit to $0 for breakeven calculations, or to the appropriate profit dollar amount for target profit calculations. $$\frac{\text{Total fixed costs + Target profit}}{\text{Weighted average contribution margin per unit}}$$
 The formula used to find the breakeven point or target profit in sales dollars for companies with multiple products or service is as follows. Simply set the “Target Profit” to $0 for breakeven calculations, or to the appropriate profit dollar amount for target profit calculations: $$\frac{\text{Total fixed costs + Target profit}}{\text{Weighted average contribution margin ratio}}$$
REVIEW PROBLEM 6.3
Ott Landscape Incorporated provides landscape maintenance services for three types of clients: commercial, residential, and sports fields. Financial projections for this coming year for the three segments are as follows:
Assume the sales mix remains the same at all levels of sales.
 How much must Ott Landscape have in total sales dollars to break even?
 How much must Ott Landscape have in total sales dollars to earn an annual profit of $1,500,000?
 What is the margin of safety, assuming projected sales are $5,000,000 as shown previously?
 Answer:

 Sales of $1,000,000 are required to break even: $$\frac{\text{Total fixed costs + Target profit}}{\text{Weighted average contribution margin ratio}} = \frac{\$ 200,000 + \$ 0}{0.20} = \$ 1,000,000$$where $$\begin{split} \text{Weighted average contribution margin ratio} &= \$ 1,000,000 \div \$ 5,000,000 \\ &= 20\; \text{percent or}\; 0.20 \ldotp \end{split}$$
 Sales of $8,500,000 are required to make a profit of $1,500,000: $$\frac{\text{Total fixed costs + Target profit}}{\text{Weighted average contribution margin ratio}} = \frac{\$ 200,000 + \$ 1,500,000}{0.20} = \$ 8,500,000$$
 The margin of safety is $4,000,000 in sales: $$\begin{split} \text{Margin of safety} &= \text{Projected sales − Breakeven sales} \\ \$ $4,000,000\; \text{in sales} &= \$ 5,000,000  \$ 1,000,000 \end{split}$$
Definitions
 The proportion of one product’s sales to total sales.
 Calculated by multiplying each product’s unit contribution margin by the product’s proportion of total sales.
 The total contribution margin divided by total sales.