Profitability Analysis Assignment | Top Universities

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.

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

Data were collected to support an analysis of customer profitability: Activity Sales visits Cost Driver Total Cost Sales visit days Number of modifications Number of minutes 484,000 262,000 92,200 $ Product modifications Phone calls E-mail/electronic communications Number of communications 164,000 $1,002,200 Visit Electronic Communications 625 Phone Gross Profit Modifications Minutes Customer Days Revenue 398,000 498,000 598,000 1,020,000 148,000 198,000 228,000 418,000 15 15 1,050 1,140 A 25 15 875 1,390 1,740 2,140 1,020 2,020 2,270 4C 40 90 60 F 1,480,000 588,000 100 70 $3,994,000 $1,580,000 270 200 7,460 6,810 Totals 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. 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 Complete this question by entering your answers in the tabs below. 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.) Share of Support Costs Based on Profit After Customer Gross Profit Profit % Support Costs Revenue 148,000 A $ B 198,000 % C 228,000 % 418,000 % % 588,000 $ 1,580,000 $ 0.00 0.00 Totals Required 2 Required 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. Complete this question by entering your answers in the tabs below. Required 1 Required 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. (Round your intermediate calculations and final answers to 2 decimal places.) Net Profit After Support Costs Gross Profit ABC Costs Customer Net Profit % A 148,000 % B 198,000 % C 228,000 % 418,000 % $ 588,000 E 1,580,000 $ 0.00 0.00 Totals Required 1 Required 2. Get Accounting homework help today

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works

Here is how simple it is to make use of our essay writing services

step 1

Submit a "write my essay for me" request

Fill out a quick order form and provide detailed requirements as to the paper, its format, etc. You can even attach screenshots or add additional instructions later. If something has to be clarified or added, the writer will contact you directly.
Pro service tips
How to get the most out of your experience with Homework Writing Services
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Religious studies
Excellent response.
Customer 460547, April 20th, 2022
English 101
Thank You!
Customer 454425, June 21st, 2020
English 101
Good job
Customer 454209, June 2nd, 2020
Business and administrative studies
Good calculations
Customer 462327, June 28th, 2022
ENG 111
looks very good
Customer 464369, June 25th, 2023
Political science
Great work thank you
Customer 453983, February 4th, 2020
Military
Excellent work
Customer 456821, June 22nd, 2022
Finance/Acc Related
Well answered.
Customer 460073, April 29th, 2022
Social Work and Human Services
Thanks
Customer 463783, October 21st, 2023
SEO
Well-written and well-researched content. Followed the instructions to the letter. Good job mate!!
Customer 463679, April 27th, 2023
Leadership Studies
Writer was very patient and completed on time
Customer 452707, October 4th, 2022
History
Great!
Customer 453413, February 27th, 2020
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend
OUR GIFT TO YOU
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat