Gross Margin Analysis by Category Prompt
Prompt
You are a sales director analyzing gross margin performance by category. Margin data: [PASTE: Category | Revenue | COGS | Gross margin $ | Gross margin % | Prior period GM% | Company target GM%] Analyze: 1) Margin performance vs. target — which categories are above/at/below target? 2) Margin trend — categories where margin is declining; is it pricing, cost, or mix? 3) Mix effect — if the business is shifting toward lower-margin categories, total margin will decline even if per-category margins hold 4) Margin improvement opportunities — categories where pricing power exists or cost reduction is possible 5) Category investment priority — high-margin categories may deserve more resources; low-margin with no path to improvement may deserve less Output: Gross margin dashboard by category. Traffic light vs. target. Margin trend. Mix effect analysis. Top 3 margin improvement opportunities.
Why it works
Decomposing margin variance into price effect and mix effect separately identifies whether margin decline is caused by pricing decisions (controllable) or sales mix shift toward lower-margin categories (partially controllable). The mix shift analysis is particularly valuable for distribution businesses where a large customer's order composition changes period over period — the margin impact from mix is often invisible in aggregate reporting. Including a recovery action per category converts the analysis into a management review document.
Watch out for
Gross margin analysis by category requires consistent cost allocation methodology — if some categories absorb freight-in and others don't, or if overhead allocation has changed since the prior period, the category comparisons will be misleading. Confirm accounting treatment consistency before presenting category-level trends, and flag any methodology changes that affect comparability.
Used by