How do I solve this?

0 Required information Exercise 6-16 Working with a Segmented Income Statement; Break-Even Analysis [LO6-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: office Chicago Minneapolis Sales $ 195,000 Variable expenses Total Company $975,000 526,500 448,500 218,400 Contribution margin 100.0% 54.0 46.08 22.49 23.68 58,500 136,500 101,400 Traceable fixed expenses office segment margin 230,100 $ 35,100. Common fixed expenses not traceable to offices 156,000 16.08 Net operating income. $ 74,100 7.68 100% 308 70% 52% 18% $ 780,000 468,000 312,000 117,000 $ 195,000 100% 60% 40% 15% 258 Exercise 6-16 Part 3 3. Assume that sales in Chicago increase by $65,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 i Chicago Minneapolis Total Company Amount % Amount Sales $ 1,040,000 Variable expenses Contribution margin 1,040,000 Traceable fixed expenses Office segment margini 1,040,000 Common fixed expenses not traceable to segments Net operating income $ 1,040,000 100.0 100.0 100.0 $ 100.0 0 0 % Amount 100.0 100.0 100.0 $ 0 0 100.0 100.0 100.0