“We love our customers!” Every business owner says it. But all customers aren’t created equal, and it’s in your strategic interest to know which customers are really strengthening your bottom line and by how much.
Sorting out the data
If your business systems track individual customer purchases, and your accounting system has good cost accounting or decision support capabilities, determining individual customer profitability will be simple. If you have cost data for individual products, but not at the customer level, you can manually “marry” product-specific purchase history with the cost data to determine individual customer value.
For example, if a customer purchased 10 units of Product 1 and five units of Product 2 last year, and Product 1 had a margin of $100 and Product 2 had a margin of $500, the total margin generated by the customer would be $3,500. Be sure to include data from enough years to even out normal fluctuations in purchases.