Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PLEASE ANSWER ALL QUESTIONS IN EXCEL INCLUDING GRAPH (Question 5) AND MEMO (Question 6) (also please show a picture of the excel calculations to get

PLEASE ANSWER ALL QUESTIONS IN EXCEL INCLUDING GRAPH (Question 5) AND MEMO (Question 6) (also please show a picture of the excel calculations to get your answers !!!!!

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.

Below is Marston Corporation budgeted income statement

Sales 30,000,000
Cost of goods sold:
Variable 17,400,000
Fixed 2,800,000 20,200,000
Gross Margin 9,800,000
Selling and administrative expenses:
Commissions 5,400,000
Fixed advertising expense 800,000
Fixed administrative expense 3,200,000 9,400,000
Net operating income 400,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 $700,000, including fringe benefits. The salespeople will also be paid commissions of 10% of sales. Travel and entertainment expenses are expected to total about $400,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 $200,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 $500,000.

Answer the following:

1. Assuming sales of $30,000,000, construct a budgeted contribution format income statement (like above) for the upcoming year for each of the following alternatives:

The independent sales agents' commission rate remains unchanged at 18%.

The independent sales agents' commission rate increases to 20%.

The company employs its own sales force.

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

The independent sales agents' commission rate remains unchanged at 18%.

The independent sales agents' commission rate increases to 20%.

The company employs its own sales force.

3. Refer to your answer to (1.b.) above. If the company employs its own sales force, what volume of sales (Sales) would be necessary to generate the net operating income the company would realize if sales are $30,000,000 and the company continues to sell through agents (at a 20% commission rate) (Net Operating Income From (1.b.)?

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.

5. Prepare a graph on which you plot the profits for both of the following alternatives.

The independent sales agents' commission rate increases to 20%.

The company employs its own sales force.

On the graph, use total sales revenue as the measure of activity.

6. Write a memo to the president of Marston Corporation in which you make a recommendation as to whether the company should continue to use independent sales agents (at a 20% commission rate) or employ its own sales force. Fully explain the reasons for your recommendation in the memo.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Customer Satisfaction Audit

Authors: Abram I Bluestein, Michael Moriarty, Ronald J Sanderson

1st Edition

190243398X, 978-1902433981

More Books

Students also viewed these Accounting questions

Question

How autonomous should the target be left after the merger deal?

Answered: 1 week ago