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 $ 934,000 $ 267,000 $ 409,000 $ 258,000 Variable manufacturing and selling expenses 466,000 114,000 200,000 152,000 Contribution margin 468,000 153,000 209,000 106,000 Fixed expenses: Advertising, traceable 69,300 8,400 40,200 20,700 Depreciation of special equipment 43,700 20,700 7,600 15,400 Salaries of product-line managers 114,400 40,200 38,400 35,800 Allocated common fixed expenses* 186,800 53,400 81,800 51,600 Total fixed expenses 414,200 122,700 168,000 123,500 Net operating income (loss) $ 53,800 $ 30,300 $ 41,000 $ (17,500) *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.
Ans:
| 1 .Computation of Total Financial Advantage / Disadvantage by Dropping Racing Bikes | ||||
| Current Total | Total If Racing Bikes Are Dropped | Difference: Net Operating Income | ||
| Sales | $ 934,000.00 | $ 676,000.00 | $ -258,000.00 | |
| Variable Manufacturing And Selling Expenses | $ 466,000.00 | $ 314,000.00 | $ 152,000.00 | |
| Contribution Margin (Loss) (a) | $ 468,000.00 | $ 362,000.00 | $ -106,000.00 | |
| Fixed Expenses: | ||||
| Advertising, Traceable | $ 69,300.00 | $ 48,600.00 | $ 20,700.00 | |
| Depreciation On Special Equipment | $ 43,700.00 | $ 43,700.00 | $ 0.00 | |
| Salaries Of Product Manager | $ 114,400.00 | $ 78,600.00 | $ 35,800.00 | |
| Common Allocated Costs | $ 186,800.00 | $ 186,800.00 | $ 0.00 | |
| Total Fixed Expenses (b) | $ 414,200.00 | $ 357,700.00 | $ 56,500.00 | |
| Net Operating Income (Loss) (a-b) | $ 53,800.00 | $ 4,300.00 | $ -49,500.00 | |
| Financial Disadvantage for 49500 by dropping Racing Bikes | ||||
| 2. No | ||||
| 3. | ||||
| Total | Dirt Bikes | Mountain Bikes | Racing Bikes | |
| Sales | $ 934,000.00 | $ 267,000.00 | $ 409,000.00 | $ 258,000.00 |
| Variable Manufacturing And Selling Expenses | $ 466,000.00 | $ 114,000.00 | $ 200,000.00 | $ 152,000.00 |
| Contribution Margin (Loss) (a) | $ 468,000.00 | $ 153,000.00 | $ 209,000.00 | $ 106,000.00 |
| Traceable Fixed Expenses: | ||||
| Advertising, Traceable | $ 69,300.00 | $ 8,400.00 | $ 40,200.00 | $ 20,700.00 |
| Depreciation On Special Equipment | $ 43,700.00 | $ 20,700.00 | $ 7,600.00 | $ 15,400.00 |
| Salaries Of Product Manager | $ 114,400.00 | $ 40,200.00 | $ 38,400.00 | $ 35,800.00 |
| Total Traceable Fixed Expenses (b) | $ 227,400.00 | $ 69,300.00 | $ 86,200.00 | $ 71,900.00 |
| Product Line Segment Margin (a-) | $ 240,600.00 | $ 83,700.00 | $ 122,800.00 | $ 34,100.00 |
| Common Fixed Expenses | $ 186,800.00 | |||
| Net Operating Income (Loss) | $ 53,800.00 | |||
| 3. Yes , Segmental income is more Useful. | ||||
Hope this helped ! Let me know in case of any queries.