3 Raner, Harris and Chan is a consulting firm that specializes in information systems for medical and dental clinics. The firm has two offices-one in Chicago and one in Minneapolis. The firm classifies the direct costs of consulting jobs as variable costs. A contribution format segmented income statement for the company's most recent year is given: Office ort 3 of 3 Total Company Chicago Minneapolis Sales $ 540,090 100% $ 180, 006 160% $ 360,060 100% Variable expenses 270 , 000 50% 54, 090 30% 216, 000 60% Contribution margin 270, 000 50% 126,900 70% 144,060 40% Traceable fixed expenses 151, 200 28% 93, 600 52% 57,600 16% nts Office segment margin 118, 800 22% $ 32, 400 18% $ 86,409 24% Common fixed expenses not traceable to offices 75, 600 14%% Net operating income $ 43, 200 8%% eBook Exercise 7-16 Part 3 (Algo) Working with a Segmented Income Statement; Break-Even Analysis [LO7-4, Print LO7-5] n 3. Assume that sales in Chicago increase by $60,000 next year and that sales in Minneapolis remain unchanged. Assume no change erences in fixed costs. a. Prepare a new segmented income statement for the company. (Round your intermediate calculations and percentage answers to 1 decimal place (i.e. 0.1234 should be entered as 12.3 and other answers to the nearest whole dollar.)) Segments Total Company Chicago Minneapolis Amount % Amount % Amount %