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 Total Company Chicago Sales $ 487,500 Variable expenses Contribution margin Traceable fixed expenses office segment margin 100.0% 263,250 54.09 224,250 46.0% 109,200 22.4 115,050 23.68 $ 17,550 29,250 $ 97,500 100% $390,000 100% 30% Minneapolis 234,000 601 68,250 708 156,000 40% 50,700 526 58,500 258 189 $ 97,500 251 Common fixed expenses not traceable to offices Net operating income 78,000 16.0% $ 37,050 7.68 3. Assume that sales in Chicago increase by $32,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 percentage answers to 1 decimal place (i.e. 0.1234 should be entered as 12.3).) Segments Total Company Chicago Minneapolis Amount % Amount Amount % Sales Variable expenses Contribution margin $ 520,000 100.0 $ 130,000 100.0 100.0 520,000 100.0 130,000 100.0 0 100.0 Traceable fixed expenses Office segment margin 520,000 100.0 $ 130,000 100.0 $ 0 100.0 Common fixed avnaneae not transshia in eanmante