$[$The following information applies to the questions displayed below.$]$ Raner, Harris and Chan is a consulting firm specializing in information systems for medical and dental clinics. The firm has two offices $-$ one in Chicago and one in Minneapolis. It 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 below: Total Company Office Chicago Minneapolis Sales $S490,500100\mathrm{.}00\%$$$163,500100\mathrm{.}00\%$ $ $327,000100\mathrm{.}00\%$ Variable expenses $245,25050\mathrm{.}00\%49,05030\mathrm{.}00\%196,20060\mathrm{.}00\%$ Contribution margin $245,25050\mathrm{.}00\%114,45070\mathrm{.}00\%130,80040\mathrm{.}00\%$ Traceable fixed expenses $137,34028\mathrm{.}00\%85,02052\mathrm{.}00\%52,32016\mathrm{.}00\%$ Office segmont margin $107,91022\mathrm{.}00\%$ $ $29,43018\mathrm{.}00\%$ $ $78,48024\mathrm{.}00\%$ Common fixed expenses not traceablo to officos $68,67014\mathrm{.}00\%$ Not operating income S $39,2408\mathrm{.}00\%3.$ Assume sales in Chicago increaso by $$54,500$ next year and sales in Minneapolis and all fixed costs remain unchangod. a$.$ Prepare a new segmented income statement for tho company. Noto: Round your intermediate calculations and percentage answors to $1$ decimal place $(1.$e$.0\mathrm{.}1234$ should be ontered as $12\mathrm{.}3$ and other answers to the nearest whole dollar.$)$