Question

In: Accounting

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 $ 923,000 $ 267,000 $ 401,000 $ 255,000
Variable manufacturing and selling expenses 472,000 115,000 207,000 150,000
Contribution margin 451,000 152,000 194,000 105,000
Fixed expenses:
Advertising, traceable 68,800 8,200 40,400 20,200
Depreciation of special equipment 43,700 20,900 7,600 15,200
Salaries of product-line managers 116,300 40,600 38,700 37,000
Allocated common fixed expenses* 184,600 53,400 80,200 51,000
Total fixed expenses 413,400 123,100 166,900 123,400
Net operating income (loss) $ 37,600 $ 28,900 $ 27,100 $ (18,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.

Solutions

Expert Solution

1
Current Total Total If Racing Bikes Are Dropped Difference: Net Operating Income
Sales 923000 668000 -255000
Variable manufacturing and selling expenses 472000 322000 150000
Contribution margin (loss) 451000 346000 -105000
Fixed expenses:
Advertising, traceable 68800 48600 20200
Depreciation on special equipment 43700 43700 0
Salaries of product manager 116300 79300 37000
Common allocated costs 184600 184600 0
Total fixed expenses 413400 356200 57200
Net operating income (loss) 37600 -10200 -47800
Financial (disadvantage) $(47800)
2
No, production and sale of racing bikes should not be discontinued
3
Total Dirt Bikes Mountain Bikes Racing Bikes
Sales 923000 267000 401000 255000
Variable manufacturing and selling expenses 472000 115000 207000 150000
Contribution margin (loss) 451000 152000 194000 105000
Traceable fixed expenses:
Advertising, traceable 68800 8200 40400 20200
Depreciation on special equipment 43700 20900 7600 15200
Salaries of product manager 116300 40600 38700 37000
Total traceable fixed expenses 228800 69700 86700 72400
Product line segment margin 222200 82300 107300 32600
Common fixed expenses 184600
Net operating income (loss) 37600

Related Solutions

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...
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 $ 267,000 $ 404,000 $ 253,000 Variable manufacturing and selling expenses 466,000 111,000 201,000 154,000 Contribution margin 458,000 156,000 203,000 99,000 Fixed expenses: Advertising, traceable 70,100 8,700 40,700 20,700 Depreciation of special equipment 43,500 20,200 7,900 15,400 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 $ 916,000 $ 263,000 $ 402,000 $ 251,000 Variable manufacturing and selling expenses 461,000 116,000 193,000 152,000 Contribution margin 455,000 147,000 209,000 99,000 Fixed expenses: Advertising, traceable 69,300 8,600 40,400 20,300 Depreciation of special equipment 43,600 20,600 7,300 15,700 Salaries of product-line managers 115,500...
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 $ 269,000 $ 407,000 $ 251,000 Variable manufacturing and selling expenses 478,000 112,000 207,000 159,000 Contribution margin 449,000 157,000 200,000 92,000 Fixed expenses: Advertising, traceable 68,900 8,600 40,100 20,200 Depreciation of special equipment 43,300 20,400 7,400 15,500 Salaries of product-line managers 114,200...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT