Purchase Solution

# Customer Economic Profitability

Not what you're looking for?

I'm looking for guidance on how to estimate customer economic profitability for a business that is not yet tracking costs or expenses to the activity level.

Here's the problem and questions:

A small business owner has 1,000 customers in his customer base. The owner wants to identify "profitable" and "unprofitable" customers in order to improve business performance. However, the business only tracks general expenses related to the acquisition and support of each customer. The owner has asked how he might be able to reasonably estimate the economic profitability of each one of his 1,000 customers. He needs to set up an Excel worksheet to help him quickly complete this task for each customer in the customer base.

1. How could this owner reasonably estimate and identity (a) the average economic profit and (b) the economic profit of each customer?

2. What should he use for a cost of capital charge (and why)?

3. What would he need to do to set up the Excel worksheet?

Thank you.

##### Solution Summary

The expert estimates customer economic profitability for a business.

##### Solution Preview

Please see the attachment for proper formatting.

A small business owner has 1,000 customers in his customer base. The owner wants to identify "profitable" and "unprofitable" customers in order to improve business performance. However, the business only tracks general expenses related to the acquisition and support of each customer. The owner has asked how he might be able to reasonably estimate the economic profitability of each one of his 1,000 customers. He needs to set up an Excel worksheet to help him quickly complete this task for each customer in the customer base.

1. How could this owner reasonably estimate and identity (a) the average economic profit and (b) the economic profit of each customer?

The average economic profit is the difference between the average revenue charged per customer and the ...

Solution provided by:
###### Education
• B. Sc., University of Nigeria
• M. Sc., London South Bank University
###### Recent Feedback
• "Thank you."
• "thank you Chidi Ngene.. if you have any APA references would be great"
• "Thank you so much for your help, your explanations were easy to understand and apply!"
• "are you able to highlight the equations used either on the xlsx or a word doc as to how each graph was formed- overall looks fine i just need help understanding this myself"
• "Chidi Ngene, M. Sc. Was extremely helpful as without the help and guidance I would have failed, but with the help I passed. I still have a lot to learn and in need of the guidance to understand and learn more on the subject. I would recommend Chidi Ngene and BrainMass to anyone that are in need of help. Thank you!!"

##### Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

##### Basics of corporate finance

These questions will test you on your knowledge of finance.