Question

Problem 10-25 Jim Coston was reviewing the latest income statement for Trenton Communications. For the second...

Problem 10-25

Jim Coston was reviewing the latest income statement for Trenton Communications. For the second year in a row, the Audio division was showing a negative segment margin, and Jim thought it was time to close the division to increase the company’s operating income. The income statement that he examined follows.
Video
Division
Audio
Division
Total
Sales revenue $5,303,900 $2,863,200 $8,167,100
Less variable expenses 3,663,600 1,649,500 5,313,100
Contribution margin 1,640,300 1,213,700 2,854,000
Less traceable fixed expenses 949,700 1,281,300 2,231,000
Segment margin $690,600 $(67,600 ) 623,000
Common fixed costs 557,000
Net operating income $66,000

When Jim broke the news, Chloe Sams, manager of the Audio division, was upset. Chloe thought that Jim could be making a snap judgment, and suggested that he look at the division’s detailed operating results. The Audio division is composed of two groups, Streaming and CD. Streaming accounts for 75% of the division’s sales and contribution margin; CD accounts for the other 25%. Streaming’s traceable fixed costs are $450,700; CD, $350,700.
Your answer is incorrect. Try again.

Prepare a segment margin income statement for the Audio division that shows the segment margin of each group. (If the amount is negative then enter with a negative sign preceding the number, e.g. -5,125 or parenthesis, e.g. (5,125) and round answers to 0 decimal places, e.g. 5,125.)

Homework Answers

Answer #1

Segment margin income statement for the Audio division

Streaming CD
Sales 2,147,400 715,800
Variable expenses - 1,237,125 - 412,375
Conribution margin 910,275 303,425
traceable fixed expenses - 450,700 - 350,700
Segment margin/loss $459,575 - $47,275

Audio division sales = $2,863,200

Streaming sales = Audio division sales x 75%

= 2,863,200 x 75%

= $2,147,400

CD sales = Audio division sales x 25%

= 2,863,200 x 25%

= $715,800

Audio division variable expenses = $1,649,500

Streaming variable expenses = Audio division variable expenses x 75%

= 1,649,500 x 75%

= $1,237,125

CD variable expenses = Audio division variable expenses x 25%

= 1,649,500 x 25%

= $412,375

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
            Trent Weaver was reviewing the latest income statement for Taryn Enterprises. For the second year...
            Trent Weaver was reviewing the latest income statement for Taryn Enterprises. For the second year in a row, the Collectibles division was showing a negative segment margin, an943,00d Trent thought it was time to close the division to increase the company’s operating income. The income statement that he examined follows.    Promotions Division Collectibles Division Total Sales revenue $5,300,000 $2,860,000 $8,160,000 Less variable expenses 3,650,000 1,645,000 5,295,000 Contribution margin 1,650,000 1,215,000 2,865,000 Less traceable fixed expenses 943,000 1,275,000 2,218,000...
Shannon Company segments its income statement into its North and South Divisions. The company’s overall sales,...
Shannon Company segments its income statement into its North and South Divisions. The company’s overall sales, contribution margin ratio, and net operating income are $380,000, 34%, and $7,600, respectively. The North Division’s contribution margin and contribution margin ratio are $83,600 and 38%, respectively. The South Division’s segment margin is $19,200. The company has $45,600 of common fixed expenses that cannot be traced to either division. Prepare an income statement for Shannon Company that uses the contribution format and is segmented...
Exercise 6-7 Segmented Income Statement [LO6-4] Shannon Company segments its income statement into its North and...
Exercise 6-7 Segmented Income Statement [LO6-4] Shannon Company segments its income statement into its North and South Divisions. The company’s overall sales, contribution margin ratio, and net operating income are $490,000, 38%, and $9,800, respectively. The North Division’s contribution margin and contribution margin ratio are $100,800 and 42%, respectively. The South Division’s segment margin is $35,000. The company has $68,600 of common fixed expenses that cannot be traced to either division. Required: Prepare an income statement for Shannon Company that...
Exercise 6-7 Segmented Income Statement [LO6-4] Shannon Company segments its income statement into its North and...
Exercise 6-7 Segmented Income Statement [LO6-4] Shannon Company segments its income statement into its North and South Divisions. The company’s overall sales, contribution margin ratio, and net operating income are $660,000, 42%, and $13,200, respectively. The North Division’s contribution margin and contribution margin ratio are $119,600 and 46%, respectively. The South Division’s segment margin is $64,000. The company has $105,600 of common fixed expenses that cannot be traced to either division. Required: Prepare an income statement for Shannon Company that...
Shannon Company segments its income statement into its North and South Divisions. The company’s overall sales,...
Shannon Company segments its income statement into its North and South Divisions. The company’s overall sales, contribution margin ratio, and net operating income are $380,000, 34%, and $7,600, respectively. The North Division’s contribution margin and contribution margin ratio are $83,600 and 38%, respectively. The South Division’s segment margin is $19,200. The company has $45,600 of common fixed expenses that cannot be traced to either division. Required: Prepare an income statement for Shannon Company that uses the contribution format and is...
Shoe Shock Innovations manufactures athletic shoe inserts that cushion the foot and reduce the impact of...
Shoe Shock Innovations manufactures athletic shoe inserts that cushion the foot and reduce the impact of exercise on the joints. The company has two divisions, Sole Inserts and Heel Inserts. A segmented income statement from last month follows. Sole Inserts Division Heel Inserts Division Total Shoe Shock Sales revenue $493,900 $2,550,000 $3,043,900 Less variable expenses 318,000 2,048,000 2,366,000 Contribution margin 175,900 502,000 677,900 Less traceable fixed expenses 121,400 349,800 471,200 Segment margin $54,500 $152,200 206,700 Common fixed costs 170,600 Net...
Shoe Shock Innovations manufactures athletic shoe inserts that cushion the foot and reduce the impact of...
Shoe Shock Innovations manufactures athletic shoe inserts that cushion the foot and reduce the impact of exercise on the joints. The company has two divisions, Sole Inserts and Heel Inserts. A segmented income statement from last month follows. Sole Inserts Division Heel Inserts Division Total Shoe Shock Sales revenue $492,900 $2,524,000 $3,016,900 Less variable expenses 313,000 2,027,000 2,340,000 Contribution margin 179,900 497,000 676,900 Less traceable fixed expenses 124,900 349,900 474,800 Segment margin $55,000 $147,100 202,100 Common fixed costs 170,700 Net...
ch 6 exer 9 Shannon Company segments its income statement into its North and South Divisions....
ch 6 exer 9 Shannon Company segments its income statement into its North and South Divisions. The company’s overall sales, contribution margin ratio, and net operating income are $780,000, 50%, and $62,400, respectively. The North Division’s contribution margin and contribution margin ratio are $247,500 and 75%, respectively. The South Division’s segment margin is $68,000. The company has $117,000 of common fixed expenses that cannot be traced to either division.    Required: Prepare an income statement for Shannon Company that uses...
Shoe Shock Innovations manufactures athletic shoe inserts that cushion the foot and reduce the impact of...
Shoe Shock Innovations manufactures athletic shoe inserts that cushion the foot and reduce the impact of exercise on the joints. The company has two divisions, Sole Inserts and Heel Inserts. A segmented income statement from last month follows. Sole Inserts Division Heel Inserts Division Total Shoe Shock Sales revenue $491,300 $2,549,000 $3,040,300 Less variable expenses 311,000 2,011,000 2,322,000 Contribution margin 180,300 538,000 718,300 Less traceable fixed expenses 123,500 348,100 471,600 Segment margin $56,800 $189,900 246,700 Common fixed costs 173,800 Net...
If a cost is a common fixed cost on a segmented income statement, the cost should:...
If a cost is a common fixed cost on a segmented income statement, the cost should: 1) Be allocated to the segments on the basis of segment sales. 2) Not be allocated to the segments. 3) Excluded from the income statement. 4) Treated as a product cost rather than a period cost. Which of the following capital budget screening methods does not consider the time value of money? 1) The Net Present Value. 2) The Payback Period. 3) The Profitability...