Pricing Strategies and Advanced Pricing Models

"Introduction Welcome to the course Step 1: Pricing Policy and Pricing Objective 6 Steps of setting a Pricing policy Different Pricing Objectives Step 2: Estimating Demand Estimating Demand Forms of Demand Curve Excel: Estimating Linear Demand Curve Excel: Estimating Power Demand curve with Elasticity2 Excel: Estimating Power Demand Curve with points2 Subjective Demand curve Excel: Estimating Subjective Demand Curve2 Excel: Maximizing Revenue using Excel Solver Step 3: Estimating Costs Estimating the cost function Excel: Modeling Cost Function and Maximizing Profit Including effect of complementary goods Excel: Effect of complementary goods Step 4: Analyzing competitors Analyzing Competitors Step 5a : Price Bundling Strategy Price Bundling Types of Bundling The Bundling Problem Excel: Solving Bundling problem Part 1 Excel: Solving Bundling problem Part 2 Excel: Solving Bundling problem (Price Reversal) Step 5b: Non-Linear Pricing Strategies Non-Linear Pricing Strategies Willingness to Pay of customers Willingness to Pay of customers Example Problem Statement Excel: Standard Quantity Discounts Excel: Two-Tier Pricing Step 5c: Price Skimming Price Skimming Strategy Excel: Price Skimming Strategy Step 5d: Revenue Management Revenue Management Excel: Handling Uncertainity Appendix: Using Lookup functions Appendix 1: Excel Crash Course Mathematical Formulas Textual Formulas Logical Formulas Date-Time Formulas Lookup Formulas ( V Lookup, Hlookup, Index-Match ) Data Tools Formatting Data And Tables Pivot Tables Excel Charts: Categories Of Messages That Can Be Conveyed Elements Of Charts The Easy Way Of Creating Charts Bar And Column Charts Congratulations"