Go to content

Add Delete Product Decisions - New Project 5

Decision Making
Bean Counter
Title
Skip menu
Skip menu

Add Delete Product Decisions

Skip menu
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 SandwitchesAlternative 2 Add CookiesDifferential AmountAlternative 1 is
Sales Revenue18,00010,0008,000Higher
Variable Costs13,0003,00010,000Higher
Contribution Margin5,0007,000(2,000)Lower
Fixed Costs5000500Higher
Profit4,5007,000(2,500)Lower
Break Even Dollars1,800N/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 BarbecuesCharcoal BarbecuesBarbecue AccessoriesTotal
Sales Revenue$450,000$90,000$60,000$600,000
Variable Costs110,00040,00015,000165,000
Contribution Margin$340,000$50,000$45,000$435,000
Direct Fixed Costs60,00040,00016,000116,000
Allocated Fixed Cost90,00018,00012,000120,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 ProductsGas BarbecuesCharcoal BarbecuesBarbecue AccessoriesTotal
Sales Revenue450,00090,00060,000600,000
Variable Costs110,00040,00015,000165,000
Contribution Margin340,00050,00045,000435,000
Direct Fixed Costs60,00040,00016,000116,000
Contribution to Fixed Costs and Profit
280,00010,00029,000319,000
Allocated Fixed Cost90,00018,00012,000120,000
Profit (loss)190,000(8,000)17,000199,000
Break Even Dollars198,529104,40037,333340,262
Barbeque Bargains Income Statement  Panel B
Drop Charcoal Grill LineGas BarbecuesCharcoal BarbecuesBarbecue AccessoriesTotal
Sales Revenue450,000060,000510,000
Variable Costs110,000015,000125,000
Contribution Margin340,000045,000385,000
Direct Fixed Costs60,000016,00076,000
Contribution to Fixed Costs and Profit
280,000029,000309,000
Allocated Fixed Cost105,882014,118120,000
Profit (loss)174,118014,882189,000
Break Even Dollars219,550
40,157259,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 LineAlternative 1
Keep All
Alternative 2
Drop Charcoal Barbecues
Differential AmountAlternative 1
Sales Revenue600,000510,00090,000Higher
Variable Costs165,000125,00040,000Higher
Contribution Margin435,000385,00045,000Higher
Direct Fixed Costs116,00076,00050,000Higher
Contribution to Fixed Costs and Profit
319,000309,00010,000Higher
Allocated Fixed Cost120,000120,0000
Profit (loss)199,000189,00010,000Higher
Break Even Dollars325,517259,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 eliminated40,000
Contribution margin eliminated(50,000)
Direct fixed costs eliminated40,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 ProductsGas BarbecuesCharcoal BarbecuesBarbecue AccessoriesTotal
Sales Revenue450,000090,00060,000600,000
Variable Costs110,00040,00015,000165,000
Contribution Margin340,00050,00045,000435,000
Direct Fixed Costs60,00040,00016,000116,000
Contribution to Fixed Costs and Profit280,00010,00029,000319,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 eliminated40,000
Contribution margin eliminated(50,000)
Direct fixed costs eliminated40,000
Loss from dropping product line
(10,000)
Lease of space formerly used  by charcoal barbecue line25,000
Profit from dropping product line15,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 CostKeep All Alternative 1Drop Charcoal Barbecues Alternative 2Differential AmountAlternative 1
Sales Revenue600,000510,00090,000Higher
Variable Costs165,000125,00040,000Higher
Contribution Margin435,000385,00045,000Higher
Direct Fixed Costs116,00076,00050,000Higher
Allocated Fixed Cost120,000120,0000
Opportunity Costs25,000025,000Higher
Profit (loss)174,000189,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 ProductsBlendersCoffee MakersToastersTotal
Sales revenue750,0001,000,000250,0002,000,000
Variable costs320,000550,000100,000970,000
Contribution margin430,000450,000150,0001,030,000
Direct Fixed Costs390,000320,00070,000780,000
Contribution to Fixed Costs and Profit
40,000130,00080,000250,000
Allocated Fixed costs56,25075,00018,750150,000
Profit (loss)($16,250)55,00061,250100,000
Break Even Dollars778,343877778147,9171,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


BlendersCoffee MakersToastersTotal
Sales revenue750,0001,000,000250,0002,000,000
Variable costs320,000550,000100,000970,000
Contribution margin430,000450,000150,0001,030,000
Direct Fixed Costs390,000320,00070,000780,000
Contribution to Fixed Costs and Profit
40,000130,00080,000250,000
Allocated fixed costs56,25075,00018,750150,000
Profit (loss)(16,250)55,00061,250100,000
Break Even Dollars778,343877,778147,9171,804,038
Contribution Margin Income Statement for Austin Appliances - Panel B
Alternative 2 Drop The Blender Line


BlendersCoffee MakersToastersTotal
Sales revenue01,000,000250,0001,250,000
Variable costs0550,000100,000650,000
Contribution margin0450,000150,000600,000
Direct Fixed Costs0320,00070,000390,000
Contribution to Fixed Costs and Profit
0130,00080,000210,000
Allocated fixed costs0120,00030,000150,000
Profit (loss)010,00050,00060,000
Break Even Dollars
977,778166,6671,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 AmountAlternative 1 is
Sales revenue2,000,0001,250,000750,000Higher
Variable costs
970,000650,000320,000
Higher
Contribution margin1,030,000600,000430,000Higher
Direct Fixed Costs780,000390,000390,000Higher
Contribution to Fixed Costs and Profit
250,000210,00040,000Higher
Allocated fixed costs150,000150,0000
Profit (loss)100,00060,00040,000Higher
Break Even Dollars1,085,,8251,125,000

Summary of Differential Analysis for Austin Appliances, Inc
Table A-3
Dropping Blenders


Sales revenue lost(750,000)
Variable costs eliminated320,000
Contribution margin eliminated(430,000)
Direct fixed costs eliminated390,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 eliminated320,000
Contribution margin eliminated(430,000)
Direct fixed costs eliminated390,000
Lease of space formerly used by blender line15,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.
Title
Lorem ipsum dolor sit amet, consectetur adipiscing elit.
Back to content