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 office Sales Total Company Chicago Minneapolis $ 471,000 1001 $ 160,500 100 $ 310,500 Variable expenses 239,000 50 52,000 304 186,300 Contribution margin 232,000 50 108,500 701 Traceable fixed expenses 124,200 128,800 289 79,400 524 49,680 164 office segment margin 103,200 $ 29,100 $ 74,520 245 Common fixed expenses not traceable to offices 66,500 Net operating income $36,700 88 15 409 185 22 145 3. Assume that sales in Chicago increase by $53,500 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)) a. Prepare a new segmented income statement for the company. (Round your intermediate calculations and percentage answers to 1 decimal place (le. 0.1234 should be entered as 12.3 and other answers to the nearest whole dollar.) ook rint Total Company Amount % Chicago Amount Segments Minneapolis Amount % % erences