In: Accounting
The Regal Cycle Company manufactures three types of bicycles—a dirt bike, a mountain bike, and a racing bike. Data on sales and expenses for the past quarter follow:
Total |
Dirt |
Mountain Bikes |
Racing |
|||||||||
Sales |
$ |
930,000 |
$ |
269,000 |
$ |
402,000 |
$ |
259,000 |
||||
Variable manufacturing and selling expenses |
467,000 |
117,000 |
192,000 |
158,000 |
||||||||
Contribution margin |
463,000 |
152,000 |
210,000 |
101,000 |
||||||||
Fixed expenses: |
||||||||||||
Advertising, traceable |
70,500 |
8,800 |
41,000 |
20,700 |
||||||||
Depreciation of special equipment |
42,500 |
20,200 |
7,100 |
15,200 |
||||||||
Salaries of product-line managers |
115,100 |
40,700 |
38,800 |
35,600 |
||||||||
Allocated common fixed expenses* |
186,000 |
53,800 |
80,400 |
51,800 |
||||||||
Total fixed expenses |
414,100 |
123,500 |
167,300 |
123,300 |
||||||||
Net operating income (loss) |
$ |
48,900 |
$ |
28,500 |
$ |
42,700 |
$ |
(22,300) |
||||
*Allocated on the basis of sales dollars.
Management is concerned about the continued losses shown by the racing bikes and wants a recommendation as to whether or not the line should be discontinued. The special equipment used to produce racing bikes has no resale value and does not wear out.
Required:
1. What is the financial advantage (disadvantage) per quarter of discontinuing the Racing Bikes?
2. Should the production and sale of racing bikes be discontinued?
3. Prepare a properly formatted segmented income statement that would be more useful to management in assessing the long-run profitability of the various product lines.
Incremental Analysis | |||||||
TOTAL | Discontinue | Net Increase/(Decrease) | |||||
AMOUNT $ | AMOUNT $ | AMOUNT $ | |||||
Sales Revenue | 930,000 | 671,000 | -259,000 | ||||
Less: Variable cost | 467,000 | 309,000 | 158,000 | ||||
Contribution margin | 463,000 | 362,000 | -101,000 | ||||
Less: Fixed cost | |||||||
Advertisement | 70,500 | 49,800 | 20,700 | ||||
Depreciation | 42,500 | 42,500 | 0 | ||||
Salary of product line manager | 115,100 | 79,500 | 35,600 | ||||
Common Fixed cost | 186,000 | 186,000 | 0 | ||||
SEGMENT MARGIN | 48,900 | 4,200 | -44,700 | ||||
No, Racing Rike Division Shall not be Discontinued | |||||||
SEGMENT-WISE INCOME STATEMENT | |||||||
TOTAL | Dirt | Mountain | Racing | ||||
AMOUNT $ | AMOUNT $ | AMOUNT $ | AMOUNT $ | ||||
Sales Revenue | 930,000 | 269,000 | 402,000 | 259,000 | |||
Less: Variable cost | 467,000 | 117,000 | 192,000 | 158,000 | |||
Contribution margin | 463,000 | 152,000 | 210,000 | 101,000 | |||
Less: Traceable Expense | |||||||
Advertisement | 70,500 | 8,800 | 41,000 | 20,700 | |||
Depreciation | 42,500 | 20,200 | 7,100 | 15,200 | |||
Salary of product line manager | 115,100 | 40,700 | 38,800 | 35,600 | |||
Total Traecable expense | 228,100 | 69,700 | 86,900 | 71,500 | |||
SEGMENT MARGIN | 234,900 | 82,300 | 123,100 | 29,500 | |||
Less: Common Fixed expesne | 186,000 | ||||||
Net Operating Income | 48,900 | ||||||