Recalculate the customer level operating profit

Assignment Help Managerial Accounting
Reference no: EM13837567

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                5Required:

(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: EM13837567

Questions Cloud

Problem regarding the expected returns of portfolio : 1. You own a portfolio invested 12.35% in Stock A, 12.21% in Stock B, 12.87% in Stock C, and the remainder in Stock D. The betas of these four stocks are 1.49, 0.74, 0.58, and 1.45. What is the portfolio beta?
Write an individual essay paper on ehrs : The student will write an Individual essay paper on EHRs: include history, implementation challenges and benefits. (3-4 pages double spaced due at the beginning of session 8).EHR: Electronic Health Record
What was the nature of foreign trade : What was the nature of foreign trade during 300 bc & 300ad?
Ways in which companies are using information gleaned : Summarize, in your own words, the different ways in which companies are using information gleaned from the internet to acquire customers, develop customers, and retain customers
Recalculate the customer level operating profit : Calculate the customer level operating profit for each of the above merchandising firms based on the actual number of orders written - Prepare a customer profitability analysis ranking the firms from most to least profitable showing the level of ne..
Identify the concepts you found to be most interesting : Describe other lessons you have learned in this course or topics in which you have developed an interest. Identify the concepts you found to be most interesting.
The role of secularization in the global financial crisis : The Role of Secularization in the Global Financial Crisis of 2007-2010
Describe the firm and explain why you chose it : Explain the way in which it excels in the category you have associated it with and how that has contributed to its success. Provide examples from your research and experience.
Find the laplace transform of the function : Find the Laplace transform of the function obtained and find the inverse Laplace transform of the function - Find the value of the integral

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Determine the activity rate for each activity

Determine the activity rate for each activity and determine the total and per-unit activity cost for all three products.

  Literature review and the methodology

Evaluate and use quantitative and qualitative information to measure financial and non financial performance of an organisation

  Part 1yummy-pop ltd makes lollipops in two sizes large and

part 1yummy-pop ltd makes lollipops in two sizes large and giant. the company sells these lollipops to convenience

  What is balance in finished goods inventory account

Gest Inc. has provided the following data for the month of November. The balance in the Finished Goods inventory account at the beginning of the month was $54,000 and at the end of the month was $40,400.

  Explain the theory of constraints

Identify the bottlenecks in Mick's production process and suggest how they might be overcome to meet the customers' requirements.

  Manufacturing plc must implement a manufacturing process

Goliath manufacturing plc must implement a manufacturing process that reduces the amount of toxic by-products. Two processes have been identified that provide the same amount of toxic product reduction. The first process would incur £205,000 in..

  Mbai 6691 i need to slove it in 2 hours it is a mab

i need to slove it in 2 hours. it is a mab management accounting questions.please help me with

  Choose an item that you would like to manufacture you do

choose an item that you would like to manufacture. you do not actually need to manufacture something but will proceed

  Managerial accounting

Managerial accounting.. a) focuses primarily on reporting to regulatory agencies

  Budget constraints in two period model

Explain how the budget constraint of househould in two-period model is affected by each of the following changes. In each case, do you think the household is better off or worst off or is the answer ambiguous?

  What is the companys contribution margin ratio

At a volume off 15,000 units, a company's reported sales revenues of $600,000, variable costs of $225,000 and fixed costs of $120,000. What is the company's contribution margin ratio?

  Old guard-materials budget-reason for ending inventory

Each gallon of Old Guard, a popular aftershave lotion, requires 3 ounces of ocean scent. Budgeted production of Old Guard for the first three quarters of 2013 is:

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