Back to Projects

Pricing Strategy Analysis

PythonPandasScikit-learnTableauExcelPricing AnalyticsMarket Research
Pricing Strategy Analysis

Project Overview

A private label brand had been gaining traction in our client's retail accounts, steadily eating into Brand 1's market share. To counter this challenge, we analyzed sales data from both brands, focusing on price sensitivity, demand patterns, and retailer margins. This project outlines strategic pricing recommendations to help Brand 1 push back against the private label's growth while maintaining strong profits and market presence.

Initial Analysis

For this analysis, we assumed that the manufacturing cost for both the private label (Control Brand) and Brand 1 is the same. Our initial findings revealed:

Control BrandBrand 1
Average Retail Price$2.15$2.61
Average Market Share Units57%43%
Average Units189144
Average Market Share (Dollars)52%48%
Average Retail Margin$0.50$0.45
Average Weekly Profit for Retailer$2,254.95$1,542.90
Average Weekly Profit for Manufacturer$2,109.24$3,358.08

Key Takeaways

  • Retailers Prefer the Private Label: The private label offers a higher retail margin ($0.50 vs. $0.45 per unit) and higher weekly retailer profits ($2,254.95 vs. $1,542.90), incentivizing stores to push their sales.
  • Consumers Choose Affordability: With a lower price point of $2.15 vs. $2.61, the private label captures 57% of unit sales, making it the preferred choice for budget-conscious shoppers.
  • Brand 1 Still Holds Value: Despite losing market share, Brand 1 generates higher manufacturer profits ($3,358.08 vs. $2,109.24 per week), meaning it remains profitable but must balance price adjustments with maintaining margins.

Regression Analysis

We conducted regression analysis to understand the impact of pricing on sales for both brands. For Brand 1, we found:

  • The Adjusted R² is 0.8511, meaning that about 85.1% of the variation in Brand 1's sales is explained by the independent variables (Week, Control Brand Price, and Brand 1 Price).
  • Brand 1's price has a significant negative impact on its sales. Every $1 increase in Brand 1's price leads to a decrease of 11,322.19 units sold.
  • The Control Brand's price positively influences Brand 1's sales. When the Control Brand raises its price by $1, Brand 1's sales increase by 1,719.54 units.

Optimization Strategy

Based on our analysis, we developed an optimal pricing strategy for Brand 1:

  • Optimal Price for Brand 1: $1.86
  • This price point maximizes total profit for the manufacturer while keeping the retailer's margin fixed.
  • Total weekly profit is approximately $4,735, leading to a total profit of $23,680 over the period analyzed.

Impact of the New Pricing Strategy

  • Retailer's profit grew by approximately 135%.
  • Brand 1's profit increased by around 55%.
  • Brand 1's sales surged from about 3,000 units per week to nearly 7,400 units per week.
  • Control Brand's sales also experienced a notable rise, increasing by 4,324 units under the new pricing strategy.
  • Overall retailer category profits improved significantly due to increased total sales and revenue.

Conclusion

Our pricing strategy analysis demonstrates that a strategic price adjustment for Brand 1 can significantly improve both manufacturer and retailer profitability while reclaiming market share from the private label. By understanding price elasticity and optimizing pricing accordingly, Brand 1 can maintain its competitive position in the market while ensuring sustainable growth.