Question

In: Accounting

Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and...

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:

Assume that Minneapolis’ sales by major market are:

Market

Minneapolis Medical Dental
Sales $ 630,000 100 % $ 420,000 100 % $ 210,000 100 %
Variable expenses 378,000 60 % 273,000 65 % 105,000 50 %
Contribution margin 252,000 40 % 147,000 35 % 105,000 50 %
Traceable fixed expenses 75,600 12 % 21,000 5 % 54,600 26 %
Market segment margin 176,400 28 % $ 126,000 30 % $ 50,400 24 %

Common fixed expenses
not traceable to markets

18,900 3 %
Office segment margin $ 157,500 25 %

The company would like to initiate an intensive advertising campaign in one of the two market segments during the next month. The campaign would cost $8,400. Marketing studies indicate that such a campaign would increase sales in the Medical market by $73,500 or increase sales in the Dental market by $63,000.

Required:

1. How much would the company's profits increase (decrease) if it implemented the advertising campaign in the Medical Market??

Company's profits by

2. How much would the company's profits increase (decrease) if it implemented the advertising campaign in the Dental Market?

Company's profits by

3. In which of the markets would you recommend that the company focus its advertising campaign?

In which of the markets would you recommend that the company focus its advertising campaign?

Medicalradio button unchecked1 of 2
Dentalradio button unchecked2 of 2

Solutions

Expert Solution

Req1: Contribution of medical market: $147000
Sales revenue of medical market: $ 420,000
CM ratio: Contribution/ Sales revenue *100
($ 147000 /420000) *100 =35%
Additional fixed cost: $ 8400
Additional sales revenue generated in Medical market: $ 73500
Additional contribution generated: 73500*35% = 25725
Net increase in profits:
Additional contribution earned 25725
Less: Addvertisement expense 8400
Net Increase in profits 17325
Req 2:
Contribution earned in Dental: $105000
Sales revenue: $ 210,000
CM ratio: $105000 /210000 *100 =50%
Additiional fixed cost: $8400
Additional sales revenue generated in Dental market: $ 63000
Additional contribution earned: 63000*50% = $ 31500
Increase in Profits:
Additional contribution earned: 31500
Less: Advertisement expense 8400
Net increase in profits 23100
Req 3:
DENTAL MARKET, the cmpany should focu on Dental market.

Related Solutions

Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and...
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 Minneapolis Sales $ 412,500 100.0 % $ 82,500 100 % $ 330,000 100 % Variable expenses 222,750 54.0 % 24,750 30...
Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and...
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 Minneapolis Sales $ 637,500 100.0 % $ 127,500 100 % $ 510,000 100 % Variable expenses 344,250 54.0 % 38,250 30...
Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and...
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 Minneapolis Sales $ 562,500 100.0 % $ 112,500 100 % $ 450,000 100 % Variable expenses 303,750 54.0 % 33,750 30...
Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and...
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 Minneapolis Sales $ 492,000 100 % $ 171,000 100 % $ 321,000 1 % Variable expenses 253,000 50 % 59,000 30...
Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and...
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: Assume that Minneapolis’ sales by major market are: Market Minneapolis Medical Dental Sales $ 330,000 100 % $ 220,000 100 % $ 110,000 100 %...
Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and...
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 Minneapolis Sales $ 450,000 100 % $ 150,000 100 % $ 300,000 100 % Variable expenses 225,000 50 % 45,000 30...
Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and...
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 Minneapolis Sales $ 825,000 100.0 % $ 165,000 100 % $ 660,000 100 % Variable expenses 445,500 54.0 % 49,500 30...
Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and...
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 Minneapolis Sales $ 1,050,000 100.0 % $ 210,000 100 % $ 840,000 100 % Variable expenses 567,000 54.0 % 63,000 30...
Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and...
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 Minneapolis Sales $ 675,000 100.0 % $ 135,000 100 % $ 540,000 100 % Variable expenses 364,500 54.0 % 40,500 30...
Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and...
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: Assume that Minneapolis’ sales by major market are: Market Minneapolis Medical Dental Sales $ 390,000 100 % $ 260,000 100 % $ 130,000 100 %...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT