EXERCISE 11–3 Working with a Segmented Income Statement [LO1]

Middleton Associates is a consulting firm that specializes in information systems for con- struction and landscaping companies. The firm has two offices—one in Toronto and one in Vancouver. The firm classifies the direct costs of consulting jobs as variable costs. A segmented contribution format income statement for the company’s most recent year is given below:

 

 

 

Sales . . . . . . . . . . . . . . . . . . . . . . . . . .	$750,000	Â	100.0%	$150,000	Â	100%	$600,000	Â	100%
Variable expenses . . . . . . . . . . . . . .	 405,000	Â	 54.0	   45,000	Â	 30	  360,000	Â	 60
Contribution margin. . . . . . . . . . . .	345,000	Â	46.0	105,000	Â	70	240,000	Â	40
Traceable fixed expenses . . . . . . .	  168,000	Â	 22.4	   78,000	Â	 52	   90,000	Â	  15
Office segment margin . . . . . . . . .	177,000	Â	23.6	$ 27,000	Â	18%	$ 150,000	Â	25%
Common fixed expenses not traceable to offices . . . . .	    120,000	Â	    16.0	Â	Â	Â	Â	Â	Â
Operating income . . . . . . . . . . . . . .	$ 57,000	Â	7.6%	Â	Â	Â	Â	Â	Â

 

Required:

1.               By how much would the company’s operating income increase if Vancouver increased its sales by $75,000 per year? Assume no change in cost behaviour patterns.

2.               Refer to the original data. Assume that sales in Toronto increase by $50,000 next year and that sales in Vancouver remain unchanged. Assume no change in fixed costs.

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 the CM ratio for Toronto has remained unchanged at 70% (the same as in the above data) but that the segment margin ratio has changed. How do you explain the change in the segment margin ratio?