Johnson 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 Johnson's disposable thermometer The sales agents are currently paid an 17 commission on sales, and this commission rate was used when Marston's management prepared the following budgeted absorption income statement for the upcoming year Johnson Corporation Budgeted Income Statement Sales $ 33,000,000 Cost of goods sold Variable $ 17,400,000 Fixed 2,740,000 20,140,000 Gross margin 12,860,000 Selling and administrative expenses Commissions 5,610,000 Fixed advertising expense 700,000 Fixed administrative expense 3,300,000 9,610,000 Net operating income $ 3,250,000 Since the completion of the above statement, Johnsons management has learned that the independent sales agents are demanding an increase in the commission rate to 19 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, Johnsons management has decided to investigate the possibility of hiring its own sales staff to replace the independent sales agents Johnson'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 $660,000, including fringe benefits The salespeople will also be paid commissions of 10 of sales Travel and entertainment expenses are expected to total about $330,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 $160,000 per year To make up for the promotions that the independent sales agents had been running on behalf of Johnson, management believes that the companys budget for fixed advertising expenses should be increased by $440,000 Required 1 Assuming sales of $33,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 17 (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 ) b The independent sales agents' commission rate increases to 19 (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 ) 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 ) 2 Calculate Johnson 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 17 (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 19 (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 $33,000,000 and the company continues to sell through agents (at a 19 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 Johnson Corporation sells through agents (at a 19 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 $ (Click to select) 1 Variable expenses (Click to select) Click to select) Total variable expense (Click to select) Fixed expenses Click to select) (Click to select) (Click to select) (Click to select) Total fixed expenses (Click to select)

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 28, 2024

Johnson Corporation manufactures disposable thermometers that are sold to hospitals through a network of independent sales agents located in the United States and Canada. These

Johnson 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 Johnson's disposable thermometer. The sales agents are currently paid an 17% commission on sales, and this commission rate was used when Marston's management prepared the following budgeted absorption income statement for the upcoming year.

Johnson Corporation Budgeted Income Statement
Sales			$	33,000,000
Cost of goods sold:
Variable	$	17,400,000
Fixed		2,740,000		20,140,000

Gross margin				12,860,000
Selling and administrative expenses:
Commissions		5,610,000
Fixed advertising expense		700,000
Fixed administrative expense		3,300,000		9,610,000

Net operating income			$	3,250,000

Since the completion of the above statement, Johnsons management has learned that the independent sales agents are demanding an increase in the commission rate to 19% 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, Johnsons management has decided to investigate the possibility of hiring its own sales staff to replace the independent sales agents.

Johnson'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 $660,000, including fringe benefits. The salespeople will also be paid commissions of 10% of sales. Travel and entertainment expenses are expected to total about $330,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 $160,000 per year. To make up for the promotions that the independent sales agents had been running on behalf of Johnson, management believes that the companys budget for fixed advertising expenses should be increased by $440,000.

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

The independent sales agents' commission rate remains unchanged at 17%. (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.)

The independent sales agents' commission rate increases to 19%. (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.)

image text in transcribed

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.)

2.	Calculate Johnson 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 17%. (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 19%. (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

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 $33,000,000 and the company continues to sell through agents (at a 19% 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

Determine the volume of sales at which net operating income would be equal regardless of whether Johnson Corporation sells through agents (at a 19% 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

(Click to select) 1% Variable expenses: (Click to select) Click to select) Total variable expense (Click to select) Fixed expenses: Click to select) (Click to select) (Click to select) (Click to select) Total fixed expenses (Click to select)