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 Office Total Company Chicago Minneapolis $474,000 100% $162,000 100% $312,000 1% 241,000 50% 53,000 30% 187,200 60% 233,000 50% 109,000 70% 124,800 40% 129,200 28% 79,600 52% 49,920 16% 103,800 22% $ 29,400 18% $ 74,880 24% 67,000 $ 36, 800 14% 8% 3. Assume that sales in Chicago increase by $54,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 (i.e. 0.1234 should be entered as 12.3 and other answers to the nearest whole dollar.)) Total Company Amount % Sales $ 528,000 100.0 Segments Chicago Minneapolis Amount % Amount % $ $ 100.0 100.0 216,000 312,000 187,200 60.0 216,000 100.0 124,800 40.0 16.0 $ $ 100.0 24.0 216,000 124,800 528,000 100.0 Variable expenses Contribution margin Traceable fixed expenses Office segment margin Common fixed expenses not traceable to segments Net operating income 528,000 100.0 $ 528,000 100.0