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 expenses Contribution margin Teaceable fixed expenses office segment margin Common fixed expenses not traceable to offices Net operating income Total Company $ 454,500 100.000 227.250 50.000 227,250 50.000 127,260 28.000 99,990 22.000 Office Chicago Minneapolis $ 151,500 100.000 $ 303,000 100.000 45,450 30.000 181,800 60.000 106,050 70.000 121,200 40.000 78.780 52.000 48,480 16.000 $ 27,270 18.000 $ 72,720 24.00 63,630 $ 36, 360 14.00N 8.000 3. Assume that sales in Chicago Increase by $50,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 (i.e. 0.1234 should be entered as 12.3 and other answers to the nearest whole dollar.)) Total Company Chicago Amount Segments Minneapolis Amount % Amount %