SB Exercise $6-16$ through Exercise $6-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:

Total Company Office

Chicago Minneapolis

Sales $ $468,000100\mathrm{.}00\%$ $ $156,000100\mathrm{.}00\%$ $ $312,000100\mathrm{.}00\%$

Variable expenses $234,00050\mathrm{.}00\%46,80030\mathrm{.}00\%187,20060\mathrm{.}00\%$

Contribution margin $234,00050\mathrm{.}00\%109,20070\mathrm{.}00\%124,80040\mathrm{.}00\%$

Traceable fixed expenses $131,04028\mathrm{.}00\%81,12052\mathrm{.}00\%49,92016\mathrm{.}00\%$

Office segment margin $102,96022\mathrm{.}00\%$ $ $28,08018\mathrm{.}00\%$ $ $74,88024\mathrm{.}00\%$

Common fixed expenses not traceable to offices $65,52014\mathrm{.}00\%$

Net operating income $ $37,4408\mathrm{.}00\%$

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

Assume Minneapolis$$s sales by major market are:

Minneapolis Market

Medical Dental

Sales $ $312,000100\mathrm{.}00\%$ $ $208,000100\mathrm{.}00\%$ $ $104,000100\mathrm{.}00\%$

Variable expenses $187,20060\mathrm{.}00\%133,12064\mathrm{.}00\%54,08052\mathrm{.}00\%$

Contribution margin $124,80040\mathrm{.}00\%74,88036\mathrm{.}00\%49,92048\mathrm{.}00\%$

Traceable fixed expenses $34,32011\mathrm{.}00\%12,4806\mathrm{.}00\%21,84021\mathrm{.}00\%$

Market segment margin $90,48029\mathrm{.}00\%$ $ $62,40030\mathrm{.}00\%$ $ $28,08027\mathrm{.}00\%$

Common fixed expenses not traceable to markets $15,6005\mathrm{.}00\%$

Office segment margin $ $74,88024\mathrm{.}00\%$

The company is planning a $$5,200$ advertising campaign next month in either the Medical or Dental market. Marketing studies indicate this campaign would increase Medical market sales by $$41,600$ or Dental market sales by $$36,400.$

Required:

How much would the company's profits increase $($decrease$)$ if it advertised in the Medical market?

How much would the company's profits increase $($decrease$)$ if it advertised in the Dental market?

Should the company advertise in the Medical or Dental market?

Please answer allll!!!!!