Prepare budgeted income statements

Assignment Help Managerial Accounting
Reference no: EM131061231

MANAGEMENT ACCOUNTING GROUP ASSIGNMENT-

The Aussie Medical Company manufactures medical instruments. It supplies penlights, thermometers, blood pressure monitors, stethoscopes and other small medical instruments to hospitals and clinics.

Currently the company sells thermometers and a variety of other products to hospitals using a network of casual sales agents located in various centres throughout Australia. The sales agents are currently paid an 18% commission on sales and the commission rate was used when you prepared the budgeted Income Statement for the upcoming year:

                                          Aussie Medical Company Income Statement

Sales                                                                                                $30,000,000

Cost of goods sold

Variable                                                         17,400,000

Fixed                                                              2,800,000                       20,200,000

Gross Profit                                                                                         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

Operating Income                                                                                  400,000

Since the above statement the Aussie Medical Company management has learned that the independent sales agents require an increase in the commission rate to 20% of sales for the upcoming year.

Due to the increasing cost from commissions the management of the Aussie Medical Company is considering changing the way it sells its products from using external sales agents to using its own full time employees.

The proposal to change to using full time employees will mean that full times sales salaries will total $700,000 per year. These staff will also be paid commissions of 10% of sales. There will also be a sales manager and other full time support staff and their total salaries will be $200,000 per year.

Travel expenses are expected to total $400,000 per year. Fixed advertising expenses will increase by $500,000 per year.

Also the Aussie Medical Company management has asked you to examine the situation regarding their blood pressure monitors .They currently sell the machine BM110 but have developed a new blood pressure monitor BM210 and are asking for advice on when the new machine should be introduced.

The introduction of the new machine BM210 will lead to the older BM110 being virtually unsaleable as the BM210 is a far superior machine and so the management want advice about when the new machine BM210 should be released to the market. Based on the current production schedule the new machine BM210 can be sold to customers from September 1st, 2016. Currently the company has a stockpile of 150 of the old blood pressure machine BM110 which they would expect to sell in three months and they could then sell the new machine BM210 after these three months, from December 1st 2016 .The development cost and marketing and administrative costs are fixed costs which are allocated to the products on a unit basis.

Comparative income statements for the old and new blood pressure monitors show the following:

                                                                   BM110            BM210

Selling price                                                  160                 195

Variable cost per unit                                      25                    30

Development cost per unit                               70                  100

Marketing and administrative cost per unit        35                    40

Total cost per unit                                         130                   170

Operating Income per unit                              30                      25

The company has also had a request for a one off special order from government hospitals for 5,000 of their penlights. The offer states that they are prepared to pay all manufacturing costs plus a fixed fee of $1500. The company has asked that the one off special order be considered and evaluated. If the one off special order is accepted it would mean that sales to other customers would need to be reduced by the amount of the special order because currently the company is producing and selling at its maximum capacity of 20,000 units.

Currently the company sells its penlights for $6 each. Details of the unit costs are as follows

Manufacturing

Direct materials                                $1.00

Direct labour                                      1.20

Variable overhead                              0.80

Fixed overhead                                  0.50

Marketing costuld bie

Variable                                            1.50

Fixed                                                 0.90

Also the company is considering what is the minimum price it would require if it was to outsource the manufacturing of its penlights. If it was to outsource the production of its penlights it would reduce its variable marketing costs by 20% but its fixed marketing costs would continue. The fixed overhead would at 50% of its current levels.

Required:

a. Prepare Budgeted Income Statements for the two alternatives -using casual sales agents assuming they will be paid 20% commission as against having full time employees and assuming that the sales value remains unchanged from the Budgeted figures.

b. Recommend which of the two alternatives should be chosen assuming that the revenue is the same as budgeted.

c. Determine when the new blood pressure monitor BM201 should be introduced based on financial considerations.

d. What factors other than the financial factors should the company consider when deciding when to introduce the blood pressure machine?

e. Should the company accept the one off special order? Show workings and conclusion.

f. What is the maximum price an outsourcer should charge the company for the penlights? Show workings.

Reference no: EM131061231

Questions Cloud

About the free cash flow valuation : Free Cash Flow Valuation Dozier Corporation is a fast-growing supplier of office products. Analysts project the following free cash flows (FCFs) during the next 3 years, after which FCF is expected to grow at a constant 9% rate. What is Dozier's term..
Failure of lehman brothers : What was the impact of the near failure of Bear Stearns and the failure of Lehman Brothers on Money Markets? What actions did the Federal Reserve and the Treasury Department take? What were the impacts of the decisions if any?
Estimate the pressure drop per tray as pounds : If the liquid density is 50 lb/ft3 and the gas density is 0.10 lb/ft3, estimate the pressure drop per tray as pounds force per square inch.
Purpose of evaluating aspects of a company : Financial ratios are usually expressed in percentage or times. Generally, financial ratios are calculated for the purpose of evaluating aspects of a company's operations and fall into the some categories: what are those categories?
Prepare budgeted income statements : ACC202 MANAGEMENT ACCOUNTING GROUP ASSIGNMENT. Prepare Budgeted Income Statements for the two alternatives -using casual sales agents assuming they will be paid 20% commission as against having full time employees and assuming that the sales value ..
Required return equal to expected return : Nonconstant Growth Stock Valuation Simpkins Corporation does not pay any dividends because it is expanding rapidly and needs to retain all of its earnings. If the required return on the stock is 17%, what is the value of the stock today (assume the m..
What do you suggest for monahan media and why : Post the entries to T-accounts; compute the ending balance for each account - post the ending balances to Unadjusted Trial Balance columns of the worksheet.
Failure of bear stearns and failure of lehman brothers : What was the impact of the near failure of Bear Stearns and the failure of Lehman Brothers on Money Markets? What actions did the Federal Reserve and the Treasury Department take? What were the impacts of the decisions if any?
How much interest would you pay over the life of the loan : How much is the down payment? How much interest would you pay over the life of the loan? How much interest will you pay over the life of the loan?

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Liabilitiesthe following items are extracted in a random

liabilitiesthe following items are extracted in a random order from the accounting records of mst corp for the period

  Tax bases-budget financing-budget deficits

Contrast the 3 major classes of tax bases, also addressing economic bases. Examine various methods of government financing in their budget, and give a synthesis of the strengths and weaknesses of these methods, as well as their long term effects.

  Oregon adventures provides tours of scenic locations

Assume that sales for each quarter in 2012 will be 30 percent higher than they were in 2011 and the price per tour is $80.Prepare a sales budget by quarter for 2012.

  Indirect labor costs to the factory overhead account

Farina Bay's computer system generated the following trial balance on December 31, 2013.

  What is probability that radio-active seepage has occurred

If a geiger-counter measurement indicates the presence of radio-active pollution, what is the probability that radio-active seepage has occurred?

  Food and merchandise revenue

The organizers will pay several companies to operate the parking, food, and merchandise concessions. They will pay $24,000 plus 15% of all parking, food, and merchandise revenue.

  Find a newspaper article

Find a newspaper article or web page report of an item of accounting news, i.e. it refers to a current event, consideration, comment or decision that has been published after November 2013

  Simid sports-production budget

Near end of 2011, the management of Simid Sports Co., merchandising company, prepared the following estimated balance sheet for December 31, 2011: Simid Sports' single product is bought for $30 per unit and resold for $60 per unit.

  Prepare an income statement for michaels company

Prepare an income statement for Michaels Company that uses the contribution format and is segmented by divisions.

  What type of advice would you give him

What type of advice would you give him about what type of investment to make and as to whether or not to use a retirement plan?

  What would you expect to happen to the costs of cakes

In that event, what would you expect to happen to the costs of cakes - measure of complexity is the number of tiers in the cake.

  Calculate the revised material handling costs

Calculate the material handling rate that would have been used by Eloise Smith's predecessor at East Coast Marine - calculate the revised material handling costs to be allocated on a per purchase order basis.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd