Segmented income statement
Not what you're looking for?
See attachment .
Total Company Percentage Houston Dallas
Sales $750,000 100% $150,000 100% $600,000 100%
Variable expenses 405,000 54 45,000 30% 360,000 60%
Contribution margin 345,000 46 105,000 70 240,000 40
Traceable fixed expenses 168,000 22.4 78,000 52 90,000 15
Office segment margin 177,000 24 27,000 18% $150,000 25%
Common fixed 120,000 16
expenses not traceable to offices
Net operating income $57,000 7.60%
1. By how much would the company's net opertaing income increase if Dallas increased its sales by $75,000
per year? Assume no change in cost behavior patterns.
2. Refer to the original data. Assume that sales in Houston increase by $50,000 next year and that sales in
Dallas remain unchanged. Assume no change in fixed cost.
a. Prepare a new segmented income statement for the company using the above format. Show both amounts
and percentages.
b. Observe from the income statement you have prepared that CM ration for Houston has remained unchanged
at 70%(the same as in the above data) but that the segment margin ration has changed. How do you
explain the change in the segment margin ratio?
Purchase this Solution
Solution Summary
The solution explains some calculations relating to segmented income statement
Purchase this Solution
Free BrainMass Quizzes
IPOs
This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)
Six Sigma for Process Improvement
A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.
Operations Management
This quiz tests a student's knowledge about Operations Management
Lean your Process
This quiz will help you understand the basic concepts of Lean.
Organizational Behavior (OB)
The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.