Question

In: Finance

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 $ 917,000 $ 264,000 $ 401,000 $ 252,000
Variable manufacturing and selling expenses 466,000 110,000 202,000 154,000
Contribution margin 451,000 154,000 199,000 98,000
Fixed expenses:
Advertising, traceable 69,600 8,400 41,000 20,200
Depreciation of special equipment 43,900 20,600 7,900 15,400
Salaries of product-line managers 116,200 40,800 38,900 36,500
Allocated common fixed expenses* 183,400 52,800 80,200 50,400
Total fixed expenses 413,100 122,600 168,000 122,500
Net operating income (loss) $ 37,900 $ 31,400 $ 31,000 $ (24,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.

Solutions

Expert Solution

Relevant fixed expenses will be considered for the purpose of this decision and allocated costs will be irrelevant since these costs will not change as a result of this decision

1.Financial Advantage/(Disadvantage)of discontinuing the racing bikes = Fixed costs saved – Contribution Margin lost

= 56,700-98,000

= $(41,300)

Depreciation is sunk cost and allocation fixed expenses are not relevant

2.No, since it will reduce net income

3.

Totals

Dirt Bikes

Mountain Bikes

Racing Bikes

Sales

917,000

264,000

401,000

252,000

Less: Variable Costs

466,000

110,000

202,000

154,000

Contribution Margin (loss)

451,000

154,000

199,000

98,000

Traceable Fixed Expenses:

Advertising

69,600

8,400

41,000

20,200

Depreciation

43,900

20,600

7,900

15,400

Salaries

116,200

40,800

38,900

36,500

Total traceable fixed expenses

229,700

69,800

87,800

72,100

Product line segment margin (loss)

221,300

84,200

111,200

25,900

Common Fixed Expenses

183,400

Net Operating income (loss)

37,900


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