Arsung Ltd produces and sells the AS mobile phone with three models in the range, the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Arsung Ltd produces and sells the AS mobile phone with three models in the range, the AS10, AS20 and the AS30. In the UK Apsung Ltd sells via its own stores located in all major cities as well as to the electronics superstore CPW World. To encourage CPW World to stock the phones a substantial trade discount has been agreed. In addition, Apsung Ltd sells the phones directly to customers online of which 70% of these sales relate to the UK with the remainder sold overseas. The latest income statements for Apsung Ltd are detailed below. AS10 AS20 Total AS30 £'000 1.158 1,222 25 32 1279 (121) 382 000.3 £'000 2.895 905 £'000 Sales Revenue 1.737 530 5.790 2,657 75 Variable Manufacturing Costs Trade Discounts Salesforce commission costs Total costs 25 15 25 570 1.167 185 25 955 1.940 302 72 2.804 2.986 869 232 Contribution Fixed manufacturing costs Sales and marketing costs Administration costs Net Income 185 1.700 982 1,638 (503) Apsung Ltd want to understand the profitability of their products when sold via the different routes to market, particularly as the AS30 has a negative contribution and have provided the following information relating to sales: i) The company's own stores account for 50% of the total sales revenue and these are split between the AS10, AS20 and AS30 in the proportions 3:5:2. CPW World are a growing source of income and now account for 20% of the total sales revenue. They sell £115,800 of the AS30 and sales of the AS10 are double this amount. The balance of their sales relate to the AS20. ii) ii) The online UK sales have the same breakdown by product as seen in their own stores. iv) The balance of sales by product relates to the online overseas customers. In addition: v) vi) The price of each type of product is the same for all customers. Variable costs can be allocated to products in the same percentage per product as shown in the income statement. vii) Trade discounts are only given to CPW World. viii) Sales commission is 1.25% of selling price. ix) Fixed manufacturing costs should be allocated to customers based on sales value of each product. Sales and marketing costs as well as administration costs should be allocated to Home Stores, CPW World, UK online and Overseas online in the proportion 3:2:2:1. x) 4 (continued) Required: a) Prepare a detailed customer profitability analysis for Apsung Ltd by customer group. (14 marks) b) Analyse the results provided for Apsung Ltd as well as your own results calculated in part a). Include any advice that you think might be important for Apsung Ltd to (6 marks) ww mw consider. Arsung Ltd produces and sells the AS mobile phone with three models in the range, the AS10, AS20 and the AS30. In the UK Apsung Ltd sells via its own stores located in all major cities as well as to the electronics superstore CPW World. To encourage CPW World to stock the phones a substantial trade discount has been agreed. In addition, Apsung Ltd sells the phones directly to customers online of which 70% of these sales relate to the UK with the remainder sold overseas. The latest income statements for Apsung Ltd are detailed below. AS10 AS20 Total AS30 £'000 1.158 1,222 25 32 1279 (121) 382 000.3 £'000 2.895 905 £'000 Sales Revenue 1.737 530 5.790 2,657 75 Variable Manufacturing Costs Trade Discounts Salesforce commission costs Total costs 25 15 25 570 1.167 185 25 955 1.940 302 72 2.804 2.986 869 232 Contribution Fixed manufacturing costs Sales and marketing costs Administration costs Net Income 185 1.700 982 1,638 (503) Apsung Ltd want to understand the profitability of their products when sold via the different routes to market, particularly as the AS30 has a negative contribution and have provided the following information relating to sales: i) The company's own stores account for 50% of the total sales revenue and these are split between the AS10, AS20 and AS30 in the proportions 3:5:2. CPW World are a growing source of income and now account for 20% of the total sales revenue. They sell £115,800 of the AS30 and sales of the AS10 are double this amount. The balance of their sales relate to the AS20. ii) ii) The online UK sales have the same breakdown by product as seen in their own stores. iv) The balance of sales by product relates to the online overseas customers. In addition: v) vi) The price of each type of product is the same for all customers. Variable costs can be allocated to products in the same percentage per product as shown in the income statement. vii) Trade discounts are only given to CPW World. viii) Sales commission is 1.25% of selling price. ix) Fixed manufacturing costs should be allocated to customers based on sales value of each product. Sales and marketing costs as well as administration costs should be allocated to Home Stores, CPW World, UK online and Overseas online in the proportion 3:2:2:1. x) 4 (continued) Required: a) Prepare a detailed customer profitability analysis for Apsung Ltd by customer group. (14 marks) b) Analyse the results provided for Apsung Ltd as well as your own results calculated in part a). Include any advice that you think might be important for Apsung Ltd to (6 marks) ww mw consider.
Expert Answer:
Answer rating: 100% (QA)
4 in 000 Apsung Ltd Customer Profitability Analysis a Home CPW UK Overseas Total World 1158 Stores O... View the full answer
Related Book For
Accounting Business Reporting for Decision Making
ISBN: 9780730302414
4th edition
Authors: Jacqueline Birt, Keryn Chalmers, Albie Brooks, Suzanne Byrne, Judy Oliver
Posted Date:
Students also viewed these accounting questions
-
Apsung Ltd produces and sells the AS mobile phone with three models in the range, the AS10, AS20 and the AS30. In the UK Apsung Ltd sells via its own stores located in all major cities as well as to...
-
The Burnaby Division of Columbia Ltd. produces and sells component parts. Its variable costs per unit are $80 for directmaterials, $32 for direct labour and $18 for variable factory overhead. It...
-
Comparative income statements for Thesaurus Inc. are as follows: Required The president and management believe that the company performed better in 2010 than it did in 2009. Write the presidents...
-
A Classifier is initialized with a list of values separated by increasing numbers, serving as the "boundaries" of the keys. I need hep with a Classifier class that will allow us to have "key-value...
-
Compare and contrast the behavior of the capital gains-inclusive saving rate since 1985 with those of the NIPA and Flow of Funds Accounts (FFA) personal saving rates over that same period.
-
What should be the goal of a manager who is faced with a limited-resource decision?
-
Consider the Gallo strategic decision. Describe how you would go about evaluating that decision.
-
Buckeye Manufacturing produces heads for engines used in the manufacture of trucks. The production line is highly complex, and it measures 900 feet in length. Two types of engine heads are produced...
-
Describe Edgar F. Codd's accomplishments and contributions to the relational model.?
-
What size loan must we take today with a 6% compound interest rate to have end-of-year payments of $1400, $1320, $1240, $1160, and $1080 for the next five years, respectively? In other words, if you...
-
12. The graph below shows relationship between body size and surface area to volume ratio of three animal species A, B, and C found in the same habitat. Surface area to volume ratio a) i) Which of...
-
How have economic and social changes affected work-life balance? Discuss how the pandemic has influenced a shift in work-life balance.
-
1. a. You were hired as a consultant to Giambono Company, whose target capital structure is 40% debt, 15% preferred, and 45% common equity. The after-tax cost of debt is 6.00%, the cost of preferred...
-
How have economic and social changes affected work-life balance? Discuss how the pandemic has influenced a shift in work-life balance.
-
A loan is being repaid with installments of $2000 at the end of each quarter for 10 years at 4.3% convertible quarterly. Find the amount of principal in the 10th instalment. ANSWER = $
-
What is the output of the following program? #include using namespace std; int main() { int n = 1; while (n
-
If a business firm refuses to comply with an agency request to inspect facilities or business records, the agency may resort to the use of a subpoena. Group of answer choices True False
-
A genetically engineered strain of Escherichia coli (E. coli) is used to synthesize human insulin for people suffering from type I diabetes mellitus. In the following simplified reaction scheme,...
-
The historical cost nature of the annual report is seen as being a limitation of financial accounting information. What do you think are the advantages and disadvantages of using historical costs?...
-
Investment decisions are made by managers in all types of business entities. Describe the common features of investments that must be taken into consideration for any investment decision making...
-
What is a chart of accounts and explain its role in the budgeting process?
-
In a recent study of how mice negotiate turns, the mice ran around a circular 90 turn on a track with a radius of 0.15 m. The maximum speed measured for a mouse (mass = 18.5 g) running around this...
-
It is well known that runners run more slowly around a curved track than a straight one. One hypothesis to explain this is that the total force from the track on a runners feet the magnitude of the...
-
You are driving your car through a roundabout that has a radius of 9.0 m. Your physics textbook is lying on the seat next to you. What is the fastest speed at which you can go around the curve...
Study smarter with the SolutionInn App