280 likes | 433 Views
Dynamic Revenue Management Through Cross-Selling in E-Commerce Retailing. Sergei Savin Graduate School of Business, Columbia University (Joint work with Sergei Netessine , The Wharton School Wen-Qiang Xiao, Columbia GSB). Cross-Selling in Retailing. “Brick-and-Mortar” Retailing
E N D
Dynamic Revenue Management Through Cross-Selling in E-Commerce Retailing Sergei Savin Graduate School of Business, Columbia University (Joint work with Sergei Netessine, The Wharton School Wen-Qiang Xiao, Columbia GSB)
Cross-Selling in Retailing • “Brick-and-Mortar” Retailing • Product A and Product B may be sold separately as well as part of package P • Shampoo and conditioner • Christmas gift preparations (wrapping paper, tape, holiday cards, etc.) • Starter kits for kid’s bicycles (bicycle, helmet, knee pads) • Package contents and package price are static
$20.37 $51.87 • Example: buying books on Amazon.com • Online retailing:packages can be composed and priced dynamically
$31.50 $174.95
$174.95 $143.45
Cross-Selling of Books on Amazon.com: Top 100 on 09/17/03 - book on the top100 list, - book outside of top 100 list
Survey be E-tailing group: cross-selling is used by • 62% of top internet retailers • 100% of top internet retailers specializing in computers, books/music, consumer electronics, pet supplies • Travel web sites: dynamic cross-selling of “air+hotel”, “air+car”, “air+hotel+car” packages
Cross-Selling in e-Retailing: Personalized Sales Recommendations • “Personalization” approach to selecting packaging complements • Designed to maximize probability of buying a package
Product Cross-Selling in the Literature • Economics and Marketing (review by V. Rao (1993)) • Static “demand-side” analysis: under what conditions cross-selling is profitable (Adams and Yellen (1976)) • No “supply-side” considerations • Operations • Optimal pricing of product bundles in static environment (Hanson and Martin (1990)) • Stocking decisions for individual products and product bundles (Ernst and Kouvelis (1999)) • Multi-Product Revenue Management (Gallego and Van Ryzin (1997), Cooper and Zhang (2003))
Dynamic Cross-Selling Model • A company sells m items • We consider a cross-selling problem between two successive inventory replenishments • N decision epochs • At the beginning of each decision epoch, the inventory levels of all products are observed and packaging and pricing decisions are made
During each decision epoch at most 1 customer arrives, asking for item i with probability li • Class i customer is offered item ithe (fixed) price pi and a an “item i – item j” (for some j) package at the price pi≤ pij≤ pi + pj. • Class i customer buys only item i with probability Fij(pij) and buys “item i – item j” package with probability 1-Fij(pij) • Objective: at each decision epoch select packages and their prices to maximize expected revenues over remaining horizon
What happens if we run out of one or more products? • Emergency Replenishment Model (ERM): missing item i is procured at an additional cost bi • Lost Sales Model (LSM): missing item is “out”
How to Price Static Packages? i=2 i=1 Packaging Primary of Porteus’s book = {Zipkin’s book, Heyman-Sobel’s book}: P(2)={1,3} Packaging Complement of Porteus’s book = Zipkin’s book: C(2)=3 i=3
Decomposition under Emergency Replenishment Model Proposition
ERM Decomposition i=2 i=1 i=3
i=1 i=2 i=3 Proposition
2 2 2 2 2 2 1 1 1 1 1 1 3 3 3 3 3 3 Optimal Packaging is State-Dependent…
2 2 2 2 2 2 1 1 1 1 1 1 3 3 3 3 3 3 … and Dynamic
Heuristic Packaging/Pricing Approaches • Optimal Package Pricing • “Infinite Supply” Pricing • is a lower bound on the optimal price, optimal when Ijis high • “Infinite Supply” Packaging “Infinite Supply” Heuristic
Heuristic Packaging/Pricing Approaches • In period n, assume that there is no product packaging in periods n+1 to N • “Two-Stage” Pricing • “Two-Stage” Packaging “Two-Stage” Heuristic
Testing “Infinite Supply” and “Two Stage” Heuristics • Prices of individual products are fixed and equal: • Exponential reservation price functions for packages: • Initial product inventories: • Emergency replenishment prices: • Three products • Various combinations of demand intensities li , i=1,2,3 • About 7000 problem instances
“Infinite Supply” heuristic: • Average performance gap (as compared to optimal) is about 10% • “Two Stage” heuristic: • Average performance gap is 0.12% • Worst performance gap is 0.69%
Summary • Dynamic Cross-Selling Model • Two types of “boundary” conditions: Emergency Replenishment and Lost Sales • Emergency Replenishment: • Static Packaging: Decomposable Value Function • Dynamic Packaging: “Two Stage” Heuristic • Lost Sales: • Few structural properties