Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Customer Profitability Analysis Leahy, Inc.has 10 customers that account for all of its $1,472,000 of net income. Its activity-based costing system is able to assign

Customer Profitability Analysis Leahy, Inc.has 10 customers that account for all of its $1,472,000 of net income. Its activity-based costing system is able to assign all costs, except for $200,000 of general administrative costs, to key activities incurred in connection with serving its customers. A customer profitability analysis based on activity costing produced the following customer profits and losses:

Customer #1 $ 350,000
#2 262,000
#3 (75,000)
#4 240,000
#5 50,000
#6 375,000
#7 (100,000)
#8 325,000
#9 225,000
#10 (180,000)
Total $ 1,472,000

Prepare a customer profitability profile like the one in Exhibit 18.3. The following link includes an Excel worksheet to create the profitability profile graph: profitability_profile_template.

Using the customer profitability analysis provided in the exercise to calculate the following profits. (i) Calculate the total profits from the 3 most profitable customers $Answer (ii) Calculate the total profits for the 4 most profitable customers $Answer $(iii) Calculate the total profits for the 6 most profitable customers $Answer (iv) Calculate the total profits for the 8 most profitable customers $Answer

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Accounting

Authors: Debra C. Jeter, Paul K. Chaney

7th edition

1119373204, 9781119373254 , 978-1119373209

More Books

Students also viewed these Accounting questions

Question

1. Why do we trust one type of information more than another?

Answered: 1 week ago