CostVolumeProfit Analysis for MultipleProduct and Service Companies
How Is CostVolumeProfit Analysis Used for Decision Making? Module
Learning Objective
 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.
Key Equation
S = Selling price per unit V = Variable cost per unit F = Total fixed costs Q = Quantity of units produced and sold CM = Contribution marginThus
$\begin{array}{ccc}\text{Profit}& =& \text{Totalsales}\text{Totalvariablecosts}\text{Totalfixedcosts}\\ \text{Profit}& =& \left[({\text{S}}_{\text{r}}\times {\text{Q}}_{\text{r}})+({\text{S}}_{\text{s}}\times {\text{Q}}_{\text{s}})\right]\left[({\text{V}}_{\text{r}}\times {\text{Q}}_{\text{r}})+({\text{V}}_{\text{s}}\times {\text{Q}}_{\text{s}})\right]\text{F}\end{array}$Without going through a detailed derivation, this equation can be restated in a simplified manner for KayaksForFun, as follows:
$\begin{array}{cc}\text{Profit}& =(\text{UnitCMforRiver}\times \text{QuantityofRiver})+(\text{UnitCMforSea}\times \text{QuantityofSea})\text{F}\\ \text{Profit}& =\text{\$4}00{\text{Q}}_{\text{r}}+\text{\$15}0{\text{Q}}_{\text{s}}\text{\$24}\text{,}000\end{array}$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 "Multiple BreakEven Points for KayaksForFun":
Profit ($0) = ($400 × 30 units of River) + ($150 × 80 units of Sea) − $24,000 Profit ($0) = ($400 × 35 units of River) + ($150 × 67 units of Sea) − $24,000 Profit ($0) = ($400 × 40 units of River) + ($150 × 53 units of Sea) − $24,000Figure 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 mixThe proportion of one product’s sales to total sales. 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 breakeven 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.
Key Equation
$\frac{\text{Totalfixedcosts}+\text{Targetprofit}}{\text{Weightedaveragecontributionmarginperunit}}$When a company assumes a constant sales mix, a weighted average contribution margin per unitCalculated by multiplying each product’s unit contribution margin by the product’s proportion of total sales. 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 × 60 percent) + ($150 × 40 percent)We can now determine the breakeven point in units by using the following formula:
$\begin{array}{cc}\text{Breakevenpointinunits}& =\frac{\text{Totalfixedcosts}+\text{Targetprofit}}{\text{Weightedaveragecontributionmarginperunit}}\\ \text{Breakevenpointinunits}& =\frac{\text{\$24}\text{,}000+\mathrm{\$0}}{\text{\$3}00}\\ & =\text{8}0\text{totalkayaks}\end{array}$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.
Key Equation
$\text{Targetprofitinunits}=\frac{\text{Totalfixedcosts}+\text{Targetprofit}}{\text{Weightedaveragecontributionmarginperunit}}$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{array}{cc}\text{Targetprofitinunits}& =\frac{\text{Totalfixedcosts}+\text{Targetprofit}}{\text{Weightedaveragecontributionmarginperunit}}\\ \text{Targetprofitinunits}& =\frac{\text{\$24}\text{,}000+\text{\$96}\text{,}000}{\text{\$3}00}\\ & =\text{4}00\text{totalkayaks}\end{array}$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?
Solution to Review Problem 6.2
Note: All solutions are rounded.


IPM must sell 20,408 printers to break even:
$\frac{\text{Totalfixedcosts}+\text{Targetprofit}}{\text{Weightedaveragecontributionmarginperunit}}$ $\frac{\text{\$5}\text{,}\mathrm{000,000}+\mathrm{\$0}}{(\text{\$15}0\times 0.\text{6}0)+(\text{\$25}0\times 0.\text{3}0)+(\text{\$8}00\times 0.\text{1}0)}=\frac{\text{\$5}\text{,}\mathrm{000,000}}{\text{\$245}}=\text{2}0\text{,}\text{4}0\text{8totalunits}$ 
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:
 $\text{Inkjet:}\text{12,}\text{245units}=\text{2}0\text{,}\text{4}0\text{8}\times 0.\text{6}0$
 $\text{Laser:6}\text{,}\text{122units}=\text{2}0\text{,}\text{4}0\text{8}\times 0.\text{3}0$
 $\text{Color laser:2}\text{,}0\text{41units}=\text{2}0\text{,}\text{4}0\text{8}\times 0.\text{1}0$



IPM must sell 24,490 printers to earn $1,000,000 in profit:
$\frac{\text{Totalfixedcosts}+\text{Targetprofit}}{\text{Weightedaveragecontributionmarginperunit}}$ $\frac{\text{\$5}\text{,}\mathrm{000,000}+\text{\$1}\text{,}\mathrm{000,000}}{(\text{\$15}0\times 0.\text{6}0)+(\text{\$25}0\times 0.\text{3}0)+(\text{\$8}00\times 0.\text{1}0)}=\frac{\text{\$6}\text{,}\mathrm{000,000}}{\text{\$245}}=\text{24}\text{,}\text{49}0\text{totalunits}$ 
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:
 $\text{Inkjet:}\text{14}\text{,}\text{694units}=\text{24}\text{,}\text{49}0\times 0.\text{6}0$
 $\text{Laser:}\text{7}\text{,}\text{347units}=\text{24}\text{,}\text{49}0\times 0.\text{3}0$
 $\text{Color laser:}\text{2}\text{,}\text{449units}=\text{24}\text{,}\text{49}0\times 0.\text{1}0$

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 "Type of Good or Service Determines Whether to Calculate BreakEven Point and Target Profit Points in Units or Sales Dollars" 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.
Key Equation
$\text{Breakevenpointinsalesdollars}=\frac{\text{Totalfixedcosts}+\text{Targetprofit}}{\text{Weightedaveragecontributionmarginratio}}$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 "Income Statement for Amy’s Accounting Service" 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 percent (= $70,000 ÷ $100,000) 
Audit  20 percent (= $30,000 ÷ $150,000) 
Consulting  50 percent (= $125,000 ÷ $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 ratioThe total contribution margin divided by total sales.. 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{array}{cc}\text{Breakevenpointinsalesdollars}& =\frac{\text{Totalfixedcosts}+\text{Targetprofit}}{\text{Weightedaveragecontributionmarginratio}}\\ \text{Breakevenpointinsalesdollars}& =\frac{\text{\$12}\mathrm{0,000}+\mathrm{\$0}}{0.\text{45}}\\ & =\text{\$266}\text{,}\text{667}\left(\text{rounded}\right)\end{array}$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.
Key Equation
$\text{Targetprofitinsalesdollars}=\frac{\text{Totalfixedcosts}+\text{Targetprofit}}{\text{Weightedaveragecontributionmarginratio}}$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{array}{cc}\text{Targetprofitinsalesdollars}& =\frac{\text{Totalfixedcosts}+\text{Targetprofit}}{\text{Weightedaveragecontributionmarginratio}}\\ \text{Targetprofitinsalesdollars}& =\frac{\text{\$12}\mathrm{0,000}+\text{\$25}\mathrm{0,000}}{0.\text{45}}\\ & =\text{\$822}\text{,}\text{222}\left(\text{rounded}\right)\end{array}$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{array}{cc}\text{Marginofsafety}& =\text{Projectedsales}\text{Breakevensales}\\ \text{\$555}\text{,}\text{555}& =\text{\$822}\text{,}\text{222}\text{\$266}\text{,}\text{667}\end{array}$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{Totalfixedcosts}+\text{Targetprofit}}{\text{Weightedaveragecontributionmarginperunit}}$ 
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{Totalfixedcosts}+\text{Targetprofit}}{\text{WeightedAveragecontributionmarginratio}}$
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?
Solution to Review Problem 6.3

Sales of $1,000,000 are required to break even:
$\frac{\text{Totalfixedcosts}+\text{Targetprofit}}{\text{Weightedaveragecontributionmarginratio}*}=\frac{\text{\$2}\mathrm{00,000}+\mathrm{\$0}}{0.\text{2}0}=\text{\$1}\text{,}\mathrm{000,000}\text{insales}$*Weighted average contribution margin ratio = $1,000,000 ÷ $5,000,000 = 20 percent or 0.20.

Sales of $8,500,000 are required to make a profit of $1,500,000:
$\frac{\text{Totalfixedcosts}+\text{Targetprofit}}{\text{Weightedaveragecontributionmarginratio}}=\frac{\text{\$2}\mathrm{00,000}+\text{\$1}\text{,}\text{5}\mathrm{00,000}}{0.\text{2}0}=\text{\$8}\text{,}\text{5}\mathrm{00,000}\text{insales}$ 
The margin of safety is $4,000,000 in sales:
$\begin{array}{cc}\text{Marginofsafety}& =\text{Projectedsales}\text{Breakevensales}\\ \text{\$4}\text{,}\mathrm{000,000}\text{insales}& =\text{\$5}\text{,}\mathrm{000,000}\text{\$1}\text{,}\mathrm{000,000}\end{array}$
 Chapter Introduction
 CostVolumeProfit Analysis for SingleProduct Companies
 CostVolumeProfit Analysis for MultipleProduct and Service Companies
 Using CostVolumeProfit Models for Sensitivity Analysis
 Impact of Cost Structure on CostVolumeProfit Analysis
 Using a Contribution Margin When Faced with Resource Constraints
 Income Taxes and CostVolumeProfit Analysis
 Using Variable Costing to Make Decisions