Middleton Associates is a consulting firm that specializes in information system
ID: 2546401 • Letter: M
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,050,000 100.00 % $ 150,000 100 % $ 900,000 100 % Variable expenses 585,000 55.71 45,000 30 540,000 60 Contribution margin 465,000 44.29 105,000 70 360,000 40 Traceable fixed expenses 153,000 14.57 63,000 42 90,000 10 Office segment margin 312,000 29.71 $ 42,000 28 % $ 270,000 30 % Common fixed expenses not traceable to offices 108,000 10.29 Operating income $ 204,000 19.43 % Required: 1. By how much would the company’s operating income increase if Vancouver increased its sales by $94,000 per year? Assume no change in cost behaviour patterns. 2-a. Refer to the original data. Assume that sales in Toronto increase by $75,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.)
Explanation / Answer
1 Increase in operating income=94000*40%= $37600 Office Total Company Toronto Vancouver Amount % Amount % Amount % Sales $1,125,000 100.00% 225000 100.00% $900,000 100.00% Variable expenses $607,500 54.00% 67,500 30.00% 540,000 60.00% Contribution margin $517,500 46.00% 157,500 70.00% 360,000 40.00% Traceable fixed expenses $153,000 13.60% 63,000 28.00% 90,000 10.00% Office segment margin $364,500 32.40% $94,500 42.00% $270,000 30.00% Common fixed expenses 108,000 9.60% Net operating income $256,500 22.80%