Introduction
Price elasticity of demand measures how sensitive consumers are to price changes. This metric helps retailers determine how much a price adjustment affects sales volume and, consequently, total revenue.
1. What Is Price Elasticity of Demand
Ep=% Δ Quantity Demanded% Δ PriceE_p = \frac{\%\ \Delta\ \text{Quantity Demanded}}{\%\ \Delta\ \text{Price}}Ep=% Δ Price% Δ Quantity Demanded
- E_p > 1: elastic demand (a small price reduction leads to a proportionally larger increase in volume)
- E_p < 1: inelastic demand (price changes have a limited impact on volume)
- E_p = 1: unit-elastic demand
2. Data Collection and Analysis
To calculate E_p, gather:
- Sales history by SKU
- Historical price records
- Seasonal and promotional variables
Use linear regression or machine learning methods to estimate price coefficients.
3. Elasticity-Based Price Adjustment
- Elastic products: offering small discounts can significantly increase sales volume and revenue.
- Inelastic products: raising prices can increase margins without losing many customers.
- Portfolio mix: combine both cases to balance revenue and overall margin.
4. Tools and Techniques
- Python (pandas, statsmodels): statistical analysis and regression modeling
- Advanced spreadsheets: what-if scenarios for price changes
- Interactive dashboards: E_p visualization by category and region
Automate the calculation so it updates periodically as new data becomes available.
5. Fictional Case Study: SuperMercado Fácil
SuperMercado Fácil:
Calculated E_p for 50 key SKUs using 12 months of data.
Found that private-label products were highly elastic (E_p ~ 1.8).
Reduced prices on these items by 5%, increasing quarterly revenue by 12%.
Conclusion
Using price elasticity of demand to set prices turns data into strategic decisions. With accurate calculations and ongoing reviews, your retail operation can maximize revenue while maintaining healthy margins.
