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 | $ | 264,000 | $ | 407,000 | $ | 253,000 | ||||
Variable manufacturing and selling expenses | 458,000 | 113,000 | 195,000 | 150,000 | ||||||||
Contribution margin | 466,000 | 151,000 | 212,000 | 103,000 | ||||||||
Fixed expenses: | ||||||||||||
Advertising, traceable | 69,100 | 8,400 | 40,600 | 20,100 | ||||||||
Depreciation of special equipment | 43,400 | 20,500 | 7,200 | 15,700 | ||||||||
Salaries of product-line managers | 115,800 | 40,500 | 38,800 | 36,500 | ||||||||
Allocated common fixed expenses* | 184,800 | 52,800 | 81,400 | 50,600 | ||||||||
Total fixed expenses | 413,100 | 122,200 | 168,000 | 122,900 | ||||||||
Net operating income (loss) | $ | 52,900 | $ | 28,800 | $ | 44,000 | $ | (19,900) | ||||
*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.
Requirement 1:-
Particulars | Amount | |
Lost Contribution margin | (103,000) | |
Avoidable fixed costs | ||
Advertising traceable | 20,100 | |
Salary of product line manager | 36,500 | |
56,600 | ||
Financial (disadvantage) of discontinuing bikes | (46,400) |
The Depreciation on the equipment is a sunk cost and is not relevant to the decision. The common costs are allocated and will continue regardless of whether or not the racing bikes are discontinued. Hence, they are not relevant in our decision making process.
Requirement 2:-
No. it should not be discontinued as there is a Financial disadvantage of discontinuing the racing bikes.
Requirement 3:-
Particulars | Total | Dirt Bikes | Mountain Bikes | Racing Bikes |
Sales | 924,000 | 264,000 | 407,000 | 253,000 |
Variable manufacturing and selling expenses | 458,000 | 113,000 | 195,000 | 150,000 |
Contribution Margin | 466,000 | 151,000 | 212,000 | 103,000 |
Traceable fixed expenses | ||||
Advertisting, traceable | 69,100 | 8,400 | 40,600 | 20,100 |
Depreciation of special equipment | 43,400 | 20,500 | 7,200 | 15,700 |
Salaries of production line managers | 115,800 | 40,500 | 38,800 | 36,500 |
Total traceable fixed expenses | 228,300 | 69,400 | 86,600 | 72,300 |
Product line segment margin(loss) | 237,700 | 81,600 | 1,25,400 | 30,700 |
Common fixed expenses | 184,800 | ` | ||
Net Operating Income (Loss) | 52,900 |
Please let me know if you have any questions via comments and all the best :)
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 $ 262,000 $ 404,000 $ 258,000 Variable manufacturing and selling expenses 476,000 118,000 207,000 151,000 Contribution margin 448,000 144,000 197,000 107,000 Fixed expenses: Advertising, traceable 69,800 8,700 40,800 20,300 Depreciation of special equipment 44,300 20,700 8,000 15,600 Salaries of product-line managers 115,800...
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 $928,000 $268,000 $407,000 $ 253,000 462,000 114,000 197,000 151,000 466,000 154,000 210,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 income (loss) 69,600...
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 $ 266,000 $ 403,000 $ 255,000 Variable manufacturing and selling expenses 480,000 120,000 209,000 151,000 Contribution margin 444,000 146,000 194,000 104,000 Fixed expenses: Advertising, traceable 69,400 8,600 40,200 20,600 Depreciation of special equipment 43,900 20,400 7,800 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 racing bike. Data on sales and expenses for the past quarter follow: Dirt Mountain Racing Bikes Total Bikes Bikes Sales Variable manufacturing and selling $924,000 $266,000 $ 400,000 484,000 116,000 209,000 258,000 159,000 expenses Contribution margin Fixed expenses: 440,000 150,000 191,000 99,000 Advertising, traceable Depreciation of special equipment Salaries of product-line managers Allocated common fixed expenses* 40,700 7,500 38,600 80,000 413,100 122,700 166,800 8,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 Bikes $ 923,000 $261,000 $ 407,000 255,000 Total Bikes Bikes Sales Variable manufacturing and selling 458,000 115,000 expenses 191,000 152,000 Contribution margin Fixed expenses: Advertising, traceable Depreciation of special equipment Salaries of product-1ine managers Allocated common fixed expenses Total fixed expenses 465,000 146,000 216,000 103,000 69,600 43,500 115,900 184,600...
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 $ 930,000 $ 269,000 $ 403,000 $ 258,000 Variable manufacturing and selling expenses 468,000 111,000 199,000 158,000 Contribution margin 462,000 158,000 204,000 100,000 Fixed expenses: Advertising, traceable 69,100 8,100 40,300 20,700 Depreciation of special equipment 43,500 20,500 7,600 15,400 Salaries of product-line managers 115,800...
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 $ 262,000 $ 404,000 $ 252,000 Variable manufacturing and selling expenses 458,000 110,000 195,000 153,000 Contribution margin 460,000 152,000 209,000 99,000 Fixed expenses: Advertising, traceable 70,300 8,700 40,900 20,700 Depreciation of special equipment 44,000 20,500 7,600 15,900 Salaries of product-line managers 115,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: Total Dirt Bikes Mountain Bikes Racing Bikes Sales $ 927,000 $ 269,000 $ 407,000 $ 251,000 Variable manufacturing and selling expenses 479,000 111,000 210,000 158,000 Contribution margin 448,000 158,000 197,000 93,000 Fixed expenses: Advertising, traceable 69,300 8,700 40,100 20,500 Depreciation of special equipment 44,000 20,200 8,000 15,800 Salaries of product-line managers 116,800...
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...
1. value: 1.25 points 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 Bikes $262,000 113,000 Total $ 921,000 455,000 Mountain Bikes $ 407,000 192,000 Racing Bikes $ 252,000 150,000 Sales Variable manufacturing and selling expenses Contribution margin 466,000 149,000 215,000 102,000 7700 Fixed expenses: Advertising, traceable Depreciation of special equipment Salaries of product-line managers Allocated common fixed expenses...