writer Pricing Strategy Simulator
Overview
Model and simulate pricing strategies across the CPG value chain — from manufacturer list price through retailer shelf price to consumer response. This skill integrates price elasticity modeling, competitive price gap analysis, price pack architecture design, and channel pricing consistency to produce financially rigorous pricing recommendations with quantified risk ranges.
When to Use
- Cost-increase pass-through strategy and sizing
- Promotional pricing depth optimization
- EDLP vs Hi-Lo strategy evaluation
- Price pack architecture (PPA) design or rationalization
- Competitive price gap analysis and response
- Private label price gap management
- Price harmonization across channels/retailers
- Revenue Growth Management (RGM) initiatives
Required Inputs
| Input | Description | Format |
|---|---|---|
| Current pricing | List price, net price, shelf price by SKU/retailer | Price table |
| Price elasticity | Own-price elasticity by SKU or brand (estimated or measured) | Coefficient (e.g., -1.8) |
| Cross-price elasticity | How competitor/substitute price changes affect your volume | Coefficient matrix |
| Cost structure | COGS breakdown, margin targets by SKU | $ per unit |
| Competitive pricing | Key competitor shelf prices and promotional patterns | Price table |
| Volume data | Current unit volume by SKU, retailer, channel | Units per period |
| Price pack architecture | Size, count, price points across portfolio | SKU matrix |
| Retailer margin requirements | Known or estimated retailer margin expectations | % or $ per unit |
Methodology
Step 1: Current Pricing Landscape Assessment
Map the complete pricing architecture:
Manufacturer List Price (MSLP)
− Off-Invoice Allowance (OI)
= Net Invoice Price
− Scan/Performance Allowances
= Net Net Price (Net Revenue to Manufacturer)
Retailer Cost (= Net Invoice Price)
+ Retailer Margin
= Regular Shelf Price (RSP)
− Promotional Discount
= Promoted Price
Key Ratios:
Trade Rate = (MSLP − Net Net) / MSLP
Retailer Margin = (RSP − Net Invoice) / RSP
Consumer Value = Price per Unit (oz, count, serving)
Step 2: Elasticity-Based Volume Modeling
Model volume impact of price changes:
Own-Price Elasticity Application:
% Volume Change = Elasticity × % Price Change
Example: Elasticity = -1.8, Price increase = +5%
Volume impact = -1.8 × 5% = -9.0%
New Volume = Current Volume × (1 + Volume Change)
New Revenue = New Volume × New Price
Revenue impact = (New Revenue / Current Revenue) − 1
Elasticity Confidence Ranges: Use a range rather than a point estimate:
- Optimistic elasticity: 70% of point estimate (less elastic)
- Base elasticity: Point estimate
- Pessimistic elasticity: 130% of point estimate (more elastic)
This produces a revenue impact range for risk assessment.
Cross-Price Elasticity (Competitive Response):
% Volume Change (Yours) = Cross-Elasticity × % Price Change (Competitor)
If competitor follows your increase: Net volume impact reduced
If competitor holds price: Full elasticity impact applies
If competitor reduces price: Amplified negative impact
Step 3: Price Gap Analysis
Analyze competitive and private label price gaps:
Price Gap Calculation:
Absolute Gap = Your Price − Competitor Price
Relative Gap = (Your Price − Competitor Price) / Competitor Price × 100
Price Per Unit Gap (normalize by size):
Your $/oz vs Competitor $/oz → Gap in $/oz and %
Critical Price Gap Thresholds (CPG industry benchmarks):
| Gap Type | Danger Zone | Optimal Zone |
|---|---|---|
| vs. #1 Branded Competitor | >15% premium | 0-10% premium |
| vs. Private Label | >40% premium | 20-35% premium |
| vs. Value Tier | <10% premium | >25% premium |
Flag any SKU crossing into the danger zone.
Step 4: Price Pack Architecture (PPA) Simulation
Evaluate the portfolio price ladder:
Good/Better/Best Framework:
Good (entry): [Size/Count] at $[X.XX] → $[X.XX]/oz → Index 100
Better (core): [Size/Count] at $[X.XX] → $[X.XX]/oz → Index [XX]
Best (premium): [Size/Count] at $[X.XX] → $[X.XX]/oz → Index [XX]
Key PPA Metrics:
- Price per unit consistency across sizes (should reward larger sizes)
- Margin per unit by tier (Best > Better > Good)
- Volume distribution across tiers (healthy: 20/50/30 or similar)
- Channel appropriateness (Club = large sizes, C-Store = small/single serve)
Size Optimization: Calculate the price-per-unit curve to ensure logical step-ups:
Price/oz should decrease with size: Single Serve > Multi-Pack > Family Size
Exception: Premium/craft segments may maintain flat $/oz across sizes
Step 5: Promotional Pricing Simulation
Model promotional depth and frequency:
Baseline Volume: [units/week at regular price]
Promoted Volume at X% discount:
= Baseline × (1 + |Promo Elasticity| × Discount %)
Note: Promo elasticity typically 2-4x regular elasticity
Promotional Profit:
= Promoted Volume × (Promoted Price − COGS) − Promo Funding Cost
vs.
Baseline Profit = Baseline Volume × (Regular Price − COGS)
Incremental Profit = Promotional Profit − Baseline Profit
EDLP vs Hi-Lo Comparison:
| Dimension | EDLP | Hi-Lo |
|---|---|---|
| Avg shelf price | Lower, stable | Higher regular, lower promo |
| Volume pattern | Steady | Spiky (promo-driven) |
| Supply chain | Predictable | Volatile (bullwhip) |
| Consumer type | Price-conscious, planned | Deal-seekers, cherry-pickers |
| Trade spend | Lower (less promo funding) | Higher (deep promotional events) |
| Margin profile | Consistent | Variable (deep promos can be negative) |
Step 6: Scenario Matrix Construction
Build a comprehensive pricing scenario matrix:
| Scenario | Your Action | Competitor Response | Volume Impact | Revenue Impact | Margin Impact |
|---|---|---|---|---|---|
| A: Full pass-through | +X% | Match | Low/Med/High | $XM | +Xpp |
| B: Full pass-through | +X% | Hold | Low/Med/High | $XM | +Xpp |
| C: Partial pass-through | +Y% | Match | Low/Med/High | $XM | +Xpp |
| D: Partial + resize | +Y% + downsize | Hold | Low/Med/High | $XM | +Xpp |
| E: Absorb | No change | N/A | None | $0 | −Xpp |
Probability-weight the scenarios and calculate expected value.
Step 7: Revenue Growth Management (RGM) Synthesis
Integrate pricing with the full RGM toolkit:
Revenue Growth Levers:
1. List Price Increase — direct margin expansion
2. Mix Management — shift volume to premium tiers
3. Pack Size Optimization — reduce $/oz while maintaining absolute price
4. Trade Spend Efficiency — same volume at lower promotional investment
5. White Space — new price points/formats without cannibalization
6. Reduce Promotions — fewer, deeper, more targeted promotions
Quantify each lever's contribution to total revenue growth target.
Output Specification
# Pricing Strategy Simulation — [Brand/Portfolio]
## Recommendation Summary
**Recommended Strategy**: [Strategy name]
**Expected Revenue Impact**: $XM (+X.X%)
**Expected Margin Impact**: +/-X.Xpp
**Volume Risk Range**: -X% to -X% (optimistic to pessimistic elasticity)
## Current Pricing Landscape
[Pricing architecture from MSLP to shelf price]
[Price gap analysis vs. key competitors and private label]
## Elasticity-Based Impact Model
| Scenario | Price Change | Volume Impact | Revenue Impact | Margin Impact |
|----------|-------------|---------------|----------------|---------------|
| [Scenario A] | +X% | −X% to −X% | +$XM to +$XM | +Xpp |
| [Scenario B] | +X% | −X% to −X% | +$XM to +$XM | +Xpp |
## Competitive Response Analysis
[Scenario matrix with competitor response assumptions]
## Price Pack Architecture Analysis
[Good/Better/Best ladder with price-per-unit curve]
## Promotional Depth Optimization
[Recommended promotional mechanics and depth with ROI by tier]
## RGM Lever Summary
| Lever | Estimated Impact | Confidence | Timeline |
|-------|-----------------|-----------|----------|
| List price | $XM | High | Q[X] |
| Mix management | $XM | Medium | Ongoing |
| Pack optimization | $XM | Medium | Q[X] |
## Risks and Mitigations
[Key risks with probability, impact, and contingency plans]
Analysis Framework
Price-Volume-Profit Triangle: Every pricing decision involves trade-offs among three dimensions. Visualize the trade-off:
- Price increase → volume risk → margin benefit (if volume decline < price gain)
- Price decrease → volume gain → margin risk (if margin dilution > volume gain)
- Breakeven volume change = Price Change % / (CM% + Price Change %)
Example
Input: "Cost increase of 8%. Current shelf price $4.99, COGS $2.30, margin 42.5%. Elasticity estimated at -2.0. Private label is at $3.49."
Analysis:
"An 8% cost increase raises COGS from $2.30 to $2.48, compressing margin from 42.5% to 38.5% if absorbed. Recommended: 5% shelf price increase to $5.24 with simultaneous introduction of a 'Value Size' at $7.99/24oz ($0.33/oz vs current $0.42/oz). The 5% increase at -2.0 elasticity yields an expected -10% volume decline on the core SKU, partially offset by trade-up to the Value Size. Net revenue impact: +$1.2M (+2.8%). Margin recovers to 40.8% (+230bps vs absorption scenario). The private label gap widens from 43% to 50% premium — approaching the danger zone. Monitor private label unit share weekly; if private label share gains >200bps in 8 weeks, deploy targeted competitive-response coupon ($0.75 off) at affected retailers."
Guidelines
- Always model a range of elasticities, not a single point estimate
- Include competitive response scenarios — pricing doesn't happen in a vacuum
- Check price gaps vs. private label after every pricing action
- Price pack architecture must maintain logical price-per-unit progression
- Separate regular shelf pricing strategy from promotional pricing strategy
- Calculate breakeven volume change for every pricing scenario
- Consider retailer margin impact — retailers must accept the shelf price
Validation Checklist
- Current pricing architecture mapped from list price to shelf price
- Elasticity applied with confidence range (optimistic/base/pessimistic)
- At least 3 pricing scenarios modeled with full financial impact
- Competitive price gaps analyzed with danger zone flagging
- Cross-price elasticity and competitor response scenarios included
- Price pack architecture evaluated for logical step-ups
- Promotional pricing depth optimized with ROI calculations
- RGM lever contribution quantified
- Breakeven volume change calculated for recommended strategy
- Retailer margin impact assessed
- Risks identified with monitoring triggers and contingency plans