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

  What is the economic order quantity

What should be the reorder point to have a 95 percent service level? Explain how the system will operate. What is the economic order quantity?

  How many books does borders expect to sell at a discount

The marginal production cost for the publisher is $1 per book. How much profit does the publisher make given Borders actions?

  Columbias management feels that the time value

Columbia's management feels that the time value of money should be considered in all long-term decisions. Briefly discuss the rationale that underlies management's belief.

  Compute the cost per equivalent unit for materials

Compute the cost per equivalent unit for materials, for labor, for overhead, and in total.

  Flexible budget amounts of fixed and variable costs

If the company actually produces 20,000 units, what are the flexible budget amounts of fixed and variable costs?

  The value of each cost element

Chelsea Household Renovations (CHR) is a rapidly growing company that has not been profitable despite increases in sales.

  Occupy mall street

Occupy Mall Street

  Prepare a detailed cost of production report

Prepare a detailed cost of production report. Use the FIFO method. Distinguish between normal and abnormal spoilage.

  Forging department-cost per equivalent units

The following information concerns production in the Forging Department for June. All direct materials are placed into the process at the beginning of production, and conversion costs are incurred evenly throughout the process. The beginning inven..

  As a manager part of your role is to develop strategy and

as a manager part of your role is to develop strategy and share this strategy with various stakeholders within the

  Calculate inventory turnover and days sales in inventory

Calculate inventory turnover and days sales in inventory. Is Safeway performing better or worse than last year?Why?

  Roehler industrial has estimated that production

In Exercise 10-8, Roehler Industrial has estimated that production for the next five quarters will be:Production Information

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