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 Bikes Mountain Bikes Racing Bikes Sales $ 923,000 $ 265,000 $ 400,000 $ 258,000 Variable manufacturing and selling expenses 464,000 116,000 197,000 151,000 Contribution margin 459,000 149,000 203,000 107,000 Fixed expenses: Advertising, traceable 70,000 8,900 40,200 20,900 Depreciation of special equipment 44,400 21,000 7,900 15,500 Salaries of product-line managers 115,800 40,800 38,600 36,400 Allocated common fixed expenses* 184,600 53,000 80,000 51,600 Total fixed expenses 414,800 123,700 166,700 124,400 Net operating income (loss) $ 44,200 $ 25,300 $ 36,300 $ (17,400) *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.
1 | ||||
Current Total | Total If Racing Bikes Are Dropped | Difference: NetOperatingIncome | ||
Sales | 923000 | 665000 | -258000 | |
Variable manufacturing and selling expenses | 464000 | 313000 | 151000 | |
Contribution margin (loss) | 459000 | 352000 | -107000 | |
Fixed expenses: | ||||
Advertising, traceable | 70000 | 49100 | 20900 | |
Depreciation on special equipment | 44400 | 44400 | 0 | |
Salaries of product manager | 115800 | 79400 | 36400 | |
Common allocated costs | 184600 | 184600 | 0 | |
Total fixed expenses | 414800 | 357500 | 57300 | |
Net operating income (loss) | 44200 | -5500 | -49700 | |
Financial (disadvantage) ($49700) | ||||
2 | ||||
No | ||||
3 | ||||
Total | Dirt Bikes | Mountain Bikes | Racing Bikes | |
Sales | 923000 | 265000 | 400000 | 258000 |
Variable manufacturing and selling expenses | 464000 | 116000 | 197000 | 151000 |
Contribution margin (loss) | 459000 | 149000 | 203000 | 107000 |
Traceable fixed expenses: | ||||
Advertising, traceable | 70000 | 8900 | 40200 | 20900 |
Depreciation on special equipment | 44400 | 21000 | 7900 | 15500 |
Salaries of product manager | 115800 | 40800 | 38600 | 36400 |
Total traceable fixed expenses | 230200 | 70700 | 86700 | 72800 |
Product line segment margin | 228800 | 78300 | 116300 | 34200 |
Common fixed expenses | 184600 | |||
Net operating income (loss) | 44200 |