Decision SupportA decision support framework for evaluating revenue performance in sequential purchase contexts

•We study the product ordering problem in sequential purchase contexts.•We propose a framework that combines data with optimization, simulation and econometric methods.•Our framework allows sellers to compare revenues of limited information sequencing strategies.•We show that the best performing sequencing strategy depends on buyers' strategic behavior.•We show that a substantial portion of the revenue difference is associated with limited information.

This paper studies the product ordering problem in sequential purchase contexts where sellers aim to maximize their revenue faced with budget constrained buyers. We propose a multi-layered decision support framework that combines empirical data with simulation, optimization, and econometric methods to address this problem. Our framework allows sellers to: (i) compare revenue performances of limited information sequencing strategies, (ii) quantify benchmark revenue levels that can be achieved via the optimal sequence based on detailed buyer information, (iii) determine the costs of limited information and strategic buyers to the seller, and (iv) identify the moderators of sequencing strategy performance. We illustrate our framework through two applications in a business-to-business used-car auction setting. Contrary to previous studies reporting practitioners' tendency to sequence items from the lowest value to the highest, our results suggest that the best-performing limited information sequencing strategy depends on buyers' bidding behavior. We also find that the revenue difference between the optimal sequence and a limited information sequencing strategy can be substantial. Our results show that a significant portion of this revenue difference is associated with the seller's limited information on buyers' budgets and product valuations. Our applications also provide various sensitivity analyses and develop new propositions on the moderators of the relationship between the seller's revenue and sequencing strategies.