Demand prediction and price optimization for semi-luxury supermarket segment

T. Qu, J. H. Zhang, Tung Sun Chan, R. S. Srivastava, M. K. Tiwari, Woo-yong Park

Research output: Journal article publicationJournal articleAcademic researchpeer-review

10 Citations (Scopus)


In case of high-end priced products, the demand is seasonal and sensitive. The investment involves high risk and revenues vary beyond fathomable bounds. The primary objective of this research is to present a decision-support system for retail pricing and revenue optimization of these retail products. The sales data of past 2.5 years from prominent retail stores across 45 different regions has been used to develop this study. A regression tree/random forest-based machine learning algorithm is used to predict weekly demand. It incorporates price, holidays, discounts, inventory and other regional factors in decision making. Following this, the demand-price interdependencies are quantified and integrated into an integer linear programming model for optimal price allocation. This methodology has been implemented on offline retailing of expensive products which generally follow high variation in demand. The expected revenue has been optimized by branch & bound and branch & cut method, followed by root node analysis. The solution is further optimized by heuristic methods.
Original languageEnglish
Pages (from-to)91-102
Number of pages12
JournalComputers and Industrial Engineering
Publication statusPublished - 1 Nov 2017


  • Analytics
  • Assignment
  • Branch and bound
  • Data mining
  • Integer programming
  • Retailing

ASJC Scopus subject areas

  • Computer Science(all)
  • Engineering(all)

Cite this