Write a well structured report to the GM Sales & Marketing.
Advanced Management Assignment
Faculty of Creative Industries & Business
Department of Accounting and Finance
Bachelor of Business
ACTY 7212 – ADVANCED MANAGEMENT ACCOUNTING, ASSESSMENT 2
Semester: Semester 2, 2015
Date issued: September, 2015
Due time and date: Submission by Week 11, 22 October 2015 by 6.00pm
Submission The assignment must be submitted with a copy of the assessment cover sheet completed and attached to the front, both:
• To the lecturer at the commencement of class on the date specified.
• Electronically via turnitin.com by the due date and time. Failure to do this will result in a zero mark. Do not submit the cover sheet or the article to turnitin.
• This is an individual assignment.
Total marks: 100 marks in total for the Assignment (Assessment 2)
Instructions: Copy and complete the cover sheet (which is attached) and attach it to the front of each submission.
The submission must be your own individual work and adhere to APA referencing requirements.
Copying or plagiarism may result in disciplinary action.
Refer to the detailed requirements for the assessment.
Objective of this assignment
The objective is to place the student in the position of a management accounting role within a business and to provide support to the General Manager of Sales and Marketing in cost analysis and in customer profitability. This is achieved through the use of information available from the public domain, combined with fictitious information, which reflects the information that would be available to a management accountant. Key parts of the assignment require analysis of the information provided, summarising and communicating to a specific audience. Some questions are open-ended to allow a variety of aspects to be investigated from the annual report and additional information. This analysis is also to be supported by academic literature to draw a link between academic theory and the practice of business. Completion of this assignment will give students an insight into skill requirements and responsibilities of a management accountant.
Methven Limited (Methven) is a New Zealand based company that operates in one industry segment, being the design and supply of shower, tapware and water control valves and has a presence in several geographical regions or segments. The company relies on continual innovation to provide leading edge products to its customers. Methven has received a number of international design awards for its innovative products.
The results for the last full financial year ended 31st March 2015, indicated that Methven had continued to recover from its difficulties following the economic downturn earlier in this decade. Total Operating Revenues remained static at approximately $96m compared to 2014. However due to operational efficiencies and marketing initiatives both EBITDA and Profit after Tax both increased by 12.4% and 20.9% respectively compared to 2014.
The geographical regions (segments) reported include New Zealand, Australia, United Kingdom (UK), and China. Australia produces 40% of total Operating Revenue, whereas New Zealand represents 33%, UK 25% and China less than 2%. All of these geographical segments except China are profitable based on their EBITDA results.
The company is optimistic about the 2015-2016 year on the basis of a new range of products being launched in to the market.
The company is listed on the New Zealand Exchange (NZX). Its share price at 31st March 2015 was $1.10 per share compared to $1.02 as at 31st March 2014.
The General Manager (GM) of Sales and Marketing, John Doherty, needs some sound management accounting advice as he provides input into the CEO’s report on areas of sales, marketing, customer profitability, cost control, improvement initiatives, risk management and opportunities for growth. It appears that 2015 – 2016 will be as challenging as the previous year. You are a recently qualified graduate, and you will be required to draw on all your management accounting knowledge to support the GM of Sales and Marketing.
John Doherty is particularly concerned with two aspects of the current business:
1. New product costs and their profitability, and
2. Customer profitability in the UK operating region (segment).
Some work has already been undertaken to better understand the costs and profitability of both of the above areas and John has provided you with the following information.
Additional fictitious information:
1. New Product Costs and Profitability (fictitious)
Methven is considering launching a new range of shower-head products (see Table 1). To date the company has conducted a lot of research and development and market research on these products and they believe that there is a market for these products across all of their geographical regions (segments). You have been able to identify the information in the following table.
Table 1: New product information
Description Product Range
Aqua Shower Fusion Silk Jet
Total manufactured Product Cost $150 $200 $250
Direct Costs % of Total manufactured Product Cost 50% 60% 65%
Mark Up applied to Product Cost for Marketing and Administration expenses 50% 50% 50%
Anticipated selling price of each product $240 $300 $350
Total Research & Development expenditure* $250,000
*The total Research and Development expenditure on these three products to date has been $250,000. This amount is currently disclosed as an Intangible Asset in Methven’s Balance Sheet.
The current costing system used across all divisions of the company is a traditional based standard costing system which applies an indirect overheard cost at the manufacturing level based on direct manufacturing costs for each product. A standard mark-up is then applied to each product cost to reflect the company Marketing and Administration Expenses. John Doherty has indicated to you that the costs for the three products should meet the anticipated selling price and earn a mark-up of 20% on total costs.
2. UK Geographical segment – customer groupings (fictitious)
Due to the current economic recession there is considerable pressure to ensure that the company manages carefully all its customers from a profitability and cash flow perspective. John Doherty has asked you to explore in more detail the profitability of the three different categories (Large, Medium and Small) of customers in the UK geographical segment. At present the company’s management accounting system is fairly coarse and focuses upon customer gross margins, while treating all selling, distribution and administrative costs as a lump sum “below the line”. John is aware that a more sophisticated costing system may reveal useful information about the profitability of the different categories of customer.
You have started a pilot exercise using Activity Based Costing (ABC) principles to examine the profitability of a typical customer chosen from each of the three categories of customer – Large, Medium and Small. The customers chosen were: Brookfields Group (large); Summerton (medium); Weymouth Bathroom Suppliers (small).Your first task was to establish the contribution margins provided by the three customers. This was relatively easy, as the data was already available in the company’s existing management accounting system. The information for the past year is summarised in Table 2:
Table 2: UK Segment Store contribution margins
Store contribution margin calculation
Brookfields Summerton Weymouth
Total revenues $1,836,000 $1,006,000 $520,000
Cost of goods sold $881,280 $492,940 $234,000
Customer gross margin $954,720 $513,060 $286,000
Customer direct costs $501,000 $253,000 $153,000
Customer contribution margin $453,720 $260,060 $133,000
In addition you have determined that the major corporate costs of $433,070 which can be associated with each customer group are; product handling, order taking, delivery, rushed delivery, managerial visits to stores, and processing obsolete stock lines (see Table 3). You have performed a detailed analysis of the activities related to these costs. The results of these for the past year are shown in Tables 3 and 4 below.
Table 3: Results of ABC Pilot Exercise
Activity Area Cost Driver Rate ($)
Product handling Number of products sold 7
Order taking Number of purchase orders 170
Delivery Number of deliveries 600
Rushed delivery Number of rush deliveries 1,100
Sales Manager visits to customers Number of sales visits 2,000
Process obsolete stock Number of products scrapped 8
Table 4: Analysis of Activities
Cost Driver Category Customer Group
Large Medium Small
Brookfields Summerton Weymouth
Number of products sold 17,800 7,550 6,000
Number of purchase orders 24 20 42
Number of deliveries 30 20 60
Number of rushed deliveries 10 10 30
Number of Manager visits to customers 5 4 10
Number of obsolete products processed 1,000 1,000 3,000
The only information you have is available through the public domain and the additional information provided for this assignment (this is fictitious information used only for the creation of this assignment). Therefore you are to limit your research, review and analysis and any report and recommendations to the information obtained through the public domain. Do not contact Methven or any persons associated with the company about this assignment.
Access and read the Methven Annual Report 2015 (from the link provided). Also review other valuable information from the company website: http://www.methven.com/nz/corporate/investor-information/financial-reports/annual-report-2015
1. Write a well structured report to the GM Sales & Marketing that clearly covers the following:
a) Identify, evaluate and provide justifications of areas of expenses or categories of costs, as defined in the financial statements and fictitious scenario, which are of concern to you including the current costing system.
b) Evaluate the results of your pilot Customer Profitability Analysis using ABC principles.
c) Review and summarise any problems and practical issues that may be faced in carrying out an ABC-based customer profitability analysis.
d) Complete an action plan outlining your recommendations of any changes or improvements you would address for any issues identified in a) and/or b) above. Present this in bullet point format, with a brief explanation of each action point.
e) Identify and discuss risks that the GM Sales and Marketing needs to consider for 2015 – 2016 that should then be discussed at Board level.
2. Identify and attach an academic or research article that support your evaluation for Question 1. a) and/or 1. b) above. From the article, prepare a maximum 200 word summary which provides the links to your evaluation in Question 1.
Maximum report length 8 pages of A4 (using Arial font 11) including tables, graphs or diagrams.
a) Identification, evaluation and justification of expenses or cost categories
which concern you. This includes any relevant calculations. 15 marks
b) Evaluation of pilot CPA 25 marks
c) Review of problems and practical issues with CPA 10 marks
d) Action plan 10 marks
e) Identification and discussion of risks for the Board 10 marks
Total Question 1 70 marks
Identification and attachment of academic article 8 marks
Discussion of links from the article 12 marks
Total Question 2 20 marks
Report format and presentation 10 marks
Total Marks 100
Marking guide considerations:
• The format is appropriate for a report.
• The report is typed, of a professional appearance, and is well laid out.
• The report has been carefully proof-read, is legible and uses clear and concise sentences and paragraphs and avoids or explains jargon.
• The report is logically organised and structured well.
• Use of diagrams, tables, charts are all appropriate.
• The report does not exceed the page limit. Use Arial, Font size 11, with single line spacing.
• Referencing is complete using APA format. Use the following library link
Responses to questions
• The requirements of each question have been met and is original work.
• An understanding of the key issues is illustrated and critical analysis is demonstrated.
• Further insight is added to the assessment by reference to other relevant readings/ articles.
Write a well structured report to the GM Sales & Marketing