Assignment:
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.
Question 1. How could this owner reasonably estimate and identity (a) the average economic profit and (b) the economic profit of each customer?
Question 2. What should he use for a cost of capital charge (and why)?
Question 3. What would he need to do to set up the Excel worksheet?