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 | $ | 263,000 | $ | 409,000 | $ | 254,000 | ||||
| Variable manufacturing and selling expenses | 480,000 | 114,000 | 207,000 | 159,000 | ||||||||
| Contribution margin | 446,000 | 149,000 | 202,000 | 95,000 | ||||||||
| Fixed expenses: | ||||||||||||
| Advertising, traceable | 69,400 | 8,300 | 40,600 | 20,500 | ||||||||
| Depreciation of special equipment | 43,400 | 20,500 | 7,500 | 15,400 | ||||||||
| Salaries of product-line managers | 114,900 | 40,400 | 38,400 | 36,100 | ||||||||
| Allocated common fixed expenses* | 185,200 | 52,600 | 81,800 | 50,800 | ||||||||
| Total fixed expenses | 412,900 | 121,800 | 168,300 | 122,800 | ||||||||
| Net operating income (loss) | $ | 33,100 | $ | 27,200 | $ | 33,700 | $ | (27,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.
1. What is the financial advantage (disadvantage) per quarter of discontinuing the Racing Bikes?
b.) Troy Engines, Ltd., manufactures a variety of engines for use in heavy equipment. The company has always produced all of the necessary parts for its engines, including all of the carburetors. An outside supplier has offered to sell one type of carburetor to Troy Engines, Ltd., for a cost of $35 per unit. To evaluate this offer, Troy Engines, Ltd., has gathered the following information relating to its own cost of producing the carburetor internally:
| Per Unit | 16,000 Units Per Year |
|||||
| Direct materials | $ | 13 | $ | 208,000 | ||
| Direct labor | 13 | 208,000 | ||||
| Variable manufacturing overhead | 2 | 32,000 | ||||
| Fixed manufacturing overhead, traceable | 9 | * | 144,000 | |||
| Fixed manufacturing overhead, allocated | 12 | 192,000 | ||||
| Total cost | $ | 49 | $ | 784,000 | ||
*One-third supervisory salaries; two-thirds depreciation of special equipment (no resale value).
Required:
1b). Assuming the company has no alternative use for the facilities that are now being used to produce the carburetors, what would be the financial advantage (disadvantage) of buying 16,000 carburetors from the outside supplier?
2b) Suppose that if the carburetors were purchased, Troy Engines, Ltd., could use the freed capacity to launch a new product. The segment margin of the new product would be $160,000 per year. Given this new assumption, what would be the financial advantage (disadvantage) of buying 16,000 carburetors from the outside supplier?
Solution 1:
Please note that:
Net Operating loss given for racing bike line is $27,800.
Revised Operating Profit (loss) for racing bike division will look like below (after adding back irrelevant costs)
Revised Operating Profit (Loss) = -$27,800 + $15,400 + $50,800
Revised Operating Profit = $38,400
In case the racing bikes line is discontinued; Regal Cycle Company will lose a financial advantage of $38,400 per quarter.
Solution 2:
For In-house production, let’s find out the relevant cost of carburetor:
Total relevant cost for production is $13 + $13+ $2 + $3 = $31 per unit
Vendor quoted price is $35 per unit. Hence if bought outside, it will create a disadvantage of $4 per unit for every carburetor bought.
For 16,000 carburetors, Financial disadvantage = $4 * 16,000 = $64,000
Please feel free to comment if the concept is unclear, happy to help. As always, keep studying, grind hard
A)
| Financial Disadvantage | $ (38,400) | |
| Note 1: | ||
| Loss of Contribution margin by dropping Racing Bikes segment | $ (95,000) | |
| Add: Saving in traceable fixed cost belongs to racing bike segment | $ 56,600 | (20500+36100) |
| Financial Disadvantage | $ (38,400) | (-95000+56600) |
B)
1b.
| Financial (Disadvantage) | $ 64,000 | |||
| Make | Buy | Advantage/Disadvantage | ||
| Direct Material | $ 208,000 | $ 208,000 | ||
| Direct labour | $ 208,000 | $ 208,000 | ||
| Variable manufacturing Overhead | $ 32,000 | $ 32,000 | ||
| Fixed manufacture overhead (Only supervisor salary) | $ 48,000 | $ 48,000 | (144000*0.33) | |
| Purchase Price | $ 560,000 | $ (560,000) | (16000*35) | |
| Total Relevant cost | $ 496,000 | $ 560,000 | $ (64,000) |
| No, due to financial disadvantage of $64000 |
2b.
| Financial Advantage | $ 96,000 | ||
| Make | Buy | Advantage/Disadvantage | |
| Direct Material | $ 208,000 | $ 208,000 | |
| Direct labour | $ 208,000 | $ 208,000 | |
| Variable manufacturing Overhead | $ 32,000 | $ 32,000 | |
| Fixed manufacture overhead (Only supervisor salary) | $ 48,000 | $ 48,000 | |
| Purchase Price | $ 560,000 | $ (560,000) | |
| Segment margin of new product due to freed capacity | $ (160,000) | $ 160,000 | |
| Total Relevant cost | $ 496,000 | $ 400,000 | $ 96,000 |
| Yes, due to financial advantage of $96000 |
a.) The Regal Cycle Company manufactures three types of bicycles—a dirt bike, a mountain bike, and...
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 $264,000 $ 404,000 $ 252,000 475,000 117,000 199,000 159,000 445,000 147,000 205,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 (loss)...
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 $ 264,000 $ 405,000 $ 257,000 Variable manufacturing and selling expenses 466,000 119,000 197,000 150,000 Contribution margin 460,000 145,000 208,000 107,000 Fixed expenses: Advertising, traceable 69,200 8,300 40,700 20,200 Depreciation of special equipment 43,800 20,500 7,500 15,800 Salaries of product-line managers 114,700...
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 $ 921,000 $ 262,000 $ 402,000 $ 257,000 Variable manufacturing and selling expenses 483,000 117,000 208,000 158,000 Contribution margin 438,000 145,000 194,000 99,000 Fixed expenses: Advertising, traceable 69,600 8,500 40,600 20,500 Depreciation of special equipment 44,000 20,900 7,700 15,400 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: 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: Dirt Mountain Racing Total Bikes Bikes Bikes $ 925,000 $268,000 $ 406,000 $ 251,000 477,000 111,000 208,000 158,000 448,000 157,000 198,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...
he 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 $ 268,000 $ 401,000 $ 259,000 Variable manufacturing and selling expenses 467,000 113,000 203,000 151,000 Contribution margin 461,000 155,000 198,000 108,000 Fixed expenses: Advertising, traceable 69,600 8,500 40,700 20,400 Depreciation of special equipment 43,200 20,500 7,400 15,300 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 Total Bikes $ 933,000 $270,000 469,000 110,000 464,000 160,000 Mountain Racing Bikes Bikes $ 409,000 $ 254,000 208,000 151,000 201,000 103,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 Total Bikes Bikes Bikes $ 930,000 $266,000 $ 407,000 $257,000 471,000 115,000 203,000 153,000 459,000 151,000 204,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 (loss)...
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 $ 407,000 $257,000 471,000 115,000 203,000 153,000 459,000 151,000 204,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 (loss)...
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...