! 4 Required information SB Exercise 7-16 through Exercise 7-17 (Algo) The following information applies to the questions displayed below.) Raner, Harris & Chon 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 Total Company Chicago Minneapolis Sales $ 507,000 100% $ 178,500 100 $ 328,500 1001 Variable expenses 253,500 504 53,550 197,180 605 Contribution margin 253,500 5e 124,95 704 131,400 40% Traceable fixed expenses 141,960 284 92,820 529 52,560 164 Office segment margin 111,540 224 $ 32, 130 189 $ 78,840 245 Common fixed expenses not traceable to offices 70,980 149 Net operating income $ 40,560 305 8% Exercise 7-16 Part 3 (Algo) Working with a Segmented Income Statement; Break-Even Analysis (LO7-4, L07-5) 3. Assume that sales in Chicago increase by $59,500 next year and that sales in Minneapolls remain unchanged. Assume no change in fixed costs a. Prepare a new segmented income statement for the company (Round your intermediate calculations and percentage answers to 1 decimal place (.e. 0.1234 should be entered as 12.3 and other answers to the nearest whole dollar.)) Chicago Total Company Amount % Segments Minneapolis Amount % Amount % 0 00 0 0.0 0 0.0 0 0.00 $ 0 0.01$ 0 0.0 $ 0 0.0 +