Chapter 6 Homework 80 Seved Part 3 of 3 125 ponts Required information The following information applies to the questions displayed below) 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: Help S office Salme Total Company $495,000 100.00% Chicago Minneapolis Variable expens 247,500 50.00% Contribution margin 247,500 50.00% 8165,000 49,500 115,500 100.00 $330,000 30.00% 100.00% 198,000 40.00% Traceable fixed expenses 138,600 28.00% 85,900 70.00% 52.00 132,000 40.00% 52,800 16.00% office segment margin 108,900 22.00% 29,700 18.00% $ 79,200 24.00 Common fixed expenses not traceable to offices Het sperating incone 69,300 39,600 14.00 8.00% 3. Assume that sales in Chicago increase by $55,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 answers to the nearest whole dollar.)) Total Company Amount Segments Chicago % Amount