Check my work

SB Exercise $7-16$ through Exercise $7-17($Algo$)$

$[$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:

$\backslash$table$[[$Sales$,$Total Company,Office$],[$Chicago$,$Minneapolis$],[,$$ $495,000,100\mathrm{.}004,$$ $165,000,100\mathrm{.}004,$$ $330,0$ee$,100\mathrm{.}004],[$Variable expenses,$247,500,50\mathrm{.}004,49,500,30\mathrm{.}604,198,889,$c$4\mathrm{.}90\%],[$Contribution nargin,$247,500,50\mathrm{.}004,115,500,70\mathrm{.}000,132,600,40\mathrm{.}00$ c$],[$Traceable fixed expenses,$138,600,28\mathrm{.}004,85,800,52\mathrm{.}004,52,500,16\mathrm{.}00$ s$],[$Office segment margin,$188,900,22\mathrm{.}004,$$ $29,700,18\mathrm{.}004,579\mathrm{.}200,24\mathrm{.}604],[$Connon fixed expenses not traceable to offices,$69,300,14\mathrm{.}604,,,,],[$Net operating incone,$ $39,600,8\mathrm{.}004,,,,]]$

Exercise $7-17($Algo$)$ Working with a Segmented Income Statement $[$LO$7-4]$

Assume Minneapolis's sales by major market are:

$\backslash$table$[[,$Minneapolis,Market$],[$Medical$,$Dental$],[$Sales$,$$ $330,000,180\mathrm{.}005,$$ $220,000,180\mathrm{.}004,$$ $110,660,109\mathrm{.}00\%],[$Variable expenses,$198,000,6$ e $.$ees,$144,8$ee$,64\mathrm{.}604,57,200,52,$eet$],[$Contribution nargin,$132,008,40\mathrm{.}004,79,2$ee$,36\mathrm{.}004,52,800,48\mathrm{.}204],[$Traceable fixed expenses,$36,300,11\mathrm{.}0e8,13,200,6\mathrm{.}604,23,100,21\mathrm{.}004],[$Market segment margin,$95,700,29\mathrm{.}204,$$ $66,000,30\mathrm{.}064,$$ $29,780,27\mathrm{.}004],[$Connon fixed expenses not traceable to markets,$15,590,5\mathrm{.}0e4,,,,],[$Office segment margin,$ $79,200,24\mathrm{.}004,,,,]]$

Prov

$5$ of $7$

NextRequired information

$\backslash$table$[[,$Minneapolis,restines$],[,$Medical,Dental$],[$Sales$,,160\mathrm{.}0e4,$$ $220,000,180\mathrm{.}004,$$ $110,008,108\mathrm{.}00\%],[$Variable expenses,$198,000,60\mathrm{.}0e4,140,800,64\mathrm{.}004,57,200,52\mathrm{.}004],[$Contribution margin,$132,8$ee$,40\mathrm{.}094,79,200,35\mathrm{.}064,52,800,48\mathrm{.}64],[$Traceable fixed expenses,$36,300,11\mathrm{.}004,13,26$e$,6\mathrm{.}004,23,100,21\mathrm{.}004],[$Market segment margin,$95,700,29\mathrm{.}0$ev$,$$ $66,000,30\mathrm{.}604,$$ $29,780,27\mathrm{.}8e4$