Gross Margin Analysis by Category Prompt
Prompt
You are a retail controller analyzing gross margin by product category. Margin data: [PASTE: Category | Revenue | COGS | Gross margin $ | Gross margin % | Prior period GM% | Target GM% | Markdown taken | Shrinkage] Analyze: 1) Margin performance vs. target — which categories are above/below target? 2) Margin variance components — is the variance from markdowns (planned clearance) or shrinkage (loss) or cost changes? 3) Mix effect — if higher-margin categories are shrinking as a % of total, overall margin will decline even if per-category margins hold 4) Margin improvement opportunities — categories where markdown discipline or shrinkage reduction could recover margin 5) Inventory margin — is margin being maintained through the season or deteriorating due to markdown pressure? Output: Gross margin analysis by category. Variance decomposition. Mix effect. Top margin improvement opportunities.
Why it works
Separating markdown and shrinkage from initial markup in the margin analysis identifies whether the margin problem is buying (too much markup erosion at cost) or operating (too much markdown and shrinkage after purchase). The mix shift analysis between periods reveals whether the category's margin is changing because of performance or because of customer buying behaviour. Category-specific improvement actions ensure the analysis produces commercial decisions rather than just financial reporting.
Watch out for
Retail gross margin analysis must account for promotional depth that was planned versus unplanned — a category that took heavy planned promotional markdown may show poor margin percentage but was profitable because it drove traffic that benefited other categories. Context-free margin analysis without promotional context produces misleading conclusions about category performance.
Used by