5 Required information The following information applies to the questions displayed below] 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 Sales Variable expended Contribution margin Traceable fixed ex Office sepat margin Cannon fixed expordes not traceable to offices Net operating income Total Company $ 675,000 100.0 314.500 54.0% 310.500 46.08 151.300 22. 159, 300 23.08 108.000 16.0 $51. 200 7.6% Chicco $ 136,000 40.500 96 500 70. 200 Office mespolit 100% $ 540,000 1004 30 324.000 70 216,000 40N 53% 81.000 18% $ 135.000 S 3. Assume that sales in Chicago increase by $45,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 percentage answers to 1 decimal place (i.e. 0.1234 should be entered as 12.3).) Total Company Amount 5 Chicago Segments Minneapolis Amount Amount