Prepare a customer profitability analysis ranking the firms

Assignment Help Managerial Accounting
Reference no: EM13832324

Argos Ltd manufactures a product called the jumbuck and it sells it to various merchandising firms such as The Jumbuck Place (JP), The House Of Jumbucks (HOJ), Jumbucks For Us(JFU),Super Jumbucks(SJ), Mega Jumbucks(MJ) and Aussie Jumbucks(AJ). The list price of the jumbuck is $55 and the full manufacturing cost to make a jumbuck is $32. Salespeople receive a commission based on the number of orders written not on sales revenue generated or number of units sold. Salespeople receive a commission of $22 per order written.

Argos makes products based on anticipated demand. It carries an inventory of jumbucks so that rush orders do not result in any increase in the manufacturing cost. Argos ships finished product to the customer at no additional charge to the customer for either a regular or an expedited delivery.

Argos has considerably higher costs for expedited deliveries than for regular deliveries. Customers occasionally return shipments to Argos and these returns are subtracted from gross revenue. Customers are not charged a restocking fee for returns.

Expected and actual customer level cost driver rates are :
Order taking(excluding sales commission)                 $25 per order
Product handling                                                 $2 per unit
Delivery                                                             $0.40 per mile driven
Expedited (rush) delivery                                      $300 per shipments
Restocking                                                         $80 per returned shipment
Visits to customers                                              $125 per customer


Because salespeople are paid $22 per written order they frequently break up their larger orders received into multiple smaller orders.


Information about Argos Ltd's clients are :

                                                                     JP         HOJ        JFU         SJ           MJ             AJ
Total number of units purchased                          250       550        320         130        450          1200
Number of orders received                                     3         15          3             4            5               15  
Number of actual orders written                              6         15         8             7           20              30  
Number of kilometres driven for deliveries               420       620        470         280          806           900
Number of units returned                                      20         35         0             0           40             60
Number of returned shipments                                2          1           0             0           2                 6 
Number of expedited deliveries                               0           6          0             0            2                5

Required:

(a) Calculate the customer level operating profit for each of the above merchandising firms based on the actual number of orders written.

(b) Prepare a customer profitability analysis ranking the firms from most to least profitable showing the level of net operating profit, revenue and revenue/profit by percentage.

(c) Recalculate the customer level operating profit based on the number of actual orders received,assuming that sales commission will also be based on this number of orders received.

Discuss the differences between the profit for the various firms and those for the firms in part (a) when actual orders written was used.

(d) Discuss what should be done to improve the profitability of the firms .Here suggestions of improvements need to cover both the more profitable and less profitable firms.

(e) Accountants are required to follow APES110 Code of Ethics for Accountants.Section 100.5 sets out the five fundamental principles to be followed by professional accountants in Australia.List these five fundamental principles and discuss whether any ethical principles have been breached by the salespeople and if any have been breached state which principle has been breached and why.

Reference no: EM13832324

Questions Cloud

When an idea is presented in a way that is original : When an idea is presented in a way that is original
Analyze and discuss the costs and benefits : Analyze and discuss the costs and benefits, if there are any, of corporations taking social responsibilities and making such disclosure in the context of efficiency and opportunistic perspectives of PAT.
The finish of patsy barnes : The Finish of Patsy Barnes
Discuss the ethical dilemma faced by john smith : How would Pharma Inc.'s case make it to the United States Supreme Court. In other words, what does it take for the United States Supreme Court to hear Pharma Inc.'s appeal. Discuss the ethical dilemma faced by John Smith. What are his competing i..
Prepare a customer profitability analysis ranking the firms : Calculate the customer level operating profit for each of the above merchandising firms based on the actual number of orders written.
Explain what were some of the credit risks that arose : What were some of the credit risks that arose from the 2008 financial crisis. How were banks affected by the credit risks. How were individuals and businesses affected by the credit risks
Evaluate the board''s philosophy on executive compensation : Evaluate the board's philosophy on executive compensation. Discuss the metrics tied to the CEO's inventive compensation. Are they sound metrics or not. Determine if compensation is reasonable considering the company's financial performance.
Evaluate varying interpretations of developmental models : Analyze the impact of culture on attachment and cognitive and moral reasoning developmental models. Evaluate varying interpretations of developmental models across cultures
Construct a histogram and a frequency polygon : 1. Construct a histogram and a frequency polygon for the following data.

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Type of costing system

Describe the costs and processes involved in making your firm's product or providing their service, and state what type of costing system might be used (job order, process or hybrid costing)

  Manufacturing overhead flexible budget - assembly department

Derek Company prepares financial statements annually. During the year, the following selected transactions occurred.

  Prepare a flowchart using job order cost system

Knox Company begins operations on January Because all work is done to customer specifications, the company decides to use a job order cost system.

  Prepare the adjusting entries on january 31

Performed services for patients who had dental plan insurance. At January 31, $750 of such services was earned but not yet billed to the insurance companies.

  Elements of management accounting

Critically evaluate the social, cultural or political implications of either the planning, controlling or decision making elements of management accounting.

  Decision analysis - complete uncertainty

What action should (s)he select if (s)he followed the criterion of Maximin and Maximax

  What is the materials inventory

Boone Company has the following balances as of December 31, 2009. Material Inventory $15,000 Work in process inventory $36,200 Finished goods inventory $50,100.

  Prepare a merchandise purchases budget for april

Prepare a Merchandise Purchases Budget for April, May and June, prepare a Cash Budgets for April, May and June and prepare a Budgeted Income Statement for the Quarter.

  Prepare the journal entry for green company

Prepare the journal entry for Green Company and assume that the exchange lacked commercial substance. Prepare the journal entry for Ice Mountain Company.

  Fastenalt is an industrial supply manufacturer that

fastenalt is an industrial supply manufacturer that provides hvac specialty thermostats to manufacturers and retailers.

  Compute the irr use interpolation

Compute the net cash inflow anticipated from the sale of the device for each of the 12 years - determine the NPV of the proposed investment.

  Vulcan flyovers offers scenic overflights of mount st

vulcan flyovers offers scenic overflights of mount st. helens the volcano in washington state that explosively erupted

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