Exercise 12-2 Dropping or Retaining a Segment [LO12-2]
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 | $ | 409,000 | $ | 252,000 | ||||
Variable manufacturing and selling expenses | 474,000 | 117,000 | 203,000 | 154,000 | ||||||||
Contribution margin | 454,000 | 150,000 | 206,000 | 98,000 | ||||||||
Fixed expenses: | ||||||||||||
Advertising, traceable | 69,500 | 8,700 | 40,500 | 20,300 | ||||||||
Depreciation of special equipment | 43,300 | 20,200 | 7,200 | 15,900 | ||||||||
Salaries of product-line managers | 114,900 | 40,000 | 38,100 | 36,800 | ||||||||
Allocated common fixed expenses* | 185,600 | 53,400 | 81,800 | 50,400 | ||||||||
Total fixed expenses | 413,300 | 122,300 | 167,600 | 123,400 | ||||||||
Net operating income (loss) | $ | 40,700 | $ | 27,700 | $ | 38,400 | $ | (25,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.
1 | Current Total | Total if racing bikes are dropped | Difference: Net operating income increase or (decrease) | ||
Sales | $ 9,28,000 | $ 6,76,000 | $ -2,52,000 | ||
Variable manufacturing and selling expenses | $ 4,74,000 | $ 3,20,000 | $ 1,54,000 | ||
Contribution margin (loss) | $ 4,54,000 | $ 3,56,000 | $ -98,000 | ||
Fixed expenses: | |||||
Advertising, traceable | $ 69,500 | $ 49,200 | $ 20,300 | ||
Depreciation on special equipment | $ 43,300 | $ 43,300 | $ - | ||
Salaries of product managers | $ 1,14,900 | $ 78,100 | $ 36,800 | ||
Allocated common expense | $ 1,85,600 | $ 1,85,600 | $ - | ||
Total fixed expenses | $ 4,13,300 | $ 3,56,200 | $ 57,100 | ||
Net operating income (loss) | $ 40,700 | $ -200 | $ -40,900 | ||
2 | No | ||||
Discontinuation of Production and sale of racing bikes will incur more loss than existing loss from the unit | |||||
3 | Total | Dirt Bikes | Mountain Bikes | Racing Bikes | |
Sales | $ 9,28,000 | $ 2,67,000 | $ 4,09,000 | $ 2,52,000 | |
Variable manufacturing and selling expenses | $ 4,74,000 | $ 1,17,000 | $ 2,03,000 | $ 1,54,000 | |
Contribution margin (loss) | $ 4,54,000 | $ 1,50,000 | $ 2,06,000 | $ 98,000 | |
Traceable Fixed expenses: | |||||
Advertising, traceable | $ 69,500 | $ 8,700 | $ 40,500 | $ 20,300 | |
Depreciation on special equipment | $ 43,300 | $ 20,200 | $ 7,200 | $ 15,900 | |
Salaries of product managers | $ 1,14,900 | $ 40,000 | $ 38,100 | $ 36,800 | |
Total traceable fixed expenses | $ 2,27,700 | $ 68,900 | $ 85,800 | $ 73,000 | |
Product line segment margin (loss) | $ 2,26,300 | $ 81,100 | $ 1,20,200 | $ 25,000 | |
Allocated common fixed expense | $ 1,85,600 | ||||
Net operating income (loss) | $ 40,700 |
Exercise 12-2 Dropping or Retaining a Segment [LO12-2] The Regal Cycle Company manufactures three types of...
Exercise 12-2 Dropping or Retaining a Segment [LO12-2] 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 $ 300,000 $ 90,000 $ 150,000 $ 60,000 Variable manufacturing and selling expenses 120,000 27,000 60,000 33,000 Contribution margin 180,000 63,000 90,000 27,000 Fixed expenses: Advertising, traceable 30,000 10,000 14,000 6,000 Depreciation of special equipment 23,000...
Exercise 12-2 Dropping or Retaining a Segment [LO12-2] 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 $ 932,000 $ 269,000 $ 404,000 $ 259,000 Variable manufacturing and selling expenses 471,000 113,000 202,000 156,000 Contribution margin 461,000 156,000 202,000 103,000 Fixed expenses: Advertising, traceable 69,500 8,600 40,600 20,300 Depreciation of special equipment 43,800...
Exercise 11-2 Dropping or Retaining a Segment [LO11-2] 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 $ 926,000 461,000 465,000 Dirt Mountain Bikes Bikes $268.000 $ 406,000 113,000 197.000 155,000 209,000 Racing Bikes 5 252.000 151,000 101.000 Sales Variable manufacturing and selling expenses Contribution margin Fixed expenses Advertising, traceable Depreciation of special equipment Salaries of product line managers Allocated...
Exercise 11-2 Dropping or Retaining a Segment (LO11-2] 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 $ 916,000 $262,000 $ 404,000 $ 250,000 462,000 115,000 191,000 156,000 454,000 147,000 213,000 94,000 Sales Variable manufacturing and selling expenses Contribution margin Fixed expenses: Advertising, traceable Depreciation of special equipment Salaries of product-line managers Allocated common...
Exercise 11-2 Dropping or Retaining a Segment [LO11-2] 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 $ 922,000 $ 264,000 $ 402,000 $ 256,000 Variable manufacturing and selling expenses 474,000 117,000 205,000 152,000 Contribution margin 448,000 147,000 197,000 104,000 Fixed expenses: Advertising, traceable 69,300 8,600 40,300 20,400 Depreciation of special equipment 43,600...
Exercise 12-2 Dropping or Retaining a Segment [LO12-2] 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: Racing Dirt Mountain Total Bikes Bikes Bikes Sales $926,000 $269,000 $404,000 $ 253,000 Variable manufacturing and selling 471,000 113,000 205,000 153,000 expenses Contribution margin Fixed expenses: 156,000 199,000 455,000 100,000 Advertising, traceable Depreciation of special equipment Salaries of product-line managers Allocated common fixed expenses...
Exercise 12-2 Dropping or Retaining a Segment (LO12-2] 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 $ 916,000 $261,000 $ 403,000 $ 252,000 480,000 115,000 210,000 155,000 436,000 146,000 193, 000 97,000 Sales Variable manufacturing and selling expenses Contribution margin Fixed expenses: Advertising, traceable Depreciation of special equipment Salaries of product-line managers Allocated...
Exercise 12-2 Dropping or Retaining a Segment[LO12-2] 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: Sales Dirt Mountain Total Bikes Bikes $ 926,000 $266, 000 $ 484,800 463,800 111,800 193,888 463,890 155,800 211,800 Racing Bikes $ 256, 800 159,808 97,800 Variable manufacturing and selling expenses Contribution margin Fixed expenses: Advertising, traceable Depreciation of special equipment Salaries of product-line managers Allocated...
Exercise 11-2 Dropping or Retaining a Segment [LO11-2] 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 $ 914,000 $ 262,000 $ 401,000 $ 251,000 Variable manufacturing and selling expenses 471,000 115,000 199,000 157,000 Contribution margin 443,000 147,000 202,000 94,000 Fixed expenses: Advertising, traceable 70,000 8,600 40,500 20,900 Depreciation of special equipment 44,100...
The Regal Cycle Company...
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: points Dirt Mountain Racing Total Bikes Bikes Bikes Bikes $928,000 $269,000 $ 403,000 $ 256,000 460,000 111,000 192,000 157,000 468,000 158,000 211,000 99,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*...