$8$

$(!)$

Required information

$[$The following information applies to the questions displayed below.$]$

Part $3$ of $4$

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:

$10$

points

Skipped

$\backslash$table$[[,$Total Company,$],[,$$ $468,000,100\mathrm{.}00\%,$$ $156,],[$Sales$,$$ $234,000,50\mathrm{.}00\%,46,8],[$Variable expenses,$234,000,50\mathrm{.}00\%,109],[$Contribution margin,$131,040,28\mathrm{.}00\%,81,],[$Traceable fixed expenses,$102,960,22\mathrm{.}00\%,$$ $28],[$Office segment margin,$102,960,,],[$Common fixed expenses not trace,$65,520,14\mathrm{.}00\%,],[$Net operating income,$ $37,440,8\mathrm{.}00\%,]]$

Assume sales in Chicago increase by $$52,000$ next year and sales in Minneapolis and all fixed costs remain unchanged.

a$.$ Prepare a new segmented income statement for the company.

Note: Round your intermediate calculations and percentage answers to $1$ decimal place $($i$.$e$.0\mathrm{.}1234$ should be entered as $12\mathrm{.}3$ and other answers to the nearest whole dollar.$)$