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: office Total Company Chicago Minneapollo Sales $ 450,000 1008 $ 150,000 1008 $ 300,000 1008 Variable expenses 225,000 508 45.000 300 180,000 600 Contribution margin 225,000 500 105,000 120,000 Traceable fixed expenses 126,000 28 78,000 40,000 16 office segment margin 99,000 226 $ 27.000 189 $ 72,000 Common fixed expenses not traceable to offices 63,000 Net operating income $36.000 405 705 528 24 148 BA 3. Assume that sales in Chicago increase by $50,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 (.e. 0.1234 should be entered as 12.3).) Total Company Chicago Amount Segments Minneapolis % Amount 100.0 S 300,000 100.0 300 180.000 60.0 700 120,000 40.0 Sales Variable expenses Contribution margin Amount $ 500,000 240,000 260.000 ooo 1000$ 200,000 48.0 60.000 520 140,000 Shop ang Shop.png Shop ong Shop.png