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 Total Company Chicago Minneapolis Sales: $ 522,000 100.00% $ 174,000 100.00% $ 348,000 100.00% Variable expenses 261,000 50.00% 52,200 30.00% 208,800 60.00% Contribution margin 261,000 50.00% Traceable fixed expenses 146,160 28.00% 121,800 90,480 70.00% 52.00% 139,200 40.00% 55,680 16.00 Office segment margin 114,840 22.00% $ 31,320 18.00% $ 83,520 24.00% Common fixed expenses not traceable to offices 73,080 Net operating income $ 41,760 14.00% 8.00% 3. Assume that sales in Chicago increase by $58,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 (i.e. 0.1234 should be entered as 12.3 and other answers to the nearest whole dollar.)) 3. Assume that sales in Chicago increase by $58,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 (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 % 0 0.0 0 0.0 0 0.0 0 0.0 $ 0 0.0 $ 0 0.0 $ 0 0.0