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.
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
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
- 1Portfolio optimization beats single-product pricing: Considering cannibalization and complementary effects across products yielded better overall results.
- 2Bayesian methods handle uncertainty well: With limited data for a new product, incorporating priors from similar products improved demand estimates.
- 3Multiple objectives reveal trade-offs: Showing both revenue and margin optimization helped stakeholders make informed strategic choices.
- 4Sensitivity analysis builds confidence: Demonstrating pricing robustness under different scenarios reduced stakeholder risk concerns.
Tech stack
Related links
More projects
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.
CLTV-driven customer acquisition strategy
Customer lifetime value modeling combined with lookalike audience optimization for targeted acquisition, improving customer quality and reducing acquisition costs.