flowchart LR
subgraph Current["📊 Current State"]
A["🍷 <b>Casalforte</b><br/>479 NOK<br/>37,670 L"]
end
subgraph Decision["🤔 Price Decision"]
B{"What price<br/>increase?"}
end
subgraph Scenarios["📈 Outcomes"]
C["✅ <b>+5%</b><br/>504 NOK<br/>35,215 L<br/>+0.8% Revenue"]
D["⚠️ <b>+10%</b><br/>528 NOK<br/>32,760 L<br/>-1.9% Revenue"]
E["❌ <b>+15%</b><br/>552 NOK<br/>30,305 L<br/>-5.2% Revenue"]
end
A --> B
B -->|"Safe"| C
B -->|"Risky"| D
B -->|"Danger"| E
style A fill:#3b82f6,color:white,stroke:#1e40af,stroke-width:2px
style B fill:#8b5cf6,color:white,stroke:#7c3aed
style C fill:#10b981,color:white,stroke:#059669,stroke-width:3px
style D fill:#f59e0b,color:white,stroke:#d97706
style E fill:#ef4444,color:white,stroke:#dc2626
6 Revenue Growth Management & Price Sensitivity
NoteBusiness Context
This chapter addresses the most common question from brand managers: “If my producer wants to increase the price, how will the market react?”
We’ll use real sales data from Robert Prizelius AS products and OR-Tools optimization to build confidence intervals around multiple pricing scenarios.
6.1 The Business Challenge
Wine and spirits brand managers face a constant balancing act:
- Producers want to protect margins or cover rising costs
- Vinmonopolet (monopoly retailer) operates on fixed margins
- Consumers make decisions based on value perception
- Market share can shift dramatically with price changes
Revenue Growth Management (RGM) provides the analytical framework to:
- Understand price sensitivity in your category
- Forecast demand under different price scenarios
- Quantify the risk of price increases with confidence intervals
- Optimize pricing strategy across your portfolio
6.2 Real Data: Italian Red Wine Portfolio
Let’s examine the Robert Prizelius AS Italian red wine portfolio using actual sales data from the SalesVP model.
6.2.1 Portfolio Overview
📊 Copy this prompt to Claude:
"Query Italian red wine portfolio for Robert Prizelius AS.
Show me products, total liters sold, and average price.
Order by volume descending."The Casalforte Rosso Veneto is clearly the volume driver - a 3L Bag-in-Box format (479.90 NOK) that dominates the portfolio. Let’s analyze its price sensitivity.
6.3 Time Series Analysis: Understanding Trends
Before forecasting price scenarios, we need to understand the underlying sales patterns.
6.3.1 Monthly Sales Pattern (36 months)
📊 Copy this prompt to Claude:
"Analyze the monthly sales trend for Casalforte Rosso Veneto
from January 2022 to December 2024.
Detect seasonality and identify any anomalies."
ImportantKey Statistical Findings
Using OR-Tools time series analysis on 36 months of Casalforte Rosso Veneto sales:
| Metric | Value | Interpretation |
|---|---|---|
| Mean Monthly Volume | 37,670 liters | Baseline expectation |
| Standard Deviation | 5,499 liters | Natural variation |
| Trend Strength | 0.454 | Moderate downward trend |
| Seasonal Strength | 0.829 | Strong seasonality |
| December Peak | 53,991 liters | 43% above mean |
| September Low | 28,401 liters | 25% below mean |
6.3.2 What the Data Tells Us
- Strong Seasonality (0.829): December sales are 43% higher than average - this is Christmas/gift-giving season
- Declining Trend (0.454): Volume has declined from ~42,000 liters/month (2022) to ~30,000 liters/month (2024)
- High Variability: Standard deviation of 5,499 liters means ±15% swings are normal
WarningBusiness Implication
The declining trend suggests market pressure. A price increase during this period carries higher risk than during stable or growing sales.
6.4 Forecasting with Confidence Intervals
Using Holt-Winters exponential smoothing, we can forecast future demand with confidence bands.
6.4.1 6-Month Forecast (Current Price Scenario)
📊 Copy this prompt to Claude:
"Forecast Casalforte Rosso Veneto sales for the next 6 months
using Holt-Winters method with 95% confidence intervals."Key Insight: The wide confidence intervals (especially by June: 13,502 - 40,565) reflect the inherent uncertainty in forecasting. This uncertainty is before any price change.
6.5 Price Sensitivity Simulation
Now for the critical RGM question: What happens if the producer increases price?
6.5.1 Building the Price Elasticity Model
Price elasticity measures how sensitive demand is to price changes:
\[\text{Elasticity} = \frac{\% \Delta \text{Quantity}}{\% \Delta \text{Price}}\]
For wine in the Vinmonopolet channel, typical elasticities are:
| Category | Elasticity | Interpretation |
|---|---|---|
| Entry (<200 NOK) | -1.8 to -2.2 | Highly elastic - price sensitive |
| Mid-Premium (200-400) | -1.2 to -1.5 | Moderately elastic |
| Premium (400-600) | -0.8 to -1.1 | Less elastic |
| Super Premium (>600) | -0.3 to -0.7 | Inelastic - brand loyal |
At 479.90 NOK (3L BIB), Casalforte sits at the Premium/Mid-Premium boundary with estimated elasticity of -1.1 to -1.3.
6.5.2 Scenario Analysis: Price Increase Impact
📊 Copy this prompt to Claude:
"Run Monte Carlo simulation for Casalforte Rosso Veneto
with these price increase scenarios:
- Scenario A: +5% (504 NOK)
- Scenario B: +10% (528 NOK)
- Scenario C: +15% (552 NOK)
Use elasticity range -1.1 to -1.3 and 10,000 simulations."
ImportantPrice Increase Impact Analysis
Baseline: 37,670 liters/month at 479.90 NOK
| Scenario | New Price | Expected Volume | Volume Range (95%) | Revenue Impact |
|---|---|---|---|---|
| +5% | 504 NOK | 35,215 L | 33,800 - 36,500 L | +0.8% revenue |
| +10% | 528 NOK | 32,760 L | 30,200 - 34,800 L | -1.9% revenue |
| +15% | 552 NOK | 30,305 L | 27,100 - 33,200 L | -5.2% revenue |
6.5.3 Visualizing the Trade-offs
6.5.4 Strategic Interpretation
TipRecommendation for Producer
Based on the analysis:
- +5% is the sweet spot - Small volume decline is offset by price increase, yielding +0.8% revenue growth
- +10% is break-even territory - Risk of 2% revenue loss with significant volume erosion
- +15% is dangerous - High probability of 5%+ revenue decline, may trigger consumer switching
Timing matters: Consider implementing increases in Q1 (Jan-Feb) when sales naturally dip, avoiding the critical December peak season.
6.6 Shadow Prices: Constrained Optimization
Sometimes the question isn’t just “what price?” but “what’s limiting my growth?” This is where shadow prices (dual values) from optimization become valuable.
6.6.1 Portfolio Optimization Example
📊 Copy this prompt to Claude:
"Optimize the Robert Prizelius Italian red wine portfolio allocation.
Constraints:
- Total marketing budget: 500,000 NOK
- Minimum spend per product: 20,000 NOK
- Maximum spend per product: 150,000 NOK
Objective: Maximize expected revenue growth
What are the shadow prices on each constraint?"Business Insight: The shadow price tells you where your constraints are costing you money. A shadow price of 2.3 on the budget constraint means lobbying headquarters for 100,000 NOK more budget would generate 230,000 NOK additional revenue.
6.7 Practical Workflow for Brand Managers
TipYour RGM Checklist
When a producer proposes a price increase, follow this workflow:
- Query historical data - Get 24-36 months of sales data from the SalesVP model
- Decompose the trend - Is the product growing, stable, or declining?
- Check seasonality - When are the peak and trough months?
- Estimate elasticity - Based on price segment and category norms
- Run scenarios - Use Monte Carlo simulation for confidence intervals
- Calculate break-even - At what volume decline does revenue fall?
- Time your decision - Avoid implementing during peak season
- Monitor results - Track actual vs. predicted after implementation
6.8 Common Questions Answered
6.8.1 “How confident can I be in these predictions?”
The 95% confidence intervals give you the range where the true outcome will fall 95% of the time. For Casalforte at +10% price:
- Best case: 34,800 liters (only 7.6% volume decline)
- Expected: 32,760 liters (13% volume decline)
- Worst case: 30,200 liters (20% volume decline)
6.8.2 “What about competitor reactions?”
The model assumes competitors don’t change prices. In reality: - If competitors follow your increase → your volume decline will be lower - If competitors hold prices → your volume decline may be worse than predicted
Add 10-20% uncertainty to your ranges if competitive dynamics are unclear.
6.8.3 “Should I increase all products or just some?”
Use portfolio optimization. Often the best strategy is: - Price up on inelastic, brand-loyal products (Amarone, Gaja) - Hold prices on elastic, volume products (Casalforte, entry wines) - Consider promotions to offset perception of “price increase brand”
6.9 Summary
ImportantKey Takeaways
- Time series decomposition reveals trend, seasonality, and anomalies before any price analysis
- Confidence intervals quantify uncertainty - never present a single-point forecast
- Price elasticity varies by segment: entry wines are 2x more sensitive than premium
- Monte Carlo simulation provides probability distributions for decision-making
- Shadow prices identify which constraints are limiting your growth
- Timing matters - implement changes during low-season, not peak-season
In the next chapter, we’ll explore advanced multi-product optimization and competitive game theory using the OR-Tools Shapley value calculator.