Check my work Required information Exercise 6-16 Working with a Segmented Income Statement; Break-Even Analysis (L06-4, LO6-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: Sales Variable expenses Contribution margin Traceable fixed expenses office segment margin Common fixed expenses not traceable to offices Het operating income JON Total Company $ 937.500 100.00 506,250 54.00 431,250 46.00 210,000 22.44 221,250 23.60 150,000 16.00 $ 71.250 7.60 Office Chicago Minneapolis $ 187,500 1000 $ 750,000 1008 56,250 450,000 603 131,250 700 300,000 400 97,500 528 112,500 158 $ 33,750 188 $ 187,500 250 Exercise 6-16 Part 3 3. Assume that sales in Chicago increase by $62,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 (le. 0.1234 should be entered as 12.3).) Exercise 6-16 Part 3 2 3. Assume that sales in Chicago increase by $62,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 (.e. 0.1234 should be entered as 12.3).) - Segments Total Company Amount % Minneapolis Chicago Amount % Amount ces 100.0 0 100.0 0.0 0 0.0 Sales Variable expenses Contribution margin Traceable fixed expenses Office segment margin Common foxed expenses not traceable to segments Net operating income 0 100.01$ 40 0.00 $ 0 0.0 $ 0 100.0