Ellie Mosk, CEO of X-Space Industries, decided to expand the company's product offering beyond the core...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Ellie Mosk, CEO of X-Space Industries, decided to expand the company's product offering beyond the core model rocket business. 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 $ 492,000 276,000 93,600 178,000 $ 1,039,600 Visit Customer Revenue Gross Profit Days Modifications Phone Minutes Electronic Communications A $ 406,000 $ 156,000 15 15 1,190 625 B C BUDE 506,000 206,000 25 15 1,280 875 606,000 236,000 40 40 1,530 1,160 D 1,160,000 426,000 90 60 1,880 2,160 E 1,560,000 596,000 100 70 2,280 2,410 Totals $4,238,000 $1,620,000 270 200 8,160 7,230 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. Required 1 Required 2 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. (Round your intermediate calculations and final answers to 2 decimal places. For percentages .1234 = 12.34%.) Share of Support Costs Based on Revenue Profit After Support Profit % Costs Customer Gross Profit A $ 156,000 B 206,000 C 236,000 D 426,000 E $ 596,000 Totals $ 1,620,000 $ 0.00 S % % % ABC Customer A Gross Profit ABC Costs Net Profit After Support Costs Net Profit % $ 156,000 % B 206,000 % 236,000 % % D 426,000 % % E $ 596,000 % 0.00 Totals $ 1,620,000 $ 0.00 $ 69 0.00 Ellie Mosk, CEO of X-Space Industries, decided to expand the company's product offering beyond the core model rocket business. 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 $ 492,000 276,000 93,600 178,000 $ 1,039,600 Visit Customer Revenue Gross Profit Days Modifications Phone Minutes Electronic Communications A $ 406,000 $ 156,000 15 15 1,190 625 B C BUDE 506,000 206,000 25 15 1,280 875 606,000 236,000 40 40 1,530 1,160 D 1,160,000 426,000 90 60 1,880 2,160 E 1,560,000 596,000 100 70 2,280 2,410 Totals $4,238,000 $1,620,000 270 200 8,160 7,230 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. Required 1 Required 2 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. (Round your intermediate calculations and final answers to 2 decimal places. For percentages .1234 = 12.34%.) Share of Support Costs Based on Revenue Profit After Support Profit % Costs Customer Gross Profit A $ 156,000 B 206,000 C 236,000 D 426,000 E $ 596,000 Totals $ 1,620,000 $ 0.00 S % % % ABC Customer A Gross Profit ABC Costs Net Profit After Support Costs Net Profit % $ 156,000 % B 206,000 % 236,000 % % D 426,000 % % E $ 596,000 % 0.00 Totals $ 1,620,000 $ 0.00 $ 69 0.00
Expert 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...
-
Googles ease of use and superior search results have propelled the search engine to its num- ber one status, ousting the early dominance of competitors such as WebCrawler and Infos- eek. Even later...
-
Hansel Electronics has the following: If Hansel has 7,000 units on hand at December 31, the cost of ending inventory under the average-cost method is: (a) $84,000. (b) $70,000. (c) $56,000. (d)...
-
Waterbury Hall, a university residence hall for men, is operated under the supervision of Mr. Kelly. The residence has three floors, each of which is divided into four sections. This coming fall Mr....
-
Two concentric, spherical, conducting shells have radii R 2 > R 1 and charges q 2 and q 1 . The volume between the shells is filled with a linear dielectric with permittivity = 0 . Determine the...
-
Defendants Jack and Claire Lein owned and lived on Willow Creek Farm from 1980 through 2004. The farm manager, Stewart, and his girlfriend, plaintiff Tambra Curtis, also lived on the farm during this...
-
Environ Company has determined that its new fireplace screen would gain widespread customer acceptance if the company could price it at or under $90. Anticipated labor hours and costs for each unit...
-
2. 16 points] Now consider a different system, +10x=u, where u is a "control input" that we can choose to make a behave the way we want. (a) What u would you choose so that r eventually ends up at...
-
Which of the following statements about firms value creation is not correct? A The value created by a firm can benefit all stakeholders. B Firms that create value make profits. C The value created...
-
For the following REDOX reaction, state the oxidation number for each element in the reaction. State which element is being oxidized and which element is being reduced, as well as how you know. State...
-
Common stock with a total par value of $80,000 is issued at a total of $110,000. The $30,000 excess above the par value should be recorded as a CREDIT to which account?
-
Clausewitz used this term to describe those assets key to an enemy's ability to survive and carry out warfare. A successful belligerent can attack and seize or destroy these assets. Examples of such...
-
What are the ecological implications of trophic interactions and food chain dynamics for ecosystem services provisioning, including the regulation of pest populations, pollination services, nutrient...
-
Explain the difference between statutory law, common law, and business law. ?
-
You are hoping to buy a house in the future and recently received an inheritance of $18,000. You inheritance of $18,000. You intend to use your inheritance as a down payment on your house. a. If you...
-
What is taxable income, and what is the formula for determining taxable income?
-
A project developed in PL/1 is expected to take 30 months. Assuming the same ratios as those shown in the table below, compare the duration, level of effort, and software size between a project...
-
What is the difference between tabular output and zoned output?
-
Develop a questionnaire for mass employee distribution based on your findings from the previous interviews. Why are we completing the analysis with an anonymous survey?
Study smarter with the SolutionInn App