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 $ 931,000 $ 268,000 $ 405,000 $ 258,000
Variable manufacturing and selling expenses 481,000 116,000 210,000 155,000
Contribution margin 450,000 152,000 195,000 103,000
Fixed expenses:
Advertising, traceable 69,400 8,300 40,600 20,500
Depreciation of special equipment 43,900 20,900 7,500 15,500
Salaries of product-line managers 115,500 40,900 38,000 36,600
Allocated common fixed expenses* 186,200 53,600 81,000 51,600
Total fixed expenses 415,000 123,700 167,100 124,200
Net operating income (loss) $ 35,000 $ 28,300 $ 27,900 $ (21,200)

*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 931000 673000 -258000
Variable manufacturing and selling expenses 481000 326000 155000
Contribution margin (loss) 450000 347000 -103000
Fixed expenses:
Advertising, traceable 69400 48900 20500
Depreciation on special equipment 43900 43900 0
Salaries of product manager 115500 78900 36600
Common allocated costs 186200 186200 0
Total fixed expenses 415000 357900 57100
Net operating income (loss) 35000 -10900 -45900
Financial (disadvantage) $(45900)
2
No, production and sale of racing bikes should not be discontinued
3
Total Dirt Bikes Mountain Bikes Racing Bikes
Sales 931000 268000 405000 258000
Variable manufacturing and selling expenses 481000 116000 210000 155000
Contribution margin (loss) 450000 152000 195000 103000
Traceable fixed expenses:
Advertising, traceable 69400 8300 40600 20500
Depreciation on special equipment 43900 20900 7500 15500
Salaries of product manager 115500 40900 38000 36600
Total traceable fixed expenses 228800 70100 86100 72600
Product line segment margin 221200 81900 108900 30400
Common fixed expenses 186200
Net operating income (loss) 35000

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