Prompt Details
Model
(gemini-3.6-flash)
Token size
743
Example input
[ASSORTMENT_AND_PERFORMANCE]: DTC women's capsule launch: 12 proposed styles; prior 8-week data shows strong sell-through for black knit tops and straight trousers, weak returns-adjusted performance for satin skirts, $18,000 open-to-buy, supplier minimum 40 units per style; margin estimates range 58-66%.
[CUSTOMER_AND_CHANNEL]: Urban professionals ages 28-42 buying through a mobile-first Shopify store; strongest traffic comes from email and organic search; customers frequently request petite lengths.
[CALENDAR_AND_CONSTRAINTS]: Six-week autumn launch window, 5-week replenishment lead time, limited warehouse space for 1,200 units, no markdown event planned before week 8.
[DECISION_OBJECTIVE]: Select the launch assortment and opening quantities while protecting cash and testing petite demand.
Example output
Executive Decision
Recommendation: Execute a focused 6-style capsule launch (down from 12 proposed), prioritizing proven Core demand (black knit tops, straight trousers) while running a controlled, capped Test on petite sizing and new tops. Re-allocate cash away from high-risk categories (satin skirts).
Decision Horizon: 6-week autumn launch window (re-evaluation at Week 2 to allow for the 5-week lead time).
Confidence Level: Medium (High on proven categories/operating limits; Low on individual unproven style metrics and exact pricing).
Input Audit
Evidence (Fact-based / Supplied Data)
OTB & Budget: Total Open-to-Buy is $18,000.
Supplier Minimums: 40 units per style minimum order quantity (MOQ).
Warehouse Capacity: Maximum capacity capped at 1,200 total units.
Financial Margin Range: Estimated product gross margin is 58% to 66%.
Historical Performance (Prior 8 Weeks):
Strong sell-through: Black knit tops, straight trousers.
Weak performance (returns-adjusted): Satin skirts.
Customer Profile: Urban professionals ages 28–42; high demand for petite lengths (frequently requested via feedback).
Channel & Traffic: Mobile-first Shopify store; top traffic drivers are Email and Organic Search.
Operating Constraints: 6-week launch window, 5-week lead time for replenishment, zero markdown events planned prior to Week 8.
Assumptions (Logical Inferences Required to Model)
Average Unit Cost (AUC): Assuming an average retail price range of $80–$140 and gross margins of 58–66%, estimated AUC ranges between $30.00 and $55.00. (A 600-unit opening buy at an average $30 AUC fully utilizes the $18,000 OTB).
Petite Demand: Frequent customer requests translate to viable conversion rates when petite inventory is made available.
Traffic Conversion: Organic and email traffic will maintain historical conversion baselines for core categories during the autumn window.
Gaps (Missing Data Points)
Style Breakdown: Names, costs, prices, and visual distinctions for all 12 proposed individual styles are unstated.
Returns Rates: Exact return percentage for satin skirts is unstated (only noted as "weak returns-adjusted performance").
Historical Velocity: Exact unit sales speed (units/week) for black knits and straight trousers is unstated.
Contradictions & Sensitivity Handling
Margin Variance (58% vs. 66%):
Affected Decision: Total purchasing power under the $18,000 OTB limit.
Handling: Base assortment planning uses the conservative 58% margin (higher unit cost assumptions) to avoid exceeding cash constraints. A 66% margin scenario is treated as a upside cash buffer.
Candidate Scorecard
Note: Since specific SKUs were not named, the 12 proposed styles are categorized based on historical category signals into 4 representative candidate groups.
Candidate Category / Style Group Demand Signal Margin Contribution Inventory Exposure Customer Fit Channel Fit Calendar Relevance Confidence Classification
1. Proven Black Knit Tops (2–3 Styles) 5/5 4/5 2/5 5/5 5/5 5/5 High Core
2. Proven Straight Trousers (2–3 Styles) 5/5 4/5 2/5 5/5 4/5 5/5 High Core
3. Petite Length Adaptation (1–2 Styles) 3/5 4/5 3/5 5/5 4/5 4/5 Medium Test
4. Satin Skirts / Bottoms (1–2 Styles) 1/5 3/5 5/5 2/5 3/5 3/5 High Exit
5. Proposed Novelty/Unproven Styles (Remaining Proposed) Unknown Unknown 4/5 Unknown Unknown Unknown Low Insufficient Evidence
Scoring & Evidence Justification
Black Knit Tops: Strong 8-week sell-through + high relevance for urban fall wardrobe → Core.
Straight Trousers: Strong 8-week sell-through + core wardrobe staple → Core.
Petite Length Adaptation: High direct feedback/request volume, but no prior sales data → Test (Capped quantity).
Satin Skirts: Weak returns-adjusted performance + no planned markdowns in 6-week window creates severe margin drag → Exit.
Unproven Styles: Zero historical data or category alignment provided in brief → Insufficient Evidence (Do not launch).
Risk Register
Likelihood Impact Trigger Event Mitigation Action Owner
High High 5-week lead time prevents stockouts if initial 2-week demand surges. Set aside $3,000–$4,000 OTB reserve for rapid week-2 reorder on top Core SKU only. Merchandise Planner
Medium High Petite length test fails to convert, tying up capital with supplier MOQs (40 units min). Limit test to 1 core trouser style in petite sizing (40 units max). Category Buyer
Medium Medium Mobile UX friction degrades conversion on complex fit items (trousers). Emphasize precise visual sizing charts and clear return policies on Shopify mobile product pages. Digital/E-Com Lead
High High Over-buying 12 styles violates the $18,000 OTB or 1,200-unit warehouse cap. Trim launch from 12 styles to 5–6 styles; enforce minimum units per style. Logistics / Inventory Lead
Protected Case (Margin & Cash Defense)
Strategy: Maximize cash preservation, eliminate markdown risk, and strictly adhere to proven category demand.
Assortment Plan (5 Styles Total):
Keep (Core): 2 Black Knit Top styles (100 units each = 200 units)
Keep (Core): 2 Straight Trouser styles (100 units each = 200 units)
Test: 1 Straight Trouser in Petite sizing (MOQ capped = 40 units)
Reduce/Exit: 0 Satin Skirts; 0 Unproven Styles.
Total Volume: 440 Units (36.6% of warehouse capacity).
Estimated Capital Commitment: ~$13,200 at ~$30 AUC (Leaving ~$4,800 cash buffer in OTB).
Allocation Logic: Protects $4,800 in reserve. Avoids stockouts on core styles while fulfilling supplier MOQs and testing petite conversion without over-committing.
Growth Case (Controlled Risk & Upside Capture)
Strategy: Capture broader market share by expanding options within proven silhouettes and testing petite options across two categories.
Assortment Plan (7 Styles Total):
Keep (Core): 3 Black Knit Top styles (110 units each = 330 units)
Keep (Core): 2 Straight Trouser styles (110 units each = 220 units)
Test: 1 Petite Trouser (50 units) + 1 Petite Knit Top (50 units)
Reduce/Exit: Exit Satin Skirts.
Total Volume: 650 Units (54.1% of warehouse capacity).
Estimated Capital Commitment: ~$17,550 at ~$27–$30 AUC (Fully utilizes ~$18,000 OTB).
Allocation Logic: Pushes volume into top-performing drivers while broadening the Petite validation test. Still stays far below the 1,200-unit warehouse limit.
Trade-off Comparison
Dimension Protected Case Growth Case
Upside Potential Moderate (Relies entirely on core replenishment velocity). Higher (Captures broader top/bottom wardrobe bundles + petite market).
Cash Exposure Low ($13,200 committed; $4,800 cash reserve retained). High (~$17,550 committed; minimal reserve).
Reversibility Highly Reversible (Low unit count; reserve cash allows mid-season pivot). Low Reversibility (Capital locked into 650 units with a 5-week lead time).
Primary Failure Mode Stockout in Week 3 if core demand spikes beyond projections. Oversupply/deadstock in test categories with no markdown safety net before Week 8.
Recommended Assortment
Ranked Action Plan
1. CORE: Re-order / Launch Proven Black Knit Tops (2 Styles)
└── Commitment: 200 Units | Risk: Low | Evidence: 8-week sell-through data
2. CORE: Launch Proven Straight Trousers (2 Styles)
└── Commitment: 200 Units | Risk: Low | Evidence: 8-week sell-through data
3. TEST: Execute Capped Petite Trouser Test (1 Style)
└── Commitment: 40 Units (Supplier MOQ limit) | Risk: Medium | Evidence: Customer requests
4. EXIT: Eliminate Satin Skirts & Unproven Styles (7 Styles Removed)
└── Commitment: 0 Units | Risk: None | Evidence: Poor return-adjusted historical performance
Final Unit Commitment: 440 Units
OTB Allocation: ~$13,200 (Protected Case Execution)
Warehouse Footprint: 36.7% capacity utilized (760 units of buffer space remaining).
Validation Plan
Smallest Useful Test: 40 units of 1 Core Straight Trouser style cut in Petite length, offered exclusively to Email subscribers via a targeted pre-launch mobile campaign.
Success Threshold: ≥60% sell-through within 14 calendar days of launch.
Stop-Loss Trigger: <25% sell-through by Day 14, or a return rate exceeding 20% due to fit issues.
Review Date: End of Week 2 post-launch (Critical date: must decide by Day 14 to trigger the 5-week replenishment lead time for late-autumn delivery).
Decision Notes
The recommendation will immediately shift if any of the following parameters change:
Supplier MOQ Flexibility: If supplier MOQs drop from 40 to 20 units, the Petite test can be expanded across additional colorways without increasing total cash exposure.
Lead Time Reductions: If replenishment lead times drop from 5 weeks to 2 weeks, initial depth on Core items can be trimmed further to maximize total liquidity.
Margin Compression: If landed cost increases drive gross margins below 58%, unit counts across all categories must be scaled back proportionally to preserve the $18,000 OTB cap.
By purchasing this prompt, you agree to our terms of service
GEMINI-3.6-FLASH
Fashion assortment risk auditor for merchandisers, boutique buyers, and apparel brands. It classifies evidence, scores demand and inventory exposure, compares protected and growth scenarios, and returns traceable keep, test, reduce, or exit decisions with stop-loss checks.
...more
Added 2 weeks ago
