AquaSports sells two types of Kayak - the River Runner and the Sea Force. The following...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
AquaSports sells two types of Kayak - the River Runner and the Sea Force. The following data has been provided: Cost per unit Markup Rebate* Customer-level information Water Adventures Sea Level Sports Lake Touring Bay Boating Serious Fishing River Runner $500 40% 15% Sales units by customer River Runner Sea Force 2,000 220 Sea Force $950 70% 10% 450 120 760 3,550 1,700 80 290 95 210 2,375 Order & dispatch $750 Number of orders 25 10 25 45 40 145 Exchange handling $650 Number of exchanges 30 45 70 75 230 450 Complimentary Customisations $90 a) Calculate profitability by customer showing detail line-by-line (25 marks) b) Create a customer ranking table (10 marks) Number of customisations 650 20 5 90 300 1,065 *If a customer purchases more than 500 units of a product in any year, they receive the rebate stated above on total purchases of that product for the full year. Required: c) Create some useful tables and visualisations of your data (25 marks) d) With reference to your analyses and other factors, provide advice to management (25 marks) e) Explain the importance of customer profitability analysis (5 marks) f) The company believes if the rebates are increased for River Runner and Sea Force to 20% and 15% respectively, that total sales volumes will increase by 10% from the customers presently entitled to the rebates. Do you recommend this move? Explain with calculations (10 marks) AquaSports sells two types of Kayak - the River Runner and the Sea Force. The following data has been provided: Cost per unit Markup Rebate* Customer-level information Water Adventures Sea Level Sports Lake Touring Bay Boating Serious Fishing River Runner $500 40% 15% Sales units by customer River Runner Sea Force 2,000 220 Sea Force $950 70% 10% 450 120 760 3,550 1,700 80 290 95 210 2,375 Order & dispatch $750 Number of orders 25 10 25 45 40 145 Exchange handling $650 Number of exchanges 30 45 70 75 230 450 Complimentary Customisations $90 a) Calculate profitability by customer showing detail line-by-line (25 marks) b) Create a customer ranking table (10 marks) Number of customisations 650 20 5 90 300 1,065 *If a customer purchases more than 500 units of a product in any year, they receive the rebate stated above on total purchases of that product for the full year. Required: c) Create some useful tables and visualisations of your data (25 marks) d) With reference to your analyses and other factors, provide advice to management (25 marks) e) Explain the importance of customer profitability analysis (5 marks) f) The company believes if the rebates are increased for River Runner and Sea Force to 20% and 15% respectively, that total sales volumes will increase by 10% from the customers presently entitled to the rebates. Do you recommend this move? Explain with calculations (10 marks)
Expert Answer:
Answer rating: 100% (QA)
This image contains text with numerical data and a set of required tasks relating to customer profitability analysis for a company named AquaSports which sells two types of Kayaks the River Runner and ... View the full answer
Related Book For
Accounting Principles Part 1
ISBN: 978-1118306789
6th Canadian edition
Authors: Jerry J. Weygandt, Donald E. Kieso, Paul D. Kimmel, Barbara Trenholm, Valerie Kinnear, Joan E. Barlow
Posted Date:
Students also viewed these accounting questions
-
The following data has been provided by Lee Company regarding its inventory purchases and sales throughout the year. Required: Compute the cost of goods sold and ending inventory using the perpetual...
-
The following data has been provided by Lee Company regarding its inventory purchases and sales throughout the year. Required: Compute the cost of goods sold and ending inventory using the perpetual...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Display the TERM_DESC, COURSE_NAME, BLDG_CODE and ROOM for every course evertaught by faculty member John Blanchard. Question 2 Display the S_LAST, S_FIRST, COURSE_NAME, TERM_DESC and GRADE values...
-
(a) Show that the flow velocity measured by a century meter (see Fig. 10.30) is given by the relation (b) A venturi tube is measuring the flow of water; it has a main diameter of 3.0cm tapering down...
-
A movable bracket is held at rest by a cable attached at E and by frictionless rollers. Knowing that the width of post FG is slightly less than the distance between the rollers, determine the force...
-
Pier 1 Imports recently reported the following stockholders' equity (adapted and in millions except par value per share): Suppose Pier 1 split its common stock 2 for 1 in order to decrease the market...
-
The stockholders' equity section of Warm Ways Inc.'s balance sheet at January 1, 2017, shows: Preferred stock, $100 par value, 10% dividend, 50,000 shares issued and...
-
(1 point) Suppose that f(x, y, z) = xyz xyz is a function of three variables. 1. Find the gradient of f(x, y, z). Answer: Vf(x, y, z) = - 2. Evaluate the gradient at the point P(2, -2, -1). Answer:...
-
Ivey Company prepared the following budgeted income statement for the first quarter of 2016: Ivey Company is considering two options. Option 1 is to increase advertising by $ 1,000 per month. Option...
-
Accenture Ltd prepares Financial Statements to 30 September each year. During the year ended 30 September 2020, Accenture (which has a number of subsidiaries) engaged in the following transactions:...
-
Identify and describe in detail the requirements for Acme Toys Inc. Make sure that you include the different requirements for workstations and servers. Identify the requirements an OS and...
-
Please detail the following and be specific. Each section should be around a few paragraphs, Effectiveness of fiscal and monetary policies. How effective is the tax and expenditure policies (fiscal...
-
1.0 m 3 /s of wastewater contains 20 mg/L of ammonium ion (as N; NH4 -N). It is necessary to nitrify the ammonium to nitrate (NO3 - ) a. How many kilograms per day (kg/d) of the ammonium (as N) must...
-
Two of the most common data integrity issues are the creation of duplicate medical records and the creation of overlays, or the mixing of two medical records. Identify and describe three data...
-
Magnesium stearate and lactose are excipients commonly used in tablet formulation. The measured contact angles of water or of a saturated aqueous solution on the surfaces of compacts of these two...
-
ICON Candies is a three store retailer of freshly boxed chocolate candies serving the greater NYC metropolitan area. ICON orders it chocolate candies directly from a candy maker in Belgium and has a...
-
The following processes constitute the air-standard Diesel cycle: 12: isentropic compression,23: constant-volume energy addition (T and P increase),34: constant-pressure energy addition (v...
-
Dartmouth Games reported the following information for a three-year period: ____________________ _2014 2013 2012 Ending inventory ..$ 20,000$ 30,000..$ 34,000 Sales... 125,000.128,000...115,000 Cost...
-
Explain the differences between the format of a T account and the standard form of accounts. In your explanation, include the benefits of each format, and when each format is typically used.
-
In the ice cream shop, all employees make change out of the same cash register drawer. Is this a violation of internal control? Why or why not?
-
The pendulum has a mass of \(7.5 \mathrm{~kg}\) with center of mass at \(G\) and has a radius of gyration about the pivot \(O\) of \(295 \mathrm{~mm}\). If the pendulum is released from rest at...
-
A metal hoop with a radius \(r=6\) in. is released from rest on the \(20^{\circ}\) incline. If the coefficients of static and kinetic friction are \(\mu_{s}=0.15\) and \(\mu_{k}=0.12\), determine the...
-
The \(\operatorname{drum} A\) is given a constant angular acceleration \(\alpha_{0}\) of \(3 \mathrm{rad} / \mathrm{s}^{2}\) and causes the 70-kg spool \(B\) to roll on the horizontal surface by...
Study smarter with the SolutionInn App