In: Accounting
Barbour Corporation, located in Buffalo, New York, is a retailer of high-tech products and is known for its excellent quality and innovation. Recently, the firm conducted a relevant cost analysis of one of its product lines that has only two products, T-1 and T-2. The sales for T-2 are decreasing and the purchase costs are increasing. The firm might drop T-2 and sell only T-1.
Barbour allocates fixed costs to products on the basis of sales revenue. When the president of Barbour saw the income statements (see below), he agreed that T-2 should be dropped. If T-2 is dropped, sales of T-1 are expected to increase by 10% next year, but the firm's cost structure will remain the same.
T-1 | T-2 | |
---|---|---|
Sales | $245,000 | $296,000 |
Variable costs: | ||
Cost of goods sold | 79,000 | 148,000 |
Selling & administrative | 19,000 | 59,000 |
Contribution margin | $147,000 | $89,000 |
Fixed expenses: | ||
Fixed corporate costs | 69,000 | 84,000 |
Fixed selling and administrative | 21,000 | 30,000 |
Total fixed expenses | $90,000 | $114,000 |
Operating income | $57,000 | $(25,000) |
Required:
1. Find the expected change in annual operating income by dropping T-2 and selling only T-1 .
2. By what percentage would sales from T-1 have to increase in order to make up the financial loss from dropping T-2? (Enter your answer as a percentage rounded to 2 decimal places (i.e. 0.1234 should be entered as 12.34).)
3. What is the required percentage increase in sales from T-1 to compensate for lost margin from T-2, if total fixed costs can be reduced by $53,000? (Enter your answer as a percentage rounded to 2 decimal places (i.e. 0.1234 should be entered as 12.34) ..)
1. | |||
---|---|---|---|
2. | Required % increase in sales of T-1 | % | |
3. | Required % increase in sales from T-1 | % |
Barbour Corporation | ||||
Current contribution margin income statement | T-1 | T-2 | Total | Note |
Sales | 245,000.00 | 296,000.00 | 541,000.00 | A |
Less: Variable costs | ||||
The variable cost of goods sold | 79,000.00 | 148,000.00 | 227,000.00 | |
Variable selling and admin expense | 19,000.00 | 59,000.00 | 78,000.00 | |
Contribution margin | 147,000.00 | 89,000.00 | 236,000.00 | B |
Less: Fixed costs | ||||
Fixed corporate costs | 69,000.00 | 84,000.00 | 153,000.00 | |
Fixed selling and admin expense | 21,000.00 | 30,000.00 | 51,000.00 | |
Operating Income (loss) | 57,000.00 | (25,000.00) | 32,000.00 | C |
Contribution margin % | 60.00% | 30.07% | D=B/A | |
Increase in T-1 sales by 10% | 24,500.00 | E=A*10% | ||
Increase in T-1 Contribution margin by | 14,700.00 | F=E*D | ||
Answer 1 | Incremental analysis for Discontinuation Decision | |||
Contribution margin lost if T-2 Discontinued | 89,000.00 | See B | ||
Less: Increase in T-1 Contribution margin | 14,700.00 | See F | ||
Operating Income will decrease by | 74,300.00 | G=B-F | ||
Answer 2 | Total | |||
Contribution margin lost if T-2 Discontinued. | 89,000.00 | See B | ||
Contribution margin % of T1 | 60.00% | See D | ||
Increase in sales of T1 | 148,333.33 | H=B/D | ||
Current sales of T1 | 245,000.00 | See A | ||
Increase % | 60.54% | I=H/A | ||
Answer 3 | Total | |||
Contribution margin lost if T-2 Discontinued. | 89,000.00 | See B | ||
More minor: decrease in fixed costs | 53,000.00 | J | ||
Net financial loss | 36,000.00 | K=B-J | ||
Contribution margin % of T1 | 60.00% | See D | ||
Increase in sales of T1 | 60,000.00 | L=K/D | ||
Current sales of T1 | 245,000.00 | See A | ||
Increase % | 24.49% | M=L/A | ||