Raner, Harris & 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 Total Company Chicago Sales Minneapolis $ 466,000 100% $ 158,00 100% $ 300,000 100% Variable expenses 232, 20e 50% 47,400 30% 184,890 Contribution margin 233,800 50% 119,60 70% 123,268 10% Traceable fixed expenses 131.440 28% 82,160 52% 49,280 16% office segment nargin 102,360 22% $ 28,440 18% $ 73,920 24% Common fixed expenses not traceable to offices 65.240 14% Net operating income $ 37,120 8% Exercise 6-16 Part 3 (Algo) Working with a Segmented Income Statement; Break-Even Analysis (LO6-4, LO6-5] 3. Assume that sales in Chicago increase by $54,000 next year and that sales in Minneapolis 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 onswers to the nearest whole dollar)) Total Company Amount % Chicago Amount Segments Minneapolis Amount 0.0 0 00 0 0.00 Sales Variable expenses Contribution margin Traceable fixed expenses office segment margin Common fixed expenses not traceable to segments Net operating income 0.01$ 0 0.0 s 0 00 0 0.0