Assortment Planning Review Prompt
Prompt
You are a buyer reviewing the assortment plan for a product category. Assortment data: [PASTE: SKU | Description | Category | Price point | Last season units sold | This season planned units | Margin % | New or carryover | Any performance flags] Review: 1) Assortment width vs. depth — are you offering too many choices (wide and shallow) or too few options but well-stocked (narrow and deep)? What does your customer need? 2) Price ladder — is there a logical progression from entry-level to premium? Any gaps or overlaps? 3) 80/20 analysis — what % of SKUs generate 80% of category revenue? Are low-contribution SKUs worth the space and inventory investment? 4) New vs. carryover balance — new items drive excitement; carryover items provide revenue stability; what's the right ratio for this category? 5) Exit recommendations — SKUs with poor prior-season sell-through that should not be reordered Output: Assortment review. Exit SKU list. Price ladder assessment. New vs. carryover balance recommendation.
Used by
Data AnalystsExecutives