Required information Exercise 7-16 Working with a Segmented Income Statement; Break-Even Analysis (L07-4, L07-5) (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: Office Total Company Chicago Minneapolis Sales $1,125.000 100.0% $ 225,000 100% $ 900,000 100% Variable expenses 607,500 54.0% 67,500 30% 540,000 60% Contribution margin 517,500 46.0% 157,500 70% 360,000 40% Traceable fixed expenses 252,000 22.4% 117.000 52% 135,000 15% office segment margin 265,500 23.6% $ 40,500 18% $ 225,000 25% Common fixed expenses not traceable to offices 180,000 16.0% Net operating income $ 85,500 7.6% Exercise 7-16 Part 3 3. Assume that sales in Chicago increase by $75,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 (le. 0.1234 should be entered as 12.3).) Total Company Chicago Amount Segments Minneapolis Amount Amount 0.0 0 0 0 0.0 0.0 Sales Variable expenses Contribution margin Traceable foxed expenses Office segment margin Common fixed expenses not traceable to segments Net operating income 0 00 $ 0 0.00 $ 0 0.0 $ 0 0.0