Question 10 [CPA; product profitability] (Source: L-S,T,S & H, 2015) The costs of customer support and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Question 10 [CPA; product profitability] (Source: L-S,T,S & H, 2015) The costs of customer support and selling activities for each customer group are as follows: Нome Educational Business entertainment Waratah Ltd manufactures electronic devices, including PDAS, MP3 and MP4 players, for home and business use. Three years ago, it implemented an activity-based costing system. Both the management accountants and the Selling $28 000 $25 750 $28 000 manufacturing managers are very pleased with the results, as they now have accurate product costing information expenses that they can use for a variety of decisions. However, the ABC system focuses only on product design and manufacturing costs. The activity-based costs of Waratah's major products are as follows: Customer 86 000 49 750 86 500 support Activity PDA Basic PDA+ PDA/Phone Required: 1 Construct two Excel® spreadsheets to calculate: Designing $100 $110 $125 Purchasing (a) Profitability of each product line. 150 95 130 (b)Profitability of each customer group. Assembling 890 1200 1400 2 What can you conclude from your analysis in requirement 1? Finishing 260 250 250 3 Would you recommend dropping the loss-making products or customers? Explain your answer. Total activity cost $1400 $1655 $1905 4 Use your spreadsheet to answer the following questions: In July, Hannah Allen, the assistant accountant, noticed that over the last six months the spending in both the Customer Support Department and the Sales Department had been steadily increasing. The previous month's costs (a) If the selling price of the PDA Basic decreased to $1600, and customer support for the PDA+ reduced to $80 000, which had been 20 per cent above budget! The customer support supervisor, Bill Dominico, is able to explain exactly why product would be the most profitable? this is happening. He has had to employ new staff, there is more overtime being worked, and some of the service (b)If sales of the PDA/Phone to business customers increased to 40 and the selling price of the PDA/Phone increased to $3200, which customer group would be the most profitable? calls have been outsourced to a third-party maintenance company. But all this was necessary, as he explains: If a customer has a problem, we have to fix it! And if we have spent more than our budget, then that is just too bad. It is important to keep customers happy. Why, only the other day the managing director was telling us how important our customers are and how customer satisfaction is critical to the company's success. Hannah asks Bill if she can have access to the records of his department for the past three months (June quarter). She intends to analyse the service calls to see exactly where the extra money is being spent. She also plans to analyse the selling expenses that have occurred during June quarter. The analysis reveals the following data: • The cost of selling and customer support activities, and selling price for each product, are as follows: PDA Basic PDA+ PDA/Phone Activities: Selling $39 000 $33 750 $ 9000 Customer support 78 300 123 750 20 200 Selling price per unit 2000 2600 2800 The company's customers can be analysed into three main groups: educational institutions, business and home entertainment. The sales to these groups during the June quarter are detailed below: Customer groups PDA Basic PDA+ PDA/Phone Educational institutions 150 40 5 Business 20 30 30 Home entertainment 130 80 Total sales 300 150 40 Question 10 [CPA; product profitability] (Source: L-S,T,S & H, 2015) The costs of customer support and selling activities for each customer group are as follows: Нome Educational Business entertainment Waratah Ltd manufactures electronic devices, including PDAS, MP3 and MP4 players, for home and business use. Three years ago, it implemented an activity-based costing system. Both the management accountants and the Selling $28 000 $25 750 $28 000 manufacturing managers are very pleased with the results, as they now have accurate product costing information expenses that they can use for a variety of decisions. However, the ABC system focuses only on product design and manufacturing costs. The activity-based costs of Waratah's major products are as follows: Customer 86 000 49 750 86 500 support Activity PDA Basic PDA+ PDA/Phone Required: 1 Construct two Excel® spreadsheets to calculate: Designing $100 $110 $125 Purchasing (a) Profitability of each product line. 150 95 130 (b)Profitability of each customer group. Assembling 890 1200 1400 2 What can you conclude from your analysis in requirement 1? Finishing 260 250 250 3 Would you recommend dropping the loss-making products or customers? Explain your answer. Total activity cost $1400 $1655 $1905 4 Use your spreadsheet to answer the following questions: In July, Hannah Allen, the assistant accountant, noticed that over the last six months the spending in both the Customer Support Department and the Sales Department had been steadily increasing. The previous month's costs (a) If the selling price of the PDA Basic decreased to $1600, and customer support for the PDA+ reduced to $80 000, which had been 20 per cent above budget! The customer support supervisor, Bill Dominico, is able to explain exactly why product would be the most profitable? this is happening. He has had to employ new staff, there is more overtime being worked, and some of the service (b)If sales of the PDA/Phone to business customers increased to 40 and the selling price of the PDA/Phone increased to $3200, which customer group would be the most profitable? calls have been outsourced to a third-party maintenance company. But all this was necessary, as he explains: If a customer has a problem, we have to fix it! And if we have spent more than our budget, then that is just too bad. It is important to keep customers happy. Why, only the other day the managing director was telling us how important our customers are and how customer satisfaction is critical to the company's success. Hannah asks Bill if she can have access to the records of his department for the past three months (June quarter). She intends to analyse the service calls to see exactly where the extra money is being spent. She also plans to analyse the selling expenses that have occurred during June quarter. The analysis reveals the following data: • The cost of selling and customer support activities, and selling price for each product, are as follows: PDA Basic PDA+ PDA/Phone Activities: Selling $39 000 $33 750 $ 9000 Customer support 78 300 123 750 20 200 Selling price per unit 2000 2600 2800 The company's customers can be analysed into three main groups: educational institutions, business and home entertainment. The sales to these groups during the June quarter are detailed below: Customer groups PDA Basic PDA+ PDA/Phone Educational institutions 150 40 5 Business 20 30 30 Home entertainment 130 80 Total sales 300 150 40
Expert Answer:
Answer rating: 100% (QA)
1 Statement of profitability based on product Particulars PDA basic PDA PDA phone Sales units a Educational institutions 150 40 5 b Business 20 30 30 ... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
? Hi-Tek Manufacturing, Inc., makes two types of industrial component parts-the B300 and the T500. An absorption costing income statement for the most recent period is shown: Hi-Tek Manufacturing...
-
Manton Corporation uses an activity based costing system to assign overhead costs to products. In the first stage, two overhead costsequipment expense and indirect laborare allocated to the three...
-
ABC Ltd entered into an agreement to borrow 500 000 from Fistral plc, a UK affiliate on 1 July 2019. Fistral plc transferred the loan money to ABC Ltds Australian bank account on the contract day....
-
The Commerce Department reported that in December 2015, retail sales rose by 0.2, net exports decreased, inventories held by businesses rose by 0.1 percent, and total sales by businesses fell by 0.6...
-
You tried to pass the salt and pepper shakers to your friend at the other end of a table of height 0.850 m by sliding them across the table. They both slid off the table, with velocities of 5.00 m/s...
-
What are the reasons that explain why international firms would enter foreign markets?
-
As a customer, think back to a recent sales presentation that you felt went well. What made it good? What did the salesperson do (or not do) that most impressed you? Did you buy the product or...
-
The balance sheet of Aqua, Inc., a world leader in the design and sale of telescopic equipment, reported the following information on its balance sheets for 2018 and 2017 (figures are in thousands):...
-
Admitting New Partners Who Buy an Interest and Contribute Assets The capital accounts of Trent Henry and Tim Chou have balances of $117,500 and $84,800, respectively. LeAnne Gilbert and Becky Clarke...
-
In Intuit QuickBooks how do I record this transaction?... Wrote check number 10010 to City Credit Union for payment of amount due (City Credit Union in the Account/Category field); $110.35.
-
The president of a medium size software company is determined to keep the hierarchy at a minimum number of levels. Will this affect the organizations ability to control activities? What do you...
-
Answer the following questions for the network in Figure 1 assuming the valley-free export-all routing policy. AS 39 AS 36 AS 33 AS 69 AS 66 AS 666 AS 99 AS 96 1 AS 93 1.2.10/23 1.2.8/21 Figure 1:...
-
Consider a database with these tables, INGREDIENT and DISTRIBUTOR: DIST_ID DIST NAME Sundown Ranch 1 2 Wright Bakery 3 Harry's Produce ING_ID 2 3 4 5 ING NAME Beef Cheese Roll Onion Lettuce DIST_ID 1...
-
Supposed that each of the following Update operations is applied directly to the database state shown in the Figure 3.6. Discuss all integrity constraints violated by each operation, if any, and the...
-
You are to create and cost a Front of House roster for the months of October to December. This will require you to: Determine your staffing requirements Create timelines and the roster for the...
-
Let's assume the inductor of the buck converter has an equivalent series inductance of R1, the diode forward voltage drop is Vf, and the load resistance is R with other devices being ideal. 1. Derive...
-
Product I's inventory is managed according to the (Q,R) model. The safety stock for Product I is 120. The lead time for replenishing Product I's inventory is 3 weeks, and the weekly demand for...
-
Calculate the change in entropy when 100 kJ of energy is transferred reversibly and isothermally as heat to a large block of copper at (i) 0 C, (ii) 50 C.
-
Grimes Grocery operates a chain of convenience stores in the Northwest. As a result of a recent consultants visit, the company is in the beginning stages of implementing an activity-based costing...
-
Garrett Boone, Farish Enterprises' vice president of operations, needs to replace an automatic lathe on the production line. The model he is considering has a sales price of $285,000 and will last...
-
Furr Fabricators produces protective covers for smart phones. Since the covers must be customized to each smart phone model, Furr uses ajob order costing system. On September 1, the company reported...
-
Test for misspecification using RESET.
-
a. Show that the mean-squared forecast error \(E\left[\left(\hat{y}_{T+1}-y_{T+1} ight)^{2} \mid I_{T} ight]\) for a forecast \(\hat{y}_{T+1}\), that depends only on past information \(I_{T}\), can...
-
Consider the AR(1) model \(y_{t}=\delta+\theta y_{t-1}+e_{t}\) where \(|\theta|)=0\) and \(\operatorname{var}\left(e_{t} \mid I_{t-1} ight)=\sigma^{2}\). Let \(\bar{y}_{-1}=\sum_{t=2}^{T} y_{t}...
Study smarter with the SolutionInn App