Required information [The following information applies to the questions displayed below.) 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 $450,000 Variable expenses 225,000 100% 508 $ 150,000 45,000 100% $ 300,000 1008 30% 180,000 609 Contribution margin 225,000 50% 105,000 70% 120,000 40% Traceable fixed expenses 126,000 28 78,000 528 48,000 169 office segment margin: 99,000 229 $27,000 188 $ 72,000 24 Common fixed expenses not traceable to offices 63,000 146 Net operating income $ 36,000 3. Assume that sales in Chicago increase by $50,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 percentage answers to 1 decimal place (i.e. 0.1234 should be entered as 12.3).) Segments Total Company Chicago Minneapolis Amount % Amount % Amount % 3. Assume that sales in Chicago increase by $50,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 percentage answers to 1 decimal place (i.e. 0.1234 should be entered as 12.3).) 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