✏️Prompts

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