After investigation, she decided to set up a separate division to design and manufacture products for...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
After investigation, she decided to set up a separate division to design and manufacture products for the drone market. Several companies were interested in having X-Space develop these drones, and financial results, to date, have been encouraging. Revenue was $4 million, gross margins have been running about 40%, and the customer sales and support costs were $1 million. However, there is a growing concern that some customers require a disproportionate share of the sales and support resources, and the true profitability of the customers is unknown. Data were collected to support an analysis of customer profitability: Activity Sales visits Product modifications Phone calls E-mail/electronic communications Cost Driver Sales visit days Number of modifications Number of minutes Number of communications Total Cost $ 490,000 274,000 93,400 176,000 $ 1,033,400 Phone Electronic Visit Customer Revenue Gross Profit Days Modifications Minutes Communications A $ 404,000 $ 154,000 15 15 1,170 625 B 504,000 204,000 25 15 1,260 875 C 604,000 234,000 40 40 1,510 1,140 D 1,140,000 424,000 90 60 1,860 2,140 E 1,540,000 594,000 100 70 2,260 2,390 Totals $4,192,000 $1,610,000 270 200 8,060 7,170 Required: 1. Management felt the easiest way to allocate the sales and support costs was based on the total revenue. Using total revenue as the allocation base, determine the profitability of each of the five customers. 2. Management felt that because the data revealed some customers require a disproportionate share of sales and support resources, activity-based costing should be used to determine customer profitability. Use ABC to prepare a customer profitability analysis. After investigation, she decided to set up a separate division to design and manufacture products for the drone market. Several companies were interested in having X-Space develop these drones, and financial results, to date, have been encouraging. Revenue was $4 million, gross margins have been running about 40%, and the customer sales and support costs were $1 million. However, there is a growing concern that some customers require a disproportionate share of the sales and support resources, and the true profitability of the customers is unknown. Data were collected to support an analysis of customer profitability: Activity Sales visits Product modifications Phone calls E-mail/electronic communications Cost Driver Sales visit days Number of modifications Number of minutes Number of communications Total Cost $ 490,000 274,000 93,400 176,000 $ 1,033,400 Phone Electronic Visit Customer Revenue Gross Profit Days Modifications Minutes Communications A $ 404,000 $ 154,000 15 15 1,170 625 B 504,000 204,000 25 15 1,260 875 C 604,000 234,000 40 40 1,510 1,140 D 1,140,000 424,000 90 60 1,860 2,140 E 1,540,000 594,000 100 70 2,260 2,390 Totals $4,192,000 $1,610,000 270 200 8,060 7,170 Required: 1. Management felt the easiest way to allocate the sales and support costs was based on the total revenue. Using total revenue as the allocation base, determine the profitability of each of the five customers. 2. Management felt that because the data revealed some customers require a disproportionate share of sales and support resources, activity-based costing should be used to determine customer profitability. Use ABC to prepare a customer profitability analysis.
Expert Answer:
Answer rating: 100% (QA)
ANSWER 1 Allocating Sales and Support Costs Based on Total Revenue Customer ... View the full answer
Related Book For
Cost Management A Strategic Emphasis
ISBN: 9781259917028
8th Edition
Authors: Edward Blocher, David F. Stout, Paul Juras, Steven Smith
Posted Date:
Students also viewed these accounting questions
-
Ellie Mosk, CEO of X-Space Industries, decided to expand the companys product offering beyond the core model rocket business. After investigation, she decided to set up a separate division to design...
-
Multiple Choice Questions 1. Direct materials are not usually easily traced to a product. A) True B) False 2. Product costs can be classified as one of three types: direct materials, direct labor, or...
-
In a recent year, the Federal Communications Commission reported that the mean wait for repairs for Verizon customers was 36.5 hours. In an effort to improve this service, suppose that a new repair...
-
The Industry life cycle has the following phases: introduction, growth, shakeout, maturity and de Identify an industry in Canada that you consider to be in the introduction or growth phase. Tell us...
-
Tomlinson Corporation is a biotech company based in Milpitas. It makes a cancer-treatment drug in a single processing department. Direct materials are added at the start of the process. Conversion...
-
The rectilinear motion of a particle is governed by a = 1 2 t - 6 t 2 . It starts from rest when t = 0 . Determine its velocity when it returns to its starting position.
-
2. Consider the situation where shareholders hire a CEO to manage a firm. The CEO's utility function is: u(w. e) = u(w)-v(e). where w is wage received, e is effort put in. Assume u' > 0. u" <0. v' >...
-
In a couple of paragraphs (3-4), describe your perceptions of a delivery person pulling up with a pizza you ordered. Think of your five senses (visual, auditory, smell, taste, and touch) Describe how...
-
Why was her pulse rate so high while she was supine? Why was her skin cool and clammy? If her pulse rate had been measured while she was upright, would it have been higher, lower, or the same as when...
-
What three factors influence cash flow projections? In your response, justify this through the use of examples Because these projections are important, identify two ways to maximize the accuracy of...
-
Q2. Consider the 2-period Cox-Ross-Rubinstein (CRR) binomial model with So = K = 1,T= 1, At = 0.5, = 0.2, u = 1/d = exp(oAt), and continuously compounded interest rate r = 0.05. (a) State the...
-
Have you had experience in which an improvement plan and budget items clash with traditions or common ways of doing things in the school? What happened in that circumstance?
-
What is the strongest of the five forces affecting Tesla? What is the strongest of the five forces affecting Tata motors?
-
(a) Explain why the concentration of dissolved oxygen in freshwater is an important indicator of the quality of the water. (b) How is the solubility of oxygen in water affected by increasing...
-
Is an oscillating object in translational equilibrium?
-
The cart-spring system shown in Figure 15. 19 is undergoing simple harmonic motion. (a) Is the cart's speed greater at A or at B? (b) At which of these two positions is the restoring force acting on...
-
Plot kinetic energy and potential energy as a function of time for the cart in Figure 15. 2. Data from Figure 15. 2 (a) t=0 5=0 (b) 0.09 s (c) 0.18 s x=0 E (d) 0.27 s E K U K U KU KU
Study smarter with the SolutionInn App