Add Delete Product Decisions

Example 1 Products
Coffee Express
Coffee Express is a small coffee shop looking to expand its product offerings beyond coffee. The company is evaluating two alternatives—sandwiches and cookies. Annual projections for sales of sandwiches are as follows: sales, $18,000; variable costs, $13,000; and fixed costs, $500. Annual projections for sales of cookies are as follows: sales, $10,000; variable costs, $3,000; and no additional fixed costs.
Ddetermine which alternative is more profitable, and by how much. Assume adding sandwiches is Alternative 1 and adding cookies is Alternative 2.
Coffee Express-Adding Product Differential Analysis | ||||
Alternative 1 Add Sandwitches | Alternative 2 Add Cookies | Differential Amount | Alternative 1 is | |
Sales Revenue | 18,000 | 10,000 | 8,000 | Higher |
Variable Costs | 13,000 | 3,000 | 10,000 | Higher |
Contribution Margin | 5,000 | 7,000 | (2,000) | Lower |
Fixed Costs | 500 | 0 | 500 | Higher |
Profit | 4,500 | 7,000 | (2,500) | Lower |
Break Even Dollars | 1,800 | N/A |
As shown in the differential analysis given, selling cookies is the most profitable alternative. Selling cookies results in profits of $7,000 for the year, which is $2,500 higher than the sandwich alternative.
Example 2 Products
Barbecue Bargains
As competitors enter the market and as products go through life cycles, managers often must decide whether to keep or drop product lines. A product line is a group of related products. Home Stop, Inc., has many different product lines such as appliances, flooring, and paint products. Ford Motor Co. produces a variety of products such as compact cars, trucks, and tractors. Companies must continually assess whether they should add new product lines, and whether they should discontinue current product lines. Differential analysis provides a format for these types of decisions.
How would differential analysis be used to make a product line decision?
Let’s look at an example of a product line decision. Assume Barbeque Bargains has three product lines: gas barbecues, charcoal barbecues, and barbecue accessories. Charcoal barbecue sales have declined in recent years, leading management to question whether this product line is worth keeping. Barbeque Bargains would like to consider two alternatives. Alternative 1 is to retain all three product lines, and Alternative 2 is to eliminate the charcoal barbecues product line.
Table B-1 Income Statement for Barbeque Bargains presents the income statement for the past year, separated by product line (this is often referred to as a segmented income statement). Carefully examine Table B-1 Income Statement for Barbeque Bargains. Notice that the charcoal barbecues product line shows a loss of $8,000 for the year. This is the reason management would like to consider dropping this product line.
Barbeque Bargains Income Statement Table B-1 | ||||
Gas Barbecues | Charcoal Barbecues | Barbecue Accessories | Total | |
Sales Revenue | $450,000 | $90,000 | $60,000 | $600,000 |
Variable Costs | 110,000 | 40,000 | 15,000 | 165,000 |
Contribution Margin | $340,000 | $50,000 | $45,000 | $435,000 |
Direct Fixed Costs | 60,000 | 40,000 | 16,000 | 116,000 |
Allocated Fixed Cost | 90,000 | 18,000 | 12,000 | 120,000 |
Profit (loss) | $190,000 | ($8,000) | $17,000 | $199,000 |
Break Even Dollars | $198,529 | $104,400 | $37,333 |
The variable and direct fixed costs in Table B-1 Income Statement for Barbeque Bargains are related directly to each product line, and thus are eliminated if the product line is eliminated. That is, all variable and direct fixed costs are differential costs for the two alternatives facing Barbeque Bargains.
Question: Notice that two lines appear for fixed costs: direct fixed costs and allocated fixed costs. What is the difference between direct fixed costs and allocated fixed costs?
Answer: Direct fixed costs are fixed costs that can be traced directly to a product line. Direct fixed costs are often differential costs. For example, the salary of the manager responsible for charcoal barbecues is easily traced to the charcoal barbecues product line. If this product line is eliminated, the product line manager’s salary is also eliminated (unless the product line manager has a long term employment contract)
Allocated fixed costs (also called common fixed costs) are fixed costs that cannot be traced directly to a product line, and therefore are assigned to product lines using an allocation process. Allocated fixed costs are typically not differential costs. For example, rent paid for Barbeque Bargains retail store is allocated to all three product lines because it is not easily traced to each product line. However, the retail store rent likely will not decrease if the charcoal barbecues product line is eliminated (unless the company chooses to move to a smaller, less costly store). The charcoal barbecues’ allocation for rent would simply be reallocated to the other two products. Thus rent for the retail store is an example of an allocated fixed cost that is not a differential cost for the two alternatives facing Barbeque Bargains.
Company’s total allocated fixed costs of $120,000 are allocated based on the percentage of total sales of $600,000. .
Gas barbecues allocated fixed costs equals $90,000 ($450,000 / $600,000 x $120,000)
Charcoal barbecues allocated fixed costs equals $18,000 ($90,000 / $600,000 x $120,000)
Gas barbecues allocated fixed costs equals $12,000 ($60,000 / $600,000 x $120,000)
Decision: Will dropping the charcoal barbecues product line result in higher company profit?
The differential analysis presented in Panel C Product Line Differential Analysis for Barbeque Bargains provides the answer. Panel A shows the income statement for Alternative 1: keeping all three product lines. Panel B shows the income statement for Alternative 2: dropping the charcoal barbecues product line. And panel C presents the differential analysis for the two alternatives. The differential analysis in panel C shows that overall profit will decrease by $10,000 if the charcoal barbecue product line is dropped.
Barbeque Bargains Income Statement - Panel A | ||||
Keep All Products | Gas Barbecues | Charcoal Barbecues | Barbecue Accessories | Total |
Sales Revenue | 450,000 | 90,000 | 60,000 | 600,000 |
Variable Costs | 110,000 | 40,000 | 15,000 | 165,000 |
Contribution Margin | 340,000 | 50,000 | 45,000 | 435,000 |
Direct Fixed Costs | 60,000 | 40,000 | 16,000 | 116,000 |
Contribution to Fixed Costs and Profit | 280,000 | 10,000 | 29,000 | 319,000 |
Allocated Fixed Cost | 90,000 | 18,000 | 12,000 | 120,000 |
Profit (loss) | 190,000 | (8,000) | 17,000 | 199,000 |
Break Even Dollars | 198,529 | 104,400 | 37,333 | 340,262 |
Barbeque Bargains Income Statement Panel B | ||||
Drop Charcoal Grill Line | Gas Barbecues | Charcoal Barbecues | Barbecue Accessories | Total |
Sales Revenue | 450,000 | 0 | 60,000 | 510,000 |
Variable Costs | 110,000 | 0 | 15,000 | 125,000 |
Contribution Margin | 340,000 | 0 | 45,000 | 385,000 |
Direct Fixed Costs | 60,000 | 0 | 16,000 | 76,000 |
Contribution to Fixed Costs and Profit | 280,000 | 0 | 29,000 | 309,000 |
Allocated Fixed Cost | 105,882 | 0 | 14,118 | 120,000 |
Profit (loss) | 174,118 | 0 | 14,882 | 189,000 |
Break Even Dollars | 219,550 | 40,157 | 259,707 |
Allocated fixed costs are based on the percentage of sales.
Product Line Differential Analysis for Barbecue Bargains - Panel C | ||||
Keep All or Drop Charcoal Grill Line | Alternative 1 Keep All | Alternative 2 Drop Charcoal Barbecues | Differential Amount | Alternative 1 |
Sales Revenue | 600,000 | 510,000 | 90,000 | Higher |
Variable Costs | 165,000 | 125,000 | 40,000 | Higher |
Contribution Margin | 435,000 | 385,000 | 45,000 | Higher |
Direct Fixed Costs | 116,000 | 76,000 | 50,000 | Higher |
Contribution to Fixed Costs and Profit | 319,000 | 309,000 | 10,000 | Higher |
Allocated Fixed Cost | 120,000 | 120,000 | 0 | |
Profit (loss) | 199,000 | 189,000 | 10,000 | Higher |
Break Even Dollars | 325,517 | 259,636 |
The Differential Amount column in panel C Product Line Differential Analysis for Barbeque Bargains indicates the company would be better off continuing with all three product lines. However, management may want a more concise explanation of why profit is $10,000 higher when all three product lines are maintained.
We provide such an explanation in Table B-2 Summary of Differential Analysis for Barbeque Bargains, which presents the Differential Amount column shown in panel C of Product Line Differential Analysis for Barbeque Bargains along with a brief description for each item. Take a close look at panel C Product Line Differential Analysis for Barbeque Bargains, confirm that the Differential Amount column matches Table B-2 Summary of Differential Analysis for Barbeque Bargains, and review the explanation of the difference.
Summary of Differential Analysis for Barbecue Bargains Table B-2 | |
Result of Dropping Charcoal Barbecues | |
Sales revenue lost | (90,000) |
Variable costs eliminated | 40,000 |
Contribution margin eliminated | (50,000) |
Direct fixed costs eliminated | 40,000 |
Loss from dropping product line | (10,000) |
Note: Amounts shown in parentheses indicate a negative impact on profit, and amounts without parentheses indicate a positive impact on profit.
Table B-2 Summary of Differential Analysis for Barbeque Bargains shows that Barbeque Bargains will lose sales revenue of $90,000 if it drops the charcoal barbecues product line. However, it saves variable costs of $40,000 and direct fixed costs of $40,000 if it drops the charcoal barbecues product line. Because the $80,000 in cost savings is not enough to make up for the $90,000 loss in sales revenue, profit will decline by $10,000. The allocated fixed costs are not relevant to the decision. These costs remain regardless of which alternative is selected.
Misleading Allocation of Fixed Costs
Question: How can the charcoal barbecues product line show a loss of $8,000 in the Income Statement - Panel A , while the company as a whole is better off keeping this product line?
Answer: The answer lies within allocated fixed costs. Even though total allocated fixed costs of $120,000 cannot easily be traced to each product line, company management wants each product line manager to be aware of these costs. As a result, it uses an allocation process to assign the costs to product lines. Thus the charcoal barbecues product line is assigned $18,000 in allocated fixed costs even though these costs cannot be controlled by the product line. If the charcoal barbecues product line is eliminated, $18,000 in allocated fixed costs is not eliminated. Instead, $18,000 in costs is assigned to the other two product lines.
In many situations, this increased allocation to other product lines may cause other product lines to appear unprofitable. The message here is to be careful when analyzing segmented information containing cost allocations. Allocated costs are typically not differential costs and are sunk costs, and therefore are typically not relevant to the decision.
An alternative and more correct view of the decision facing Barbeque Bargains—whether to keep or drop the charcoal barbecues product line—is simply to calculate profitability of this product line before deducting allocated fixed costs using a Contribution Margin Income Statement.
Table B-3 Contribution Margin Income Statement for Barbeque Bargains shows a contribution margin of $50,000 for charcoal barbecues. Deduct direct fixed costs of $40,000 and this product line has a remaining contribution to fixed costs and profits of $10,000. This explains why Barbeque Bargains overall profit would be $10,000 lower if the charcoal barbecues product line were eliminated. (As discussed previously, the allocated fixed costs (sunk costs) are irrelevant to this decision.)
Barbecue Bargains Contribution Margin Income Statement Table B-3 | ||||
Keep All Products | Gas Barbecues | Charcoal Barbecues | Barbecue Accessories | Total |
Sales Revenue | 450,0000 | 90,000 | 60,000 | 600,000 |
Variable Costs | 110,000 | 40,000 | 15,000 | 165,000 |
Contribution Margin | 340,000 | 50,000 | 45,000 | 435,000 |
Direct Fixed Costs | 60,000 | 40,000 | 16,000 | 116,000 |
Contribution to Fixed Costs and Profit | 280,000 | 10,000 | 29,000 | 319,000 |
Fixed Cost | 120,000 | |||
Profit (loss) | 199,000 |
Including Opportunity Costs in Differential Analysis
Managers must often consider the impact of opportunity costs when making decisions. An opportunity cost is the benefit foregone when one alternative is selected over another. For example, assume you have the choice between going to school and working. The opportunity cost of attending school is the lost wages from working.
Question: In the case of Barbeque Bargains, assume the company can lease the space currently being used by the charcoal barbecues product line for $25,000 per year. Thus the opportunity cost (benefit foregone) of keeping the charcoal barbecues is $25,000.
How does this affect Barbeque Accessories decision to keep or drop charcoal barbecues?
Answer:Table B4 Differential Analysis with Opportunity Cost for Barbeque Bargains provides the answer by simply adding one item to Table B-2 Summary of Differential Analysis for Barbeque Bargains. Barbeque Bargans would increase profits $15,000 by dropping the charcoal barbecues.
Summary of Differential Analysis for Barbecue Bargains Including Opportunity Costs - Table B-4 | |
Dropping Charcoal Opportunity Cost | |
Sales revenue lost | (90,000) |
Variable costs eliminated | 40,000 |
Contribution margin eliminated | (50,000) |
Direct fixed costs eliminated | 40,000 |
Loss from dropping product line | (10,000) |
Lease of space formerly used by charcoal barbecue line | 25,000 |
Profit from dropping product line | 15,000 |
Note: Amounts shown in parentheses indicate a negative impact on profit, and amounts without parentheses indicate a positive impact on profit.
Opportunity costs can also be included in the differential analysis format presented in Product Line Differential Analysis for Barbeque Bargains. Panel C Product Line Differential Analysis for Barbeque Bargains is simply modified to reflect the opportunity cost, as shown in Table B-5.
Product Line Differential Analysis for Barbecue Bargains Table B-5 | ||||
Including Opportunity Cost | Keep All Alternative 1 | Drop Charcoal Barbecues Alternative 2 | Differential Amount | Alternative 1 |
Sales Revenue | 600,000 | 510,000 | 90,000 | Higher |
Variable Costs | 165,000 | 125,000 | 40,000 | Higher |
Contribution Margin | 435,000 | 385,000 | 45,000 | Higher |
Direct Fixed Costs | 116,000 | 76,000 | 50,000 | Higher |
Allocated Fixed Cost | 120,000 | 120,000 | 0 | |
Opportunity Costs | 25,000 | 0 | 25,000 | Higher |
Profit (loss) | 174,000 | 189,000 | (15,000) | Lower |
Sunk Costs and Differential Analysis
Question: What is a sunk cost, and how do sunk costs affect differential analysis?
Answer: A sunk cost is a cost incurred in the past that cannot be changed by future decisions. For example, suppose Barbeque Bargains must dispose of store equipment related to the charcoal barbecues product line if charcoal barbecues are eliminated. The original cost of this store equipment is a sunk cost and should have no bearing on the decision whether to eliminate charcoal barbecues. As a general rule, sunk costs are not differential costs.
Example 3 Products
Austin Appliances, Inc.
The following annual income statement is for Austin Appliances, Inc., a maker of electrical appliances:
Austin Appliances, Inc Contribution Margin Income Statement Table A-1 | ||||
All Products | Blenders | Coffee Makers | Toasters | Total |
Sales revenue | 750,000 | 1,000,000 | 250,000 | 2,000,000 |
Variable costs | 320,000 | 550,000 | 100,000 | 970,000 |
Contribution margin | 430,000 | 450,000 | 150,000 | 1,030,000 |
Direct Fixed Costs | 390,000 | 320,000 | 70,000 | 780,000 |
Contribution to Fixed Costs and Profit | 40,000 | 130,000 | 80,000 | 250,000 |
Allocated Fixed costs | 56,250 | 75,000 | 18,750 | 150,000 |
Profit (loss) | ($16,250) | 55,000 | 61,250 | 100,000 |
Break Even Dollars | 778,343 | 877778 | 147,917 | 1,804,038 |
Austin Appliances is concerned about the losses associated with the blenders product line and is considering dropping this product line. Allocated fixed costs are assigned to product lines based on sales. If Austin Appliances eliminates a product line, total allocated fixed costs are assigned to the remaining product lines based on the percentage of sales. All variable costs and direct fixed costs are differential costs.
1. Using the differential analysis format determine whether Austin Appliances would be better off dropping the blenders product line or keeping the product line.
2. Assume Austin Appliances can lease the warehouse space currently being used by the blenders product line for $15,000 per year. How does this affect the company’s decision to keep or drop the blenders product line?
Austin Appliances, Inc Contribution Margin Income Statement - Panel A | ||||
Alternative 1 Keep All Product Lines | ||||
Blenders | Coffee Makers | Toasters | Total | |
Sales revenue | 750,000 | 1,000,000 | 250,000 | 2,000,000 |
Variable costs | 320,000 | 550,000 | 100,000 | 970,000 |
Contribution margin | 430,000 | 450,000 | 150,000 | 1,030,000 |
Direct Fixed Costs | 390,000 | 320,000 | 70,000 | 780,000 |
Contribution to Fixed Costs and Profit | 40,000 | 130,000 | 80,000 | 250,000 |
Allocated fixed costs | 56,250 | 75,000 | 18,750 | 150,000 |
Profit (loss) | (16,250) | 55,000 | 61,250 | 100,000 |
Break Even Dollars | 778,343 | 877,778 | 147,917 | 1,804,038 |
Contribution Margin Income Statement for Austin Appliances - Panel B | ||||
Alternative 2 Drop The Blender Line | ||||
Blenders | Coffee Makers | Toasters | Total | |
Sales revenue | 0 | 1,000,000 | 250,000 | 1,250,000 |
Variable costs | 0 | 550,000 | 100,000 | 650,000 |
Contribution margin | 0 | 450,000 | 150,000 | 600,000 |
Direct Fixed Costs | 0 | 320,000 | 70,000 | 390,000 |
Contribution to Fixed Costs and Profit | 0 | 130,000 | 80,000 | 210,000 |
Allocated fixed costs | 0 | 120,000 | 30,000 | 150,000 |
Profit (loss) | 0 | 10,000 | 50,000 | 60,000 |
Break Even Dollars | 977,778 | 166,667 | 1,144,445 |
As shown in the differential analysis given here, Austin Appliances would be better off keeping the blenders product line.
Dropping this product line would result in a drop in total profit of $40,000.
Austin Appliances, Inc Product Differential Analysis Table A-2 | ||||
Alternative 1 Total Keep All The Product Lines | Alternative 2 Total Drop Blender Line | Differential Amount | Alternative 1 is | |
Sales revenue | 2,000,000 | 1,250,000 | 750,000 | Higher |
Variable costs | 970,000 | 650,000 | 320,000 | Higher |
Contribution margin | 1,030,000 | 600,000 | 430,000 | Higher |
Direct Fixed Costs | 780,000 | 390,000 | 390,000 | Higher |
Contribution to Fixed Costs and Profit | 250,000 | 210,000 | 40,000 | Higher |
Allocated fixed costs | 150,000 | 150,000 | 0 | |
Profit (loss) | 100,000 | 60,000 | 40,000 | Higher |
Break Even Dollars | 1,085,,825 | 1,125,000 |
Summary of Differential Analysis for Austin Appliances, Inc Table A-3 | |
Dropping Blenders | |
Sales revenue lost | (750,000) |
Variable costs eliminated | 320,000 |
Contribution margin eliminated | (430,000) |
Direct fixed costs eliminated | 390,000 |
Loss from dropping product line | (40,000) |
Note: Amounts shown in parentheses indicate a negative impact on profit, and amounts without parentheses indicate a positive impact on profit.
The $15,000 opportunity cost of keeping all three product lines would not affect the company’s decision to keep the blenders product line. If the blenders are dropped, total profit will decrease by $40,000. Lease revenue of $15,000 is not enough to offset the $40,000 decrease in profit. In this scenario, total profit would decrease by $25,000 . This result is presented formally, as follows:
Summary of Differential Analysis for Austin Appliances, Inc With Opportunity Cost Table A-4 | |
Dropping Blenders Lease Warehouse | |
Sales revenue lost | (750,000) |
Variable costs eliminated | 320,000 |
Contribution margin eliminated | (430,000) |
Direct fixed costs eliminated | 390,000 |
Lease of space formerly used by blender line | 15,000 |
Loss from dropping product line | (25,000) |
Note: Amounts shown in parentheses indicate a negative impact on profit, and amounts without parentheses indicate a positive impact on profit.