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

$

924,000

$

270,000

$

402,000

$

252,000

Variable manufacturing and selling expenses

456,000

114,000

190,000

152,000

Contribution margin

468,000

156,000

212,000

100,000

Fixed expenses:

Advertising, traceable

69,700

8,200

40,800

20,700

Depreciation of special equipment

43,100

20,200

7,500

15,400

Salaries of product-line managers

115,500

41,000

38,800

35,700

Allocated common fixed expenses*

184,800

54,000

80,400

50,400

Total fixed expenses

413,100

123,400

167,500

122,200

Net operating income (loss)

$

54,900

$

32,600

$

44,500

$

(22,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.

What is the financial advantage (disadvantage) per quarter of discontinuing the Racing Bikes?

requirement_content

requr_content_cntr

requirement_cntr

sheet is drawn here

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.

requirement_content

requr_content_cntr

requirement_cntr

Totals

Dirt Bikes

Mountain Bikes

Racing Bikes

Contribution margin (loss)

Traceable fixed expenses:

Total traceable fixed expenses

Product line segment margin (loss)

Net operating income (loss)

Solutions

Expert Solution

Incremental Analysis
TOTAL Discontinue Net Increase/(Decrease)
AMOUNT $ AMOUNT $ AMOUNT $
Sales Revenue 924,000 672,000 -252,000
Less: Variable cost 456,000 304,000 152,000
Contribution margin 468,000 368,000 -100,000
Less: Fixed cost
Advertisement 69,700 49,000 20,700
Depreciation 43,100 43,100 0
Salary of product line manager 115,500 79,800 35,700
Common Fixed cost 184,800 184,800 0
SEGMENT MARGIN 54,900 11,300 -43,600
No, Racing Rike Division Shall not be Discontinued
SEGMENT-WISE INCOME STATEMENT
TOTAL Dirt Mountain Racing
AMOUNT $ AMOUNT $ AMOUNT $ AMOUNT $
Sales Revenue 924,000 270,000 402,000 252,000
Less: Variable cost 456,000 114,000 190,000 152,000
Contribution margin 468,000 156,000 212,000 100,000
Less: Traceable Expense
Advertisement 69,700 8,200 40,800 20,700
Depreciation 43,100 20,200 7,500 15,400
Salary of product line manager 115,500 41,000 38,800 35,700
Total Traecable expense 228,300 69,400 87,100 71,800
SEGMENT MARGIN 239,700 86,600 124,900 28,200
Less: Common Fixed expesne 184,800
Net Operating Income 54,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