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 Sales Variable expenses Total Company $495,000 100% Chicago $165,000 100% Contribution margin Traceable fixed expenses Office segment margin 247,500 50% 247,500 50% 138,600 28% 108.900 22% 49,500 30% 115,500 70% Minneapolis $330,000 100% 198,000 60% 132,000 40% 85,800 $29,700 18% 52% 52.800 16% $79.200 24% Common fixed expenses not traceable to offices Net operating income 69,300 14% $39,600 8% References Section Break 58 Exercise 7-16 through Exercise 7-17 (Algol B. Award: 2.00 points Exercise 7-16 Part 3 (Algo) Working with a Segmented Income Statement; Break-Even Analysis [LO7-4, LO7-5] 3. Assume that sales in Chicago increase by $55,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.)) Segments Total Company Chicago Minneapolis Amount % Amount % Amount %