Learn how to use pricing analysis to maximize firm profits with scenario analysis, price optimization, and data analytics in Excel.
Overview
Syllabus
Introduction
- Welcome
- Our project: Optimizing price
- Why pricing matters
- Models of pricing
- Supply and demand
- Optimize pricing in business
- Assess price in a scenario
- Gather data to set price
- Demand curves
- Estimate linear and power demand curves
- Estimate profit maximizing price
- Optimization and scenario analysis
- Fundamentals of price discrimination
- What is price elasticity?
- Estimate price elasticity
- Price discrimination
- Profits under price discrimination
- Price discrimination with many variables
- Applied pricing discrimination
- Business forecasting
- Assess the impact of competition
- Scenario analysis in pricing
- Variance analysis walks and pricing
- Variance waterfalls
- Best practices in pricing
- Next steps
Taught by
Michael McDonald
