0 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 Traceable fixed expenses Office segment margin Common fixed expenses not traceable to offices Net operating income Total Company $ 510,000 1004 265,000 508 245,000 508 134,000 288 111,000 22) 73,000 $ 38,000 office Chicago Minneapolis $ 180,000 1008 $ 330,000 18 65,000 300 198,000 600 115,000 705 132,000 400 82,000 528 52,800 160 $ 33,000 180 $ 79,200 240 3. Assume that sales in Chicago Increase by $60,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 (ie. 0.1234 should be entered as 12.3 and other answers to the nearest whole dollar.)) Total Company Chicago Amount % Amount $ 570,000 100.0 $ 240,000 284,667 49.9 86,667 285,333 50.1 153,333 Sales Variable expensen Contribution margin Traceable food expenses Office segment margin Common fixed expenses noftraceable to segments Net operating income Segmento Minneapolis % Amount % 100,0 330,000 100.0 38.1 198.000 60.0 63.9 132,000 400 52.800 16.0 630S 79.200 24.0 285,333 50.15 153.333 $ 285,333 50.1