AI Skill Report Card
Planning Fresh Product Categories
YAML--- name: planning-fresh-product-categories description: Plans fresh product categories for supermarket operations including seafood, meat, produce, and bakery sections. Use when developing category strategies, optimizing product mix, or restructuring fresh departments. ---
Fresh Product Category Planning
Quick Start15 / 15
Category Planning Template:
Category: [Seafood/Meat/Produce/Bakery/Dairy]
Target Revenue: ¥[amount]/month
Space Allocation: [sqm]
SKU Count: [number]
Profit Margin Target: [%]
Key Suppliers: [3-5 main suppliers]
Seasonal Adjustments: [Q1/Q2/Q3/Q4 variations]
Recommendation▾
Add one more concrete input/output example showing a poor planning outcome to demonstrate what NOT to do
Workflow15 / 15
Progress:
- Market analysis and competitor benchmarking
- Sales data review (last 12 months)
- Customer demand assessment
- Supplier capacity evaluation
- Space and equipment requirements
- Pricing strategy development
- Staffing and training needs
- Implementation timeline
- KPI setting and monitoring plan
Detailed Process
-
Data Collection
- Analyze previous 12 months sales by subcategory
- Review customer traffic patterns and peak hours
- Benchmark competitor offerings within 3km radius
-
Category Prioritization
- Rank categories by: Revenue potential, Profit margin, Customer frequency, Operational complexity
- Apply 80/20 rule: Focus on top-performing subcategories
-
Space Planning
- Allocate floor space based on revenue per sqm
- Plan cold storage and display requirements
- Consider customer flow and cross-merchandising opportunities
-
Supplier Strategy
- Identify 3-5 primary suppliers per category
- Negotiate volume discounts and delivery schedules
- Establish quality standards and return policies
Recommendation▾
Include specific KPI targets and benchmarks (e.g., 'Target 15+ inventory turns annually for produce, 8+ for seafood')
Examples18 / 20
Example 1: Seafood Category Input: Planning seafood section for 200sqm store Output:
- Live seafood: 30% space, ¥80k/month target
- Fresh fish: 45% space, ¥120k/month target
- Frozen seafood: 25% space, ¥40k/month target
- Key suppliers: Local fish market (60%), Frozen distributor (40%)
- Peak seasons: Chinese New Year (+150%), Summer (+30%)
Example 2: Produce Category Input: Optimizing vegetable section profitability Output:
- Leafy greens: 40% space, 25% margin, daily delivery
- Root vegetables: 30% space, 35% margin, 3-day cycle
- Seasonal fruits: 30% space, 20% margin, varies by season
- Organic premium line: 15% price premium, 10% space allocation
Recommendation▾
Provide a quick decision framework or scoring matrix for category prioritization rather than just listing factors
Best Practices
- Seasonal Planning: Adjust category mix quarterly based on Chinese festivals and weather patterns
- Local Sourcing: Prioritize local suppliers for produce (shorter supply chain, higher freshness)
- Cross-Category Synergy: Place complementary items nearby (tomatoes near basil, fish near lemon)
- Quality Standards: Implement strict freshness rotation (FIFO) and quality checkpoints
- Price Positioning: Maintain 3-tier pricing (economy/standard/premium) across categories
Common Pitfalls
- Over-SKU-ing: Too many similar products confuse customers and increase waste
- Ignoring Local Taste: Not adapting to regional preferences and cooking habits
- Poor Cold Chain: Inadequate temperature control leading to quality loss and complaints
- Seasonal Miscalculation: Overstocking before holidays or understocking during peak demand
- Supplier Over-Dependence: Relying on single suppliers creates supply risk
- Space Inefficiency: Allocating premium space to low-margin or slow-moving items