Question

Middleton Associates is a consulting firm that specializes in information systems for construction 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:

					Office
	Total Company				Toronto				Vancouver
Sales	$	1,000,000	100.00	%	$	280,000	100	%	$	720,000	100	%
Variable expenses		516,000	51.60			84,000	30			432,000	60
Contribution margin		484,000	48.40			196,000	70			288,000	40
Traceable fixed expenses		259,200	25.92			151,200	54			108,000	15
Office segment margin		224,800	22.48		$	44,800	16	%	$	180,000	25	%
Common fixed expenses not     traceable to offices		81,000	8.10
Operating income	$	143,800	14.38	%

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

2-a. Refer to the original data. Assume that sales in Toronto increase by $80,000 next year and that sales in Vancouver remain unchanged. Assume no change in fixed costs. Prepare a new segmented income statement for the company. (Round your percentage answers to 2 decimal places.)

Answer 1

Part 1

Increase in sales of Vancouver	$        81,000
Multiply: contribution margin ratio of Vancouver	40%
Increase in contribution margin	$        32,400
Less: Increase in fixed cost	$                  0
Increase in Company’s operating income	$        32,400

Part 2

	Increase	Plus: Original Data	Revised Data
Increase in sales of Toronto	$              80,000	$        280,000	$        360,000
Less: Increase in variable cost of Toronto (80000*30%)	$              24,000	$          84,000	$        108,000
Increase in contribution margin of Toronto	$              56,000	$        196,000	$        252,000

Segmented contribution format income statement
	Total Company	Toronto	Vancouver
	Amount	%	Amount	%	Amount	%
Sales	$        1,080,000	100.00%	$        360,000	100.00%	$        720,000	100.00%
Variable expenses	$            540,000	50.00%	$        108,000	30.00%	$        432,000	60.00%
Contribution margin	$            540,000	50.00%	$        252,000	70.00%	$        288,000	40.00%
Traceable fixed expenses	$            259,200	24.00%	$        151,200	42.00%	$        108,000	15.00%
Office segment margin	$            280,800	26.00%	$        100,800	28.00%	$        180,000	25.00%
Common fixed expenses	$              81,000	7.50%
Operating income	$            199,800	18.50%