B8816-001: Quantitative Pricing & Revenue Analytics
M - B Term, 09:00AM to 12:15PM
Credit hours: 1.5
Location: URI 140
Instructor: Wei Ke
Course Description:
Quantitative pricing and revenue analytics collectively refers to the set of practices and tools that firms in various industries use to quantitatively model consumer preferences, segment their market, and tactically optimize (often in micro targeted or personalized manner) their product assortment, pricing, and promotion strategies.
The origins of this field, often referred to as revenue management as it is also called, are in the airline industry during the late 80s. The prototypical question is how a firm should set and update pricing and product availability decisions across its various selling channels in order to maximize its profitability. In the airline industry, as most of us know, tickets for the same flight may be sold at many different fares, the availability of which is changing as a function of purchase restrictions, the forecasted future demand, and the number of unsold seats. The adoption of such systems has transformed the transportation and hospitality industries, and is increasingly important in retail, telecommunications, entertainment, financial services, health care, manufacturing, as well as on-line advertising, online retailing, and online markets. In parallel, pricing and revenue optimization has become a rapidly expanding practice in consulting services, and a growing area of software and IT development.
We will be doing a hands-on dive into the above tools in the context of 2-3 case studies and datasets, in conjunction with lectures to set the stage. The case studies will cover markdown pricing for a retailer, demand and inventory data for a self-storage company, customer research data of a mortgage lender, and peak load pricing data for a highway toll booth.
Through this course, students will be able to model and identify opportunities for revenue optimization in different business contexts. As the ensuing outline reveals, most of the topics covered in the course are either directly or indirectly related to customer segmentation, demand modeling, and tactical price optimization.
Textbook
One recommended book for the course is by Robert Phillips titled “Pricing and Revenue Optimization.”
Prerequisites / Connections to the Core
I will assume that students are familiar with the content covered in the managerial statistics, business analytics, managerial economics and marketing core courses. In more detail, the course assumes knowledge in the following areas:
§ Managerial statistics: basic understanding of probability; probability distributions; expected value calculations; knowledge of regression and how to run a regression in excel
§ Business Analytics: some knowledge of spreadsheet modeling; linear & nonlinear optimization; how to formulate these problems in excel; how to use solver to get a solution; how to interpret the solution; how to interpret the shadow price variables (we will use this type of knowledge quite a bit). We will also use logistic regression as well as the tool used in the BA course (I will make it available anew).
§ Marketing / Economics: basic understanding of demand functions; what they mean; some examples; some basic understanding of consumer choice.
§ Intro to Programming in Python (pre- or co-requisite)
In addition to the above, it is important to note that the course will emphasize quantitative analysis and tools, will involve a significant amount of quantitative data analysis, and some degree of programming in Python. This will primarily be done in teams, much of it in class, and with the help of the TA(s) and the professor. Sample code will be shared for various parts of these analyses.
Course deliverables
Apart from class participation (30% of the total grade), the other course deliverables consist of a set of in-class (homework) assignments (40%) and a take-home final exam (30%).
§ Class participation: I will routinely ask that you review some material, or watch some short recorded lecture, and come to class ready to discuss, but more importantly, use some of these concepts.
§ As mentioned earlier, most of the course will be organized around a few hands-on analyses that will be done in groups (of up to 6 students). A significant part of the work will be done in class, but some will be done offline. The in class sessions will be planning, brainstorming sessions, where the TAs and professors will be involved in working through the issues.
§ There is a take-home final that will touch upon multiple – but perhaps not all - topics of the course. The take-home final is an individual assignment that should not be discussed with your classmates.
Wei Ke
Adjunct Assistant Professor
Dr. Wei Ke is a Partner based in Simon-Kucher’s New York and Toronto offices. He currently heads the Financial Services Practice in North America and serves as the President of Simon-Kucher Canada.
Wei has advised leading financial institutions in North America and Europe on product innovation, pricing strategy, marketing & promotional tactics, customer value management, risk management, value...