Insights and Recommendations — Sales Dashboard¶
Executive Summary¶
Superstore Co. is growing revenue (8% YoY) but its profit margin is thin (12.5%) and deteriorating. The root cause is a discounting problem: nearly one in five line items sells at a loss, and the entire Furniture category — a third of revenue — operates at a near-zero margin. Capping discounts and fixing the Tables sub-category alone could increase total profit by an estimated 30-45% without sacrificing meaningful revenue.
Findings¶
Finding 1 — Discounts Above 20% Destroy Profit¶
| Discount Band | Line Items | Profit | Avg Margin |
|---|---|---|---|
| No Discount | 4,798 | +$320,987 | +29.5% |
| Low (0-20%) | 3,156 | +$95,430 | +13.6% |
| Medium (20-40%) | 1,241 | −$28,765 | −10.0% |
| High (40%+) | 799 | −$101,255 | −46.1% |
The relationship is stark and clear: every line item discounted above 20% loses money on average. The 799 line items discounted 40%+ generated a combined $101k loss. The company is effectively paying these customers to take the product.
Finding 2 — Furniture is a Margin Trap¶
Furniture generates $742k in revenue (32% of total) but only $18k in profit (6% of total). Its 2.5% margin is 7× lower than Technology (17.4%) or Office Supplies (17.0%).
Drilling down, the Tables sub-category is the worst offender — it generates $207k revenue but a $17.7k loss, driven by a 26% average discount.
Finding 3 — The Central Region Underperforms¶
| Region | Revenue | Margin |
|---|---|---|
| West | $725k | 14.9% |
| East | $679k | 13.5% |
| South | $392k | 11.9% |
| Central | $501k | 7.9% |
Central has respectable revenue but the lowest margin by far. This is almost certainly a discounting discipline issue — the region is likely buying revenue with margin-destroying discounts.
Finding 4 — Revenue is Growing but Margin is Shrinking¶
Revenue is up 8% year over year, but margin dropped 1.2 percentage points. This is the classic "growth at the expense of profit" trap — the business is becoming busier but not richer.
Recommendations¶
Recommendation 1 — Cap Discounts at 20% (Highest Impact)¶
Action: Implement a hard cap of 20% on discounts. Require manager approval for anything above.
Expected impact: Eliminating the negative profit from the 20%+ discount bands would recover approximately $130k in lost profit — a 45% increase on the current $286k total. Even accounting for some lost sales (customers who only bought because of the deep discount), the net effect is strongly positive.
Effort: Low — a policy and system change, no analysis required.
Recommendation 2 — Fix or Exit the Tables Sub-Category¶
Action: The Tables sub-category loses money. Options: 1. Reprice — raise prices or cut the discount; test elasticity 2. Renegotiate supplier costs 3. Exit — if it can't be made profitable, discontinue it
Expected impact: Turning the Tables loss ($-17.7k) into even a 5% margin would swing $28k+ to the bottom line.
Recommendation 3 — Audit the Central Region's Discounting¶
Action: Investigate why Central's margin is half the company average. Compare its discount distribution to other regions. Coach the regional sales team on the discount-profit relationship.
Expected impact: Bringing Central's margin from 7.9% to the company average of 12.5% would add roughly $23k profit on its current revenue.
Recommendation 4 — Shift Sales Incentives from Revenue to Profit¶
Action: If sales reps are compensated on revenue, they're incentivised to discount. Restructure incentives to reward profit (or margin), not just top-line sales.
Expected impact: Cultural and structural — slower to take effect, but addresses the root cause of the discounting problem.
What I'd Analyse Next¶
- Customer-level profitability: are some big customers actually unprofitable due to their discount demands?
- Discount elasticity: for each discount band, how much extra volume does the discount actually drive? (Needs an experiment or historical price-change data.)
- Shipping cost impact: does Same Day shipping erode margin on certain orders?