From the course: Data Analytics for Pricing Analysts in Excel
Unlock this course with a free trial
Join today to access over 25,500 courses taught by industry experts.
Best practices in pricing - Microsoft Excel Tutorial
From the course: Data Analytics for Pricing Analysts in Excel
Best practices in pricing
- [Instructor] One of the key truisms that we've talked about throughout this course is that trade off between price and volume. A firm can choose how many units it wants to sell or it can choose its price, but it can't choose both. If you're going to try and maximize unit sales, you're going to have to follow a low price strategy. If you're trying to maximize your price and hopefully profitability, you're going to have low sales. Now, one important point to note, a unit of price is more valuable to a firm than a unit of volume. If you could choose between a 1% increase in price or a 1% increase in volume for your firm, you should always choose the unit of price. Why is that? Well, the answer is cost of goods sold. Price flows to the bottom line directly while volume is diluted based on the level of COGS that your firm has. This is even true for zero marginal costs producers like software companies. the reality is that…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
(Locked)
Business forecasting2m 33s
-
(Locked)
Assessing the impact of competition5m 19s
-
(Locked)
Scenario analysis in pricing6m 17s
-
(Locked)
Variance analysis walks and pricing3m 35s
-
(Locked)
Building variance waterfalls6m 5s
-
(Locked)
Best practices in pricing3m 30s
-
(Locked)
Tools for pricing6m 2s
-
(Locked)
-