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 customer profitability analysis.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Topic Video
Question
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.
Transcribed Image Text: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.
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
Cost Driver
Total Cost
$ 479,000
267,000
Sales visits
Sales visit days
Product modifications
Number of modifications
Phone calls
Number of minutes
92,700
169,000
$ 1,007,700
E-mail/electronic communications
Number of communications
Visit
Phone
Electronic
Customer
Revenue
Gross Profit
Days
Modifications
Minutes
Communications
$ 393,000
493,000
593,000
1,070,000
1,430,000
$ 143,000
193,000
223,000
413,000
583,000
1,100
1,190
1,440
1,790
2,190
А
15
15
625
В
25
15
875
C
40
40
1,070
2,070
90
60
100
70
2,320
Totals
$3,979,000
$1,555,000
270
200
7,710
6,960
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 Cost Driver Total Cost $ 479,000 267,000 Sales visits Sales visit days Product modifications Number of modifications Phone calls Number of minutes 92,700 169,000 $ 1,007,700 E-mail/electronic communications Number of communications Visit Phone Electronic Customer Revenue Gross Profit Days Modifications Minutes Communications $ 393,000 493,000 593,000 1,070,000 1,430,000 $ 143,000 193,000 223,000 413,000 583,000 1,100 1,190 1,440 1,790 2,190 А 15 15 625 В 25 15 875 C 40 40 1,070 2,070 90 60 100 70 2,320 Totals $3,979,000 $1,555,000 270 200 7,710 6,960
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 4 images

Blurred answer
Knowledge Booster
Costing Systems
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education