A template that helps evaluate revenue by customer and SKU. This can be useful for any business with customer concentration. A consistently broader SKU base might suggest that the customer is less likely to find an alternative vendor with a similarly diversified offering.
The tab titled "Top Customer Metrics" pulls from the tab titled "Raw Data." The final tab, titled "Breaking Down the Formula," explains how the Excel formula returning revenue by SKU works.