Question

In: Accounting

he Regal Cycle Company manufactures three types of bicycles—a dirt bike, a mountain bike, and a...

he 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 $ 932,000 $ 269,000 $ 406,000 $ 257,000 Variable manufacturing and selling expenses 473,000 114,000 199,000 160,000 Contribution margin 459,000 155,000 207,000 97,000 Fixed expenses: Advertising, traceable 69,800 8,400 40,700 20,700 Depreciation of special equipment 43,700 20,400 8,000 15,300 Salaries of product-line managers 114,700 40,600 38,500 35,600 Allocated common fixed expenses* 186,400 53,800 81,200 51,400 Total fixed expenses 414,600 123,200 168,400 123,000 Net operating income (loss) $ 44,400 $ 31,800 $ 38,600 $ (26,000) *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.

Solutions

Expert Solution

Ans:

Part-1 Computa of Total Financial Advantage / Disadvantge by Droppng Racing Bikes
Current Total Total If Racing Bikes Are Dropped Difference: NetOperating Income
Sales $ 932,000.00 $ 675,000.00 $ -257,000.00
Variable Manufacturing And Selling Expenses $ 473,000.00 $ 313,000.00 $ -160,000.00
Contribution Margin (Loss) (a) $ 459,000.00 $ 362,000.00 $ -97,000.00
Fixed Expenses:
Advertising, Traceable $ 69,800.00 $ 49,100.00 $ -20,700.00
Depreciation On Special Equipment $ 43,700.00 $ 28,400.00 $ -15,300.00
Salaries Of Product Manager $ 114,700.00 $ 79,100.00 $ -35,600.00
Common Allocated Costs $ 186,400.00 $ 135,000.00 $ -51,400.00
Total Fixed Expenses (b) $ 414,600.00 $ 291,600.00 $ -123,000.00
Net Operating Income (Loss) (a-b) $ 44,400.00 $ 70,400.00 $ 26,000.00
Financial advantage of $26000 by dropping Racing Bikes
Part-2 Yes, racing bikes should be discontinued
Part-3
Total Dirt Bikes Mountain Bikes Racing Bikes
Sales $ 932,000.00 $ 269,000.00 $ 406,000.00 $ 257,000.00
Variable Manufacturing And Selling Expenses $ 473,000.00 $ 114,000.00 $ 199,000.00 $ 160,000.00
Contribution Margin (Loss) (a) $ 459,000.00 $ 155,000.00 $ 207,000.00 $ 97,000.00
Traceable Fixed Expenses:
Advertising, Traceable $ 69,800.00 $ 8,400.00 $ 40,700.00 $ 20,700.00
Depreciation On Special Equipment $ 43,700.00 $ 20,400.00 $ 8,000.00 $ 15,300.00
Salaries Of Product Manager $ 114,700.00 $ 40,600.00 $ 38,500.00 $ 35,600.00
Total Traceable Fixed Expenses (b) $ 228,200.00 $ 69,400.00 $ 87,200.00 $ 71,600.00
Product Line Segment Margin (a-) $ 230,800.00 $ 85,600.00 $ 119,800.00 $ 25,400.00
Common Fixed Expenses $ 186,400.00
Net Operating Income (Loss) $ 44,400.00

Related Solutions

he Regal Cycle Company manufactures three types of bicycles—a dirt bike, a mountain bike, and a...
he 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 $ 929,000 $ 270,000 $ 405,000 $ 254,000 Variable manufacturing and selling expenses 473,000 119,000 196,000 158,000 Contribution margin 456,000 151,000 209,000 96,000 Fixed expenses: Advertising, traceable 69,600 8,300 40,400 20,900 Depreciation of special equipment 44,200 20,800 7,500 15,900 Salaries of product-line managers 115,000...
he Regal Cycle Company manufactures three types of bicycles—a dirt bike, a mountain bike, and a...
he 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 $ 925,000 $ 267,000 $ 402,000 $ 256,000 Variable manufacturing and selling expenses 455,000 112,000 192,000 151,000 Contribution margin 470,000 155,000 210,000 105,000 Fixed expenses: Advertising, traceable 70,000 9,000 40,300 20,700 Depreciation of special equipment 43,700 20,600 7,400 15,700 Salaries of product-line managers 115,900...
he Regal Cycle Company manufactures three types of bicycles—a dirt bike, a mountain bike, and a...
he 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 $ 933,000 $ 266,000 $ 407,000 $ 260,000 Variable manufacturing and selling expenses 474,000 116,000 205,000 153,000 Contribution margin 459,000 150,000 202,000 107,000 Fixed expenses: Advertising, traceable 69,400 8,200 40,500 20,700 Depreciation of special equipment 42,700 20,300 7,300 15,100 Salaries of product-line managers 116,300...
The Regal Cycle Company manufactures three types of bicycles—a dirt bike, a mountain bike, and a...
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 $ 927,000 $ 262,000 $ 407,000 $ 258,000 Variable manufacturing and selling expenses 475,000 117,000 200,000 158,000 Contribution margin 452,000 145,000 207,000 100,000 Fixed expenses: Advertising, traceable 69,400 8,200 40,300 20,900 Depreciation of special equipment 44,700 21,000 7,900 15,800 Salaries of product-line managers 114,400...
The Regal Cycle Company manufactures three types of bicycles—a dirt bike, a mountain bike, and a...
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 $ 935,000 $ 269,000 $ 408,000 $ 258,000 Variable manufacturing and selling expenses 472,000 118,000 203,000 151,000 Contribution margin 463,000 151,000 205,000 107,000 Fixed expenses: Advertising, traceable 69,500 8,400 40,600 20,500 Depreciation of special equipment 43,800 21,000 7,300 15,500 Salaries of product-line managers 114,900...
The Regal Cycle Company manufactures three types of bicycles—a dirt bike, a mountain bike, and a...
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 $ 919,000 $ 262,000 $ 401,000 $ 256,000 Variable manufacturing and selling expenses 471,000 118,000 198,000 155,000 Contribution margin 448,000 144,000 203,000 101,000 Fixed expenses: Advertising, traceable 69,300 8,300 40,700 20,300 Depreciation of special equipment 44,100 20,900 7,900 15,300 Salaries of product-line managers 115,700...
The Regal Cycle Company manufactures three types of bicycles—a dirt bike, a mountain bike, and a...
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 $ 926,000 $ 268,000 $ 402,000 $ 256,000 Variable manufacturing and selling expenses 472,000 115,000 200,000 157,000 Contribution margin 454,000 153,000 202,000 99,000 Fixed expenses: Advertising, traceable 70,100 8,900 40,200 21,000 Depreciation of special equipment 43,300 20,400 7,300 15,600 Salaries of product-line managers 115,200...
The Regal Cycle Company manufactures three types of bicycles—a dirt bike, a mountain bike, and a...
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 $ 918,000 $ 261,000 $ 404,000 $ 253,000 Variable manufacturing and selling expenses 462,000 114,000 196,000 152,000 Contribution margin 456,000 147,000 208,000 101,000 Fixed expenses: Advertising, traceable 69,500 8,600 40,800 20,100 Depreciation of special equipment 44,000 20,200 7,800 16,000 Salaries of product-line managers 116,100...
The Regal Cycle Company manufactures three types of bicycles—a dirt bike, a mountain bike, and a...
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 $ 929,000 $ 261,000 $ 409,000 $ 259,000 Variable manufacturing and selling expenses 478,000 116,000 209,000 153,000 Contribution margin 451,000 145,000 200,000 106,000 Fixed expenses: Advertising, traceable 70,400 8,600 41,000 20,800 Depreciation of special equipment 44,400 20,900 7,600 15,900 Salaries of product-line managers 115,800...
The Regal Cycle Company manufactures three types of bicycles—a dirt bike, a mountain bike, and a...
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 $ 924,000 $ 265,000 $ 406,000 $ 253,000 Variable manufacturing and selling expenses 477,000 117,000 209,000 151,000 Contribution margin 447,000 148,000 197,000 102,000 Fixed expenses: Advertising, traceable 69,600 8,400 41,000 20,200 Depreciation of special equipment 43,000 20,400 7,400 15,200 Salaries of product-line managers 113,600...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT