Question

In: Accounting

Marston Corporation manufactures disposable thermometers that are sold to hospitals through a network of independent sales...

Marston Corporation manufactures disposable thermometers that are sold to hospitals through a network of independent sales agents located in the United States and Canada. These sales agents sell a variety of products to hospitals in addition to Marston's disposable thermometer. The sales agents are currently paid an 18% commission on sales, and this commission rate was used when Marston's management prepared the following budgeted absorption income statement for the upcoming year.

Marston Corporation
Budgeted Income Statement
  Sales $ 39,000,000
  Cost of goods sold:
      Variable $ 17,400,000
      Fixed 2,750,000 20,150,000
  Gross margin 18,850,000
  Selling and administrative expenses:
      Commissions 7,020,000
      Fixed advertising expense 780,000
      Fixed administrative expense 3,300,000 11,100,000
  Net operating income $ 7,750,000

  

     Since the completion of the above statement, Marston’s management has learned that the independent sales agents are demanding an increase in the commission rate to 20% of sales for the upcoming year. This would be the third increase in commissions demanded by the independent sales agents in five years. As a result, Marston’s management has decided to investigate the possibility of hiring its own sales staff to replace the independent sales agents.

     Marston's controller estimates that the company will have to hire eight salespeople to cover the current market area, and the total annual payroll cost of these employees will be about $670,000, including fringe benefits. The salespeople will also be paid commissions of 10% of sales. Travel and entertainment expenses are expected to total about $390,000 for the year. The company will also have to hire a sales manager and support staff whose salaries and fringe benefits will come to $190,000 per year. To make up for the promotions that the independent sales agents had been running on behalf of Marston, management believes that the company’s budget for fixed advertising expenses should be increased by $430,000.

  

Required:
1. Assuming sales of $39,000,000, construct a budgeted contribution format income statement for the upcoming year for each of the following alternatives:

  

a.

The independent sales agents' commission rate remains unchanged at 18%. (Input all amounts as positive values except losses which should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Enter your answers in thousands. Round your percentage answers to the nearest whole percent.)

  

  (Click to select)Net operating income (loss)Fixed marketing staff expenseVariable cost of goods soldCommissionsFixed advertising expenseFixed cost of goods soldFixed administrative expenseContribution marginSales $      %  
  Variable expenses:
$   
  
  Total variable expense    %  
   %  
  Fixed expenses:
  
  
  
  
  Total fixed expenses   
$   

   

b.

The independent sales agents' commission rate increases to 20%. (Input all amounts as positive values except losses which should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Enter your answers in thousands. Round your percentage answers to the nearest whole percent.)

   

$      %  
  Variable expenses:
$   
  
  Total variable expense    %  
   %  
  Fixed expenses:
  
  
  
  
  Total fixed expenses   
$   

  

c.

The company employs its own sales force. (Input all amounts as positive values except losses which should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Enter your answers in thousands. Round your percentage answers to the nearest whole percent.)

  

$      %  
  Variable expenses:
$   
  
  Total variable expense    %  
   %  
  Fixed expenses:
  
  
  
  
  Total fixed expenses   
$   

  

2. Calculate Marston Corporation's break-even point in sales dollars for the upcoming year assuming the following:

  

a. The independent sales agents' commission rate remains unchanged at 18%. (Round the CM ratio to 2 decimal places and final answer to the nearest dollar amount. Enter your answers in whole dollars and not in thousands.)

  

  Break-even point in sales dollars $   

  

b.

The independent sales agents' commission rate increases to 20%. (Round the CM ratio to 2 decimal places and final answer to the nearest dollar amount. Enter your answers in whole dollars and not in thousands.)

  

  Break-even point in sales dollars $   

  

c.
The company employs its own sales force. (Round the CM ratio to 2 decimal places and final answer to the nearest dollar amount. Enter your answers in whole dollars and not in thousands.)

  

  Break-even point in sales dollars $   

  

3.

Refer to your answer to (1)(b) above. If the company employs its own sales force, what volume of sales would be necessary to generate the net operating income the company would realize if sales are $39,000,000 and the company continues to sell through agents (at a 20% commission rate)? (Round the CM ratio to 2 decimal places and final answer to the nearest dollar amount. Enter your answers in whole dollars and not in thousands.)

  

  Volume of sales $   

  

4.

Determine the volume of sales at which net operating income would be equal regardless of whether Marston Corporation sells through agents (at a 20% commission rate) or employs its own sales force. (Round the CM ratio to 2 decimal places and final answer to the nearest dollar amount. Enter your answers in whole dollars and not in thousands.)

  

  Volume of sales $   

Solutions

Expert Solution

Please hit LIKE button if this helped. For any further explanation, please put your query in comment, will get back to you.
Part 1
Commission 18% Commission 20% Own Sales Force Working
Sales. . . . . . . . . . . . . . . . . . . $           39,000,000 $            39,000,000 $          39,000,000
Less: Variable Cost
Variable Manufacturing exp $          17,400,000 $            17,400,000 $          17,400,000
Agents Commission $            7,020,000 $               7,800,000 $            3,900,000 10% Commission
Total Variable Cost $           24,420,000 $            25,200,000 $          21,300,000
Contribution Margin $           14,580,000 $            13,800,000 $          17,700,000
Less: Fixed Cost
Fixed overhead. . . . . . . . . . . . . . . $            2,750,000 $            2,750,000
Fixed marketing expenses. . .  . .  . .  . .  . . . $                780,000 $            1,210,000 Increase by $430,000
Fixed administrative expenses. . . . . . . $            3,300,000 $            4,550,000 Increase by $670,000+$390,000+$190,000
Total Fixed Cost $             6,830,000 $               6,830,000 $            8,510,000
Net Operating Income $             7,750,000 $               6,970,000 $            9,190,000
Income before income taxes $             7,750,000 $               6,970,000 $            9,190,000
Net Income $             7,750,000 $               6,970,000 $            9,190,000
Part 2
a. BEP with 18% Comission
BEP=Fixed Cost/Contribution Margin
Fixed Cost (Fixed Cost+Interest) $            6,830,000
Contribution Margin (CM/Sales) 37.38%
BEP (Fixed Cost/CM Ratio) $          18,269,547
b. BEP with 20% Comission
Fixed Cost (Fixed Cost+Interest) $            6,830,000
Contribution Margin (CM/Sales) 35.38%
BEP (Fixed Cost/CM Ratio) $          19,302,174
c. BEP with own sales force
Fixed Cost (Fixed Cost+Interest) $            8,510,000
Contribution Margin (CM/Sales) 45.38%
BEP (Fixed Cost/CM Ratio) $          18,750,847
3. TO maintain budgeted Net Income
To maintain budgeted Net Income $2,053,800 i.e. $2,934,000 before tax income
(Fixed Cost+Target Profit)/Contribution Margin
Fixed Cost at 20% Commission $            6,830,000 From b Above a
Contribution Margin at 20% commission 35.38% From b Above b
Target Income before tax $            6,970,000 c
Target Sales (a+c)/b $          39,000,000
4. Equal Net income
Let Sale be x
20% Commission Own Sales force
Let Sale be x x
Variable Cost Ratio (100-Margin Ratio) 65% 54.62%
Fixed Cost (From b and c) $            6,830,000 $             8,510,000
0.65x+6830000=0.5462x+8510000
x= $          16,800,000

Related Solutions

Marston Corporation manufactures disposable thermometers that are sold to hospitals through a network of independent sales...
Marston Corporation manufactures disposable thermometers that are sold to hospitals through a network of independent sales agents located in the United States and Canada. These sales agents sell a variety of products to hospitals in addition to Marston's disposable thermometer. The sales agents are currently paid an 19% commission on sales, and this commission rate was used when Marston's management prepared the following budgeted absorption income statement for the upcoming year. Marston Corporation Budgeted Income Statement Sales $ 33,000,000 Cost...
Marston Corporation manufactures disposable thermometers that are sold to hospitals through a network of independent sales...
Marston Corporation manufactures disposable thermometers that are sold to hospitals through a network of independent sales agents located in the United States and Canada. These sales agents sell a variety of products to hospitals in addition to Marston's disposable thermometer. The sales agents are currently paid an 16% commission on sales, and this commission rate was used when Marston's management prepared the following budgeted absorption income statement for the upcoming year. Budgeted income statement Sales: $39,000,000 Coast of Goods Sold:...
partial credit, P3-48 (similar to) Marston Corporation manufactures housewares products that are sold through a network...
partial credit, P3-48 (similar to) Marston Corporation manufactures housewares products that are sold through a network of external sales agents. The agents are paid a commission of 19​% of revenues. Marston is considering replacing the sales agents with its own​ salespeople, who would be paid a commission of 10​% of revenues and total salaries of $ 2 comma 520 comma 000. The income statement for the year ending December​ 31, 2017​, under the two scenarios is shown here. Marston Corporation...
Bonita Beauty Corporation manufactures cosmetic products that are sold through a network of sales agents. The...
Bonita Beauty Corporation manufactures cosmetic products that are sold through a network of sales agents. The agents are paid a commission of  19% of sales. The income statement for the year ending December 31, 2020, is as follows. BONITA BEAUTY CORPORATION Income Statement For the Year Ended December 31, 2020 Sales $ 78,400,000 Cost of goods sold     Variable $ 32,144,000     Fixed 9,000,000 41,144,000     Gross margin $ 37,256,000 Selling and marketing expenses     Commissions $ 14,896,000     Fixed costs 10,528,000 25,424,000     Operating income $...
Marigold Beauty Corporation manufactures cosmetic products that are sold through a network of sales agents. The...
Marigold Beauty Corporation manufactures cosmetic products that are sold through a network of sales agents. The agents are paid a commission of 22% of sales. The income statement for the year ending December 31, 2020, is as follows. MARIGOLD BEAUTY CORPORATION Income Statement For the Year Ended December 31, 2020 Sales $75,100,000 Cost of goods sold     Variable $32,293,000     Fixed 8,870,000 41,163,000     Gross margin $33,937,000 Selling and marketing expenses     Commissions $16,522,000     Fixed costs 10,380,000 26,902,000     Operating income $7,035,000 The company is...
Bonita Beauty Corporation manufactures cosmetic products that are sold through a network of sales agents. The...
Bonita Beauty Corporation manufactures cosmetic products that are sold through a network of sales agents. The agents are paid a commission of 21% of sales. The income statement for the year ending December 31, 2020, is as follows. BONITA BEAUTY CORPORATION Income Statement For the Year Ended December 31, 2020 Sales $78,800,000 Cost of goods sold     Variable $31,520,000     Fixed 8,650,000 40,170,000     Gross margin $38,630,000 Selling and marketing expenses     Commissions $16,548,000     Fixed costs 10,970,900 27,518,900     Operating income $11,111,100 The company is...
Klyne Corporation manufactures pharmaceutical products that are sold through a network of sales agents. The agents...
Klyne Corporation manufactures pharmaceutical products that are sold through a network of sales agents. The agents are paid a commission of 24% of sales. The income statement for the year ending December 31, 2017, is as follows: KLYNE CORPORATION Income Statement For the Year Ending December 31, 2017   Sales $ 29,000,000   Cost of goods sold      Variable $ 14,790,000         Fixed 2,876,000    17,666,000   Gross margin 11,334,000   Selling and marketing expenses      Commissions 6,960,000         Fixed costs 3,270,000    10,230,000   Operating income...
Klyne Corporation manufactures pharmaceutical products that are sold through a network of sales agents. The agents...
Klyne Corporation manufactures pharmaceutical products that are sold through a network of sales agents. The agents are paid a commission of 24% of sales. The income statement for the year ending December 31, 2017, is as follows: KLYNE CORPORATION Income Statement For the Year Ending December 31, 2017   Sales $ 29,000,000   Cost of goods sold      Variable $ 14,790,000         Fixed 2,876,000    17,666,000   Gross margin 11,334,000   Selling and marketing expenses      Commissions 6,960,000         Fixed costs 3,270,000    10,230,000   Operating income...
Olin Beauty Corporation manufactures cosmetic products that are sold through a network of sales agents. The...
Olin Beauty Corporation manufactures cosmetic products that are sold through a network of sales agents. The agents are paid a commission of 18% of sales. The forecast income statement for the year ending December 31, 2020, is as follows: OLIN BEAUTY CORPORATION Income Statement Year Ending December 31, 2020 Sales $78,335,000 Cost of goods sold Variable $36,034,100 Fixed 7,880,000 43,914,100 Gross margin 34,420,900 Selling and marketing expenses Commissions $14,100,300 Fixed costs 10,084,000 24,184,300 Operating income $10,236,600 The company is considering...
Lionel Corporation manufactures pharmaceutical products sold through a network of sales agents in the United States...
Lionel Corporation manufactures pharmaceutical products sold through a network of sales agents in the United States and Canada. The agents are currently paid an 18% commission on sales; that percentage was used when Lionel prepared the following budgeted income statement for the fiscal year ending June 30, 2019: Lionel Corporation Budgeted Income Statement For the Year Ending June 30, 2019 ($000 omitted) Sales $ 28,500 Cost of goods sold Variable $ 12,825 Fixed 3,500 16,325 Gross profit $ 12,175 Selling...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT