Vitamins product pricing optimization
Data-driven pricing strategy for new vitamin product launch using Bayesian demand modeling and mixed-integer programming to optimize portfolio-wide pricing.
Key result
Revenue ↑18%
The challenge
A supplement manufacturer was launching a new sleep medication product but lacked a data-driven approach to set optimal pricing. Their traditional methods relied on competitor analysis and limited market research, potentially leading to missed opportunities or profit erosion.
The challenge was compounded by the need to consider their entire product portfolio - pricing the new product incorrectly could cannibalize sales from existing products. They needed a systematic approach that would account for cross-product effects and market dynamics.
Without proper pricing optimization, they risked either leaving money on the table with underpricing or losing market share with overpricing, especially in a highly competitive supplements market.
The solution
I developed a comprehensive pricing optimization framework using Bayesian analysis and mixed-integer programming (MIP). The solution started with gathering historical sales data of existing sleep medications and competitor pricing strategies to understand market dynamics.
The Bayesian framework allowed me to estimate demand-price relationships with uncertainty quantification, which was crucial given the limited data available for a new product launch. I incorporated informative priors based on similar existing products to improve the demand curve estimates.
The core of the solution was a MIP model that optimized pricing across the entire medication portfolio. This considered demand-price relationships, cost constraints, and the potential for cannibalization between products. The model explored multiple objective functions including maximizing total revenue and maximizing gross margin, allowing the client to understand trade-offs between sales volume and profitability.
Technical approach
- Historical data analysis of existing sleep medications and competitor pricing strategies
- Bayesian demand modeling with uncertainty quantification for price elasticity estimation
- Conjoint analysis for understanding customer preferences and willingness-to-pay
- Mixed-integer programming (MIP) for portfolio-wide pricing optimization
- Cannibalization modeling to account for cross-product substitution effects
- Multi-objective optimization: revenue maximization vs. margin maximization
- Sensitivity analysis for robust pricing recommendations under different market scenarios
Results
Revenue Impact
+18%
From portfolio-wide optimization
Market Share
Maintained
Despite competitive pricing
Pricing Decisions
100% data-driven
From subjective to analytical
Portfolio Margin
+12%
Optimized across all products
Overall impact
The client successfully transitioned from subjective pricing to a data-driven approach, ensuring their pricing strategy considered cost structures and market dynamics. The MIP model identified optimal price points that balanced market competitiveness with profit maximization. Portfolio-wide pricing adjustments led to an 18% revenue increase while maintaining market share. Most importantly, the framework provided long-term strategic advantage with the agility to adapt pricing to future market changes and product launches, especially valuable during periods of high inflation.
Key lessons
- 01Portfolio optimization beats single-product pricing: Considering cannibalization and complementary effects across products yielded better overall results.
- 02Bayesian methods handle uncertainty well: With limited data for a new product, incorporating priors from similar products improved demand estimates.
- 03Multiple objectives reveal trade-offs: Showing both revenue and margin optimization helped stakeholders make informed strategic choices.
- 04Sensitivity analysis builds confidence: Demonstrating pricing robustness under different scenarios reduced stakeholder risk concerns.
Tech stack
Related links
Similar project?
Need help with a similar challenge? Let's discuss how I can help.
More projects
AI-guided recommendation engine for premium floral e-commerce
A production-oriented recommendation system that guides customers through emotionally loaded floral purchases — using a deterministic state machine with LLM components constrained to intent parsing and rationale generation only.
Travel retail forecasting system
Multi-SKU demand forecasting pipeline for 30+ products across 100+ duty-free locations with automated monthly updates.
Consumer healthcare marketing mix model & budget optimizer
Proprietary Marketing Mix Model with budget optimization replacing intuitive allocation with data-driven decision making across multiple countries and touchpoints.