Question

In: Accounting

Exercise 5-5 Companywide and Segment Break-Even Analysis [LO5-5] Piedmont Company segments its business into two regions—North...

Exercise 5-5 Companywide and Segment Break-Even Analysis [LO5-5]

Piedmont Company segments its business into two regions—North and South. The company prepared the contribution format segmented income statement shown below:

Total
Company
North South
Sales $ 825,000 $ 550,000 $ 275,000
Variable expenses 495,000 385,000 110,000
Contribution margin 330,000 165,000 165,000
Traceable fixed expenses 144,000 72,000 72,000
Segment margin 186,000 $ 93,000 $ 93,000
Common fixed expenses 64,000
Net operating income $ 122,000

Required:

1. Compute the companywide break-even point in dollar sales.

2. Compute the break-even point in dollar sales for the North region.

3. Compute the break-even point in dollar sales for the South region.

Solutions

Expert Solution

Answer
Total company North South
sales            8,25,000          5,50,000            2,75,000
variable cost            4,95,000          3,85,000            1,10,000
contribution margin            3,30,000          1,65,000            1,65,000
treceable fixed cost            1,44,000             72,000               72,000
segment margin            1,86,000             93,000               93,000
common fixed cost               64,000
net operating income            1,22,000
Fixed cost            2,08,000             72,000               72,000
contribution margin ratio = contribution /sales 0.4 0.3 0.6
break even point in sales = fixed cost/contribution margin ratio            5,20,000          2,40,000            1,20,000

Related Solutions

Exercise 6-10 Companywide and Segment Break-Even Analysis [LO6-5] Crossfire Company segments its business into two regions—East...
Exercise 6-10 Companywide and Segment Break-Even Analysis [LO6-5] Crossfire Company segments its business into two regions—East and West. The company prepared a contribution format segmented income statement as shown below: Total Company East West Sales $ 750,000 $ 500,000 $ 250,000 Variable expenses 525,000 375,000 150,000 Contribution margin 225,000 125,000 100,000 Traceable fixed expenses 140,000 60,000 80,000 Segment margin 85,000 $ 65,000 $ 20,000 Common fixed expenses 70,000 Net operating income $ 15,000 Required: 1. Compute the companywide break-even point...
Companywide and Segment Break-Even Analysis; Decision Making Toxaway Company is a merchandiser that segments its business...
Companywide and Segment Break-Even Analysis; Decision Making Toxaway Company is a merchandiser that segments its business into two divisions—Commercial and Residential. The company’s accounting intern was asked to prepare segmented income statements that the company’s divisional managers could use to calculate their break-even points and make decisions. She took the prior month’s companywide income statement and prepared the absorption format segmented income statement shown below: Total Company Commercial Residential Sales $ 750,000 $ 250,000 $ 500,000 Cost of goods sold...
Piedmont Company segments its business into two regions—North and South. The company prepared the contribution format...
Piedmont Company segments its business into two regions—North and South. The company prepared the contribution format segmented income statement as shown: Total Company North South Sales $ 937,500 $ 750,000 $ 187,500 Variable expenses 637,500 600,000 37,500 Contribution margin 300,000 150,000 150,000 Traceable fixed expenses 142,000 71,000 71,000 Segment margin 158,000 $ 79,000 $ 79,000 Common fixed expenses 62,000 Net operating income $ 96,000 Required: 1. Compute the companywide break-even point in dollar sales. 2. Compute the break-even point in...
Piedmont Company segments its business into two regions—North and South. The company prepared the contribution format...
Piedmont Company segments its business into two regions—North and South. The company prepared the contribution format segmented income statement as shown: Total Company North South Sales $ 937,500 $ 750,000 $ 187,500 Variable expenses 637,500 600,000 37,500 Contribution margin 300,000 150,000 150,000 Traceable fixed expenses 152,000 76,000 76,000 Segment margin 148,000 $ 74,000 $ 74,000 Common fixed expenses 64,000 Net operating income $ 84,000 Required: 1. Compute the companywide break-even point in dollar sales. 2. Compute the break-even point in...
Piedmont Company segments its business into two regions—North and South. The company prepared the contribution format...
Piedmont Company segments its business into two regions—North and South. The company prepared the contribution format segmented income statement shown below: Total Company North South   Sales $ 1,156,250 $ 925,000   $ 231,250     Variable expenses 786,250   740,000   46,250     Contribution margin 370,000   185,000   185,000     Traceable fixed expenses 156,000   78,000   78,000     Segment margin 214,000   $ 107,000   $ 107,000     Common fixed expenses 68,000     Net operating income $ 146,000   Required: 1. Compute the companywide break-even point in dollar sales .                2. Compute the...
Piedmont Company segments its business into two regions—North and South. The company prepared the contribution format...
Piedmont Company segments its business into two regions—North and South. The company prepared the contribution format segmented income statement as shown: Total Company North South Sales $ 937,500 $ 750,000 $ 187,500 Variable expenses 637,500 600,000 37,500 Contribution margin 300,000 150,000 150,000 Traceable fixed expenses 152,000 76,000 76,000 Segment margin 148,000 $ 74,000 $ 74,000 Common fixed expenses 64,000 Net operating income $ 84,000 Required: 1. Compute the companywide break-even point in dollar sales. 2. Compute the break-even point in...
Piedmont Company segments its business into two regions—North and South. The company prepared the contribution format...
Piedmont Company segments its business into two regions—North and South. The company prepared the contribution format segmented income statement shown below: Total Company North South Sales $ 812,500 $ 650,000 $ 162,500 Variable expenses 552,500 520,000 32,500 Contribution margin 260,000 130,000 130,000 Traceable fixed expenses 134,000 67,000 67,000 Segment margin 126,000 $ 63,000 $ 63,000 Common fixed expenses 54,000 Net operating income $ 72,000 Required: 1. Compute the companywide break-even point in dollar sales. 2. Compute the break-even point in...
Piedmont Company segments its business into two regions—North and South. The company prepared the contribution format...
Piedmont Company segments its business into two regions—North and South. The company prepared the contribution format segmented income statement as shown: Total Company North South Sales $ 825,000 $ 550,000 $ 275,000 Variable expenses 495,000 385,000 110,000 Contribution margin 330,000 165,000 165,000 Traceable fixed expenses 144,000 72,000 72,000 Segment margin 186,000 $ 93,000 $ 93,000 Common fixed expenses 64,000 Net operating income $ 122,000 Required: 1. Compute the companywide break-even point in dollar sales. 2. Compute the break-even point in...
Exercise 5-14 Break-Even and Target Profit Analysis [LO5-3, LO5-4, LO5-5, LO5-6] Lindon Company is the exclusive...
Exercise 5-14 Break-Even and Target Profit Analysis [LO5-3, LO5-4, LO5-5, LO5-6] Lindon Company is the exclusive distributor for an automotive product that sells for $18.00 per unit and has a CM ratio of 30%. The company’s fixed expenses are $92,340 per year. The company plans to sell 13,200 units this year. Required: 1. What are the variable expenses per unit? (Round your answer to 2 decimal places.)       2. Use the equation method: a. What is the break-even point in...
Exercise 5-14 Break-Even and Target Profit Analysis [LO5-3, LO5-4, LO5-5, LO5-6] Lindon Company is the exclusive...
Exercise 5-14 Break-Even and Target Profit Analysis [LO5-3, LO5-4, LO5-5, LO5-6] Lindon Company is the exclusive distributor for an automotive product that sells for $38.00 per unit and has a CM ratio of 39%. The company’s fixed expenses are $355,680 per year. The company plans to sell 25,000 units this year. Required: 1. What are the variable expenses per unit? (Round your answer to 2 decimal places.)        2. Use the equation method: a. What is the break-even point in...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT