In: Accounting
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.
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 |