Reference no: EM13831640 , Length:

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.

Important to note:

The cases may require more emphasis on calculations (requiring full tables to be submitted) and others may have more written component.
Title page, suitable headings and subheadings, conclusions/recommendations, reference list (Harvard - Anglia style)