Customer Account Profitability Analysis Prompt
Prompt
You are a sales manager analyzing customer account profitability. Customer data: [PASTE: Customer | Annual revenue | COGS | Gross margin $ | Gross margin % | Freight cost | Returns cost | Deductions/chargebacks | Sales rep time estimate | Net profitability] Analyze: 1) Net profitability ranking — customers ranked by true net profit after freight, returns, deductions, and cost to serve 2) Margin erosion — customers where gross margin looks acceptable but deductions, freight, or returns are destroying net profitability 3) Cost-to-serve outliers — customers requiring disproportionate service cost (frequent small orders / high return rates / excessive deductions) 4) Unprofitable customers — any customers where net profitability is negative; quantify the loss 5) Recommended actions: renegotiate terms / add freight minimums / reduce service cost / exit relationship Output: Customer profitability table ranked by net profit. Unprofitable customer action plan. Top 5 improvements to customer mix profitability.
Why it works
Fully-loaded account profitability — including freight, returns, deductions, and sales rep time — reveals the actual commercial relationship value in a way that revenue alone misses. Net profit margin ranking sorts accounts by actual value rather than revenue, which often produces a dramatically different priority list for sales investment. The under-pricing versus over-serving diagnosis distinguishes between two different problems that require different remediation approaches.
Watch out for
Account profitability analyses that reveal large accounts as unprofitable must be acted on carefully — abrupt commercial changes to a strategic account relationship can trigger churn that is more costly than the margin improvement from remediation. Develop an improvement plan over 12-18 months that gradually improves terms or reduces service cost rather than making changes that feel sudden to the customer.
Used by