Managerial Economics & Pricing Lab

Cross-Price Elasticity & Cannibalization Calculator

Model cross-price elasticity of demand (XED), substitutes, complements, product line cannibalization, and multi-product portfolio profit.

Elasticity Engine Price & XED Matrix XED Principles FAQ

Commercial Presets

Load calibrated multi-product pricing models.

Step 1: Multi-Product Unit Prices, Unit Costs, Volumes & Elasticity Coefficients

Cross-Price Elasticity & Portfolio Inputs

📦 Product A (Monitored Spillover Product)

Positive (> 0) = Substitutes (Competitors/Tiers). Negative (< 0) = Complements (Hardware & Consumables).

🏷️ Product B (Price Driver / Decision Product)

Determines own-volume loss/gain when Product B's price is adjusted.

Cross-Price Elasticity
+1.20 XED
Substitute Goods (XED > 0)
Net Incremental Profit
+$85.2K
Portfolio Gross Margin moves from $564.0K to $649.2K
Net Incremental Revenue
+$124.0K
Total Portfolio Sales: $1.10M vs $980.0K base
Product A Volume Delta
+1,674 Units
Product A demand shifts by +16.7%

Portfolio Profit Matrix: Product B Price Change vs. Cross-Price Elasticity (XED)

Simulates Net Incremental Portfolio Gross Profit ($) and Total Combined Margin across price actions and product relationship tiers.

Product B Price Delta XED = -1.50 (Strong Complement) XED = -0.75 (Mod Complement) XED = 0.00 (Independent) XED = +0.75 (Mod Substitute) XED = +1.50 (Strong Substitute)

Managerial Economics Principles

Understanding Cross-Price Elasticity

Key product portfolio, merchandising, and pricing principles:

  • Substitute Dynamics ($XED > 0$): When Product B increases in price, consumers migrate to Product A. In internal product lines, discounting low-tier tiers risks cannibalizing high-margin premium offerings.
  • Complementary Attachment ($XED < 0$): Products consumed together (coffee and pastries, game consoles and digital titles). Discounting the platform (Product B) surges attached high-margin consumables (Product A).
  • Midpoint Arc Elasticity Standard: Solves directional asymmetry by evaluating price changes over average baseline and test prices.
  • Portfolio Gross Profit Optimization: Isolated single-product pricing optimization often leads to sub-optimal outcomes because it ignores cross-category margin spillovers.

Test single-product elasticity in the Price Elasticity Lab.

Mathematical Formulation

XED & Portfolio equations

% Delta P_B = rac{P_{B2} - P_{B1}}{(P_{B1} + P_{B2}) / 2}

% Delta Q_B = % Delta P_B imes PED_B

% Delta Q_A = % Delta P_B imes XED_{A,B}

Q_{A2} = Q_{A1} imes ( 1 + % Delta Q_A )

Q_{B2} = Q_{B1} imes ( 1 + % Delta Q_B )

ext{Incremental Gross Profit} = left[ (P_A - C_A) Q_{A2} + (P_{B2} - C_B) Q_{B2} ight] - ext{Base Gross Profit}

ext{Cannibalization Rate} = rac{-Delta Q_A}{Delta Q_B} imes 100%

Explore multi-tier pricing in the Two-Part Tariff Lab.

FAQ

Cross-price elasticity & cannibalization questions

What is Cross-Price Elasticity of Demand (XED)?

Cross-Price Elasticity of Demand (XED) measures the percentage responsiveness in the quantity demanded of Product A when the price of Product B changes: XED = (% Delta Q_A) ÷ (% Delta P_B).

How do positive and negative XED values indicate product relationships?

A positive XED (>0) indicates substitute goods (e.g. Coke vs. Pepsi), where raising Product B's price increases demand for Product A. A negative XED (<0) indicates complementary goods (e.g. Razors & Blades), where raising B's price decreases demand for both.

What is product line cannibalization?

Cannibalization occurs when launching or discounting a lower-tier product diverts sales away from an existing higher-margin product. It is quantified as the volume loss of Product A divided by the volume gain of Product B.

How do complementary products enable loss-leader pricing?

In loss-leader pricing, Product B is sold near or below cost to stimulate massive volume, driving high-margin attached sales of complementary Product A (e.g., cheap gaming consoles driving high-margin game sales).

Can I export cross-price elasticity calculations to CSV?

Yes. You can export complete dual-product volumes, revenues, contribution margins, XED coefficients, cannibalization rates, and 6x5 sensitivity matrices as a UTF-8 CSV spreadsheet with formula defense.

Continue Exploring Pricing & Economics Tools

Explore our Pricing Hub, test single-product elasticity in the Price Elasticity Lab, model volume tiers in the Volume Discount Lab, calculate bundling tradeoffs in the Bundle Pricing Lab, or analyze customer willingness-to-pay in the Van Westendorp Lab.