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 | 20,400 | 7,700 | 15,500 | ||||||||
Salaries of product-line managers | 114,800 | 40,600 | 38,500 | 35,700 | ||||||||
Allocated common fixed expenses* | 184,400 | 52,800 | 80,400 | 51,200 | ||||||||
Total fixed expenses | 412,100 | 122,400 | 166,900 | 122,800 | ||||||||
Net operating income (loss) | $ | 35,900 | $ | 24,600 | $ | 30,100 | $ | (18,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.
1 | ||||
Current Total | Total If Racing Bikes Are Dropped | Difference: Net Operating Income | ||
Sales | 922000 | 666000 | -256000 | |
Variable manufacturing and selling expenses | 474000 | 322000 | 152000 | |
Contribution margin (loss) | 448000 | 344000 | -104000 | |
Fixed expenses: | ||||
Advertising, traceable | 69300 | 48900 | 20400 | |
Depreciation on special equipment | 43600 | 43600 | 0 | |
Salaries of product manager | 114800 | 79100 | 35700 | |
Common allocated costs | 184400 | 184400 | 0 | |
Total fixed expenses | 412100 | 356000 | 56100 | |
Net operating income (loss) | 35900 | -12000 | -47900 | |
Financial (disadvantage) (47900) | ||||
2 | ||||
No, production and sale of racing bikes should not be discontinued | ||||
3 | ||||
Total | Dirt Bikes | Mountain Bikes | Racing Bikes | |
Sales | 922000 | 264000 | 402000 | 256000 |
Variable manufacturing and selling expenses | 474000 | 117000 | 205000 | 152000 |
Contribution margin (loss) | 448000 | 147000 | 197000 | 104000 |
Traceable fixed expenses: | ||||
Advertising, traceable | 69300 | 8600 | 40300 | 20400 |
Depreciation on special equipment | 43600 | 20400 | 7700 | 15500 |
Salaries of product manager | 114800 | 40600 | 38500 | 35700 |
Total traceable fixed expenses | 227700 | 69600 | 86500 | 71600 |
Product line segment margin | 220300 | 77400 | 110500 | 32400 |
Common fixed expenses | 184400 | |||
Net operating income (loss) | 35900 |
Exercise 11-2 Dropping or Retaining a Segment [LO11-2] The Regal Cycle Company manufactures three types of...
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 $ 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: 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...
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 $ 923,000 $ 264,000 $ 403,000 $ 256,000 Variable manufacturing and selling expenses 477,000 117,000 204,000 156,000 Contribution margin 446,000 147,000 199,000 100,000 Fixed expenses: Advertising, traceable 69,200 8,800 40,200 20,200 Depreciation of special equipment 43,500...
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...
Exercise 11-2 Dropping or Retaining a Segment [L011-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 Bikes Mountain Racing Bikes Total Bikes 60,000 33,000 Sales Variable manufacturing and selling expenses Contribution margin Fixed expenses: $ 300,000 $ 90,000 $ 150,000 60,000 90,000 120,000 27,000 180,000 63,000 6,000 8,000 10,000 12,000 36,000 $ 32,000 17,000 24,000 (9,000) 14,000 9,000 13,000...
Exercise 11-2 Dropping or Retaining a Segment (L011-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 Total Bikes $ 925,000 $265,000 469,000 118,000 456,000 147,000 Mountain Racing Bikes Bikes $ 406,000 $ 254,000 192,000 159,000 214,000 95,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 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 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...