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 | $ | 266,000 | $ | 400,000 | $ | 251,000 | ||||
Variable manufacturing and selling expenses | 464,000 | 116,000 | 196,000 | 152,000 | ||||||||
Contribution margin | 453,000 | 150,000 | 204,000 | 99,000 | ||||||||
Fixed expenses: | ||||||||||||
Advertising, traceable | 69,200 | 8,200 | 40,500 | 20,500 | ||||||||
Depreciation of special equipment | 44,300 | 21,000 | 7,500 | 15,800 | ||||||||
Salaries of product-line managers | 114,200 | 40,200 | 38,700 | 35,300 | ||||||||
Allocated common fixed expenses* | 183,400 | 53,200 | 80,000 | 50,200 | ||||||||
Total fixed expenses | 411,100 | 122,600 | 166,700 | 121,800 | ||||||||
Net operating income (loss) | $ | 41,900 | $ | 27,400 | $ | 37,300 | $ | (22,800) | ||||
*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.
Answer:
1
Total |
|||
Total |
If racing bike |
Diffrance: |
|
Sales |
917000 |
666000 |
-251000 |
Variable manufacturing and selling expenses |
464000 |
312000 |
152000 |
Contribution margin |
453000 |
354000 |
-99000 |
Fixed expenses: |
|||
Advertising, traceable |
69200 |
48700 |
20500 |
Depreciation of special equipment |
44300 |
44300 |
0 |
Salaries of product-line managers |
114200 |
78900 |
35300 |
Allocated common fixed expenses* |
183400 |
183400 |
0 |
Total fixed expenses |
411100 |
355300 |
55800 |
Net operating income (loss) |
41900 |
-1300 |
-43200 |
_____________________________________________________________________
2
2. Should the production and sale of racing bikes be discontinued?
Answer:
No, production and sale of the racing bikes should not be discontinued.
If the racing bikes were discontinued, then the net operating income for the company as a whole would decrease by $(43,200) each quarter:
__________________________________________________________________________
3
segmented income statement. |
||||
Total |
Dirt |
Mountain Bikes |
Racing |
|
Sales |
917000 |
266000 |
400000 |
251000 |
Variable manufacturing and selling expenses |
464000 |
116000 |
196000 |
152000 |
Contribution margin |
453000 |
150000 |
204000 |
99000 |
Fixed expenses: |
||||
Advertising, traceable |
69200 |
8200 |
40500 |
20500 |
Depreciation of special equipment |
44300 |
21000 |
7500 |
15800 |
Salaries of product-line managers |
114200 |
40200 |
38700 |
35300 |
Total Tracable Fixed cost |
227700 |
69400 |
86700 |
71600 |
Product segment Margin |
225300 |
80600 |
117300 |
27400 |
common fixed expenses |
183400 |
|||
Net operating income (loss) |
41900 |
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 $ 403,000 $ 250,000 Variable manufacturing and selling expenses 468,000 111,000 203,000 154,000 Contribution margin 449,000 153,000 200,000 96,000 Fixed expenses: Advertising, traceable 69,200 8,600 40,300 20,300 Depreciation of special equipment 43,300 20,700 7,300 15,300 Salaries of product-line managers 115,200...
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 $ 920,000 $ 269,000 $ 400,000 $ 251,000 Variable manufacturing and selling expenses 464,000 114,000 198,000 152,000 Contribution margin 456,000 155,000 202,000 99,000 Fixed expenses: Advertising, traceable 69,700 8,800 40,200 20,700 Depreciation of special equipment 43,900 20,400 8,000 15,500 Salaries of product-line managers 114,100...
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: Dirt Mountain Racing Total Bikes Bikes Bikes $ 920,000 $261,000 $ 409,000 $ 250,000 480,000 117,000 206,000 157,000 440,000 144,000 203,000 93,000 Sales Variable manufacturing and selling expenses Contribution margin Fixed expenses: Advertising, traceable Depreciation of special equipment Salaries of product-line managers Allocated common fixed expenses Total fixed expenses Net operating income...
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: Dirt Mountain Racing Bikes Total Bikes Bikes Sales Variable manufacturing and selling $921,000 $264,000 407,000 250,000 475,000 118,000 201,000 156,000 expenseS Contribution margin Fixed expenses: 446,000 146,000 206,000 94,000 Advertising, traceable Depreciation of special equipment Salaries of product-line managers Allocated common fixed expenses* 40,900 7,500 38,900 81,400 412,500 121,800 168,700 70,300 20,900...
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: Dirt Mountain Racing Total Bikes Bikes Bikes $ 929,000 $265,000 $ 409,000 $ 255,000 465,000 117,000 195,000 153,000 464,000 148,000 214,000 102,000 Sales Variable manufacturing and selling expenses Contribution margin Fixed expenses : Advertising, traceable Depreciation of special equipment Salaries of product-line managers Allocated common fixed expenses Total fixed expenses Net operating...
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: 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 $ 928,000 $ 267,000 $ 401,000 $ 260,000 Variable manufacturing and selling expenses 458,000 113,000 193,000...
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: Dirt Mountain Racing Total Bikes Bikes Bikes $ 932,000 $269,000 $ 405,000 $ 258,000 477,000 117,000 209,000 151,000 455,000 152,000 196,000 107,000 Sales Variable manufacturing and selling expenses Contribution margin Fixed expenses: Advertising, traceable Depreciation of special equipment Salaries of product-line managers Allocated common fixed expenses* Total fixed expenses Net operating income...
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: 2.33 points Dirt Mountain Racing Total Bikes Bikes Bikes $ 923,000 $265,000 $ 405,000 $ 253,000 460,000 115,000 191,000 154,000 463,000 150,000 214,000 eBook Sales Variable manufacturing and selling expenses Contribution margin Fixed expenses: Advertising, traceable Depreciation of special equipment Salaries of product-line managers Allocated common fixed expenses Total fixed expenses Net...
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: Dirt Mountain Racing Total Bikes Bikes Bikes $ 930,000 $266,000 $ 404,000 $ 260,000 480,000 116,000 208,000 156,000 450,000 150,000 196,000 104,000 Sales Variable manufacturing and selling expenses Contribution margin Fixed expenses: Advertising, traceable Depreciation of special equipment Salaries of product-line managers Allocated common fixed expenses* Total fixed expenses Net operating income...
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 $ 925,000 $ 266,000 $ 406,000 $ 253,000 Variable manufacturing and selling expenses 468,000 113,000 203,000 152,000 Contribution margin 457,000 153,000 203,000 101,000 Fixed expenses: Advertising, traceable 69,600 8,500 40,300 20,800 Depreciation of special equipment 43,500 20,600 7,400 15,500 Salaries of product-line managers 116,100...