Category Intern - Luxury Indiluxe

Designation: Category Intern (Indiluxe)

Internship Duration: 3-4 months

Office Location: Vikhroli West, Mumbai, Maharashtra

Primary Responsibilities:

• Review roadmap
• Request data access for all needed datasets.
• Document data quality issues, missing fields.
• Create data dictionary and initial exploratory analysis
• Set up Excel environment for analysis
• Draft analysis frameworks
• Calculate basic price elasticity for major accessory categories (watches, handbags, jewelry, etc.)
• Analyze discount effectiveness (10%, 20%, 30%, 40% off)
• Calculate revenue vs. volume trade-offs
• Consumer surplus analysis - estimate willingness to pay
• Identify optimal pricing points
• Build pricing recommendation matrix by category
• Create visualizations
• Segment customers by purchase behavior (frequency, basket size, AOV)
• Identify luxury aspirants vs. established luxury buyers
• Income/spending pattern analysis across segments
• Calculate Customer Lifetime Value by segment
• Calculate Customer Acquisition Cost vs. retention costs
• Analyze repeat purchase rates by segment
• Build retention economics model
• Identify high-value segment opportunities
• Analyze brand performance: revenue, margin, units sold
• Calculate HHI for market concentration
• Contribution margin analysis by accessory type and brand
• Identify high-margin vs. high-volume products
• Cross-selling analysis: basket composition, product affinity
• Which accessories are bought together?
• Build brand portfolio matrix (Boston Consulting Group style)
• Stars, Cash Cows, Question Marks, Dogs
• Analyze seasonal patterns: Diwali, New Year, Valentine's, Raksha Bandhan, weddings
• Quantify festival impact on sales
• Build seasonal demand index by accessory category
• Forecast upcoming season demand
• Geographic analysis: Metro vs. Tier 1 vs. Tier 2 cities
• Mumbai, Delhi, Bangalore, Hyderabad, etc.
• Regional pricing and assortment recommendations
• Should strategy differ by geography?
• Integrate findings
• Identify common themes and priority actions.
• Build comprehensive recommendations with ROI estimates
• Prioritize: Quick wins vs. long-term strategies
• Create executive summary
  
  

• 4 project analysis reports with actionable recommendations
• 1 integrated strategic roadmap for Indiluxe
• Presentation deck
• Implementation playbook with prioritized actions
• Data models/templates