PLEASE ANSWER IN DETAIL THANK YOU!

E19-26. 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:

Required Prepare a customer profitability profile like the one in Exhibit 19.3. Customer Profitability Profile If a company knows the amount of profits (or losses) generated by each of its customers, a customer profitability profile can be prepared similar to the one illustrated in Exhibit 19.3. This hypothetical company has 350 customers and has current total profits of $5 million, but only 200 of its customers are profitable. Cumulative profits reach $7.5 million when the 200 th customer is added to the graph, but the 201st through the 350th customers cause cumulative profits to decline to $5 million because they are unprofitable. Once a company has profitability data on each of its customers (or categories of customers), only then can it proceed to try to convert them to profitability, or seek to terminate the relationship with those customers. Just as we saw that ABC provided a model for producing more accurate product cost data, ABC is also a valuable tool for generating customer profitability data