Question
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,
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started